Or am I missing something?
Because users just had addresses in their addressbooks, without filing them under contact groups, then 0.5 shows empty addressbooks with queries like:
SELECT * FROM contactgroups WHERE del<>1 AND user_id='23' ORDER BY name
Seems like there's some mysql Fu that needs to happen to put each users's contacts into a contactgroup. . .
Ben _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
2011.01.29 23:21, ben@electricembers.net rašė:
Or am I missing something?
Because users just had addresses in their addressbooks, without filing them under contact groups, then 0.5 shows empty addressbooks with queries like:
SELECT * FROM contactgroups WHERE del<>1 AND user_id='23' ORDER BY name
Seems like there's some mysql Fu that needs to happen to put each users's contacts into a contactgroup. . .
Did you run the update script?
Rimas
List info: http://lists.roundcube.net/dev/ BT/aba52c80
Did you run the update script?
I did. As well as the MySQL queries in SQL/mysql.update.sql for updating db/tables from version 0.4.2.
And turning on SQL logging, I see both versions execute the same two queries::::::::
SELECT * FROM contactgroups WHERE del<>1 AND user_id=? ORDER BY name SELECT * FROM contacts AS c WHERE c.del<>1 AND c.user_id=? ORDER BY c.name LIMIT 0, 40
only 0.5 doesn't seem to show the contacts that are not in contactgroups to the GUI :( Seems like a bug to me.
Let me know if/how I can help squish it!
Benjamin _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
Actually I see this now (with 0.5.1):
*** logs/errors *** [11-Feb-2011 12:30:12] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2.php on line 390 [11-Feb-2011 12:30:12] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2.php on line 1885 [11-Feb-2011 12:30:12] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2.php on line 2572 [11-Feb-2011 12:30:12] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2.php on line 2595 [11-Feb-2011 12:30:12] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2.php on line 2940 [11-Feb-2011 12:30:12] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2/Driver/mysql.php on line 924 [11-Feb-2011 12:30:12] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2/Driver/mysql.php on line 1190 [11-Feb-2011 12:30:12] MDB2 Error: not found (-4): [Error message: Unable to bind to missing placeholder: 1]
[11-Feb-2011 12:30:12] MDB2 Error: unknown error (-1): execute: [Error message: Binding Values failed with message: MDB2 Error: not found] [Last executed query: SELECT * FROM contactgroups WHERE del<>1 AND user_id='23' ORDER BY name] [Native code: 0]
[11-Feb-2011 12:30:12 -0800]: DB Error: MDB2 Error: unknown error Query: execute: [Error message: Binding Values failed with message: MDB2 Error: not found] [Last executed query: SELECT * FROM contactgroups WHERE del<>1 AND user_id='23' ORDER BY name] [Native code: 0] in /home/www/roundcubemail-0.5.1-dep/program/include/rcube_mdb2.php on line 650 (GET /rc51/?_task=addressbook)
I would love to assist in resolving this. Are others *not* seeing the same behavior (disappearing addressbooks after 0.4.2!)
Benjamin _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
On Fri, 11 Feb 2011 12:37:13 -0800 (PST), ben@electricembers.net wrote:
[11-Feb-2011 12:30:12] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2/Driver/mysql.php on line 1190 [11-Feb-2011 12:30:12] MDB2 Error: not found (-4): [Error message: Unable to bind to missing placeholder: 1]
You are using old versions of PEAR packages. Use those included in Roundcube package.
On Sat, Feb 12, 2011 at 9:28 AM, A.L.E.C alec@alec.pl wrote:
On Fri, 11 Feb 2011 12:37:13 -0800 (PST), ben@electricembers.net wrote:
[11-Feb-2011 12:30:12] PHP Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2/Driver/mysql.php on line 1190 [11-Feb-2011 12:30:12] MDB2 Error: not found (-4): [Error message: Unable to bind to missing placeholder: 1]
You are using old versions of PEAR packages. Use those included in Roundcube package.
Is the include_path is messed up?
Wonder how though: http://trac.roundcube.net/browser/trunk/roundcubemail/program/include/iniset...
Till _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80