Database errror: Config file and database different names?

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 errror: Config file and database different names?

Postby AlternativePhoto » 11:14am, Sat 20 Dec, 2014

Hi,
I've upgraded to 3.10, but it can't find the database.
The database is called malinfab_plst01
And the config file says this:
# what is the name of the database we are using
(dollarsign)database_name = "malinfab_plst01";

# what user has access to this database
(dollarsign)database_user = "malinfab_plst01";

But this error comes up:
Database error 1146 while doing query Table 'malinfab_plst01.phplist_user_user' doesn't exist
Database error 1054 while doing query Unknown column 'id' in 'field list'

I am a real "dummy" on this sort of stuff, so I really appreciate any help on the subject! :-)
AlternativePhoto
phpLister
 
Posts: 12
Joined: 4:37pm, Wed 05 Jan, 2011

Re: Database errror: Config file and database different name

Postby Dragonrider » 11:52am, Sat 20 Dec, 2014

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 errror: Config file and database different name

Postby AlternativePhoto » 1:32pm, Sat 20 Dec, 2014

Thanks.
I did to the initialise database. It seemed to work.
The error I get is not EXACTLY the same as the ones you describe below.
Mine is
Database error 1146 while doing query Table 'malinfab_plst01.phplist_user_user'
It’s similar to:
1d. Database Error 1146 Database error 1146 while doing query Table 'database.phplist_user_blacklist_data' doesn't exist.
I will attempt to do this, but where do i find this “Apply the code below to your phpList database using phpMyAdmin”. I can’t see it in one of the menus. :-)
AlternativePhoto
phpLister
 
Posts: 12
Joined: 4:37pm, Wed 05 Jan, 2011

Re: Database errror: Config file and database different name

Postby Dragonrider » 1:44pm, Sat 20 Dec, 2014

phpMyAdmin?

This is on your server, not phpList.

Log in to your server admin control panel (Cpanel/Plesk) look under the database area, look for phpMyAdmin, find your phplist database and apply the fix in the SQL section.

If this is too complicated for your experience, ask host if they could do it for you, otherwise find a more experienced friend (or trusted expert) to do it for you. Once logged in an expert should only need 5-10 minutes to apply the fix. They may of course reserve the right to make a charge for their time.

There is also a pretty good tutorial on siteground.com
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 errror: Config file and database different name

Postby AlternativePhoto » 1:51pm, Sat 20 Dec, 2014

When i click on SQL it says
“Run SSL query on database”
Is that where i input the code?
(Yes, to me this IS VERY complicated!) :-)
AlternativePhoto
phpLister
 
Posts: 12
Joined: 4:37pm, Wed 05 Jan, 2011

Re: Database errror: Config file and database different name

Postby AlternativePhoto » 2:04pm, Sat 20 Dec, 2014

I'm wondering if the code will work, because it's not "user_blacklist_data" that is my error, it's "user_user"...?
I'm in over my head here...
AlternativePhoto
phpLister
 
Posts: 12
Joined: 4:37pm, Wed 05 Jan, 2011

Re: Database errror: Config file and database different name

Postby Dragonrider » 10:19pm, Sat 20 Dec, 2014

SSL??? Should be SQL...

Just substitute the database table, see my reply to your PM. :wink:
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 Installing and Upgrading

Who is online

Users browsing this forum: No registered users and 2 guests

cron