Page 1 of 1

Database errror: Config file and database different names?

PostPosted: 11:14am, Sat 20 Dec, 2014
by AlternativePhoto
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! :-)

Re: Database errror: Config file and database different name

PostPosted: 11:52am, Sat 20 Dec, 2014
by Dragonrider

Re: Database errror: Config file and database different name

PostPosted: 1:32pm, Sat 20 Dec, 2014
by AlternativePhoto
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. :-)

Re: Database errror: Config file and database different name

PostPosted: 1:44pm, Sat 20 Dec, 2014
by Dragonrider
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

Re: Database errror: Config file and database different name

PostPosted: 1:51pm, Sat 20 Dec, 2014
by AlternativePhoto
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!) :-)

Re: Database errror: Config file and database different name

PostPosted: 2:04pm, Sat 20 Dec, 2014
by AlternativePhoto
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...

Re: Database errror: Config file and database different name

PostPosted: 10:19pm, Sat 20 Dec, 2014
by Dragonrider
SSL??? Should be SQL...

Just substitute the database table, see my reply to your PM. :wink: