bsmither Posted May 3, 2017 Share Posted May 3, 2017 Let's just make sure that 'date_added' is, in fact, a column in the CubeCart_inventory table for this store. Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 3, 2017 Author Share Posted May 3, 2017 Doesn't look like it. I have 34 columns. Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 3, 2017 Share Posted May 3, 2017 CC617 inventory table has 37 columns. Who knows what else has been missed. If this is a very fresh store, consider blowing away the database and re-installing. Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 3, 2017 Author Share Posted May 3, 2017 it's been around since v3 i believe. How can I add this column? Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 3, 2017 Share Posted May 3, 2017 The 'date_added' column was introduced in CC410. So, is this store an upgrade from a CC3/4 installation? Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 3, 2017 Author Share Posted May 3, 2017 yeah, but i've been upgrading pretty regularly throughout the years. You'd think that the Maintenance/Database tab would be telling me i'm missing things. Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 3, 2017 Share Posted May 3, 2017 CubeCart has no "schema verifier" (other than indexes at this point). Using that external utility, compare these columns and add/change any differences: `product_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product ID', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Status', `product_code` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Product Code', `quantity` int(11) NOT NULL DEFAULT '1' COMMENT 'Quantity', `description` text COLLATE utf8_unicode_ci COMMENT 'Description', `description_short` text NULL COLLATE utf8_unicode_ci COMMENT 'Short Description', `price` decimal(16,2) NOT NULL DEFAULT '0.00' COMMENT 'Retail Price', `sale_price` decimal(16,2) DEFAULT '0.00' COMMENT 'Sale Price', `cost_price` decimal(16,2) NOT NULL DEFAULT '0.00' COMMENT 'Cost Price', `name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Product Name', `cat_id` int(10) unsigned DEFAULT '0' COMMENT 'Main Category ID', `popularity` int(10) unsigned DEFAULT '0' COMMENT 'Popularity', `stock_level` int(11) DEFAULT '0' COMMENT 'Main Stock Level', `stock_warning` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Main Stock Warning level', `use_stock_level` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Use Stock Control', `digital` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Digital?', `digital_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Digital Path', `product_weight` decimal(10,3) DEFAULT NULL COMMENT 'Product Weight', `tax_type` int(10) unsigned DEFAULT NULL COMMENT 'Tax Type', `tax_inclusive` tinyint(1) unsigned DEFAULT '0' COMMENT 'Price inclusive of tax', `featured` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Featured product', `latest` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Included on Homepage', `seo_meta_title` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'SEO Meta Title', `seo_meta_description` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'SEO Meta Description', `seo_meta_keywords` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'SEO Meta Keywords', `upc` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'UPC Code', `ean` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'EAN Code', `jan` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'JAN Code', `isbn` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ISBN Code', `brand` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Brand', `google_category` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Google Cat', `gtin` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'GTIN Code', `mpn` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'MPN Code', `date_added` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date Added', `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last Updated', `manufacturer` int(10) unsigned DEFAULT NULL COMMENT 'Manufacturer ID', `condition` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Condition', `available` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `minimum_quantity` INT( 10) NOT NULL DEFAULT '0', PRIMARY KEY (`product_id`), KEY `status` (`status`), KEY `popularity` (`popularity`), FULLTEXT KEY `fulltext` (`product_code`,`description`,`name`) Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 3, 2017 Author Share Posted May 3, 2017 That did it! Phew! Now, for the issue with my other site, should I do it as a seperate thread, or continue here? Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 3, 2017 Share Posted May 3, 2017 Separate. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.