Having issues with the Hikashop Google Products Pl

  • Posts: 33
  • Thank you received: 2
  • Hikashop Business
11 years 5 months ago #114969

Hikashop Google Products Plugin

I'm having issues getting it to work I'm getting this error after clicking trigger.

http://www.webpagescreenshot.info/img/51ec278086b723-52284953

Here is the setting I'm using on the plugin.

http://www.webpagescreenshot.info/img/51ec265df079d5-93046740


http://www.webpagescreenshot.info/img/51ec271c67d7e4-45641189

Any help would be so kind.


HikaShop Business 2.6.0

PHP Version 5.6.16
Web Server Apache

Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
11 years 5 months ago #115036

I see you have Hikashop 2.1.3, you try to update to our last version (2.2.0), it may fix the problem.
If not, could you please give us a screenshot of you error?

Thanks.

Please Log in or Create an account to join the conversation.

  • Posts: 33
  • Thank you received: 2
  • Hikashop Business
11 years 5 months ago #115083

I got the 2.2.0 installed successfully. But still get error its like several pages long.

I have over 2000 products listed could that be a problem, with some type of timeout or other issue?

Warning: Invalid argument supplied for foreach() in /home/ifixma5/public_html/plugins/hikashop/google_products/google_products.php on line 225

Warning: Invalid argument supplied for foreach() in /home/ifixma5/public_html/plugins/hikashop/google_products/google_products.php on line 225

Warning: Invalid argument supplied for foreach() in /home/ifixma5/public_html/plugins/hikashop/google_products/google_products.php on line 225

Warning: Invalid argument supplied for foreach() in /home/ifixma5/public_html/plugins/hikashop/google_products/google_products.php on line 225


HikaShop Business 2.6.0

PHP Version 5.6.16
Web Server Apache

Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT
Last edit: 11 years 5 months ago by cctaco.

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
11 years 5 months ago #115091

Hi,

No the Hikashop 2.2.0 is the last stable version, you'll just have to download another installation package through the Hikashop website and install it.

Please Log in or Create an account to join the conversation.

  • Posts: 33
  • Thank you received: 2
  • Hikashop Business
11 years 5 months ago #115108

I got the 2.2.0 installed successfully. But still get error its like several pages long.

I have over 2000 products listed could that be a problem, with some type of timeout or other issue?

Warning: Invalid argument supplied for foreach() in /home/ifixma5/public_html/plugins/hikashop/google_products/google_products.php on line 225

Warning: Invalid argument supplied for foreach() in /home/ifixma5/public_html/plugins/hikashop/google_products/google_products.php on line 225

Warning: Invalid argument supplied for foreach() in /home/ifixma5/public_html/plugins/hikashop/google_products/google_products.php on line 225

Warning: Invalid argument supplied for foreach() in /home/ifixma5/public_html/plugins/hikashop/google_products/google_products.php on line 225


HikaShop Business 2.6.0

PHP Version 5.6.16
Web Server Apache

Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
11 years 5 months ago #115195

Could you take a look at the given line and post it here?
I think I see what's the problem and I could give you the code to fix it.

Please Log in or Create an account to join the conversation.

  • Posts: 33
  • Thank you received: 2
  • Hikashop Business
11 years 5 months ago #115258

Thank you for the reply Eliot, I got a new plugin from Nicolas which I'm going to install when I get to work.
Will let you know, also will post the line 225 as requested.


HikaShop Business 2.6.0

PHP Version 5.6.16
Web Server Apache

Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT

Please Log in or Create an account to join the conversation.

  • Posts: 33
  • Thank you received: 2
  • Hikashop Business
11 years 5 months ago #115268

Hey,

I know this will show how much of a novice I am, but what file do I use. The php or xml one?


HikaShop Business 2.6.0

PHP Version 5.6.16
Web Server Apache

Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
11 years 5 months ago #115292

Don't worry, we all started by this step ;)
The php file is one which give the error so just copy paste here the lines around 225 (if you still encounter the issue).

Please Log in or Create an account to join the conversation.

  • Posts: 33
  • Thank you received: 2
  • Hikashop Business
11 years 5 months ago #115308

Successfully installed the patched plugin, which is now creating a different error. Timeout after 30 seconds.
I unsuccessfully tried to edit the php.ini to allow max time of 180, but it didn't work still timed out after 30 seconds.

Wondering because of the amount of products that it is taking too long to process my store, is there a way to do it in pieces. (break it into smaller chunks)

foreach($categoriesId as $catId){

if($row->product_id==$catId->product_id){

$products[$k]->categories_id[]=$catId->category_id;

}

}

}

$queryImage = 'SELECT * FROM '.hikashop_table('file').' WHERE file_ref_id IN ('.implode(',',$ids).') AND file_type=\'product\' ORDER BY file_ordering ASC, file_id ASC';

$db->setQuery($queryImage);

$images = $db->loadObjectList();

foreach($products as $k=>$row){

$i=0;

foreach($images as $image){

if($row->product_id==$image->file_ref_id){

foreach(get_object_vars($image) as $key => $name){

$products[$k]->images[$i]->$key = $name;

}

}

$i++;

}

}

$db->setQuery('SELECT * FROM '.hikashop_table('variant').' WHERE variant_product_id IN ('.implode(',',$ids).')');

$variants = $db->loadObjectList();


HikaShop Business 2.6.0

PHP Version 5.6.16
Web Server Apache

Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT
Last edit: 11 years 5 months ago by cctaco.

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
11 years 5 months ago #115496

How much product do you have?
If it's just a matter of number, I can give you some code to restrict the export to a specific category.
Then you'll have to change the id for each category but at least you'll be able to export them ;)

Please Log in or Create an account to join the conversation.

  • Posts: 33
  • Thank you received: 2
  • Hikashop Business
11 years 5 months ago #115914

That would be great do you need a copy of the google_products.php that I got from nicolas?

I have about 2500 catagories with 1 to 5 products in each cat.


Just let me know what I need to provide to you. You can check out my site if you want www.ifixmachines.com

I had a google products thing for virtuemart that worked well, it did something incrementally. like it would take 50 products and write it to the file, then it would do the next 50. Not really sure how it worked, possible write to database and then some form of a call. It didn't time out.

Thanks


HikaShop Business 2.6.0

PHP Version 5.6.16
Web Server Apache

Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
11 years 4 months ago #116475

I checked the code and I indeed would like a backend access to your website as well as an FTP access.
Could you provide me these informations by PM?

Please Log in or Create an account to join the conversation.

Time to create page: 0.091 seconds
Powered by Kunena Forum