When I am trying to import a feed to the site midway through it goes to a page cannot be found page. When you go to the feed admin page it has imported some but not all of the products. For example the feed I have just tried to import had 809 feeds according to AWIN, but there is only 771 on the site!
Thank you, I tried the slow import tool which worked for the smaller feeds but the bigger ones kept showing this error midway through:
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/*****/public_html/shopping/includes/database.php on line 18
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/******/public_html/shopping/includes/database.php on line 27
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/******/public_html/shopping/includes/database.php on line 32
There are no registered CSV feeds to display.
Hi kimarie,
That could indicate a MySQL resource restriction - please could you enable Database Debug Mode by changing line 6 of config.advanced.php as follows;
$config_databaseDebugMode = TRUE;...and then try the procedure again. I recall seeing this before, and if the MySQL error displayed is "MySQL server has gone away", then to resolve this, edit includes/database.php and look for the following code on both lines 14 AND 47:
$link = @mysql_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword);...and REPLACE each instance with:
$link = @mysql_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword,TRUE);Don't forget to turn Database Debug Mode back to FALSE afterwards as the duplication filtering mechanism generates intentional database errors during import.
Cheers,
David.
While importing the products I got:
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@***.co.uk and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.
And I just tried again and got the same errors as last night.
Hi kimarie,
Could you perhaps email me a link to your site, and any password required for /admin/, plus the name of one of the feeds causing the problem, and if it's OK if I could then try the procedure myself so that I can see exactly where in the process it occurs that will help...
Thanks!
David.
Hi,
I went onto the page which lists all the merchants with the debug thing still on and it said the products table in mysql needed repaired, I done this in phpmyadmin and now they are all uploading fine. Would this have been the cause of the problem?
Hi there,
Yes - that will definitely be the cause.
All the best,
David.
Hi Kim,
That sounds like a web server imposed timeout - check out the following page for lots of information on handling timeouts importing larger feeds:
http://www.pricetapestry.com/node/582
...but in particular, have a go with the Slow Import Tool (all AWIN feeds are available in CSV as well as XML if you are currently using XML) which should help. Ideally of course importing from the command line if you have SSH access is best (details here)
If you're still not sure of course, email me a link to your site, any password required for /admin/, and I'll take a look for you...
Cheers,
David.