Post by Disea32 » Sun Jun 30, 2013 8:30 pm

Hello Team,

I am using OC 1.5.3.1
I have a problem with uploading the google base file, whenever I type:
http://www.stars-mode.fr/googlebase.xml

The page displays empty and its takes long to load. (I have over 4000 products) I generated my google base file using the google merchant's page. I have removed the & characters from all my products names but the problem persists, has anyone else had this same issue before?.

When I do not upload the googlebase.xml file to my ftp I get the 500 errors in the database and I see the logs:

Code: Select all

2013-06-29 17:15:59 - PHP Notice:  Error: Query execution was interrupted<br />Error No: 1317<br />SELECT   p.product_id,  pd.name,  GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories,  p.sku,  p.upc,  p.location,  p.quantity,  p.model,  m.name AS manufacturer,  p.image AS image_name,  p.shipping,  p.price,  p.points,  p.date_added,  p.date_modified,  p.date_available,  p.weight,  wc.unit,  p.length,  p.width,  p.height,  p.status,  p.tax_class_id,  p.viewed,  p.sort_order,  pd.language_id,  ua.keyword,  pd.description,   pd.meta_description,   pd.meta_keyword,   p.stock_status_id,   mc.unit AS length_unit,   p.subtract,   p.minimum,   GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related,   GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `sky_product` p LEFT JOIN `sky_product_description` pd ON p.product_id=pd.product_id   AND pd.language_id=2 LEFT JOIN `sky_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `sky_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `sky_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `sky_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id   AND wc.language_id=2 LEFT JOIN `sky_length_class_description` mc ON mc.length_class_id=p.length_class_id   AND mc.language_id=2 LEFT JOIN `sky_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `sky_product_tag` pt ON pt.product_id=p.product_id   AND pt.language_id=2 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;  in /homez.582/starsmod/www/system/database/mysql.php on line 49
2013-06-30 1:39:01 - PHP Warning:  unlink(/homez.582/starsmod/www/system/cache/cache.product.2.0.1.294c205aabc52664921909ece59fcb86.1372552741) [<a href='function.unlink'>function.unlink</a>]: No such file or directory in /homez.582/starsmod/www/system/library/cache.php on line 49
2013-06-30 1:40:04 - PHP Warning:  file_get_contents(/homez.582/starsmod/www/system/cache/cache.product.2.0.1.13eaec7e7fe9d231424708d3ae8b6973.1372552803) [<a href='function.file-get-contents'>function.file-get-contents</a>]: failed to open stream: No such file or directory in /homez.582/starsmod/www/system/library/cache.php on line 25
I guess this is because the feed may be to big that the server times out before showing it?

Thanks in advance for all the help.

Newbie

Posts

Joined
Sun Jun 30, 2013 8:18 pm
Who is online

Users browsing this forum: No registered users and 2 guests