Jump to content

lexijade

Member
  • Posts

    41
  • Joined

  • Last visited

Everything posted by lexijade

  1. SELECT I.* FROM `CubeCart_inventory` AS I JOIN `CubeCart_category` AS C ON C.cat_id=I.cat_id AND C.`status`=1 AND I.status = '1' ORDER BY I.date_added DESC, I.product_id DESC LIMIT 4 That's the line I get on the debug, so clearly that's part of the issue since it's missing the latest part. I noticed a new problem, which may also be a factor. When I check the "include in latest products" box it doesn't save that when I update the product. I can make other changes at the same time and it'll save those, but it will revert back to unchecked for the latest product box. and this is Line 95-104 in cubecart.class.php $products = array(); $where = $GLOBALS['catalogue']->outOfStockWhere(array('I.status' => '1', 'I.latest' => '1'), 'I'); if ($GLOBALS['config']->get('config', 'catalogue_latest_products')) { $query = sprintf("SELECT I.* FROM `%1\$sCubeCart_inventory` AS I JOIN `%1\$sCubeCart_category` AS C ON C.cat_id=I.cat_id AND C.`status`=1 AND $where ORDER BY I.date_added DESC, I.product_id DESC", $GLOBALS['config']->get('config', 'dbprefix')); $latestProducts = $GLOBALS['db']->query($query, (int)$GLOBALS['config']->get('config', 'catalogue_latest_products_count')); foreach ($GLOBALS['hooks']->load('class.cubecart.latest_products') as $hook) { include $hook; }
  2. I don't understand what I'm looking for in the debug and once I find that, how it helps me fix it. My limit is set to 4. That part is working correctly.
  3. All of my products show up whether or not the "Include in latest products" box is checked. Checking the box does nothing. My guess is I messed up the coding for that at some point, but have no idea how or where to look to fix it. But it would be really nice to be able to actually pick what shows up in that list and not just the 4 most recent products created. In a related question, is there a way to have it show products that were recently updated vs just created. For example if I update a product and have it selected as "Include in latest products", can I make that item show up in latest even if it wasn't just created?
  4. How do I do a manual upgrade without losing all of the changes/customization that I've done?
  5. Still having this issue. Would love to upgrade to 6.1.14 and stop having the "WARNING: Your store appears to be using source code from 6.1.14 but the database is still at 6.0.5. Please complete the upgrade by running the setup process."
  6. Any new thoughts? I'd love to get our site to be completely updated!
  7. Here's the code from line 110 to line 155 ## If version is less then 4 or 5 try to fix database encoding if (!$_SESSION['setup']['db_converted'] && version_compare($current, '5.0.0', '<')) { /* ######################## ## Following code based on; ## Migrating MySQL Data to Unicode ## http://daveyshafik.com/archives/166-migrating-mysql-data-to-unicode.html ## Thanks to Davey Shafik ## ######################## */ $tables = $db->getRows(); foreach ($tables as $table) { ## Get Schema if ($schema = $db->misc('SHOW CREATE TABLE '.$table['Name'])) { ## Fix Schema and Create Temp Table $find = array("latin1", $table['Name']); $replace = array("utf8", $table['Name'].'_utf8'); if($db->misc(str_replace($find, $replace, $schema[0]['Create Table']))) { if ($db->misc("SHOW TABLES LIKE '".$table['Name']."_utf8'", false)) { ## Copy Data $db->misc('INSERT INTO '.$table['Name'].'_utf8 SELECT * FROM '.$table['Name']); ## Deleting Original Table $db->misc('DROP TABLE '.$table['Name']); ## Renaming Temporary Table $db->misc('ALTER TABLE '.$table['Name'].'_utf8 RENAME TO '.$table['Name']); } } } } $_SESSION['setup']['db_converted'] = true; } ## Updates from version 3 if (!$_SESSION['setup']['config_converted'] && version_compare($current, '4.0.0', '<')) { ## Version 3: Upgrade config data $config_string = $db->select('CubeCart_config', array('array'), array('name' => 'config')); if ($config_string) { $old_config = unserialize($config_string[0]['array']); foreach ($old_config as $key => $value) { $new_config[base64_decode($key)] = stripslashes(base64_decode($value)); } $db->update('CubeCart_config', array('array' => base64_encode(json_encode($new_config))), array('name' => 'config')); } $_SESSION['setup']['short_lang_identifier'] = $new_config['defaultLang']; unset($old_config, $new_config, $config_string);
  8. [04-Jan-2018 23:07:39 UTC] PHP Notice: Undefined index: db_converted in /home/content/88/5118188/html/setup/setup.upgrade.php on line 111 [04-Jan-2018 23:07:39 UTC] PHP Notice: Undefined index: config_converted in /home/content/88/5118188/html/setup/setup.upgrade.php on line 142 that's what in the error_log file in the setup folder
  9. [04-Jan-2018 14:59:59 America/Tijuana] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/content/88/5118188/html/classes/db/database.class.php on line 900
  10. The page is refreshing, but the screen doesn't change. It's still going from 6.0.5 to 6.0.6
  11. Been over 2 hours and nothing has happened. I have tried clicking continue and nothing happens when I do that either.
  12. I am pretty sure it is auto-refreshing. How many times should I have to click continue, because that doesn't seem to be doing anything either? There aren't any "steps" it's just that same screen going from 6.0.5 to .6. I have had it open since I took the screenshot, and it's still on that same page.
  13. It just gets stuck on the "Upgrading from version 6.0.5 to version 6.0.6" forever.
  14. Whenever I try to update to the latest version, it just gets stuck. I just close the window then, and then I get the error in admin "WARNING: Your store appears to be using source code from 6.1.13 but the database is still at 6.0.5.Please complete the upgrade by running the setup process." Help!
  15. I want to replace the text that says $0 with Call for Price. I have done this before, but when I updated it reverted, and I can't for the life of me find where I go to change this! Please help.
  16. Oh duh. Totally didn't even see that in the admin. That's exactly what I was looking for, thanks!
  17. Is there a way to format it so that the price just shows as whole dollars with no cents? Nothing we sell has cents, so I would like to hide those and have it just be the dollar amount.
  18. I still haven't figured out how I changed this before. I have looked all over the files and can't find anything.
  19. "1. Basket 2. Get Quote 3. Payment 4. Complete" is what it says now at the top when you are in the checkout process. I edited the skin (or something) so that step 3 is 'Complete' and nothing says payment. I know cubecart will still let the order go through, I just don't want to confuse people. I just can't for the life of me remember how I did it.
  20. I changed the checkout progress list to remove the 'payment' step since we are doing quotes and not taking payments. But now I updated versions and it reverted back and I have no idea how I did it. I can't find it anywhere. Help please!
  21. I don't see any option to export orders. Also I definitely need a way to export complete customer list as well. Thanks!
  22. I am using V6 with an old skin apparently lol. Thanks for the code. I put that in instead of what I had before and it works perfect! This has been driving me insane, but now it's fixed. Thank you so much for all of your help!!
  23. With this as my code nothing shows up on the page- it's totally broken, but there aren't any errors in the debug. $noKeys = count($searchArray); $regexp = ''; $rlike = ' AND ( '; for ($i=0; $i<$noKeys; ++$i) { $ucSearchTerm = strtoupper($searchArray[$i]); if ( ($ucSearchTerm != 'AND') && ($ucSearchTerm != 'OR') && (strlen($ucSearchTerm) > 0) ) { $searchArray[$i] = str_replace(array('%','_'), array('%','_'), $searchArray[$i]); $regexp = '%'.$searchArray[$i].'%'; } else { $rlike .= " ".$ucSearchTerm." "; continue; } $rlike .= "(I.name LIKE '".$regexp."' OR I.seo_meta_keywords LIKE '".$regexp."' OR I.product_code LIKE '".$regexp."') AND "; } $rlike = substr($rlike, 0, strlen($rlike)-5); $rlike .= " )"; } $q2 = "SELECT I.* FROM ".$GLOBALS['config']->get('config', 'dbprefix')."CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price
×
×
  • Create New...