Error message - gallery gone

Scrapdango · May 24th, 2009, 12:31 PM

We are getting this error message when we try to access our gallery...

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'scrpdng_vb'@'localhost' (using password: YES) in /usr/home/scrpdng/public_html/gallery/pp-inc.php on line 185
I cannot connect to the PhotoPost database. [$php_errormsg]

What do we need to do?

Chuck S · May 24th, 2009, 01:49 PM

have you recently changed your mysql database access?

The information in your config-inc.php for the database is incorrect it would appear by that error.

Scrapdango · May 24th, 2009, 08:11 PM

We didn't change anything but we did do a vbulletin upgrade and wonder if it happened during that. I'm really not sure how to check what you suggest, how do we go about finding out if the mysql database was changed & if so can you give us more info on how we fix it?

Chuck S · May 25th, 2009, 07:44 AM

You need to look in your photopost directory and make sure that the information in the config-inc.php file is correct for accessing the photopost and vbulletin database.

Scrapdango · May 25th, 2009, 12:02 PM

Where can I find the information to know what is correct?

Chuck S · May 25th, 2009, 04:33 PM

Well your server control panel in your hosting setup has the mysql info. If your photopost is installed in the same database as vbulletin you can find the proper info also in your vbulletin config.php file in there includes subdirectory of the forum files.

Scrapdango · May 26th, 2009, 06:36 AM

Can you please tell me exactly what information I am looking for to match? I have looked at both files & at first glance they appear to have the same database info in each. The only difference being the password & I'm not sure if both photopost & vbulletin would have the same password.

Thanks!

Chuck S · May 26th, 2009, 09:49 AM

If the Photopost mysql tables are in the vbulletin database they would definately have the same password.

My suggestion is since your trying to access the vb database then you need to make sure you have the correct mysql user and password entered in your photopost config-inc.php file. You say you recently updated vbulletin well apparently whom ever you had do the work changed your mysql password and caused this issue.

Scrapdango · May 26th, 2009, 09:57 AM

Okay, I changed the password so it's the same as in the vb database & I still get this error message: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'scrpdng_vb'@'localhost' (using password: YES) in /usr/home/scrpdng/public_html/gallery/pp-inc.php on line 185
I cannot connect to the PhotoPost database. [$php_errormsg]

Chuck S · May 26th, 2009, 10:16 AM

Okay relook at your vb config file. You want to compare these things and set accordingly in your vb config file.

mysql host

mysql database

mysql user

mysql password

These all must be exact to work

Scrapdango · May 26th, 2009, 10:38 AM

Everything looks identical to me. I'm lost.

Chuck S · May 26th, 2009, 11:51 AM

They can not be. Feel free to send ftp information to the contact us link in our header.

Scrapdango · May 26th, 2009, 01:48 PM

Thank you! I just sent the info!

Chuck S · May 26th, 2009, 02:14 PM

No problem I will respond via that email then.

Scrapdango · May 26th, 2009, 05:38 PM

Thank you so much for all your help Chuck! You're a lifesaver! Our gallery is back up & running thanks to you!!

During all this our Featured Photos Display disappeared & I have no idea where the settings for that are! Can you please help?? Thanks again!

Chuck S · May 26th, 2009, 09:33 PM

http://www.photopost.com/forum/photo...3-5-3-8-a.html

If your referring to how to show it on your forum this should help you fix that

Scrapdango · May 27th, 2009, 03:59 AM

Thanks Chuck. The plug-in has been installed since we first installed photopost & vb & it had worked perfectly, but I'm assuming this last vb upgrade is what is causing things to go wonky & why it's not showing on our forums anymore. I'm a little confused on where to begin since the plug-in is already installed & had been working?

Thanks for any advice & help you can offer.

Chuck S · May 27th, 2009, 10:36 AM

My suggestion is to look in your vb admin under the plugin section. There should be a plugin there.

Just go through install the plugin and edit that forumhome template.

Scrapdango · May 27th, 2009, 11:52 AM

Here is what I see in the Admin CP:

Product vBulletin
Hook Location forumhome_complete
Title Photopost Featured Photos
Execution Order 5
Plugin PHP Code include('../gallery/inc_features.php');
Plugin is Active Yes

Down at the bottom:
Plugin PHP Code
include('../gallery/inc_features.php');

I'm not sure where to go from here since it states that the plugin is active but it's not showing up on the forums.

Thanks Chuck.

Chuck S · May 27th, 2009, 11:55 AM

Under your styles admin have you edited the forumhome template and placed this code where noted in the instructions?

Code:

Content visible to verified customers only.