Page 1 of 1

Database error 1054 after upgrading

PostPosted: 4:31pm, Wed 04 Sep, 2013
by brianstorm
Hi,

I've just upgraded (to v 3.0.2 )and it seemed proceed as expected (inc db upgrade), but I can't see any of my lists, and there are several errors on the check database page.

When I go to view my lists this is the reported error:
Database error 1054 while doing query Unknown column 'category' in 'order clause'

Users seem to be all present and correct. I can login as admin and send test mail.

Can anyone suggest how I might fix this error.,, Help much apprecciated.

Many thanks

Re: Database error 1054 after upgrading

PostPosted: 6:38pm, Wed 04 Sep, 2013
by Sven2157
Caching problem ...

Close your browser. Then open it, and go to your settings to clear all browser cache ... Try again, if it doesn't work the first, second or third time.

If after several failed attempts, there may be a problem somewhere else.

Sven2157

Re: Database error 1054 after upgrading

PostPosted: 9:04am, Thu 05 Sep, 2013
by brianstorm
Hi,

thanks for the suggestion. that doesn't seem to have fixed my problem. It appears that new users can still subscribe (via a form on the website, rather than directly on the phplist subscribe page)...

I'm looking at the category section and wondering about that. It seems new, and this is what I see when visiting the lists page:


subscriber lists
Categorise listsAdd a list
Database error 1054 while doing query Unknown column 'category' in 'field list'

Uncategorised

Database error 1054 while doing query Unknown column 'category' in 'where clause'

Lists
Database error 1054 while doing query Unknown column 'category' in 'where clause'
No lists, use Add List to add one


Does anyone have any further suggestions?

Thanks

Re: Database error 1054 after upgrading

PostPosted: 9:59am, Thu 05 Sep, 2013
by Dragonrider
Did you upgrade your database after upgrading to 3.0.2? There's a link to check this on the admin pages, System>Update phpList This link actually checks that the database has been upgraded to 3.0.2 as there are a number of extra fields from 2.10.x and probably from 2.11.x as well.

The actual error number (1054) just means that the database table phplist_list is missing "category" from it's fields. Sounds to me like the db hasn't updated.

Re: Database error 1054 after upgrading

PostPosted: 1:26pm, Thu 05 Sep, 2013
by brianstorm
Thanks for the reply. I did run the database upgrade (from 2.10.17 to 3.0.2) and it said it completed. I have upgraded several times in the past successfully and followed the upgrade instructions, which seemed similar to previous upgrades.

There are errors when I verify the db structure.

I have cured one fault (no lists available), by manually adding the field "category" to the table "phplist_list".

I guess I'll have to manually work my way through and see whats missing....

Re: Database error 1054 after upgrading

PostPosted: 12:56pm, Thu 03 Oct, 2013
by pjeutr
I also had 1054 errors after upgrading 2.10.7 to 3.0.5 , during the update I saw some errors passing by, but it was to quick to really notice.
Turned out my dbuser in phplist was missing ALTER permissions for the table. So I altered the user, also adding INDEX. Reran the upgrade and everything was ok.

Re: Database error 1054 after upgrading

PostPosted: 11:43am, Tue 03 Feb, 2015
by rani123
I am having same issue, when upgrading my phplist version 2.10 to 3
Can any one please share that how to solve this issue ?