moving to a new server

[raf696]

Hi thanks for that. all works now but just one thing in the url now it is displaying my domain username
url eg: www.yourdomain.com/~username/index.php

[RodG]

Hi thanks for that. all works now but just one thing in the url now it is displaying my domain username
url eg: www.yourdomain.com/~username/index.php

This URL is something that some hosts will supply so that you can work on/access a site whilst the domain name is being setup/propagated.

I would assume that this is what you entered (or what got entered) into the two zencart configure files. These will need to be changed to point to your real domain name.

Cheers
Rod

[raf696]

Hi where can I find this info to change, would it be under confi.php

[RodG]

Hi where can I find this info to change, would it be under confi.php

/renamedAdmin/includes/configure.php &
/includes/configure.php

You shouldn't need to change anything except the two lines in each

define('HTTP_SERVER', 'http:/your_domain.name') ; and
define('HTTPS_SERVER', 'http:/your_domain.name') ;

Cheers
Rod

[raf696]

I have that in there but there is something missing under

// 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', '//');

as when loadint the site I get this now
www.mydomain.com//index.php?

[RodG]

I have that in there but there is something missing under

// 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', '//');

as when loadint the site I get this now
www.mydomain.com//index.php?

I've NO idea how you managed to get two // in there. There should only be one in each (or, if your store is located in a different folder than /public_html/
such as /public_html/store/ then these would be define('DIR_WS_HTTP_CATALOG', '/store/');

Cheers
Rod

[ak6000]

Hi Folks,

I am trying to move my zen cart v1.3.9 from one hosting package to another with more space on Linux OS. I have followed the instruction on how to do this exacltly as documented.

Per instruction, I have dropped all tables in my new site and tried to upload my backup DB to the server. But when I press Go on the PhpMyAdmin I get the this error:

"There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:"

"MySQL said: Documentation
#1064 - 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 'PK' at line 1 "

I am not a SQL DBA and I am totally lost I appreciate any help you can give me.