JNeuhoff wrote: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.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?
The only way to find out is to ask your webhost for the corresponding entries in the server's error_log.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."
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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 !!!
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
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.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
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
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
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!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
<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:…
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.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
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Sorry! I didn't press the blue refresh button! It worked! Haha brilliant thank you so much ))
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
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.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?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Users browsing this forum: No registered users and 126 guests