1.3.0 hacked; 1.4.9.1 upgrade issues

Post Reply

9 posts Page 1 of 1

1.3.0 hacked; 1.4.9.1 upgrade issues

tahnmeep

New member

Posts

Joined

Sun Jul 05, 2009 1:24 pm

Post by tahnmeep » Mon Sep 27, 2010 4:43 pm

Hey everyone,
updates always caused a lot of issues, and once I got 1.3.0 going I left it because "if it ain't broke, don't fix it".
That got hacked-- long story short, I have some old config.php files that I think worked but I'm not too sure about.
I copied them into the new install and performed the 1.3.2 config updates, along with the 1.3.2>1.4.7 and 1.4.9.1 updates.
Yet I always receive this error on front- and back-ends:

Error: Table 'tahnee_emporium.cart_setting' doesn't exist
Error No: 1146
SELECT * FROM cart_setting

Also, the Upgrade had a load of errors:

Code: Select all

Could not execute this query: ALTER TABLE cart_customer ADD customer_group_id int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER status;

Could not execute this query: ALTER TABLE cart_customer ALTER ip SET DEFAULT 0;

Could not execute this query: ALTER TABLE cart_product ADD measurement_class_id int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER height;

Could not execute this query: ALTER TABLE cart_product ALTER length SET DEFAULT 0.00;

Could not execute this query: ALTER TABLE cart_product ALTER width SET DEFAULT 0.00;

Could not execute this query: ALTER TABLE cart_product ALTER height SET DEFAULT 0.00;

Could not execute this query: ALTER TABLE cart_product_discount ADD customer_group_id int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER product_id;

Could not execute this query: ALTER TABLE cart_product_discount ADD priority int(5) NOT NULL DEFAULT '1' COMMENT '' AFTER quantity;

Could not execute this query: ALTER TABLE cart_product_discount ADD price decimal(15,4) NOT NULL DEFAULT '0.0000' COMMENT '' AFTER priority;

Could not execute this query: ALTER TABLE cart_product_discount ADD date_start date NOT NULL DEFAULT '0000-00-00' COMMENT '' AFTER price;

Could not execute this query: ALTER TABLE cart_product_discount ADD date_end date NOT NULL DEFAULT '0000-00-00' COMMENT '' AFTER date_start;

Could not execute this query: ALTER TABLE cart_product_discount ALTER quantity SET DEFAULT 0;

Could not execute this query: ALTER TABLE cart_product_special ADD customer_group_id int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER product_id;

Could not execute this query: ALTER TABLE cart_product_special ADD priority int(5) NOT NULL DEFAULT '1' COMMENT '' AFTER customer_group_id;

Could not execute this query: ALTER TABLE cart_product_special ALTER price SET DEFAULT 0.0000;

Could not execute this query: ALTER TABLE cart_product_special ALTER date_start SET DEFAULT '0000-00-00';

Could not execute this query: ALTER TABLE cart_product_special ALTER date_end SET DEFAULT '0000-00-00';

Could not execute this query: INSERT INTO `cart_setting` (`setting_id` ,`group` ,`key` ,`value`) VALUES (NULL , 'config', 'config_error_filename', 'error.log') ON DUPLICATE KEY UPDATE setting_id=setting_id;

Could not execute this query: ALTER TABLE cart_coupon ADD logged int(1) NOT NULL DEFAULT 0 COMMENT '' AFTER discount;

Could not execute this query: ALTER TABLE cart_coupon ALTER date_start SET DEFAULT '0000-00-00';

Could not execute this query: ALTER TABLE cart_coupon ALTER date_end SET DEFAULT '0000-00-00';

Could not execute this query: ALTER TABLE cart_order ADD shipping_zone_id int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER shipping_zone;

Could not execute this query: ALTER TABLE cart_order ADD shipping_country_id int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER shipping_country;

Could not execute this query: ALTER TABLE cart_order ADD payment_zone_id int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER payment_zone;

Could not execute this query: ALTER TABLE cart_order ADD payment_country_id int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER payment_country;

Could not execute this query: ALTER TABLE cart_order_option ADD product_option_value_id int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER order_product_id;

