Upgrade problem from 2.12 to 2.14 - Load list error

by MisteSanders, Wednesday, October 07, 2015, 05:22 (3291 days ago)

Upgrading from 2.12 to 2.14 everything works fine, that I can tell, everything seems functional. But when I click Settings I get a blank page with a red banner at the top that reads the following:

Load list error: error Internal Server Error

My log shows the following error:

Error PDOStatement: Unknown column 'items.source' in 'group statement'

Reverting back to my 2.12 install (I made a copy of it) presents no problems; Settings works fine. I'm running WAMP 2.5 with a MySQL database.

Any help solving this is appreciated.

Post reply
  5694 views

Upgrade problem from 2.12 to 2.14 - Load list error

by kereslas, Tuesday, November 17, 2015, 23:42 (3249 days ago) @ MisteSanders

To fix it, on file daos/mysql/Sources.php change:

  • Line 203
    FROM '.\F3::get('db_prefix').'items,
    to
    FROM '.\F3::get('db_prefix').'items AS items,

  • Line 205
    FROM '.\F3::get('db_prefix').'items
    to
    FROM '.\F3::get('db_prefix').'items AS items


I have submitted this fix to github, so I hope it will be fixed in future versions.

Post reply
  5164 views

Upgrade problem from 2.12 to 2.14 - Load list error

by MisteSanders, Thursday, December 03, 2015, 05:05 (3234 days ago) @ kereslas

Kereslas, that did the trick! Thanks a lot for helping out.

Post reply
  5134 views
RSS Feed of thread
powered by my little forum