Hi,
my server got reloaded and now I have several issues.
I get this import warning: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/bestetes/public_html/nintendo/includes/database.php on line 27
The database is repaired, but the warning stays.
You can check it here:
{link saved}
I allready set $config_databaseDebugMode = TRUE;
Hi,
The strange thing it happened to one PT install. I have an exactly same one (copy) and this hasn't the problem.
I was thinking about doing the setup again first.
Is it just the following?
1. Database tool Backup
2. Running setup.php
3. Database tool Restore
4. Import feeds
Or even drop the table first in phpmyadmin so that the table is build again?
Hi Marco,
Yes, make sure that you are running setup.php against an empty database (no tables)...
Cheers,
David.
--
PriceTapestry.com
Hi,
I did the setup again but the error was still there.
But I gave your input to the host and they run a myisamcheck on the database tables and now it goes smoothly again.
Thanks a lot.
Hi Marco,
The database debug output is reporting the little understood i'm afraid "MySQL Server has Gone away" error, which occurs when PHP thinks it still has a database connection open (and so tries to reuse it, but it has failed).
I have found that this can sometimes be fixed either with a mysql_ping() call, or if not a modification to make sure that the database is closed and re-opened for each call. Both changes are documented in sequence in the following thread so that you can try the mysql_ping() on its own first, or the close / re-open if necessary if that doesn't do the trick..
http://www.pricetapestry.com/node/3861#comment-15583
Cheers,
David.
--
PriceTapestry.com