Jump to content

[Resolved] Vareity of Issues


Trickyjimz

Recommended Posts

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

 

 

 

Link to comment
Share on other sites

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.

 

Link to comment
Share on other sites

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'
Link to comment
Share on other sites

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 by bsmither
Link to comment
Share on other sites

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

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...