Errors in roundcube log after upgrade from 0.72 to 1.0

[entropicsinkhole]

MySQL 5.5.8 with RC version 1.  Suggestions, anyone?

Types of errors I'm getting: 

#1 --> DB Error: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as t1 join  as t2 on t1.user_id = t2.user_id where t1.username='username@mydomain.co' at line 1 (SQL Query: SELECT t2.email FROM  as t1 join  as t2 on t1.user_id = t2.user_id where t1.username='username@mydomain.com' and t2.standard=1) in D:\xampp\htdocs\RCMail\program\lib\Roundcube\rcube_db.php on line 465 (GET /RCmail/?_task=logout)

#2 -->  PHP Deprecated:  Assigning the return value of new by reference is deprecated in D:\xampp\php\PEAR\Mail.php on line 154

#3 -->DB Error: [1054] Unknown column 'expires' in 'where clause' (SQL Query: DELETE FROM cache WHERE expires < now()) in D:\xampp\htdocs\RCMail\program\lib\Roundcube\rcube_db.php on line 465 (GET /RCmail/?_task=mail)

[SKaero]

Did you upgrade the database?

[entropicsinkhole]

Yep.  It prompted to upgrade the database when I ran the web-based upgrade.  No error messages or indication that it didn't run.  Is there something else I can run to verify it was successfully upgraded?  I can access Roundcube fine, but there are some plugins that seem to be looking for fields or tables that don't exist.  Couldn't find any documentation on what tables/fields I should be seeing in mysql, to verify.


EDIT -- I re-ran the web upgrade and *did* get a database schema upgrade failed error (attached below), but I'm not sure if the errors are just because I already successfully updated.  I verified (via index.php) file that it recognizes my version as 1.0RC

Should I manually create tables/fields? Any script I can manually run?

[entropicsinkhole]

Alright, figured it out. 

I manually ran the last two sql scripts under SQL\mysql using phpmyadmin (2013052500.sql and 2013061000.sql, in case it's useful to someone). 

Now, off to see if this fixes a couple of plugin issues too

[entropicsinkhole]

Got rid of third error, but still have the following:

#1 --> DB Error: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as t1 join  as t2 on t1.user_id = t2.user_id where t1.username='username@mydomain.co' at line 1 (SQL Query: SELECT t2.email FROM  as t1 join  as t2 on t1.user_id = t2.user_id where t1.username='username@mydomain.com' and t2.standard=1) in D:\xampp\htdocs\RCMail\program\lib\Roundcube\rcube_db.php on line 465 (GET /RCmail/?_task=logout)

#2 -->  PHP Deprecated:  Assigning the return value of new by reference is deprecated in D:\xampp\php\PEAR\Mail.php on line 154

[SKaero]

1. Are all plugins disabled when you are getting this error?
2. Your using a shared PEAR library if you download the full RoundCube package (not the GPL dependent version) it should load a newer version that doesn't have the deprecated warring.

[entropicsinkhole]

Thanks SKaero,

1)  No, they're not.  I'll start disabling them and see if one is responsible.
2) I did an upgrade, so maybe it doesn't update the PEAR library?  Anyway, I removed the ampersand (&) in front of new on line 154 in Mail.php and that got rid of the error. 

[entropicsinkhole]

And the problem was the logout_redirect plugin.  I downloaded a new from here:  http://notes.sagredo.eu/node/35#logout_redirect

Now I am error-free!