selfoss support forum - PDOStatement: Duplicate column name 'updatetime'

PDOStatement: Duplicate column name 'updatetime' (reply)

AdVitam — Thu, 11 Sep 2014 13:58:42 +0000

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.

geobaev — Sat, 06 Sep 2014 05:31:48 +0000

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!

napo — Tue, 12 Aug 2014 10:37:48 +0000

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

banane4fun — Fri, 08 Aug 2014 20:35:34 +0000

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.