If this is your first visit, check our documentation. To post, register or login.
Forums / Installing on a Linux/Unix Server / Database did not upgrade

Database did not upgrade

Started by athena on 15 Mar 2013, 10:41 PM · Views: 3,924

Results 21 to 29 of 29
16 Mar 2013, 10:24 PM
#21
athena avatar

athena

Totally Zenned

Join Date:
Jan 2006
Location:
NM
Posts:
740
Plugin Contributions:
0

Database did not upgrade

I'm wondering if one possible problem in this mess was that I created a new template....but it was actually my default template on the old server, just had a new name. For instance, I had, in error, done all my modifications using the "classic" folder in the old cart. In the new install I put all those modifications in a folder "newcart" and that was chosen in the admin when I installed the mods. The old db had never heard of this new template folder.

I know you are right about not trying to upgrade while moving...but I didn't see it that way as I could not run the upgrade sql on the old server and I did not want all the old problems following me to the new server. I still don't...and I'm loath to move those old files over. My cart was loading so slow....3 to 12 seconds per page. It is so blazing fast on this Linux server I'm thinking we'll need helmets. I need this store to run this fast and my old store is really full of upgrade after upgrade and multiple mod installs from over the many years we've used zencart.

Thank you...any who...

16 Mar 2013, 10:51 PM
#22
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Database did not upgrade

I'm loath to move those old files over
What version are we talking about - if it is the 1.3.9x series I would move all the files and grab a fresh database backup and import it....

Then when all is well - install 1.5.1 in a folder and perform the upgrade on the linux server in a folder and test test test
Once you are satisfied, you can migrate your install to these upgraded files & import the database - which all of this should be no more than about an hour of downtime

Zen-Venom Get Bitten

17 Mar 2013, 6:25 PM
#23
athena avatar

athena

Totally Zenned

Join Date:
Jan 2006
Location:
NM
Posts:
740
Plugin Contributions:
0

Re: Database did not upgrade

I re-installed and upgraded my db and everything seems ok now.

but for some reason the configuration file settings were not correct during the install.

So i've been at it for hours again and I think there must just be some lag time from my changes to upload...maybe this has been part of my issue installing. It kept adding an extra url to the shared ssl so I went in a changed it to the following. I'm convinced I have the correct settings for my config files, but my eyes are falling out by now so maybe it is just something I can't see. Could you take a look? The admin side is ok. I discovered this error after the zc_install and tried to click on checkout button with an item in the store. It had a double url. I found that the ssl was in the DIR_WS_HTTPS_CATALOG instead of just the slash. My store in the root....but now I can't see the store at all with the below changes. I can log into the admin securely ok.

