[SOLVED] Database error 1054 ??

Once you've installed phpList Version 2... ask questions here!
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. This is for Version 2 of phpList (the orange one).

[SOLVED] Database error 1054 ??

Postby abdel65 » 3:20pm, Thu 09 May, 2013

Hi,

I am a newbie and need help, thanks.
I have a hostgator account and just installed PhpList using Fanatstico.

When I visit the the page "list of all users" , I get 2 error messages below:
1- Database error 1054 while doing query Unknown column 'confirmed' in 'where clause'
2- Database error 1054 while doing query Unknown column 'phplist_user_user.id' in 'field list'

And when I visit the the page "list membership" , I get 2 error messages below:
3- Database error 1054 while doing query Unknown column 'phplist_user_user.id' in 'where clause'
4- Database error 1054 while doing query Unknown column 'phplist_user_user.id' in 'field list'

So, can some one help me to resolve this issue please? many thanks.
abdel65
phpLister
 
Posts: 8
Joined: 2:58pm, Thu 09 May, 2013

Re: Database error 1054 ??

Postby Dragonrider » 4:34pm, Thu 09 May, 2013

This topic may hold the answer.
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 ??

Postby abdel65 » 9:13am, Fri 10 May, 2013

Dragonrider wrote:This topic may hold the answer.

Unfortunately it did not fix the problem. Any other suggestions please?
Anyway, thank you.
abdel65
phpLister
 
Posts: 8
Joined: 2:58pm, Thu 09 May, 2013

Re: Database error 1054 ??

Postby Dragonrider » 9:27am, Fri 10 May, 2013

Doing a search on Google proves that this is not specifically a phpList error but can affect a database no matter which program is accessing it.

One person seems to have solved his issue by deleting the database and installation and starting afresh. In fact just found a really old post here on the phpList forums that suggests the same.

Might be worth a try, also if it still continues to be an issue, try downloading from the source forge distrubtion and install phpList manually.
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 ?? (ISSUE FIXED)

Postby abdel65 » 1:29am, Sat 11 May, 2013

issue fixed, Fantastico was responsible, how?
phplist was installed using Fantastico in my Cpanel. I uninstalled it first then reinstalled it again, but this time using Quickinstall instead of Fantastico, and it worked.
Hope it will work for all of you too.
Have nice weekend.
abdel65
phpLister
 
Posts: 8
Joined: 2:58pm, Thu 09 May, 2013

Re: Database error 1054 ??

Postby Dragonrider » 6:35am, Sat 11 May, 2013

Good news, glad it's sorted.
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


Return to Question & Problems - after installing

Who is online

Users browsing this forum: No registered users and 3 guests