Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

Profile Information

  • Gender
  • Location
    San Diego, CA

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. How do I do a manual upgrade without losing all of the changes/customization that I've done?
  2. 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."
  3. Any new thoughts? I'd love to get our site to be completely updated!
  4. 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);
  5. [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
  6. [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
  7. The page is refreshing, but the screen doesn't change. It's still going from 6.0.5 to 6.0.6
  8. Been over 2 hours and nothing has happened. I have tried clicking continue and nothing happens when I do that either.
  9. 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.
  10. It just gets stuck on the "Upgrading from version 6.0.5 to version 6.0.6" forever.
  11. 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!
  12. 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.
  13. lexijade

    fuzzy search

    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!!
  14. lexijade

    fuzzy search

    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
  15. lexijade

    fuzzy search

    Tried this again and it worked. Seems to do exactly what is required. Thanks bsmither. I must be doing something wrong because that doesn't work for me :/ [Notice] /home/content/88/5118188/html/ltcube/classes/catalogue.class.php:1530 - Undefined variable: order [Notice] /home/content/88/5118188/html/ltcube/classes/catalogue.class.php:1598 - Undefined variable: noKeys I am getting these errors, not sure if that helps.