// Define the webserver and path parameters
  // HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
  // HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
  define('HTTP_SERVER', 'http://mydomain.com');
  define('HTTPS_SERVER', 'https://cloudwebx1.ssldomain.com/~bozo');

  // Use secure webserver for checkout procedure?
  define('ENABLE_SSL', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
  // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
  define('DIR_WS_CATALOG', '/');
  define('DIR_WS_HTTPS_CATALOG', '/');
17 Mar 2013, 6:39 PM
#24
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Database did not upgrade

athena:

I think there must just be some lag time from my changes to upload
If there's any lag-time, then it's something your hosting company has done on their servers. Nothing in Zen Cart does any sort of caching that would cause lag-time between files being usable. Maybe your host has some extra caching tools turned on?

Or, maybe your configure.php files are just getting flipped into read-only mode automatically (ZC does this by default for security reasons every time you click a link on the site) so if you make an edit, upload it, click on your site and find a problem, then go back to edit and upload but don't make the file writable first before uploading, that could be your "lag" source.

As far as the content of your configure.php files, it would be much more helpful if you posted both your admin and non-admin file contents COMPLETELY and without ANY changes other than removing the DB password. Otherwise we're only guessing at the big picture and then we have to post back and forth 5 times to finally get that from you before being able to give a working solution.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

17 Mar 2013, 7:00 PM
#25
athena avatar

athena

Totally Zenned

Join Date:
Jan 2006
Location:
NM
Posts:
740
Plugin Contributions:
0

Re: Database did not upgrade

THANK YOU...I do realize it is my own lack of understanding about all this...which goes to prove zencart is workable for just about anyone who needs a store.

Here is admin:

<?php
/**
 * @package Configuration Settings circa 1.5.1
 * @copyright Copyright 2003-2012 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * File Built by zc_install on 2013-03-17 07:25:15
 */


/*************** NOTE: This file is similar, but DIFFERENT from the "store" version of configure.php. ***********/
/***************       The 2 files should be kept separate and not used to overwrite each other.      ***********/

/**
 * WE RECOMMEND THAT YOU USE SSL PROTECTION FOR YOUR ENTIRE ADMIN:
 * To do that, make sure you use a "https:" URL for BOTH the HTTP_SERVER and HTTPS_SERVER entries:
 */
  define('HTTP_SERVER', 'http://topkayaker.com');
  define('HTTPS_SERVER', 'https://cloudwebx1.ssldomain.com/~topkayak');
  define('HTTP_CATALOG_SERVER', 'http://topkayaker.com');
  define('HTTPS_CATALOG_SERVER', 'https://cloudwebx1.ssldomain.com/~topkayak');

  // secure webserver for admin?  Valid choices are 'true' or 'false' (including quotes).
  define('ENABLE_SSL_ADMIN', 'true');

  // secure webserver for storefront?  Valid choices are 'true' or 'false' (including quotes).
  define('ENABLE_SSL_CATALOG', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
  // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
  $t1 = parse_url(HTTP_SERVER);$p1 = $t1['path'];$t2 = parse_url(HTTPS_SERVER);$p2 = $t2['path'];

  define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', $p1) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
  define('DIR_WS_CATALOG', '/');
  define('DIR_WS_HTTPS_ADMIN', preg_replace('#^' . str_replace('-', '\-', $p2) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
  define('DIR_WS_HTTPS_CATALOG', '/');

  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
  define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
  define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
  define('DIR_WS_INCLUDES', 'includes/');
  define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
  define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
  define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
  define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
  define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
  define('DIR_WS_CATALOG_LANGUAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');

// * DIR_FS_* = Filesystem directories (local/physical)
  define('DIR_FS_ADMIN', realpath(dirname(__FILE__) . '/../') . '/');
  //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
  define('DIR_FS_CATALOG', '/home/topkayak/public_html/');

  //the following path is a COMPLETE path to the /logs/ folder  eg: /var/www/vhost/accountname/public_html/store/logs ... and no trailing slash
  define('DIR_FS_LOGS', '/home/topkayak/public_html/logs');

  define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
  define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
  define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
  define('DIR_FS_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
  define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
  define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
  define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', '');
  define('DB_CHARSET', 'utf8');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'topkayak_admin');
  define('DB_SERVER_PASSWORD', 'password');
  define('DB_DATABASE', 'topkayak_shop');

  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache 
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash  
  define('SQL_CACHE_METHOD', 'none'); 
  define('DIR_FS_SQL_CACHE', '/home/topkayak/public_html/cache');


// Define the webserver and path parameters
  // Main webserver: eg-http://www.your_domain.com - 
  // HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
  // HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
  // HTTP_CATALOG_SERVER is your Main webserver: eg-http://www.your_domain.com
  // HTTPS_CATALOG_SERVER is your Secure webserver: eg-https://www.your_domain.com
  /* 
   * URLs for your site will be built via:  
   *     HTTP_SERVER plus DIR_WS_ADMIN or
   *     HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or 
   *     HTTP_SERVER plus DIR_WS_CATALOG or 
   *     HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG
   * ...depending on your system configuration settings
   */
// EOF

Here is store...AH! I just copied it off the server and all the settings were blank!...so it was not letting me edit it after all:

<?php
/**
 * @package Configuration Settings circa 1.5.1
 * @copyright Copyright 2003-2012 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * File Built by zc_install on 2013-03-17 07:25:15
 */


/*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/
/***************       The 2 files should be kept separate and not used to overwrite each other.      ***********/

// Define the webserver and path parameters
  // HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
  // HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
  define('HTTP_SERVER', 'http://topkayaker.com');
  define('HTTPS_SERVER', 'https://cloudwebx1.ssldomain.com/~topkayak');

  // Use secure webserver for checkout procedure?
  define('ENABLE_SSL', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
  // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
  define('DIR_WS_CATALOG', '/');
  define('DIR_WS_HTTPS_CATALOG', '/');

  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_INCLUDES', 'includes/');
  define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
  define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
  define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
  define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
  define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
  define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

  define('DIR_WS_PHPBB', '/');

// * DIR_FS_* = Filesystem directories (local/physical)
  //the following path isALOG', '/hom a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
  define('DIR_FS_CATe/topkayak/public_html/');

  //the following path is a COMPLETE path to the /logs/ folder  eg: /var/www/vhost/accountname/public_html/store/logs ... and no trailing slash
  define('DIR_FS_LOGS', '/home/topkayak/public_html/logs');

  define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
  define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
  define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
  define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
  define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', '');
  define('DB_CHARSET', 'utf8');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'topkayak_admin');
  define('DB_SERVER_PASSWORD', 'password');
  define('DB_DATABASE', 'topkayak_shop');

  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache 
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash  
  define('SQL_CACHE_METHOD', 'none'); 
  define('DIR_FS_SQL_CACHE', '/home/topkayak/public_html/cache');

// EOF
17 Mar 2013, 7:27 PM
#26
athena avatar

athena

Totally Zenned

Join Date:
Jan 2006
Location:
NM
Posts:
740
Plugin Contributions:
0

Re: Database did not upgrade

I'm also getting bumped out of the admin everytime I click on something after logging in. It does remember where I wanted to go as when I do log back in i'm on the page in the admin I was going for. THis began with the config file issue which is still not working on the store side.

17 Mar 2013, 9:29 PM
#27
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Database did not upgrade

One change for admin, as a first step:> athena:

Here is admin:

/**

  • WE RECOMMEND THAT YOU USE SSL PROTECTION FOR YOUR ENTIRE ADMIN:
  • To do that, make sure you use a "https:" URL for BOTH the HTTP_SERVER and HTTPS_SERVER entries:
    */
    [B] define('HTTP_SERVER', 'https://cloudwebx1.ssldomain.com/~topkayak');[/B]
    define('HTTPS_SERVER', 'https://cloudwebx1.ssldomain.com/~topkayak');
    define('HTTP_CATALOG_SERVER', 'http://topkayaker.com');
    define('HTTPS_CATALOG_SERVER', 'https://cloudwebx1.ssldomain.com/~topkayak');

// secure webserver for admin? Valid choices are 'true' or 'false' (including quotes).
define('ENABLE_SSL_ADMIN', 'true');

// secure webserver for storefront? Valid choices are 'true' or 'false' (including quotes).
define('ENABLE_SSL_CATALOG', 'true');


And looks like a major foobar in the store one:
> **athena:**
>
> Here is **store**...
> 
> ```
  //the following path isALOG', '/hom a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
  define('DIR_FS_CATe/topkayak/public_html/');

That should probably be: ```
define('[B]DIR_FS_CATALOG', '/home/topkayak/public_html/[/B]');

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

18 Mar 2013, 6:13 PM
#28
athena avatar

athena

Totally Zenned

Join Date:
Jan 2006
Location:
NM
Posts:
740
Plugin Contributions:
0

Re: Database did not upgrade

I came back from dinner last night and found this wonderful help!

Can't thank you enough...I would not have thought to winmerge the config files to see that.

WE ARE GOING LIVE TODAY! YEAH!!!!!!!!!!!!!!

Everything seems to be working as well as the old shop...but so much faster. My host said, yes....I was on a busy Windows server and that had much to do with the slowness...but he agreed Linux was the way to go for zencart. Even he was having issues with the speed on his side...so glad we were able to move.

Most of my troubles were do to my inexperience with running sql and understanding of Mysql; but my Mods are ok. Stock by Attributes, still imperfect, but thanks to RoboPhung is working better than before on the admin and store side in 1.5.1.

Thank you..... :)

18 Mar 2013, 6:55 PM
#29
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Database did not upgrade

Yay! Glad it's working!

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.