http://www.mhccorp.com/opencart/export-import-tool
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Export works fine
however when importing I get this error
Notice: Undefined index: 13 in /home/*****/public_html/shop5/admin/model/tool/export.php on line 873Error: 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 '74,13,64,0,0,0,'',0,'',0.00,'')' at line 1
Error No: 1064
INSERT INTO `product_option_value` (`product_option_value_id`,`product_option_id`,`product_id`,`option_id`,`option_value_id`,`quantity`,`subtract`,`price`,`price_prefix`,`points`,`points_prefix`,`weight`,`weight_prefix`) VALUES (11,,74,13,64,0,0,0,'',0,'',0.00,'');
Thanks
Ronnie
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I think I found the bug. Just fixed it, install and try again, it should work now.ronnieb wrote:Hi
Export works fine
however when importing I get this error
Notice: Undefined index: 13 in /home/*****/public_html/shop5/admin/model/tool/export.php on line 873Error: 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 '74,13,64,0,0,0,'',0,'',0.00,'')' at line 1
Error No: 1064
INSERT INTO `product_option_value` (`product_option_value_id`,`product_option_id`,`product_id`,`option_id`,`option_value_id`,`quantity`,`subtract`,`price`,`price_prefix`,`points`,`points_prefix`,`weight`,`weight_prefix`) VALUES (11,,74,13,64,0,0,0,'',0,'',0.00,'');
Thanks
Ronnie
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
do you have vqmod installed? It's a seperate mod from this one you have to install it first before any vqmod scripts will work.hellogoodbye wrote:Hi I uploaded the vqmod folder, but nothing seems to have happened. There was no 'tool/export' in the Top Admin User Group
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
edit: just went back over to the vqmod thread, saw the host and redownload fixes so let me try those first and i'll post back.
Instructions do not explain that you should still copy over the system and tools files.
If you manually add the language and variable data, it works fine.
wait, so we still need to upload the admin and system folders? The instructions made it sound like all I needed to upload was the VQmod folder if I have VQmod installed.SXGuy wrote:i had trouble installing this in 1.5.0 with the vqmod and my vqmod files are up to date.
Instructions do not explain that you should still copy over the system and tools files.
If you manually add the language and variable data, it works fine.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
when you say no, you mean, yes (for other folders)? Thanks for the newbie explanation. Uploaded the other 2 folders. and SXGuy's helpXsecrets wrote:no vqmod just handles the core files that get changed. Any new files still have to be uploaded. It is that way with every module. vqmod cannot create new files it only modifies existing ones.
Op al uw computervragen een antwoord -- Extigo Computers
http://www.extigo.nl
Using OC 1.4.9.4
Send me a PM with your XLS filewhich has the Import problem with the attributes, and I takle a look at it.extigo wrote:I've got a problem with the attributes. I added the attributes in the admin inside an attribute group, but when I edit the XLS and connect the attributes with products, these are not imported. Is this correct?
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
Op al uw computervragen een antwoord -- Extigo Computers
http://www.extigo.nl
Using OC 1.4.9.4
Now have an admin screen that is "text_logged" and no options appearing on it apart from home & dashboard overview & latest 10 orders
Please advise where it's gone wrong asap!
Op al uw computervragen een antwoord -- Extigo Computers
http://www.extigo.nl
Using OC 1.4.9.4
Users browsing this forum: No registered users and 78 guests