PDOStatement: Duplicate column name 'updatetime'

by banane4fun, Friday, August 08, 2014, 22:35 (3333 days ago)

Hi there,

I have a small problem after the upgrade from 2.10 to 2.11

PDOStatement: Duplicate column name 'updatetime'

I've looked into the database, but I could not find a duplicate column. Any ideas anyone?

very thx.

PDOStatement: Duplicate column name 'updatetime'

by napo, Tuesday, August 12, 2014, 12:37 (3330 days ago) @ banane4fun

I had exactly the same problem. So I return to 2.10 waiting to see if other people had the same problem :-)

PDOStatement: Duplicate column name 'updatetime'

by geobaev, Saturday, September 06, 2014, 07:31 (3305 days ago) @ napo

This problem still exists in 2.12 . Could you please fix this bug? I can't update to newer versions and I am stuck at version 2.10. Thank you!

PDOStatement: Duplicate column name 'updatetime'

by AdVitam, Thursday, September 11, 2014, 15:58 (3299 days ago) @ geobaev

It look like to be a problem when the selfoss db is in 3 or 4 version (in selfoss database, table version) and want to update to the last db version.

To avoid the problem in daos/mysql/Database.php

Comment the line 134 like this :

/* \F3::get('db')->exec('
ALTER TABLE '.\F3::get('db_prefix').'items ADD updatetime DATETIME;
'); */

After i need to give "super" privilege to the selfoss db user (just 1 time), reload the page and remove the "super" privilege.

RSS Feed of thread
powered by my little forum