Notice: Error: Unknown column 'meta_keywords' in 'field list'
Error No: 1054
INSERT INTO `category_description` (`category_id`, `language_id`, `name`, `meta_keywords`, `meta_description`, `description`) VALUES ('73', '1', 'Air Compressor Generator Welder', '', '', '') in /home/nels11/public_html/secure/system/database/mysql.php on line 49
this is the error I am getting. also now after reloading my excel import/export script it is returning out of memory errors on a small 2mb excel file.
Also due to this it appears that the categories have not been reloaded.
with over 2000+ products loaded and now not linking to the categories correctly it is making life very difficult
Please any help would be appeciated
Step 1: Run the script from viewtopic.php?f=2&t=36519. This will update from 1.4.x to 1.5.1.2.
Step 2: Run the upgrade script in your 1.5.1.3 package. This will update from 1.5.1.2 to 1.5.1.3.x
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
You can't import your backup once you have run the update script(s). There are new tables added and some tables have had fields added or had fields removed. Some tables have fields that have changed names.mosesg wrote:that is after the update script and upgrade to 1.5.x i then try to import my backup and returns same error
Sure, the instructions say to backup your database (as they should). This is so you can restore your website to how it used to be before you updated in the event of a problem.
Trying to restore your backup after running the update script(s) will only cause problems.
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Copy the files from the 1.5.1.3 package over your existing site files. Then:
You will get errors. After you have run the upgrade scripts, log in to your admin, go to "Extensions->Modules" and uninstall ALL of your modules, then re-install (and re-configure) those you wish to use.fido-x wrote:Step 1: Run the script from viewtopic.php?f=2&t=36519. This will update from 1.4.x to 1.5.1.2.
Step 2: Run the upgrade script in your 1.5.1.3 package. This will update from 1.5.1.2 to 1.5.1.3.x
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
also after uninstallnig and reinstalling modules I am encountering these errors now
Fatal error: Cannot access private property Document::$title in /home/nels11/public_html/secure/admin/controller/module/manufacturer.php on line 8
No. As previously stated, there have been changes in the database structure.mosesg wrote:It cant be done even after running the script?
Uninstall the manufacturer module. It is has been replaced by the "carousel" module.also after uninstallnig and reinstalling modules I am encountering these errors now
Fatal error: Cannot access private property Document::$title in /home/nels11/public_html/secure/admin/controller/module/manufacturer.php on line 8
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Notice: Error: Duplicate entry '77-0' for key 'PRIMARY'
Error No: 1062
INSERT INTO category_to_store SET category_id = '77', store_id = '0' in /home/nels11/public_html/secure/system/database/mysql.php on line 49
when trying to add categories it does not let me as props this but there is nothing showing the the categories menu on the admin in the categories.
You shouldn't need to restore (or re-import) anything.mosesg wrote:so how does one re import the categories and products?
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Code: Select all
# Add Meta Keywords
ALTER TABLE `oc_category_description` MODIFY name varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin;
ALTER TABLE `oc_category_description` ADD `meta_keywords` varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin;
ALTER TABLE `oc_product_description` ADD `meta_keywords` varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin;
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Thank You for your help btw I have been pulling my hair out over the categories thing since with 2500+ products it would be godly time consuming trying to manually re assign all. but since the products already have the data there and the previous categories assigned still but just not showing is making it very frustrating. so anyone willing to help I appreciate much and your the first one to address it beyond run upgrade script and follow directions since I did all that.
Users browsing this forum: No registered users and 160 guests