Hi
I bought this gift voucher extension
http://www.opencart.com/index.php?route ... order=DESC
In the instructions it says this:
##############################################################################
# STEP 2: Make Database Changes
##############################################################################
****************************************
* MAKE SURE TO BACK UP YOUR DATABASE *
* BEFORE MAKING ANY CHANGES. I AM NOT *
* RESPONSIBLE FOR ANY LOSS OF DATA. *
****************************************
Skip this step if you are upgrading from a previous version of Gift Vouchers.
Execute the following SQL code on your database. Remember to add a table
prefix if you are using one. A copy of this SQL code can be found in
"gift_voucher.sql".
-- START: Gift Voucher SQL Code --
CREATE TABLE `gift_voucher` (
`gift_voucher_id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`code` varchar(32) COLLATE utf8_bin NOT NULL,
`balance` decimal(15,4) NOT NULL,
`shipping` int(1) NOT NULL,
`tax` int(1) NOT NULL,
`date_start` date NOT NULL DEFAULT '0000-00-00',
`date_end` date NOT NULL DEFAULT '0000-00-00',
`status` int(1) NOT NULL,
`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`gift_voucher_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
CREATE TABLE `gift_voucher_history` (
`gift_voucher_history_id` int(11) NOT NULL AUTO_INCREMENT,
`gift_voucher_id` int(11) NOT NULL,
`order_id` int(11) NOT NULL,
`amount` decimal(15,4) NOT NULL,
`status` int(1),
`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`gift_voucher_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
-- END: Gift Voucher SQL Code --
What does a table prefix look like?
table prefix is the one you defined. How to know if you have one?
1. Access your database via phpmyadmin.
2. View your tables, scroll down to this table, "setting".
3. If your tables has anything infront of it (eg. oc_setting, or xyz_setting, or whatever_setting), that will be the prefix.
(Eg. oc will be prefix, xyz will be prefix, whatever will be prefix respectively for the example above)
1. Access your database via phpmyadmin.
2. View your tables, scroll down to this table, "setting".
3. If your tables has anything infront of it (eg. oc_setting, or xyz_setting, or whatever_setting), that will be the prefix.
(Eg. oc will be prefix, xyz will be prefix, whatever will be prefix respectively for the example above)
Dear All
I am using 1.5.1.1
I am moving hosting...
I have backup my old database using PHPMyAdmin
I installed a new version of 1.5.1.1 in new host..
When I import the DB.. I can the new installation in new host does not have the oc infront of the table for example: -
My old host database table ocadddress, but in the new hosting i see address only.. Now when I imported the old db into the new hosting.. I have 2 table name ocaddress and address..
What happen? What did i do wrong?
Please help and I am kind of desperate
Regards
Shiokguy
I am using 1.5.1.1
I am moving hosting...
I have backup my old database using PHPMyAdmin
I installed a new version of 1.5.1.1 in new host..
When I import the DB.. I can the new installation in new host does not have the oc infront of the table for example: -
My old host database table ocadddress, but in the new hosting i see address only.. Now when I imported the old db into the new hosting.. I have 2 table name ocaddress and address..
What happen? What did i do wrong?
Please help and I am kind of desperate
Regards
Shiokguy
Who is online
Users browsing this forum: Baidu [Spider] and 4 guests