Author Topic: Upgrade to 0.4.2 not working  (Read 3599 times)

Offline wilgeno

  • Newbie
  • *
  • Posts: 4
Upgrade to 0.4.2 not working
« 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:
« Last Edit: October 19, 2010, 09:02:13 PM by wilgeno »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Upgrade to 0.4.2 not working
« Reply #1 on: October 19, 2010, 08:53:25 PM »
It must be a browser problem as the login shows up fine for me.

Offline wilgeno

  • Newbie
  • *
  • Posts: 4
Upgrade to 0.4.2 not working
« Reply #2 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

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

Take a look again.
« Last Edit: October 20, 2010, 04:13:59 AM by wilgeno »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Upgrade to 0.4.2 not working
« Reply #3 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?

Offline wilgeno

  • Newbie
  • *
  • Posts: 4
Upgrade to 0.4.2 not working
« Reply #4 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.
« Last Edit: October 19, 2010, 10:25:31 PM by wilgeno »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Upgrade to 0.4.2 not working
« Reply #5 on: October 19, 2010, 10:39:31 PM »
Is the session table using utf-8?

Offline wilgeno

  • Newbie
  • *
  • Posts: 4
Upgrade to 0.4.2 not working
« Reply #6 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.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Upgrade to 0.4.2 not working
« Reply #7 on: October 20, 2010, 03:54:09 AM »
Have you tried a fresh install of RoundCube 0.4.2?