Post by gsc1ugs » Sat Oct 07, 2023 11:07 pm

Ok, i backed up my older version of opencart 2.0.2.0 i then restored the database in version 3.0.3.8 off github, the restore was succesfull but column names have changed in oc_event table

`sort_order` int(3) NOT NULL,

New but how may more??


-- Table structure for table `oc_event`
VERSION 2.0.2.0

Code: Select all

DROP TABLE IF EXISTS `oc_event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oc_event` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(32) NOT NULL,
  `trigger` text NOT NULL,
  `action` text NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

THE 3.0.3.8 IS THIS
DROP TABLE IF EXISTS `oc_event`;
CREATE TABLE `oc_event` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL,
  `trigger` text NOT NULL,
  `action` text NOT NULL,
  `status` tinyint(1) NOT NULL,
  `sort_order` int(3) NOT NULL,
  PRIMARY KEY (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
Last edited by gsc1ugs on Mon Oct 09, 2023 10:10 pm, edited 1 time in total.

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by gsc1ugs » Sat Oct 07, 2023 11:37 pm

Am i right understanding that 2.0.2.0 backup will not update the 3.0.3.8 version ?

it seems many columns have been changed, this is a disaster for me, i at least would like to add the products, categories and customers back!

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by Cue4cheap » Sun Oct 08, 2023 1:06 am

gsc1ugs wrote:
Sat Oct 07, 2023 11:37 pm
Am i right understanding that 2.0.2.0 backup will not update the 3.0.3.8 version ?

it seems many columns have been changed, this is a disaster for me, i at least would like to add the products, categories and customers back!
Products , categories and customers can be done with the export/import tool....https://www.opencart.com/index.php?rout ... sion_id=17

For orders you'll have to do it yourself, buy an extension, or hire someone.
Mike

cue4cheap not cheap quality


Expert Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by gsc1ugs » Sun Oct 08, 2023 1:22 am

Cue4cheap wrote:
Sun Oct 08, 2023 1:06 am
Products , categories and customers can be done with the export/import tool....https://www.opencart.com/index.php?rout ... sion_id=17
Ive tried the above, it wont add any backup XLSX from version 2.0.2.0

2023-10-07 17:21:10 - Export/Import: Invalid header in the Products worksheet
2023-10-07 17:21:00 - Export/Import: Invalid header in the Categories worksheet
2023-10-07 17:21:46 - Export/Import: Invalid header in the Customers worksheet

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by Cue4cheap » Sun Oct 08, 2023 11:06 am

gsc1ugs wrote:
Sun Oct 08, 2023 1:22 am
Cue4cheap wrote:
Sun Oct 08, 2023 1:06 am
Products , categories and customers can be done with the export/import tool....https://www.opencart.com/index.php?rout ... sion_id=17
Ive tried the above, it wont add any backup XLSX from version 2.0.2.0

2023-10-07 17:21:10 - Export/Import: Invalid header in the Products worksheet
2023-10-07 17:21:00 - Export/Import: Invalid header in the Categories worksheet
2023-10-07 17:21:46 - Export/Import: Invalid header in the Customers worksheet
I am Very certain JNeuhoff explained this to you in another one of your threads. Please follow his instructions.

This post: viewtopic.php?p=862172&hilit=export#p862172
Mike

cue4cheap not cheap quality


Expert Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by gsc1ugs » Sun Oct 08, 2023 3:12 pm

It's best to do a fresh install of the new OpenCart 3.0.3.8 (Use the 3.0.x.x_Maintenance branch, because it has some bugfixes and added PHP8 support). And you can then use the Export/Import tool to copy your product and categories data from the old to the new server via spreadsheets, see our FAQ on how to do it.
Did exactly the above, there is no real explanation on his site about the options you have, i will try again on one download of data old site to new and post results
Thanks

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by gsc1ugs » Mon Oct 09, 2023 10:10 pm

SOLVED - Column name modification required

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm
Who is online

Users browsing this forum: No registered users and 1 guest