Could not execute this query: ALTER TABLE cart_product ADD sku varchar(64) NOT NULL COMMENT '' COLLATE utf8_unicode_ci AFTER model;

Could not execute this query: ALTER TABLE cart_product ADD location varchar(128) NOT NULL COMMENT '' COLLATE utf8_unicode_ci AFTER sku;

Could not execute this query: ALTER TABLE cart_product ALTER measurement_class_id SET DEFAULT 0;

Could not execute this query: ALTER TABLE cart_product_option_value ADD quantity int(4) NOT NULL DEFAULT '0' COMMENT '' AFTER product_id;

Could not execute this query: ALTER TABLE cart_product_option_value ADD subtract int(1) NOT NULL DEFAULT '0' COMMENT '' AFTER quantity;

Could not execute this query: DELETE FROM cart_extension WHERE `type` = 'module' AND `key` = 'currency';

Could not execute this query: DELETE FROM cart_setting WHERE `group` = 'currency';

Could not execute this query: UPDATE `cart_product` SET `weight_class_id` = '5' WHERE `weight_class_id` = '3';

Could not execute this query: UPDATE `cart_product` SET `weight_class_id` = '6' WHERE `weight_class_id` = '4';

Could not execute this query: ALTER TABLE cart_address DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_category DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_category_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_country DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_coupon DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_coupon_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_coupon_product DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_currency DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_customer ADD approved int(1) NOT NULL DEFAULT '0' COMMENT '' AFTER status, DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_download DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_download_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_extension DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_geo_zone DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_information DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_information_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_language DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_manufacturer DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_order ADD store_id int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER order_id;

Could not execute this query: ALTER TABLE cart_order ADD store_name varchar(64) NOT NULL COMMENT '' COLLATE utf8_bin AFTER store_id;

Could not execute this query: ALTER TABLE cart_order ADD store_url varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin AFTER store_name;

Could not execute this query: ALTER TABLE cart_order ADD customer_group_id int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER customer_id;

Could not execute this query: ALTER TABLE cart_order ALTER customer_id SET DEFAULT 0, DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_order_download DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_order_history DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_order_option DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_order_product DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_order_status DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_order_total DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product ADD length_class_id int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER height;

Could not execute this query: ALTER TABLE cart_product_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product_discount DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product_image DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product_option DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product_option_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product_option_value DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product_option_value_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product_related DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product_special DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product_to_category DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_product_to_download DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_review DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_setting DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_stock_status DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_tax_class DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_tax_rate DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_url_alias DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_user DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_user_group DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_zone DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_zone_to_geo_zone DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Could not execute this query: ALTER TABLE cart_customer ADD store_id int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER customer_id;

Could not execute this query: ALTER TABLE cart_order ADD invoice_id int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER order_id;

Could not execute this query: ALTER TABLE cart_order ADD invoice_prefix varchar(10) NOT NULL COMMENT '' COLLATE utf8_bin AFTER invoice_id;

Could not execute this query: SELECT @dat:=`value` FROM cart_setting WHERE `group` = 'config' and `key` = 'config_description_1';

Could not execute this query: SELECT @id:=`setting_id` FROM cart_setting WHERE `group` = 'config' and `key` = 'config_description_1';

Could not execute this query: SELECT @dat:=`value` FROM cart_setting WHERE `group` = 'config' and `key` = 'config_welcome_1';

Could not execute this query: INSERT INTO `cart_setting` (`setting_id`, `group`, `key`, `value`) VALUES (@id, 'config', 'config_description_1', @dat) ON DUPLICATE KEY UPDATE setting_id=setting_id;

Could not execute this query: ALTER TABLE `cart_country` ADD `status` INT( 1 ) NOT NULL DEFAULT '1';

Could not execute this query: ALTER TABLE `cart_zone` ADD `status` INT( 1 ) NOT NULL DEFAULT '1';

Could not execute this query: ALTER TABLE `cart_category` ADD `status` INT( 1 ) NOT NULL DEFAULT '1';

Could not execute this query: ALTER TABLE `cart_information` ADD `status` INT( 1 ) NOT NULL DEFAULT '1';

Could not execute this query: INSERT INTO `cart_setting` (`setting_id`, `group`, `key`, `value`) VALUES (NULL, 'config', 'config_catalog_limit', '12') ON DUPLICATE KEY UPDATE setting_id=setting_id;

