Upgrade problem from 2.12 to 2.14 - Load list error

by MisteSanders, (3751 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.

Upgrade problem from 2.12 to 2.14 - Load list error

by kereslas, (3709 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.

Upgrade problem from 2.12 to 2.14 - Load list error

by MisteSanders, (3694 days ago) @ kereslas

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

RSS Feed of thread