All Activity

This stream auto-updates   

  1. Today
  2. Thank you for your help all repaired.
  3. Since my last upgrade 6.1.5 I have not been able to see my Options fully only the first letter (as shown in the images) has anyone else had this issue and if so how do we sort it out?
  4. Odd. Sorry for any confusion.
  5. It wasn't me, I don't think I have ever used the online chat, and I wasn't anywhere near a computer or smartphone then, I was driving!
  6. Sorry.. you left a message via the offline live chat which creates a ticket. This was on 27 February 2017 at 08:50 PM (UK time).
  7. Hi Al, AFAIK I don't have any support tickets open, and if I did the email would be the same as the one for this forum, which is working because I got the notification of your reply.
  8. Sorry but don't work...
  9. Hi Peter, I replied to your support ticket about this but the email bounced. The answer is no... but I have opened a feature request here: https://github.com/cubecart/v6/issues/1525
  10. My store is currently in Sale Mode, giving a global 10% discount. If I issue a discount coupon, it comes off after the 10% sale discount has been applied. I need to issue coupon codes to give 50% discount, but off of the base price, not the sale price. Is there any way to do this?
  11. 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
  12. SEO is like religion. There are a number of common tenets, but just as many differences of opinion and understanding. Plus, it may make a difference when these tools were written - implementing the understandings of the day - which have the potential to change over time much as do the rules of the inscrutable overlord that is Google.
  13. Ok taken a look this is what I am getting (If i am looking at the right place)
  14. As I understand it this is known about and should be fixed in 6.1.6.
  15. This is a known issue and will not cause any damage to the store. The programmer's are working on it. CubeCart makes three attempts at searching for a product. 1. Using a complicated (as implemented by the database server) algorithm that searches the database using a 'relevance approach'. The results have a "relevance weighting factor". If nothing found, 2. Using an expression looking for whole words. If nothing found, 3. Looking for the characters entered which may appear anywhere. The problem with the CubeCart code is that the Advanced Search page has a sort selector that defaults to a sort method (Relevance) that is only applicable to method #1. CubeCart is supposed to drop that sort method and default to another, legal sort criteria for #2 or #3, but doesn't. Thus, the error message from the database server. You shouldn't see this error if you choose to sort by something other than Relevance on the Advanced Search page.
  16. 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.
  17. 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'
  18. 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.
  19. 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
  20. Whilst try to find out why we have CSRF warnings I have copied the errors below from the System Error Log, could some one please explain what it means and what I need to do to stop it happening - thanks you in advance. James Today, 12:29 File: [catalogue.class.php] Line: [1817] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[:<:]]Bow[[:>:]]' OR I.description RLIKE '[[:<:]]Bow[[:>:]]' OR I.product_code RLIKE '[[:<:]]Bow[[:>:]]') ORDER BY Relevance DESC LIMIT 12 OFFSET 0 " - Unknown column 'Relevance' in 'order clause' Today, 08:13 File: [catalogue.class.php] Line: [1817] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[:<:]]Plr[[:>:]].*[[:<:]]500[[:>:]]' OR I.description RLIKE '[[:<:]]Plr[[:>:]].*[[:<:]]500[[:>:]]' OR I.product_code RLIKE '[[:<:]]Plr[[:>:]].*[[:<:]]500[[:>:]]') ORDER BY Relevance DESC LIMIT 12 OFFSET 0 " - Unknown column 'Relevance' in 'order clause' Yesterday, 21:40 File: [catalogue.class.php] Line: [1817] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[:<:]]bag[[:>:]]' OR I.description RLIKE '[[:<:]]bag[[:>:]]' OR I.product_code RLIKE '[[:<:]]bag[[:>:]]') ORDER BY Relevance DESC LIMIT 12 OFFSET 0 " - Unknown column 'Relevance' in 'order clause' Yesterday, 15:17 File: [catalogue.class.php] Line: [1817] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[:<:]]711[[:>:]]' OR I.description RLIKE '[[:<:]]711[[:>:]]' OR I.product_code RLIKE '[[:<:]]711[[:>:]]') ORDER BY Relevance DESC LIMIT 12 OFFSET 0 " - Unknown column 'Relevance' in 'order clause'
  21. I've just cleared out a few hundred today, although I've no idea how long they've been there. My server now runs Mod Security so hopefully, this should be well protected anyway.
  22. Regardless of which of these so called free SEO tools I use, each one has thier own take on what's good and whats not. I'm not sure I can entirley trust that any have a definitive answer. Any thoughts.
  23. Google translate attempt:
  24. It is a feature of the Foundation skin. CubeCart is not aware of it. A skin can have whatever the skin designer wants. A stock CubeCart package comes with the Foundation skin, and the sample Homepage document has a slideshow.
  1. Load more activity