James S

Member
  • Content count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

About James S

  1. As you say Freaky, but I am not aware of it but will ask the hosting service if they are aware of issues. Thanks for the help.
  2. Just wondering about anyone's experience of integrating finance providers into CubeCart 6, the shop staff want to integrate 'OmniPort' into the site to offer finance to customers. Is it easy to actually setup? So far I have read the integration guide but its not specific to CC6 or any other version. Interested in others experience of doing this. James
  3. "CSRF or Browser Back Button Used" Just reporting back that this issue seems to be resolved without doing anything - Don't know why but the shop staff have reported that the problem seems to have gone away. Can't say I believe it but.... Thanks for the help. James
  4. 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'
  5. Yes it is the fly out box, type a few letters and select the 'predictive text' as you say no 'enter' is required. Sometimes works sometimes not. I have installed the DB and files on a test domain with an alternative hosting company to test it off the live environment and can't get that to fall over with the same error. So does seem to be hosting related. We were forced to a new host a few weeks back (from Ariotek to Krystal ) The Max_input_Vars is 5000 for both fields (local and master)
  6. HI, Have been having an issue with a CC6.1.5 site using php 5.6. Getting "CSRF or Browser Back Button Used". It happens at verious times but can be simulated by doing a product search in Admin, having found the product pressing 'enter ' drops the page back to the admin landing page with the error on the top banner. The odd thing is it seems to happen every other time a product is searched for...? Am using firefox only open once (back button not being used) The shop staff get it during the day (different IP) and it stops them or slows them down adding products and completing orders. It was happening before an upgrade when using 6.1.11 we had hoped the upgrade would fix it! Any thoughts or ideas greatfully received. James
  7. Many thanks for the responses and information - education never stops!
  8. Neither of the IPs are mine, I might have been using Chrome as well as Firefox and switching. But it could be the shop owner on different PCs? Will keep an eye on it. The shop have been getting some CSRF warnings (in the backend) in the last few days when doing product searches and adding products and getting dumped back at the landing page. The file could not be deleted with the clear error button. Is 0644 correct for that file?
  9. Yes the error message comes back when the file is renamed. This is extract from the error log file (in the site root) last two entries since renaming the file. I have no idea what these are! [19-Feb-2017 23:34:43 UTC] PHP Warning: Stored session data did not match DB record. Session aborted as possible session hijack. Old IP Address: '86.175.151.107' New IP Address: '94.194.197.144' Old User Agent: 'Mozilla/5.0 (iPad; CPU OS 8_4_1 like Mac OS X) AppleWebKit/600.1.4 (KHTML, like Gecko) Version/8.0 Mobile/12H321 Safari/600.1.4' New User Agent: 'Mozilla/5.0 (iPad; CPU OS 9_3_2 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13F69 Safari/601.1' in /home/sitename/public_html/shop/classes/session.class.php on line 675 [19-Feb-2017 23:43:52 Europe/London] PHP Warning: array_keys() expects parameter 1 to be array, boolean given in /home/sitename/public_html/shop/admin_lATOmV/sources/dashboard.index.inc.php on line 311
  10. Thanks for that, yes a fresh page does appear when the link is clicked. I renamed the file 'upgrade_error_log' to 'old' and on browser refresh the error clears. The permissions are 0644 for the file and the 'backup' folder is 0755, not sure what they should be. php error messages were not on, but are now so will see what happens! Thanks for your assistance.
  11. Not sure if I have an issue with this or not, although I have manually upgraded to 6.1.5, I still have this error message (below) in the Error Log on the upgrade tab. Clicking 'delete error log ' has no effect. Should I do anything? ----- Upgrade log to 6.1.1 (15 Feb 2017 - 14:41:50) ----- includes/extra/.htaccess - Extract Status: write_error includes/extra/index.php - Extract Status: write_error includes/extra/.htaccess . includes/extra/index.php . ------------------------------