Database error 1054 after upgrading

Questions & Problems about Installing or Upgrading with Version 3 phpList.
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

Database error 1054 after upgrading

Postby brianstorm » 4:31pm, Wed 04 Sep, 2013

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
Last edited by brianstorm on 1:44pm, Thu 05 Sep, 2013, edited 1 time in total.
Replacement Projector Lamps & Accessories in the UK
http://www.london-projectors.co.uk/projector-lamps.php
brianstorm
PL Geek
 
Posts: 138
Joined: 9:12am, Fri 26 Jun, 2009

Re: Database error 1054 after upgrading

Postby Sven2157 » 6:38pm, Wed 04 Sep, 2013

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
Sven2157
PL Master
 
Posts: 170
Joined: 12:18pm, Fri 07 Jun, 2013

Re: Database error 1054 after upgrading

Postby brianstorm » 9:04am, Thu 05 Sep, 2013

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
Replacement Projector Lamps & Accessories in the UK
http://www.london-projectors.co.uk/projector-lamps.php
brianstorm
PL Geek
 
Posts: 138
Joined: 9:12am, Fri 26 Jun, 2009

Re: Database error 1054 after upgrading

Postby Dragonrider » 9:59am, Thu 05 Sep, 2013

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.
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Re: Database error 1054 after upgrading

Postby brianstorm » 1:26pm, Thu 05 Sep, 2013

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....
Replacement Projector Lamps & Accessories in the UK
http://www.london-projectors.co.uk/projector-lamps.php
brianstorm
PL Geek
 
Posts: 138
Joined: 9:12am, Fri 26 Jun, 2009

Re: Database error 1054 after upgrading

Postby pjeutr » 12:56pm, Thu 03 Oct, 2013

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.
pjeutr
phpList newbie
 
Posts: 4
Joined: 9:39am, Mon 31 Mar, 2008

Re: Database error 1054 after upgrading

Postby rani123 » 11:43am, Tue 03 Feb, 2015

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 ?
rani123
phpList newbie
 
Posts: 1
Joined: 11:36am, Tue 03 Feb, 2015


Return to Installing and Upgrading

Who is online

Users browsing this forum: No registered users and 1 guest

cron