Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

OK, help needed again, I can get all items downloaded using the Google Merchant Feed now in 5 files. The first two are 1500 each and are ok to use. The 3, 4, and 5th xml files downloaded have a problem. Each item, instead of all column entries being on one line, the first three column entries are lined up in a row but the rest drop one cell for each column. So those three .xml files have 14 lines for each item. They look like this:

1 heading heading heading heading heading heading heading and so on.....
2 item.......entry.......entry
3 .......................................decription
4 .....................................................url
5 ..................................................................image
6 ...............................................................................p rice
and so on...

(Without the dots, had to insert them on here to make it look like the file does, they don't exactly line up on here like they should.)

hopefully you can get the idea. Each item is this way, 14 total lines for each item instead of just one.
The column headings are ok but the entries for each product drop on cell for each column.

Anyone have any ideas why this is happening? I use Excel2003 and after I download each file and move it to my desktop I open Excel and use File/Open to open the xml file.

Thanks for any ideas anyone can give me,

Jim

Configuration->Google Merchant Center Feeder Configuration page
error: PHP Fatal error: Call to undefined function google_cfg_pull_down_country_list() in /home/obsbscom/cellphone-express.com/gli/configuration.php(217) : eval()'d code on line 1
search the plugin folder by xsearch, the string google_cfg_pull_down_country_list appeared in install.sql only.

Quote:

---

Originally Posted by su35

Configuration->Google Merchant Center Feeder Configuration page
error: PHP Fatal error: Call to undefined function google_cfg_pull_down_country_list() in /home/obsbscom/cellphone-express.com/gli/configuration.php(217) : eval()'d code on line 1
search the plugin folder by xsearch, the string google_cfg_pull_down_country_list appeared in install.sql only.

---

Got solution on http://www.zen-cart.com/showthread.p...Thread/page285

Hello all,

Disregard my last post, I found the problem that was causing it and got it fixed. Three product descriptions caused it.

I downloaded the first two xml files of 1500 products each but then had to reduce the next download down to 500 product in order for it to download all of them and then I couldn't download the rest at all.

Here is the error log I got this morning, can anyone tell me from it what I need to look at now. Thanks, Jim

[10-Jan-2014 08:47:13 America/Chicago] PHP Fatal error: 2008:MySQL client ran out of memory :: select pa.products_attributes_id
from zc_products_attributes pa
where pa.products_id = '7568' limit 1 in /home2/jstiles/public_html/includes/classes/db/mysql/query_factory.php on line 120
[10-Jan-2014 08:47:13 America/Chicago] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from zc_sessions
where sesskey = '7dc4cfb79a517cc3ae66d3b87cd64aad' in /home2/jstiles/public_html/includes/classes/db/mysql/query_factory.php on line 120

Not sure, but did you try to increase the memory limitation?
configuration=>google mer....=>Memory Limit

Quote:

---

Originally Posted by su35

Not sure, but did you try to increase the memory limitation?
configuration=>google mer....=>Memory Limit

---

I tried that earlier but it didn't make any difference but I need to try it again now that I found and fixed some database errors. I also found the below statement in the googlefroogle.php file but not sure what or if I should make any changes here or not.

if ((int)GOOGLE_PRODUCTS_MAX_EXECUTION_TIME > 0) {
ini_set('max_execution_time', (int)GOOGLE_PRODUCTS_MAX_EXECUTION_TIME); // change to whatever time you need
set_time_limit((int)GOOGLE_PRODUCTS_MAX_EXECUTION_TIME); // change to whatever time you need
}
if ((int)GOOGLE_PRODUCTS_MEMORY_LIMIT > 0) ini_set('memory_limit', (int)GOOGLE_PRODUCTS_MEMORY_LIMIT . 'M'); // change to whatever you need

I don't think it is a good idea to modify the code directly. All the memory and time limitations could be set on configuration filed.

Also try, tools=>store manger=>Optimize Database

i now getting the following in error log

PHP Warning: preg_match() [<a href='function.preg-match'>function.preg-match</a>]: Compilation failed: missing ) at offset 30 in /home/public_html/includes/classes/google_base.php on line 42

Getting a simular error in logs as River city

[17-Jan-2014 12:13:15 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: select count(*) as count
from categories
where parent_id = '154' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120

[17-Jan-2014 12:13:15 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from sessions
where sesskey = 'a59debf412ff965efb1187c10bd2c51d' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120

Quote:

---

Originally Posted by kitcorsa

Getting a simular error in logs as River city

[17-Jan-2014 12:13:15 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: select count(*) as count
from categories
where parent_id = '154' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120

[17-Jan-2014 12:13:15 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from sessions
where sesskey = 'a59debf412ff965efb1187c10bd2c51d' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120

---

Never got a remedy for it even from Numinix, did find out from them to check my host for timeout settings, even when they say "unlimited". That was and is a problem with my current host so looks like I'll have to live with it for now. I am switching from the free Google Merchant Feed plug in to the $35 Google Product Search feed module which from what I understand is a more stable module and more forgiving on .xml errors that Google doesn't use anyway. I was told that it would not help with the timeout issue as that is most probably caused by the host settings. I also found a few errors in my data that might have been causing some problems. I finally got several smaller downloads that I put all in one file and got it to upload to Google ok.