Page 11 of 52

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Thu May 14, 2015 3:19 pm
by SVN
JNeuhoff wrote:
oc4 wrote:Hi,

probably it is a known issue, but i cant find a solution in forum.
After the import using this tool one can see new categories over web interface ... BUT ALL categories in Catalog->Categories of the Admin UI are disappeared. Same happened with products after import. I checked the DB, new products are in DB, openCart can see them, but Admin UI shows empty Product list. There were no errors in the log.
Can smbd help me?
You are probably using langauges for the front end default language and the admin backend language, please fill in your categories and products data for all languages.

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Thu May 14, 2015 4:49 pm
by JNeuhoff
vryannn wrote:I upload the extension and it was fine, then went to modifications and click refresh and got the

"500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed."
The only way to find out is to ask your webhost for the corresponding entries in the server's error_log.

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Thu May 14, 2015 10:12 pm
by SVN
JNeuhoff wrote:
SVN wrote:I installed OC 2.0.2.0 and only this export/import extension.
When I export, it works great, I can see all the demo data that is the clean install of OC.

That exported file I open and copy/past some other data in in.
I make sure every line is filled in like the demo data.

This error I get when I'm trying to upload the xlsx file.

2015-05-13 20:15:12 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''A10U',11,'',1,40,0,'2009-02-03 16:06:50','2011-09-30 01:05:39','2009-02-03',0,1' at line 1<br />Error No: 1064<br />INSERT INTO `product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (28,12,'','','','','','','',,'A10U',11,'',1,40,0,'2009-02-03 16:06:50','2011-09-30 01:05:39','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/A003196/poortautomatisatie.eu/maasland.poortautomatisatie.eu/system/library/db/mysqli.php on line 41
2015-05-13 20:15:12 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''AP10U',11,'',1,42,0,'2009-02-03 16:42:17','2011-09-30 01:06:08','2009-02-03',0,' at line 1<br />Error No: 1064<br />INSERT INTO `product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (29,13,'','','','','','','',,'AP10U',11,'',1,42,0,'2009-02-03 16:42:17','2011-09-30 01:06:08','2009-02-03',0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/users/system/library/db/mysqli.php on line 41


You forgot to set the stock_status_id. On a standard OpenCart 2.0.x
install, it can be one of the following numeric values:

5 (Out Of Stock)
6 (2-3 Days)
7 (In Stock)
8 (Pre-Order)


I enabled English again, did an export, English collums were visible in the export, filled it in in Dutch and now it works.
Thank you !!!

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Sat May 16, 2015 6:46 pm
by Flashback87
Hello,

i have problem with Import/Export TOOL on Opencart 2.0.2.

I exported original products, add 1-2 testing products and reimport. No products will add, but if im make new product so i see below error and new product is rename to testing products from import....

Im not understand this :(

PLEASE COULD SOMEBODY HELP ME?

THANK YOU!

ERROR MSG:

Warning: mysqli::query() [mysqli.query]: (21000/1242): Subquery returns more than 1 row in /home/progamershop.cz/progamershop.cz/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=50') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '50' AND pd.language_id = '2' in /home/progamershop.cz/progamershop.cz/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/progamershop.cz/progamershop.cz/admin/model/catalog/product.php on line 345

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Sat May 16, 2015 11:36 pm
by JNeuhoff
Warning: mysqli::query() [mysqli.query]: (21000/1242): Subquery returns more than 1 row in /home/progamershop.cz/progamershop.cz/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=50') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '50' AND pd.language_id = '2' in /home/progamershop.cz/progamershop.cz/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/progamershop.cz/progamershop.cz/admin/model/catalog/product.php on line 345
Your database is corrupted. For product_id=50, you have more than 1 defined SEO keyword. Remove the duplicate entry from the 'url_alias' table via PHPMyAdmin.

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Mon May 18, 2015 1:08 pm
by svetik08
Good day. I changed the hosting and then when I want to export goods an error "Could not close zip file php://output.

in logs
2015-05-18 4:52:54 - PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/www/almori/data:.) in /var/www/almori/data/www/xn----8sbwech0d6adg.xn--p1ai/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 175
2015-05-18 4:52:54 - PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/var/www/almori/data:.) in /var/www/almori/data/www/xn----8sbwech0d6adg.xn--p1ai/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 197
2015-05-18 4:52:54 - PHP PHPExcel_Writer_Exception: Could not close zip file php://output. in /var/www/almori/data/www/xn----8sbwech0d6adg.xn--p1ai/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 399

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Mon May 18, 2015 4:55 pm
by Flashback87
Yes, it works now :)

THX you.

But i have one problem else...

http://forum.opencart.com/viewtopic.php?f=183&t=144713