Could not execute this query: INSERT INTO `cart_setting` (`setting_id`, `group`, `key`, `value`) VALUES (NULL, 'config', 'config_admin_limit', '20') ON DUPLICATE KEY UPDATE setting_id=setting_id;

Could not execute this query: INSERT INTO `cart_setting` (`setting_id` ,`group` ,`key` ,`value`) VALUES (NULL , 'config', 'config_compression', '0') ON DUPLICATE KEY UPDATE setting_id=setting_id;

Could not execute this query: INSERT INTO `cart_setting` (`setting_id`, `group`, `key`, `value`) VALUES (NULL, 'config', 'config_review', '1') ON DUPLICATE KEY UPDATE setting_id=setting_id;

Could not execute this query: DELETE FROM cart_setting WHERE `group` = 'latest';

Could not execute this query: INSERT INTO `cart_setting` (`setting_id` ,`group` ,`key` ,`value`) VALUES (NULL, 'latest', 'latest_limit', '8') ON DUPLICATE KEY UPDATE setting_id=setting_id;

Could not execute this query: INSERT INTO `cart_setting` (`setting_id` ,`group` ,`key` ,`value`) VALUES (NULL, 'latest', 'latest_position', 'home') ON DUPLICATE KEY UPDATE setting_id=setting_id;

Could not execute this query: INSERT INTO `cart_setting` (`setting_id` ,`group` ,`key` ,`value`) VALUES (NULL, 'latest', 'latest_status', '1') ON DUPLICATE KEY UPDATE setting_id=setting_id;

Could not execute this query: INSERT INTO `cart_setting` (`setting_id` ,`group` ,`key` ,`value`) VALUES (NULL, 'latest', 'latest_sort_order', '0') ON DUPLICATE KEY UPDATE setting_id=setting_id;

Could not execute this query: DELETE FROM `cart_extension` WHERE `type` = 'module' AND `key` = 'latest';

Could not execute this query: INSERT INTO `cart_extension` (`extension_id`, `type`, `key`) VALUES (NULL, 'module', 'latest') ON DUPLICATE KEY UPDATE extension_id=extension_id;

Could not execute this query: ALTER TABLE `cart_category_description` ADD `meta_keywords` varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin;

Could not execute this query: ALTER TABLE `cart_product_description` ADD `meta_keywords` varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin;

Could not execute this query: ALTER TABLE `cart_product` ADD `cost` DECIMAL(15,4) NOT NULL DEFAULT '0.0000' COMMENT '';

