Post by SVN » Thu May 14, 2015 3:19 pm

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.
Last edited by SVN on Thu May 14, 2015 10:10 pm, edited 1 time in total.

User avatar
SVN
Active Member

Posts

Joined
Mon Jan 03, 2011 11:59 pm

Post by JNeuhoff » Thu May 14, 2015 4:49 pm

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.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by SVN » Thu May 14, 2015 10:12 pm

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 !!!

User avatar
SVN
Active Member

Posts

Joined
Mon Jan 03, 2011 11:59 pm

Post by Flashback87 » Sat May 16, 2015 6:46 pm

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

New member

Posts

Joined
Sat Nov 10, 2012 1:57 am

Post by JNeuhoff » Sat May 16, 2015 11:36 pm

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.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by svetik08 » Mon May 18, 2015 1:08 pm

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

Newbie

Posts

Joined
Mon May 18, 2015 1:03 pm

Post by Flashback87 » Mon May 18, 2015 4:55 pm

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

New member

Posts

Joined
Sat Nov 10, 2012 1:57 am

Post by natlia » Tue May 19, 2015 3:56 am

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!

http://bridalbynatalie.com


Newbie

Posts

Joined
Wed Sep 25, 2013 8:35 pm


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Flashback87 » Wed May 20, 2015 12:15 am

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

New member

Posts

Joined
Sat Nov 10, 2012 1:57 am

Post by TobyTheFox » Sat May 23, 2015 7:07 pm

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:…

New member

Posts

Joined
Mon Jun 09, 2014 1:28 am

Post by JNeuhoff » Sat May 23, 2015 9:01 pm

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.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TobyTheFox » Sat May 23, 2015 9:38 pm

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

New member

Posts

Joined
Mon Jun 09, 2014 1:28 am

User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TobyTheFox » Sat May 23, 2015 10:22 pm

EDIT

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

New member

Posts

Joined
Mon Jun 09, 2014 1:28 am

Post by Flashback87 » Sun May 24, 2015 8:26 pm

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

New member

Posts

Joined
Sat Nov 10, 2012 1:57 am

Post by Ljubo » Mon May 25, 2015 4:44 am

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?

Active Member

Posts

Joined
Mon Jan 31, 2011 10:07 pm
Location - Serbia

Post by JNeuhoff » Mon May 25, 2015 4:59 am

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.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Flashback87 » Mon May 25, 2015 1:16 pm

JNeuhoff please, could you help me too? :((

New member

Posts

Joined
Sat Nov 10, 2012 1:57 am

Post by Ljubo » Mon May 25, 2015 9:05 pm

@JNeuhoff

You were right, thanks!

Active Member

Posts

Joined
Mon Jan 31, 2011 10:07 pm
Location - Serbia
Who is online

Users browsing this forum: OSWorX and 4 guests