Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. Upgrade 4.1.6 to 5.1.2 (Mysql error)

Upgrade 4.1.6 to 5.1.2 (Mysql error)

1 Sep 20, 2014 03:17    

Hi,
Problem with upgrading. Should have should be done a 2-step upgrading (but with which version?)
Thanks
Mel

Verification de la version du schema BD... 10975 : OK.
Adding new countries... OK.
Upgrading message thread statuses table... OK.
Upgrading Item Settings...

MySQL error!

Unknown column 'post_double1' in 'field list'(Errno=1054)

Your query:

INSERT INTO evo2_items__item_settings( iset_item_ID, iset_name, iset_value )

SELECT post_ID, 'custom_double1', post_double1

  FROM evo2_items__item

 WHERE post_double1 IS NOT NULL UNION

SELECT post_ID, 'custom_double2', post_double2

  FROM evo2_items__item

 WHERE post_double2 IS NOT NULL UNION

SELECT post_ID, 'custom_double3', post_double3

  FROM evo2_items__item

 WHERE post_double3 IS NOT NULL UNION

SELECT post_ID, 'custom_double4', post_double4

  FROM evo2_items__item

 WHERE post_double4 IS NOT NULL UNION

SELECT post_ID, 'custom_double5', post_double5

  FROM evo2_items__item

 WHERE post_double5 IS NOT NULL UNION

SELECT post_ID, 'custom_varchar1', post_varchar1

  FROM evo2_items__item

 WHERE post_varchar1 IS NOT NULL UNION

SELECT post_ID, 'custom_varchar2', post_varchar2

  FROM evo2_items__item

 WHERE post_varchar2 IS NOT NULL UNION

SELECT post_ID, 'custom_varchar3', post_varchar3

  FROM evo2_items__item

 WHERE post_varchar3 IS NOT NULL</code>
<code>     debug_die( "<p class="error">MySQL error!</p>\n<div><p><strong>Unknown column 'post_double1' in 'field list'(Errno=1054)</strong></p>\n<p class="error">Your query: </p><pre>INSERT INTO evo2_items__item_settings( iset_item_ID, iset_name, iset_value )<br />\nSELECT po?" )
    File: /var/www/vhosts/science24heures.com/httpdocs/comm/inc/_core/model/db/_db.class.php on line 668
    DB->print_error( "", "", "" )
    File: /var/www/vhosts/science24heures.com/httpdocs/comm/inc/_core/model/db/_db.class.php on line 881
    DB->query( "INSERT INTO T_items__item_settings( iset_item_ID, iset_name, iset_value ) SELECT post_ID, 'custom_double1', post_double1\n FROM T_items__item WHERE post_double1 IS NOT NULL UNION SELECT post_ID, 'custom_double2', post_double2\n FROM T_items_?" )
    File: /var/www/vhosts/science24heures.com/httpdocs/comm/install/_functions_evoupgrade.php on line 3853
    upgrade_b2evo_tables( "evoupgrade" )
    File: /var/www/vhosts/science24heures.com/httpdocs/comm/install/index.php on line 774

Ignored last: 1

Back to top

2 Sep 20, 2014 04:20

I guess, it should be first updated to the last 4.1.x version. This is - if I'm right - version 4.1.7.