Could not execute this query: ALTER TABLE `cart_product` ADD `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT '';

Could not execute this query: ALTER TABLE `cart_product` ADD `minimum` int(11) NOT NULL DEFAULT '1' COMMENT '';

Could not execute this query: ALTER TABLE `cart_product` ADD `subtract` int(1) NOT NULL DEFAULT '1' COMMENT '';

Could not execute this query: ALTER TABLE `cart_order_product` ADD `subtract` int(1) NOT NULL DEFAULT '0' COMMENT '';

Could not execute this query: UPDATE `cart_setting` SET `value` = '0' WHERE `key` = 'pp_standard_status';

Could not execute this query: DELETE FROM `cart_zone` WHERE `code` = 'ANT';

Could not execute this query: DELETE FROM `cart_zone` WHERE `code` = 'ARM';

Could not execute this query: DELETE FROM `cart_zone` WHERE `code` = 'DOW';

Could not execute this query: DELETE FROM `cart_zone` WHERE `code` = 'FER';

Could not execute this query: DELETE FROM `cart_zone` WHERE `code` = 'LDY';

Could not execute this query: DELETE FROM `cart_zone` WHERE `code` = 'TYR';

Could not execute this query: INSERT INTO `cart_zone` (`zone_id`, `country_id`, `code`, `name`, `status`) VALUES (NULL, 222, 'ANT', 'County Antrim', 1) ON DUPLICATE KEY UPDATE zone_id=zone_id;

Could not execute this query: INSERT INTO `cart_zone` (`zone_id`, `country_id`, `code`, `name`, `status`) VALUES (NULL, 222, 'ARM', 'County Armagh', 1) ON DUPLICATE KEY UPDATE zone_id=zone_id;

Could not execute this query: INSERT INTO `cart_zone` (`zone_id`, `country_id`, `code`, `name`, `status`) VALUES (NULL, 222, 'DOW', 'County Down', 1) ON DUPLICATE KEY UPDATE zone_id=zone_id;

Could not execute this query: INSERT INTO `cart_zone` (`zone_id`, `country_id`, `code`, `name`, `status`) VALUES (NULL, 222, 'FER', 'County Fermanagh', 1) ON DUPLICATE KEY UPDATE zone_id=zone_id;

Could not execute this query: INSERT INTO `cart_zone` (`zone_id`, `country_id`, `code`, `name`, `status`) VALUES (NULL, 222, 'LDY', 'County Londonderry', 1) ON DUPLICATE KEY UPDATE zone_id=zone_id;

Could not execute this query: INSERT INTO `cart_zone` (`zone_id`, `country_id`, `code`, `name`, `status`) VALUES (NULL, 222, 'TYR', 'County Tyrone', 1) ON DUPLICATE KEY UPDATE zone_id=zone_id;

Could not execute this query: ALTER TABLE `cart_product_special` ADD INDEX ( `product_id` ) ;

Could not execute this query: ALTER TABLE `cart_product_discount` ADD INDEX ( `product_id` ) ;

Could not execute this query: ALTER TABLE `cart_product_related` ADD INDEX ( `product_id` ) ;

Could not execute this query: ALTER TABLE `cart_review` ADD INDEX ( `product_id` ) ;

Could not execute this query: ALTER TABLE `cart_country` ADD `postcode_required` int(1) NOT NULL DEFAULT '1' ;

Could not execute this query: UPDATE `cart_country` SET `postcode_required` = 0 WHERE iso_code_3 = 'IRL';

Could not execute this query: UPDATE `cart_country` SET `postcode_required` = 0 WHERE iso_code_3 = 'HKG';

Could not execute this query: UPDATE `cart_country` SET `postcode_required` = 0 WHERE iso_code_3 = 'PAN';

Should I just do an install? I already have a lot of data in my databases that I don't want to redo.
I'm not too knowledgeable on mySQL, but did try to run all those queries but was stopped at the first one:

SQL query:
ALTER TABLE cart_customer ADD customer_group_id int( 11 ) NOT NULL DEFAULT 0 COMMENT '' AFTER STATUS ;
MySQL said: Documentation
#1146 - Table 'tahnee_emporium.cart_customer' doesn't exist

Also, here's my root config (xxxxx's placed on private data):

Code: Select all

<?php


// DIR
define('DIR_APPLICATION', '/xxxxx/catalog/');
define('DIR_SYSTEM', '/xxxxx/system/');
define('DIR_DATABASE', '/xxxxx/system/database/');
define('DIR_LANGUAGE', '/xxxxx/catalog/language/');
define('DIR_TEMPLATE', '/xxxxx/catalog/view/theme/');
define('DIR_CONFIG', '/xxxxx/system/config/');
define('DIR_IMAGE', '/xxxxx/image/');
define('DIR_CACHE', '/xxxxx/cache/');
define('DIR_DOWNLOAD', '/xxxxx/download/');
define('DIR_LOGS', '/xxxxx/system/logs/');

// DB
define('DB_DRIVER', 'mysql');
define('DB_HOSTNAME', 'xxxxx');
define('DB_USERNAME', 'xxxxx');
define('DB_PASSWORD', 'xxxxx');
define('DB_DATABASE', 'xxxxx');
define('DB_PREFIX', 'cart_');
?>

I browsed the forums and saw that I had this exact same problem before and it was the config that fixed it. Still, I'm not too sure about all those mySQL tables. Eeek!
--Folders have also been properly chmodded.
Thanks so much in advance.

tahnmeep

New member

Posts

Joined

Sun Jul 05, 2009 1:24 pm

Re: 1.3.0 hacked; 1.4.9.1 upgrade issues

i2Paq

Global Moderator

Posts

12244

Joined

Mon Nov 09, 2009 7:00 pm

Location

Winkel - The Netherlands

Post by i2Paq » Mon Sep 27, 2010 6:50 pm

Did you test your upgrade from 1.3.0 to 1.3.2 before you moved from 1.3.2 to the current version?

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.

i2Paq

Global Moderator

Posts

12244

Joined

Mon Nov 09, 2009 7:00 pm

Location - Winkel - The Netherlands

Re: 1.3.0 hacked; 1.4.9.1 upgrade issues

tahnmeep

New member

Posts

Joined

Sun Jul 05, 2009 1:24 pm

Post by tahnmeep » Mon Sep 27, 2010 11:34 pm

no.... Should I go back to my original config files and delete all of 1.4.9.1 and go to 1.3.2, test it, get it working to perfection, delete it, replace with 1.4.7, test it, get it working to perfection, delete it, then install 1.4.9.1?? I was hoping to skip all the other installs and just get a nice clean install of the latest, with all the edits required by previous versions in place.
(This is why I'm wondering if I should just do an install instead)....

tahnmeep

New member

Posts

Joined

Sun Jul 05, 2009 1:24 pm

Re: 1.3.0 hacked; 1.4.9.1 upgrade issues

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

Post by Qphoria » Tue Sep 28, 2010 3:02 am

remove the DB_PREFIX 'cart_' in your config files. That was a bug added by 1.2.9 that needs to be removed unless actually using cart_ as your prefix

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

Re: 1.3.0 hacked; 1.4.9.1 upgrade issues

tahnmeep

New member

Posts

Joined

Sun Jul 05, 2009 1:24 pm

Post by tahnmeep » Tue Sep 28, 2010 4:34 am

My site's being a difficult customer

I completely removed the DB Prefix thing and am now getting this error:

Error: Table 'tahnee_emporium.DB_PREFIXsetting' doesn't exist
Error No: 1146
SELECT * FROM DB_PREFIXsetting

There are a handful of DB_PREFIX tables but none of them are DB_PREFIXsetting. Feels like I did something totally backwards because DB_PREFIX seems like a strange title for a table.... :/

tahnmeep

New member

Posts

Joined

Sun Jul 05, 2009 1:24 pm

Re: 1.3.0 hacked; 1.4.9.1 upgrade issues

SteveSherry

Active Member

Posts

583

Joined

Thu Apr 08, 2010 7:47 am

Location

Wirral, UK

Post by SteveSherry » Tue Sep 28, 2010 7:32 am

'cart_' is the DB_PREFIX
you need to remove all mentions of "cart_" not replace it with DB_PREFIX

Code: Select all

ALTER TABLE cart_customer ADD customer_group_id int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER status;

becomes

Code: Select all

ALTER TABLE customer ADD customer_group_id int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER status;

My Website ¦ Summer Madness Special Offer ¦

SteveSherry

Active Member

Posts

583

Joined

Thu Apr 08, 2010 7:47 am

Location - Wirral, UK

Re: 1.3.0 hacked; 1.4.9.1 upgrade issues

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

Post by Qphoria » Tue Sep 28, 2010 8:13 am

lol i didn't say remove that line
just the 'cart_' part
replace with '' <-- 2 single quotes

Qphoria

Administrator

Posts

20056

Joined

Tue Jul 22, 2008 3:02 am

Re: 1.3.0 hacked; 1.4.9.1 upgrade issues

tahnmeep

New member

Posts

Joined

Sun Jul 05, 2009 1:24 pm

Post by tahnmeep » Tue Sep 28, 2010 5:41 pm

Thank you, thank you, I'm getting steps closer-- I can now get into my admin panel, but have several new problems:

-Can't update System>Users>User Groups ("You do not have permission to access this page, please refer to your system administrator." That error goes for all the other pages on Sales as well as the Error Logs.)

-Shop CSS is broken (with SSL on and off) http://www.tahnee.org/emporium/

-Users can't really do much-- all addresses are missing a / (example: .../emporiumindex.php?route=account/login :: There should be a / between /emporium and index.php). I'm guessing this has to do with possibly the admin config file? It looks like everything has proper http:// https:// and /'s where they belong, including the end of the addresses.

Thaaaaannnnkss!

tahnmeep

New member

Posts

Joined

Sun Jul 05, 2009 1:24 pm