Can you help me please?

BR
Jakub

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Tue May 19, 2015 3:56 am
by natlia
Hi,
I installed export/import, Everything ok. When I upload file I get message - Success: You have successfully imported your data!

But, I don't any product in my admin panel and site.

Can you help me?
Thank you!

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Tue May 19, 2015 9:41 pm
by JNeuhoff
You don't provide any details, so I am unable to reproduce your error.

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Wed May 20, 2015 12:15 am
by Flashback87
Hi,

I installed the free export/import tool extension.

When I try to export a product list, I receive following message :"Undefined Offset: 3"
Exporting and importing categories is working fine.

What can I do about this?

Thank you.

Jakub

EDIT: This is msg from my error log
2015-05-19 18:18:21 - PHP Notice: Undefined offset: 3 in /home/progamershop.cz/progamershop.cz/admin/model/tool/export_import.php on line 5028

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Sat May 23, 2015 7:07 pm
by TobyTheFox
Hi, im trying to install the module using ocmod but i'm getting this error message, i was wondering if anyone could understand what it was about? Thanks


<b>Warning</b>: ftp_nlist(): bind() failed: Permission denied (13) in <b>/hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/admin/controller/extension/installer.php</b> on line <b>328</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin: File exists in <b>/hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: ftp_nlist(): bind() failed: Permission denied (13) in <b>/hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/admin/controller/extension/installer.php</b> on line <b>328</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): system: File exists in <b>/hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/admin/controller/extension/installer.php</b> on line <b>338</b><b>Warning</b>: ftp_nlist(): bind() failed: Permission denied (13) in <b>/hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/admin/controller/extension/installer.php</b> on line <b>328</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/admin/controller/extension/installer.php</b> on line <b>333</b><b>Warning</b>: ftp_mkdir(): admin/controller: File exists in <b>/hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/a...hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: ftp_put(): Type set to I in <b>/hermes/bosnaweb03b/b2254/ipg.pjsmusiccom/admin/controller/extension/installer.php</b> on line <b>345</b><b>Warning</b>: ftp_nlist(): bind() failed:…

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Sat May 23, 2015 9:01 pm
by JNeuhoff
Hi, im trying to install the module using ocmod but i'm getting this error message, i was wondering if anyone could understand what it was about? Thanks
Your FTP settings aren't correctly set up in your OpenCart settings. I suggest to either fix that, or you could this extension installer fix which doesn't rely on FTP.

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Sat May 23, 2015 9:38 pm
by TobyTheFox
Hi, thank you for your reply, the FTP details are correct, and the built in ftp browser works fine, the extension doesn't work too... What is it to do with 'installer.php' as per the error message? Thanks

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Sat May 23, 2015 10:18 pm
by JNeuhoff
I can't help you then, just use the above mentioned extension installer fix.

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Sat May 23, 2015 10:22 pm
by TobyTheFox
EDIT

Sorry! I didn't press the blue refresh button! It worked! Haha brilliant thank you so much :)))

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Sun May 24, 2015 8:26 pm
by Flashback87
Hi,

I installed the free export/import tool extension.

When I try to export a product list, I receive following message :"Undefined Offset: 3"
Exporting and importing categories is working fine.

What can I do about this?

Thank you.

Jakub

EDIT: This is msg from my error log
2015-05-19 18:18:21 - PHP Notice: Undefined offset: 3 in /home/progamershop.cz/progamershop.cz/admin/model/tool/export_import.php on line 5028

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Mon May 25, 2015 4:44 am
by Ljubo
I have a fresh install on oc 2.0.3 and installed your tool.
However, after successsfull instalation, it gives me Permission Denied error.
The problem is that there is no "tool/export_import" showing under Settings/Users/User Groups/Administrator, so that I can not set access to it.
Weird... any advice?

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Mon May 25, 2015 4:59 am
by JNeuhoff
Ljubo wrote:I have a fresh install on oc 2.0.3 and installed your tool.
However, after successsfull instalation, it gives me Permission Denied error.
The problem is that there is no "tool/export_import" showing under Settings/Users/User Groups/Administrator, so that I can not set access to it.
Weird... any advice?
You most likely uploaded it to the wrong place. Maybe your FTP settings in OpenCart, e.g. FTP root, is wrong? The OpenCart installer is quite cumbersome for many users, so you may use iSenseLab's installer fix which eliminates the need for OpenCart to use its own FTP.

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Mon May 25, 2015 1:16 pm
by Flashback87
JNeuhoff please, could you help me too? :((

Re: [RELEASED] Multilingual Export/Import for OpenCart 2.x

Posted: Mon May 25, 2015 9:05 pm
by Ljubo
@JNeuhoff

You were right, thanks!