Classifieds databaseAccess denied for user error

[pcgorilla]

No Configurations were made last night, but my entire classifieds section is down with the error on a white background

Could not connect to PhotoPost Classifieds databaseAccess denied for user xxxxx@'localhost' to database xxxxx

A bit scary since we go live tomorrow. What config file do I need to look at to fix?

it actually gives usernames but i placed the xxx's

[pcgorilla]

For some reason my database access has been denied. I fixed it but am now getting We're sorry, but the system experienced an unrecoverable error. Please try again later.

at Message - Eastvale Classifieds

I repaired all DB's and same error

[pcgorilla]

I try the admin and I get the same error

[Chuck S]

Well something definately happened to your database. If your logged in as admin you can run this query to set debug to display errors and it should tell you the error so we can assist you in how to fix it.

You need to do this using phpmyadmin or if your classifieds tables are in the vb database you can use the vb sql box in vb admin.

Content visible to verified customers only.

[pcgorilla]

I cannot access the Classifieds admin at all. Same message. Are you talking about the VB Admin?

I have a seperate database from VBulletin Forum

[Chuck S]

You need to login to vb as admin

You need to run that query in phpmyadmin then in your cpanel etc

You should then if you visit classifieds see the correct error.

[pcgorilla]

I ran the query in the PHP admin, same error and no difference. I ran it in the vbulletin Cpanel and got this message:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'eastval2_boards.cp_settings' doesn't exist

they are in seperate databases and I cannot access the admin cpanel of the classifieds..

[Chuck S]

If you ran the query on the right database in phpmyadmin and your classifieds tables are prefixed with cp_ and you log into vb as admin and show as logged in when viewing the classifieds you should indeed see your true error.

You can send server info admin info urls etc to the contact us link if you want us to take a look

[pcgorilla]

I followed the directions and see the same error. I will send info through contact info.

[pcgorilla]

I removed the line
if ( $User['adminedit'] == 1 )

from pp-inc and got this message

and here is my error:

Script:

Query: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,s.lastactivity,u.membergroupids FROM user u LEFT JOIN session s ON s.userid=u.userid WHERE u.userid=5

Result: Table 'eastval2_classifieds.user' doesn't exist

Database handle: Resource id #57

[pcgorilla]

On the above error, userID is me, logged in as I am user5. When I login as user 60, it changes to userid=60 , etc...

[Chuck S]

You have the wrong database information in your photopost config-inc.php file then.

There are two database portions there. The first one is classifieds database information and the second one is the forums. You must have changed both to the classifieds one trying to fix the intial error you where reporting not being able to connect to the classifieds database as now you cant connect to the forum.

[pcgorilla]

I just checked, I have both set up as follows

// PhotoPost Classifieds database host address, or leave as localhost
$host="localhost";

// PhotoPost Classifieds's database name
$database="CLASSIFIEDS DB NAME";

// MySQL username and password to access PhotoPost Classifieds's database
//
// These two variables are for the userid and password needed to access
// the PhotoPost Classifieds database named above.
$mysql_user="CLASSIFIED USERNAME";
$mysql_password="CLASSIFIED PASSWORD";

// User database host address, or leave as localhost
$host_bb="localhost";

// If you want to use a prefix for your database tables, enter it here.
// NOTE: This variable can only be set PRIOR to your first installation of PhotoPost Classifieds;
// existing databases will not be changed and you will be unable to connect if you change
// this variable after performing a default installation.
$pp_db_prefix = "cp_";

// User database MySQL database name
//
// This is the variable for the User Database; if you are using Internal
// as your registration system, then these variables are the same as the
// ones above. If you are linking to a message board system,
// thse variables should be set to the database, user and password for that
// database.
$database_bb="VBULLETIN DATABASE";

// MySQL username and password to access user database
//
// These two variables are for the userid and password needed to access
// the PhotoPost Classifieds or BB database.
$user_bb="VBULLETIN DATABASE USERNAME";
$password_bb="VBULLETIN PASSWORD";

[Chuck S]

That can not be so with the error posted here

Content visible to verified customers only.

That error tells me that your config information is telling classifieds to look into the classifieds database for the vb tables.

Make sure your ftp client is uploading the file if you have modified it.

[pcgorilla]

I verified all that. Can I email you my pp-inc and my config file?

[Chuck S]

Hello

Main Index - Eastvale Classifieds

Your issues where caused by something you modified in the code. I replaced default files and low and behold your operational.

[pcgorilla]

and THIS is why I made my switch to your product Chuck. Nice.

What default files did you replace? I just want to make sure it does not happen again. and if it does, I understand how to get it up.

[Chuck S]

Well I just replaced the default core php files

I would just suggest if you do modify your files hack or mod things whatever one wants to call it to make sure you keep a list of any files and such you modify. You could then replace just those to see if it helps. We can not say what hacks/mods will do to peoples code so bringing the files back to core defaults will of course always work and is what vbulletin or our company will tell you do to obtain product support.

[pcgorilla]

Good tip. Will do. Thanks again.

[Chuck S]

Not a problem glad to assist thats why I am here