Trickyjimz Posted March 1, 2017 Share Posted March 1, 2017 I have a variety of issues with cube cart currently. Admin Login When i login it says failed then I have to try again i then get a blank page but have to refresh to get the page to work. Update When logged in I get below show up even though I have tried to update numerous times and it tells me I am running the latest version. WARNING: Your store is not up-to-date, v6.1.5 is available, but you are running v6.1.1 Upgrade Now Security Issue I have updated my max_input_vars to 6000 but I am still constantly getting this issue. (I only have one window open with admin session running) Security Alert: Possible Cross-Site Request Forgery (CSRF) or browser back button used. Reviews I have tried to add reviews it either says added successfully and it doesn't show up anywhere or I get the issue as shown above. Would appreciate some help with these issues. Kind Regards James Quote Link to comment Share on other sites More sharing options...
keat Posted March 1, 2017 Share Posted March 1, 2017 Is there anything in the error logs ? Also, when the login fails, are you using a cached password ? Might be worth clearing your browser cache. Regarding the version, using PHPMyAdmin open up the table history, and see what version numbers are there. Quote Link to comment Share on other sites More sharing options...
Trickyjimz Posted March 1, 2017 Author Share Posted March 1, 2017 Wow just seen that i got 330 pages of error logs most looking like this Date Message Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:47 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:39 File: [catalogue.class.php] Line: [322] "SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_reviews` ORDER BY time DESC LIMIT 5 OFFSET 0;" - Unknown column 'time' in 'order clause' Today, 15:26 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:26 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:26 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:26 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:26 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Today, 15:26 File: [cubecart.class.php] Line: [127] "SELECT SUM(`rating`) AS Score, COUNT(`id`) as Count FROM `CubeCart_reviews` ;" - Unknown column 'rating' in 'field list' Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 1, 2017 Share Posted March 1, 2017 (edited) The table CubeCart_reviews first appeared in CC400, and has a 'rating' column. Initially an integer (0-5), then changed to hold a decimal (0.0 - 5.0) at CC500. For this message to appear, something strange must have happened to this database table. Please use phpMyAdmin to look at this table directly. Edited March 1, 2017 by bsmither Quote Link to comment Share on other sites More sharing options...
Trickyjimz Posted March 1, 2017 Author Share Posted March 1, 2017 Ok taken a look this is what I am getting (If i am looking at the right place) Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 1, 2017 Share Posted March 1, 2017 CC3 doesn't have reviews, so this table does not come from a stock CC3 installation. Therefore, I must make an educated guess this is a remnant of a third-party module that gave CC3 this capability. Unfortunately, there has been a name collision. Please delete this table. There is nothing in it anyway. Then (taken from the file /setup/db/install/structure.sql), execute this command to create a CC6 table: CREATE TABLE IF NOT EXISTS `CubeCart_reviews` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `approved` SMALLINT(1) UNSIGNED NOT NULL DEFAULT '0', `product_id` INT UNSIGNED NOT NULL DEFAULT '0', `customer_id` INT UNSIGNED NOT NULL DEFAULT '0', `rating` DECIMAL(2,1) UNSIGNED NOT NULL DEFAULT '0.0', `vote_up` INT NOT NULL DEFAULT '0', `vote_down` INT NOT NULL DEFAULT '0', `anon` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `name` VARCHAR(255) NOT NULL, `email` VARCHAR(254) NOT NULL, `title` VARCHAR(255) NOT NULL, `review` TEXT NOT NULL, `ip_address` VARCHAR(45) NOT NULL COMMENT 'Supports IPv6 addresses', `time` INT UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `product_id` (`product_id`), KEY `vote_up` (`vote_up`), KEY `vote_down` (`vote_down`), KEY `approved` (`approved`), FULLTEXT KEY `fulltext` (`name`,`email`,`title`,`review`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; #EOQ Quote Link to comment Share on other sites More sharing options...
Trickyjimz Posted March 1, 2017 Author Share Posted March 1, 2017 Thank you for your help all repaired. 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.