Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: wilgeno on October 19, 2010, 05:18:55 PM

Title: Upgrade to 0.4.2 not working
Post by: wilgeno on October 19, 2010, 05:18:55 PM
I am trying to upgrade from Roundcube 0.3 to 0.4.2. I followed all the upgrade steps to upgrade my install.  After that didn't work I decided to try a new install and use a new db. Both results in the same end result.  A blank screen

hit http://mail.trunkful.com/webmail and see.  Nothing - no source in view source. Just a blank page.

I've restarted Apache a few times. Cleared the sessions from the DB. Cleared my browser cache etc.

I've turned on logging and outputed it to the syslog. All I get is the same query trying to run.

SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = 'oontin19a1cuk8utt8fjuo4t23';

I have everything backed up so I can go back. That's not an issue.  I'd just like to be able to use the new version.

So what's going on here?:confused:
Title: Upgrade to 0.4.2 not working
Post by: SKaero on October 19, 2010, 08:53:25 PM
It must be a browser problem as the login shows up fine for me.
Title: Upgrade to 0.4.2 not working
Post by: wilgeno on October 19, 2010, 09:00:15 PM
Quote from: skaero;30810
It must be a browser problem as the login shows up fine for me.


Actually, I just switched back to 0.3.1 for a minute so I can get both versions running at the same time. Each using it's own DB.

Version 0.3.1
RoundCube Webmail :: Welcome to RoundCube Webmail (http://mail.trunkful.com/webmail/)

Version 0.4.2
http://mail.trunkful.com/webmail1/

Take a look again.
Title: Upgrade to 0.4.2 not working
Post by: SKaero on October 19, 2010, 09:48:09 PM
Can you turn on $rcmail_config['sql_debug'] in /config/main.inc.php and post the log?
Title: Upgrade to 0.4.2 not working
Post by: wilgeno on October 19, 2010, 10:14:04 PM
This is all it reports each time I try to load the page.

Oct 19 21:11:43 mail01 roundcube: query(1): SET NAMES 'utf8';
Oct 19 21:11:43 mail01 roundcube: query(1): SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = 'oontin19a1cuk8utt8fjuo4t23';

When I run the query in the mysql admin it returns 0 results. But the sess_id 'oontin19a1cuk8utt8fjuo4t23' is in the table.

Very odd - I've reverified the permissions and those are correct.

More oddities: When I use the mysql text based client and run this query I get 1 result as I would expect. But no results when I use phpMyadmin.
Title: Upgrade to 0.4.2 not working
Post by: SKaero on October 19, 2010, 10:39:31 PM
Is the session table using utf-8?
Title: Upgrade to 0.4.2 not working
Post by: wilgeno on October 20, 2010, 03:46:39 AM
The DB itself is utf8_general_ci.  The session table was created using the provided SQL script.  The session table is type InnoDB and is also utf8_general_ci.

The db and tables are setup the same for both versions.
Title: Upgrade to 0.4.2 not working
Post by: SKaero on October 20, 2010, 03:54:09 AM
Have you tried a fresh install of RoundCube 0.4.2?