error above admin panel

[calvorn]

New install of 5.5 seemed to go well until I got to the admin panel where I see the following above the admin login in


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/nycaphoto/www/www/photopost/forums/vb3.php on line 341

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/nycaphoto/www/www/photopost/forums/vb3.php on line 32

If I just click the submit button I get this:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'nycaphoto@server325.com' (Using password: YES) in /home/nycaphoto/www/www/photopost/pp-inc.php on line 185
I cannot connect to the PhotoPost database. [$php_errormsg]

usernames and passwords seem to be ok and vb and photopost are in the same database. I am using mySQL 5 and had a bit of a problem installing vb because localhost no longer works. My ISP told me to use these lines for host address instead of localhost:

ini_set('mysql.default_socket', '/tmp/mysql5.sock');
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3307;

Any ideas?

[calvorn]

We have checked the issue, and it appears that the port to that MySQL database service is hard-coded in the scripts and is not configurable.

We have changed the following line in your /www/www/photopost/pp-inc.php file:

$link = mysql_connect("$host:3306", "$mysql_user", "$mysql_password") or die ('I cannot connect to the PhotoPost database. [$php_errormsg]');
to
$link = mysql_connect("$host", "$mysql_user", "$mysql_password") or die ('I cannot connect to the PhotoPost database. [$php_errormsg]');

and the error is not displayed any more.

However, there is another issue with PhotoPost and MySQL 5, now the script produces the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/nycaphoto/www/www/photopost/forums/vb3.php on line 32

We have found the following thread which provides more information on the issue:

Mysql 5 Compatibility

According to Chuck S (Photopost Developer):

"MySQL 5.0 and higher have a strict mode that is currently incompatible with a number of queries in PhotoPost products. The Windows Installer from MySQL.com enables this strict mode by default.

In Layman's terms MySQL in strict mode can not allow query inserts with null values to be entered."

Unfortunately, the suggested workarounds do not work on our servers. You can start using MySQL4 and change the line above back or you can contact the developers of PhotoPost for more information.

Thank you.

[Chuck S]

Content visible to verified customers only.

That error has nothing to do with mysql5. You can rerun install and input all the proper info to connect to vbulletin. Right now as it stands on step 4 you did not enter the correct vbulletin mysql table prefix to do the queries. There are many posts here on this as it is the most common installation blunder. You must enter in the config portion of the install the correct user database info and on step 4 enter the correct info asked.