Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Migrated database and files... having trouble

Migrated database and files... having trouble

Locked

Views: 6,176

Results 21 to 33 of 33
This thread is locked. New replies are disabled.
8 Jul 2008, 2:11 PM
#21
kay6284 avatar

kay6284

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Migrated database and files... having trouble

My apologies to you bud, I've been so frustrated with this I failed to mention that. On my original site I had it setup as two separate catalogs which worked fine and still does. Anyway, let me get back to you later tonight after work so I can spend some time sorting this.

9 Jul 2008, 11:24 AM
#22
kay6284 avatar

kay6284

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Re: Migrated database and files... having trouble

Ok here it is, if you go here you will see what I have http://act-iv.com/doubledstoreonline . This site was setup so that when you type "www.doubledstoreonline.com" in the address that is where you would be taken but I have changed it to direct to the new site, all that is fine and dandy.
The http://act-iv.com/doubledstoreonline was designed originally as the act-iv shop instead of doubledstore so I did a clean install then pointed the doubledstore catalog to use the original act-iv shop catalog, this as you can see if you visit the site worked out great.
Now with that said I don't really care if it still uses the "Shop" catalog because if I can get the darn doubledstore thing to work on the new site I can change that later.

9 Jul 2008, 11:51 PM
#23
kay6284 avatar

kay6284

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Re: Migrated database and files... having trouble

Original config file (this is the functioning site):

define('HTTP_SERVER', 'http://www.act-iv.com');
define('HTTPS_SERVER', 'https://www.act-iv.com');

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

// 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', '/doubledstoreonline/');
define('DIR_WS_HTTPS_CATALOG', '/doubledstoreonline/');

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 is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_CATALOG', '/home/public_html/Shop/');

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('DB_TYPE', 'mysql');
define('DB_PREFIX', 'act_');
define('DB_SERVER', '');
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', '
******');
define('DB_DATABASE', 'lrk_
_zencart');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

define('SQL_CACHE_METHOD', 'none'); 

define('DIR_FS_SQL_CACHE', '/home/public_html/doubledstoreonline/cache')

New config file (This is the failing site):

define('HTTP_SERVER', 'http://www.dennisramsey.com');
define('HTTPS_SERVER', 'https://www.dennisramsey.com');

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

// 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', '/doubledstoreonline/');
define('DIR_WS_HTTPS_CATALOG', '/doubledstoreonline/');

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 is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_CATALOG', '/data/16/1/0/76/1489076/user/1601385/htdocs/Shop/');

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', 'act_');
define('DB_SERVER', '');
define('DB_SERVER_USERNAME', '
');
define('DB_SERVER_PASSWORD', '
');
define('DB_DATABASE', '
**_zencart');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/data/16/1/0/76/1489076/user/1601385/htdocs/doubledstoreonline/cache')

10 Jul 2008, 3:37 AM
#24
drbyte avatar

drbyte

Sensei

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

Re: Migrated database and files... having trouble

First observation is that this looks odd:> kay6284:

define('DIR_FS_CATALOG', '/data/16/1/0/76/1489076/user/1601385/htdocs/Shop/');
define('DIR_FS_SQL_CACHE', '/data/16/1/0/76/1489076/user/1601385/htdocs/doubledstoreonline/cache')

Chances are it would be better to point both of these to the correct path, ie: one that exists.
And, in Admin->Configuration->Sessions, set the Session Directory to the same (existing, writable) path as DIR_FS_SQL_CACHE.

10 Jul 2008, 11:24 AM
#25
kay6284 avatar

kay6284

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Re: Migrated database and files... having trouble

I did try that and just did again per your suggestion. One thing I did notice is the cache folder has permissions of 775, my original site that was 777. Does the cache folder require permission of 777? I have tried to change it to that but Network Solutions keeps overwriting my permissions and setting it back to 775.

10 Jul 2008, 11:41 AM
#26
kay6284 avatar

kay6284

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Re: Migrated database and files... having trouble

Also, maybe I'm wrong, but it seems to me I recall having to set the store directory "/data/16/1/0/76/1489076/user/1601385/htdocs/Shop/" (in my original site) in another file other than the config.php, is this so? I cannot remember where I had to do this.

10 Jul 2008, 11:45 AM
#27
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Migrated database and files... having trouble

http://www.act-iv.com/doubledstoreonline/
Works as expected

http://www.act-iv.com/Shop/
Works but with path problems; images not showing due to wrong URL.

http://www.doubledstoreonline.com/Shop/includes/templates/template_default/images/act-ivlogo.gif

should be

http://www.doubledstoreonline.com/includes/templates/template_default/images/act-ivlogo.gif

These two URLs do not work:
http://www.doubledstoreonline.com/
http://dennisramsey.com/doubledstoreonline/

due to misconfiguration:

Fatal error: Class 'phpBB' not found in /data/16/1/0/76/1489076/user/1601385/htdocs/doubledstoreonline/includes/autoload_func.php on line 79

As to dir. permissions of 775, that is / was probably setup by your Hoster for good security whilst allowing scripts not owned by you to run. Mind you, it could be a Server-wide settings applying to all Clients. So even though you do not require that setting it still applies to your Hosting account. Other accounts may be using Joomla or Mamba for example, both of which require some dir. / files to be owned by 'nobody' in order to work. A security problem indeed and permissions of 775 allow the best of both worlds.

10 Jul 2008, 12:05 PM
#28
kay6284 avatar

kay6284

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Re: Migrated database and files... having trouble

Website Rob:

http://www.act-iv.com/doubledstoreonline/
Works as expected
That is the old site (I have not disabled it yet)

http://www.act-iv.com/Shop/
Works but with path problems; images not showing due to wrong URL.
That is also correct, it was never intended to function.

These two URLs do not work:
http://www.doubledstoreonline.com/
http://dennisramsey.com/doubledstoreonline/

due to misconfiguration:
That is the new one we are trying to fix.

10 Jul 2008, 12:10 PM
#29
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Migrated database and files... having trouble

Admin > My Store > Enable phpBB linkage?

Not sure if want a phpBB link or not but make that setting 'false' and see what happens.

10 Jul 2008, 9:16 PM
#30
kay6284 avatar

kay6284

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Re: Migrated database and files... having trouble

That is set to false.

11 Jul 2008, 1:15 AM
#31
kay6284 avatar

kay6284

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Re: Migrated database and files... having trouble

Website Rob:

http://www.doubledstoreonline.com/Shop/includes/templates/template_default/images/act-ivlogo.gif

should be

http://www.doubledstoreonline.com/includes/templates/template_default/images/act-ivlogo.gif

I see what you say now, where can I change that? I just can't remember I been staring at these files so long, I got a feeling that may cure several things.

11 Jul 2008, 3:33 AM
#32
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Migrated database and files... having trouble

You would need to change both config files. Presumably, removing 'Shop' from all paths should work. Might even help with the phpBB problem.

12 Jul 2008, 6:10 PM
#33
kay6284 avatar

kay6284

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Re: Migrated database and files... having trouble

I still don't know what caused the original error but I did get it fixed.
http://doubledstoreonline.com/