OpenCart Community

Posted: **Wed Jun 22, 2016 12:33 pm**

So i was following a video tutorial on YouTube on how to upgrade from 2.0.3.1 to 2.1.0.2.

Here is the video: https://www.youtube.com/watch?v=7uc7ACgvdCA

The video said to export the Database of your OC 2.0.3.1 and to un-select the following tables (1:37 into the video):
- OC_Extension
- OC_Layout
- OC_Layout_Route
- OC_Layout_Module
- OC_Customer_Activity
- OC_User_Group
- OC_Settings
- OC_Customer_Ban_IP

I un-selected the above tables, and exported the database.

I then imported this database to a fresh install of OC 2.1.0.2

I received an error stating:

Code: Select all

admin/controller/dashboard/activity.php on line 19Warning: vsprintf(): Too few arguments

This was because I also needed to remove oc_Affiliate_Activity table before exporting.

So I then repeated the steps above, and un-selected the following
- OC_Extension
- OC_Layout
- OC_Layout_Route
- OC_Layout_Module
- OC_Customer_Activity
- OC_User_Group
- OC_Settings
- OC_Customer_Ban_IP
OC_Affiliate_Activity <-- I un-selected this table also

I then imported this database to a fresh install of OC 2.1.0.2 and the error disappeared. YAY!

...When I thought everything was going well, I decided to head over to system>settings>edit
My luck was over at this point.

I received the following NEW error:

Code: Select all

Error: Unknown column 'name' in 'order clause'
Error No: 1054
SELECT * FROM `oc_api` ORDER BY name ASC in /public_html/SMB/OpenCart_2.1.0.2/system/library/db/mysqli.php

I am assuming that I also need to remove the table oc_api from the database before I export. I have not completed this step as im guessing there is going to be other tables that need to be un-selected before exporting.

So this is my question: Does anyone know the list of tables that i must un-select from my 2.0.3.1 database to be imported to a fresh install of oc 2.1.0.2

Thanks!

Posted: **Wed Jun 22, 2016 6:46 pm**

The only times vsprintf function is being used in the core is for activity controller purposes at this time. Other than this mentioned comes from an installed contribution. I would suggest to contact the developer of that extension.

However, I do recommend the use of this contribution to export and import Opencart database tables from Excel: http://www.opencart.com/index.php?route ... sion_id=17

OpenCart Community

What 2.0.3.1 Database Tables can be Imported to 2.1.0.2?

What 2.0.3.1 Database Tables can be Imported to 2.1.0.2?

Re: What 2.0.3.1 Database Tables can be Imported to 2.1.0.2?