Hi Dave, Does Price Tapestry (as supplied) work smoothly with PHP 5.0?
My web host upgraded to PHP 5.0 and I am having problems importing many feeds. Went to the error logs and found that there are more problems than I realize. They seem to all be related to includes/database.php.
I can't remember if I ever made modifications, so, I thought I would ask you first.
Thanks, Diana
Errors:
PHP Warning mysql_fetch_array() supplied argument is not a valid MySQL result resource in /hermes/bosweb/web201/b2010/apo.login/site.com/directory/includes/database.php on line 21 ( and line 26)
PHP Warning mysql_query() supplied argument is not a valid MySQL-Link resource in /hermes/bosweb/web201/b2010/apo.login/site.com/directory/includes/database.php on line 17Includes/database.php
{code saved}
Checking database connection...PASS
Checking database selection...PASS
Checking database tables...PASS
Setup Completed!
Using PHP Version 5.2.4
Using MySQL Version 5.0.45-log
Based on your thoughts, I will first setup a new database. As I said, the webhost made some major changes, some of which involved Mysql and PHP, and moving databases. If that does not work, I will contact them re: database connection / authentication error, before I bother you.
The rest of the site seems ok, except the link in Admin called Admin Home now goes to the directory home page. It appears this is because the link leaves off "index.php". It ends with admin/.
If you can tell me where I can fix that, that would be great.
Diana
Hi Diana,
That would indicate that the new configuration does not have index.php registered as a directory index file. The best thing to do would be to add it in a .htaccess file in /admin/ containing the following line:
DirectoryIndex index.phpCheers,
David.
Hi Diana,
There are no known issues with PHP5 - I run test servers on both versions to make sure the script is always working correctly.
The error message is indicating a database connection / authentication error ("not a valid MySQL-Link resource....") but since you mentioned that it is only applying to the importing of some feeds; I guess the majority of your site (including the front end) is working ok?
Can you first browse to setup.php and let me know the outcome of the 3 database tests that are performed when browsing to that script?
Cheers,
David.