Make sure you first have a complete ftp backup of your entire OC, plus two database backups. Back up the database using admin System / Backup so that you can use it via System / Restore if need be later, AND back up the database using host control panel's phpMyAdmin / Export so that you can use that via phpMyAdmin / Import if need be later. (The two put out and take in a .sql file and the data are the same, but the file formats differ slightly, so you do NOT want to mix those two methods and files.) If the host also has a "Backup" provision (it will make .zip files if it is available), then you can also use that (preferably not instead but additionally -- you want to play safe).
BEFORE doing the admin System / Backup (prior to the upgrade step) you should insert backup_improved.xml by rph (http://forum.opencart.com/viewtopic.php ... 62#p401314, THEN download at his http://forum.opencart.com/viewtopic.php ... 01#p423332). The reason is that rph's extension improves the efficiency and reduces the .sql size of the backup, and it works.
Error: Unknown column 'GMGM2301' in 'field list'
Error No: 1054
INSERT INTO `oc_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 (GMGM2301-2ND,2,'GMGM2301-2ND','089006787160','','','','','New Braunfels, TX',5,'GMGM2301-2ND',171,'data/D/GMGM2301-2ND.jpg',1,29.99,0,NOW(),NOW(),NOW(),3,5,1,9,5,4,8.5,8.5,'3','1','1','1');
See also 'System > Error Logs' for more details.
Thanks for your hard work on this, I have updated it to work with 18.104.22.168jipsa78 wrote:Sure, you can use the attached file :-)crispylettuce wrote:jipsa78 wrote:Hi,
First of all: great job on this extension!
I am now trying to get it to work with the Custom Page Titles extension (url: http://www.opencart.com/index.php?route ... on_id=7867), which I want to use for SEO purposes.
The Custom Page Titles extension adds these new fields to the database:
ALTER TABLE art1_category_description ADD column cptitle VARCHAR(255) NOT NULL;
ALTER TABLE art1_information_description ADD column cptitle VARCHAR(255) NOT NULL;
ALTER TABLE art1_product_description ADD column cptitle VARCHAR(255) NOT NULL;
It also contains a vQmod file that adds the custom page title fields to admin.
Because the export/import tool doesn't know these new database fields, any custom page title I make is deleted on import of an xls file. To solve this I've tried to add the new fields to your admin/model/tool/export.php file.
As a result I am now able to export the xls file with the new fields and correct content.
However when I import the xls file again it empties the database and doesn't populate it with new data.
I have tried hard to find the cause of this, but with my limited php knowledge I haven't succeeded.
Could you take a look at the attached php file?
You can find my entries with a search for 'cptitle'.
Would be very much appreciated :-)
I am running OpenCart 22.214.171.124 with opencart-1-5-2-x-export-import-10
Works fine without the custom page titles alteration.
My OpenCart error log shows no errors.
I assume you have this working well, could you possibly upload an example of the modified php, so i can check i have done it correct?
Should work on 126.96.36.199
Actually, this could be the part of this module in the future.
I have error while exporting the product. it shows " Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 85 bytes) in /home/localann/public_html/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123 "
And also i changed the memory limit 128m to 512m .but the error still shows . any one can suggest me the solution?
Thanks in advance
Use Export/Import tool (multilingual) V2.xmotionmindz wrote:Fatal error with OC2 on this module extension. A shame cos I could really use this!
MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig
Users browsing this forum: Bing [Bot] and 8 guests