I have updated from the last 4.1.x to the first stable 5.0.6 and just some days ago to the 5.1.2. It needs between 3-5 times (I can't remember exactly) to update the db. After this many times, all other things works fine.

Back to top

3 Sep 20, 2014 06:15

You mean run installer 3-5 times on 5.0.6?
I try to 4.1.7, this is fine, there is no database change. Now, I'm stuck at 5.0.6 with the same error.

Back to top

4 Sep 20, 2014 14:38

Yes,
I meant to run the database updater (within the install.php) more than one times. I needed to run it almost 5 times.
It updated step by step the version until the last version of database is ready.

Back to top

5 Sep 21, 2014 04:44

Hi
I re-run many times. It's true I had some progression, but now, I'm stuck at "session table" and it doesn't seems to go further. I'm at quite more than 5 tentatives... I don't know what I should do.
Thanks

Back to top

6 Sep 21, 2014 20:03

What is the exact name of the table?
What is the exact error message you get?

Back to top

7 Sep 21, 2014 23:07

It's "sessions" table.

Loading module: _core/model/__core.install.php
Loading module: collections/model/_collections.install.php
Loading module: files/model/_files.install.php
Loading module: sessions/model/_sessions.install.php
Loading module: messaging/model/_messaging.install.php
Loading module: maintenance/model/_maintenance.install.php

Verification de la version du schema BD... 10900 : OK.
Upgrading Locales table... OK.
Upgrading general settings table... OK.
Upgrading sessions table... MySQL error!

Unknown column 'sess_lastseen' in 'where clause'(Errno=1054)

Your query:

UPDATE evo2_sessions SET sess_lastseen = concat( '2000-01-01 ', time( sess_lastseen ) )

 WHERE date( sess_lastseen ) = '1970-01-01'
     debug_die( "<p class="error">MySQL error!</p>\n<div><p><strong>Unknown column 'sess_lastseen' in 'where clause'(Errno=1054)</strong></p>\n<p class="error">Your query: </p><pre>UPDATE evo2_sessions SET sess_lastseen = concat( '2000-01-01 ', time( sess_lastseen ) )<br?" )
    File: /multimedia/sites/test/b2evo-5.0.6/inc/_core/model/db/_db.class.php on line 664
    DB->print_error( "", "", "" )
    File: /multimedia/sites/test/b2evo-5.0.6/inc/_core/model/db/_db.class.php on line 877
    DB->query( "UPDATE T_sessions SET sess_lastseen = concat( '2000-01-01 ', time( sess_lastseen ) )\n WHERE date( sess_lastseen ) = '1970-01-01'" )
    File: /multimedia/sites/test/b2evo-5.0.6/install/_functions_evoupgrade.php on line 3750
    upgrade_b2evo_tables( "evoupgrade" )
    File: /multimedia/sites/test/b2evo-5.0.6/install/index.php on line 739

Ignored last: 1

Back to top

8 Sep 22, 2014 00:16

Hm,
I haven't had this kind of error.

My suggestion:
1. Make a backup of your DB (you can use mySQLDumper - http://www.mysqldumper.de/ - for it).
2. You did made a backup of your DB? Else -> 1.
3. Delete the content of your table sessions, not the table itself.
4. Try to update with this.

Will this works and you don't need the content of this table (I don't know what the content will be, I guess the statistic thing) than it is ok.
Will this works but you need the content of the table - maybe you can import it from your DB-backup (should be possible with mysqldumper).

Have success.

Back to top

9 Sep 22, 2014 01:27

It was already empty (took too much space to backup, so I clean it before). Anyway, with or without data, I'm stuck at the same error.

Back to top

10 Sep 22, 2014 19:05

I'm guessing again:

Errno 1054 means, there is something unknown ( https://search.oracle.com/search/search?q=errno+1054&group=MySQL&x=0&y=0 and http://www.ahfb2000.com/threads/6429-mySQL-and-PHP-1054-error ).
So, maybe this column will exist since you have tried a lot - or why there are plug ins.

Maybe you should deactivate all third party plug ins. This could help too.

If you have a backup of you db - and only then - you can try to delete the named column. If after this there will be the same errno in the next try to upgrade, I guess there is something wrong with your version of the upgrade script.

I have upgraded from a 4.1.2 (if saw it now) to the 5.0.6 and after this to the 5.1.2. It needs more cycles of upgrading the DB. The only one error I got at the thing with the "evo_track__keyphrase" if I converted the DB to utf-8 ( http://forums.b2evolution.net/upgrade-script-for-db-to-utf-8-the ).

Back to top


Form is loading...