Upgraded from 1.3.5 SP4 to 2.08 and get the error that cscart_product_popularity’ doesn’t exist.
Is there a script to run to build this tables and its indices?
Here is the backtrace…
Backtrace:
File: /home/ferriswh/public_html/store/core/fn.database.php
Line: 311
Function: db_error
File: /home/ferriswh/public_html/store/core/fn.database.php
Line: 37
Function: db_query
File: /home/ferriswh/public_html/store/core/fn.catalog.php
Line: 2980
Function: db_get_array
File: /home/ferriswh/public_html/store/core/fn.cms.php
Line: 568
Function: fn_get_products
File: /home/ferriswh/public_html/store/core/templater_plugins/function.block.php
Line: 46
Function: fn_get_block_items
File: /home/ferriswh/public_html/store/var/compiled/customer/%%FF^FFE^FFEE6CE5%%left.tpl.php
Line: 7
Function: smarty_function_block
File: /home/ferriswh/public_html/store/core/class.templater.php
Line: 133
Function: include
File: /home/ferriswh/public_html/store/var/compiled/customer/%%72^72D^72DAF6E8%%main.tpl.php
Line: 15
Function: _smarty_include
File: /home/ferriswh/public_html/store/core/class.templater.php
Line: 133
Function: include
File: /home/ferriswh/public_html/store/var/compiled/customer/%%45^45E^45E480CD%%index.tpl.php
Line: 312
Function: _smarty_include
File: /home/ferriswh/public_html/store/lib/templater/Smarty.class.php
Line: 1258
Function: include
File: /home/ferriswh/public_html/store/lib/templater/Smarty.class.php
Line: 1108
Function: fetch
File: /home/ferriswh/public_html/store/core/class.templater.php
Line: 170
Function: display
File: /home/ferriswh/public_html/store/core/fn.control.php
Line: 420
Function: display
File: /home/ferriswh/public_html/store/index.php
Line: 26
Function: fn_dispatch
Built up a clean 2.08 install
Exported the cscart_product_popularity table to SQL from the clean install
Ran the script on the new database a everything works…
This was the script to create the missing table…
– phpMyAdmin SQL Dump
– version 3.2.2.1
– http://www.phpmyadmin.net
–
– Host: 127.0.0.1:3306
– Generation Time: Oct 27, 2009 at 09:58 AM
– Server version: 5.0.67
– PHP Version: 5.2.6
SET SQL_MODE=“NO_AUTO_VALUE_ON_ZERO”;
–
– Database: ``
–
– --------------------------------------------------------
–
– Table structure for table cscart_product_popularity
–
CREATE TABLE IF NOT EXISTS cscart_product_popularity
(
product_id
mediumint(8) NOT NULL default ‘0’,
viewed
int(11) NOT NULL default ‘0’,
added
int(11) NOT NULL default ‘0’,
deleted
int(11) NOT NULL default ‘0’,
bought
int(11) NOT NULL default ‘0’,
total
int(11) NOT NULL default ‘0’,
PRIMARY KEY (product_id
),
KEY total
(product_id
,total
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
–
– Dumping data for table cscart_product_popularity
–
INSERT INTO cscart_product_popularity
(product_id
, viewed
, added
, deleted
, bought
, total
) VALUES
(1, 1, 0, 0, 0, 3);