Cannot see contacts on 0.4.x

[limb]

Everything was fine on 0.3.x, then I updated to 0.4 (currently 0.4.2), ran the portions of the SQL updates I needed, and ported my config settings to the new config files. I can't see contacts, even newly created ones, though they're in the DB.

I'm the Fedora RC maintainer, and I've gotten lots of requests to get 0.4.x in Rawhide.

[alec]

Any errors in log? What browser? What PHP version?

[limb]

No errors (save timezone-related), multiple recent Firefoxes, php 5.3.3. Running on Fedora 12. Are there any new PHP modules required or anything?

[alec]

Be more precise, what means "can't see contacts"? Enable sql_debug and check the SQL queries. Are you using any plugins? Disable them. Are you using non-default skin? Change to default.

[limb]

I don't see any errors. No plugins, no skins. I do see, however, that there are no rows in contactgroupmebmers or contactgroups.

[alec]

How about the SQL queries? Check the log and run the same queries on database by hand. Are you using LDAP addressbook?

[alec]

No feedback.

[limb]

The contacts I add get added to the db, and I'm not using an LDAP addressbook. I suspect a javascipt problem, since they're not being displayed, but I don't know javascript.

[alec]

Please, describe steps to reproduce more precissely. What happens after clicking Save in new contact form? Any errors in javascript errors console? What happens when you refresh the page, is the new contact listed on the contacts list? Can you click it? You're the only person with this problem, so we need more info.

[limb]

Log in, click Address Book. Click New contact button. Fill out fields. Click Save.

In error console:

this.rows[a] is undefined Line 19 in program/js/list.js.

No contacts are displayed, before or after, and many exist for this user in the DB.

[alec]

I'm unable to reproduce. Enable sql_debug and attach the log.

[limb]

I grepped otu the bits from today.

[alec]

This is very strange. Lets check (08:17:20):

SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = '44b9490f4bee05c660e24f4797c573ad';
SELECT * FROM users WHERE user_id = '5';

here should be also SELECT COUNT(c.contact_id)....

INSERT INTO contacts (user_id, changed, del, `name`, `email`, `firstname`, `surname`) VALUES (5, now(), 0, 'Biscuit Flayer', 'eatme@coo.com', 'Biscuit', 'Flayer');
SELECT LAST_INSERT_ID();

and here stops, why? Maybe it doesn't return last insert id. Try to execute these two queries. I think you should also try do reinstall Roundcube, because this log isn't looking normal.

[limb]

The insert succeeds, and select last_insert_id() returns 302, which is correct.

This is an RPM install, as I'm the Fedora packager for rc. My rc installation basically had the fields upgraded, the config file settings migrated, and the mysql.update.sql run from Line 75 onward.

[alec]

Consider giving me access to your box. Without some debugging in /program/steps/addressbook/save.inc we'll probably not able to fix this.

[alec]

Make sure your tables have ENGINE=InnoDB set.

[limb]

Fascinating. contactgroupmembers and contactgroups are InnoDB, the rest are MyISAM. A. Which need to be InnoDB B. Why does this matter C. Is this not something that could be included in the sql upgrade script?

[alec]

All should be InnoDB (contacts for sure). It is in update script, but I'm not sure when it has been added. Reopen if changing it doesn't help.

[limb]

Changed all tables to InnoDB. Same issue.

[alec]

My last hint is to check MDB2 package version. Again, consider giving me access to your box.

[limb]

2.4.1.

[limb]

Also, the MDB2 mysql driver version is 1.4.1.

[alec]

It's too old. Check INSTALL file for requirements.

[limb]

Ah. Ok. We only have 2.4.1, even in rawhide. The website only gives a Beta release for MDB2, when do you think there will be a stable release?

[alec]

I have no idea. Just use MDB2 code bundled with Roundcube.

[limb]

In Fedora, we try to minimize, and when possible, eliminate us of bundled code.

​https://fedoraproject.org/wiki/Packaging:No_Bundled_Libraries

In short, using bundled code presents serious challenges in keeping current on security patches.