Jump to content

adamfrey

Member
  • Posts

    21
  • Joined

  • Last visited

Everything posted by adamfrey

  1. I have recently gotten a LOT of orders having problems checking out. I checked the error log and have a LOT of errors. I seem to remember a maintenance option awhile back that would rebuild the DB and correct any errors, but does not seem to do 1) File: [catbanners.class.php] Line: [38] "select * from Category_banners WHERE status = 1 AND cat_id = sale AND flash=1 order by priority ASC " - Unknown column 'sale' in 'where clause' 2) File: [filter.class.php] Line: [95] "SELECT max(I.price) as maxval from `CubeCart_inventory` as I INNER JOIN `CubeCart_category_index` as CI ON I.product_id = CI.product_id WHERE I.status=1 AND CI.cat_id = " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 3) File: [filter.class.php] Line: [62] "Select OV.value_name, OV.value_id FROM CubeCart_option_assign AS OA INNER JOIN CubeCart_category_index as CI ON OA.product = CI.product_id INNER JOIN CubeCart_option_value AS OV ON OV.value_id = OA.value_id where CI.cat_id= AND OA.option_id=6 group by OV.value_name " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND OA.option_id=6 group by OV.value_name' at line 1 When I look in the DB maintenance, there is also this error on the CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY. Thank you for any advice or help, Adam
  2. So my site displays Out of Stock on the desktop version of the website, but it does not show on the mobile site. Any advice or anyone interested in getting hired to fix this? Thanks. http://www.euphonium.com/store/david-childs-mouthpiece-dc4-silver-plate-p681-p682.html
  3. Does anyone know an add-on for V6 that allows you to add the Customer name on a purchased PDF?
  4. Mine doesn't work under php 7.0 when I change it on bluehost. Would it be related to my skin?
  5. I have version 5 and like it very much. I need to use PHP 7 on my website for some other parts of the website. Is there a way to write the php.ini so that I can make it use php 5.6?
×
×
  • Create New...