DataBase problem after moving site!!!!!!

03 Nov 2008, 20:15

#1

Zen Follower

Join Date:: Jul 2007
Posts:: 148
Plugin Contributions:: 0

DataBase problem after moving site!!!!!!

Hey Dr or anyone else who wishes to chime in! I moved the site from the in-store server to Go Daddy! We are doing some remodeling and brining in a T1 Line and upgrading equipment. So I decided to put it on Go Daddy thru the first of the year. I had the in-store site still on version 1.3.7 on Go Daddy they have the app you install 1.3.8 I installed the app ftp'd the custom folders di a few other things that I needed. I backed up the data base with the modle you ad to zen cart for doing DB backups! I FTP'd it up to the site. I have no customer inforamtion or any other info for that matter as well as my catalog is not their! Also none of the catagories or catalog is on the site as well????? I really have no thought? What did I do wrong?

www.petestown.com is the go daddy site

www.petesboots.org is still pointed to the old server and working that is how it should look!

Rich

03 Nov 2008, 20:31

#2

kuroi

Totally Zenned

Join Date:: Apr 2006
Posts:: 10,475
Plugin Contributions:: 9

Re: DataBase problem after moving site!!!!!!

Did you follow the step-by-step guide in the FAQ? If so, at which step did you first notice a problem and what was it?

You seem to be saying that you've used some utility on your goDaddy control panel to upgrade your site. If so, that sounds like a bad idea. How did you upgrade the database?

Have you looked at the database in phpMyAdmin or whatever facility goDaddy makes available. If so, are the products and categories in their respective tables?

03 Nov 2008, 22:24

#3

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: DataBase problem after moving site!!!!!!

As kuroi mentioned, you would be best advised to follow the step-by-step FAQ on moving your site to another server.
Also as kuroi mentioned, it's unwise to do an upgrade mid-stream whilst moving from one server to another. Better to stick with the same version until it's running on the destination side. Then do an upgrade after it's confirmed to be working. And NEVER use an automated upgrade script for handling your PHP files. Always do that by hand.

I'll interject that choosing GoDaddy may or may not be the best choice for hosting. You'll find much discussion about its limitations on various parts of the forum.

03 Nov 2008, 23:35

#4

petestown

Zen Follower

Join Date:: Jul 2007
Posts:: 148
Plugin Contributions:: 0

Re: DataBase problem after moving site!!!!!!

Well the problem is you have to goto there apps and install the latest version of the cart which is 1.3.8 it also asks for tall the info and creates you a data base! Would it help if I upgraded to 1.3.8 on the old server first the backed up the data base and FTP'd it? So as far as following the step by step with them its like doing a new install so I did not really have a choice. As you can see everything else worked fine!

04 Nov 2008, 05:08

#5

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: DataBase problem after moving site!!!!!!

You don't "have to" use their app-installer. All the setup steps can be done manually using FTP and their hosting control panel (for database setup), etc.

If you want to upgrade your site first, that's fine. The key is: if it's broken after moving, and you're comparing apples-with-apples, then you have a better chance of figuring out what might have caused the problem. If you're mixing apples-and-oranges, then sorry, you're on your own to sort out what you've busted.

04 Nov 2008, 16:43

#6

petestown

Zen Follower

Join Date:: Jul 2007
Posts:: 148
Plugin Contributions:: 0

Re: DataBase problem after moving site!!!!!!

Well yes I agree with that Doc no doubt. When I first did this I did not even know they offered the app LOL. I FTP'd all my stuff up their. But it would not start because you have to make some changes in the admin config file! You can not restart their server so how do you get config changes to take affect. THEY told me use their app it loads the latest version which I did. They had me restore the database I FTP'd up over the one it creates when loading the new app! Everything is working fine except the DATABASE LOL! So the 64 million dollar question is whay its not pointing properly which they have not been able to answer. WORLD CLASS SUPPORT is what they advertise :censored:

04 Nov 2008, 20:31

#7

petestown

Zen Follower

Join Date:: Jul 2007
Posts:: 148
Plugin Contributions:: 0

Re: DataBase problem after moving site!!!!!!

OK so whats the differance in restoring vs importing?

04 Nov 2008, 21:17

#8

kuroi

Totally Zenned

Join Date:: Apr 2006
Posts:: 10,475
Plugin Contributions:: 9

Re: DataBase problem after moving site!!!!!!

Semantically, restoring implies putting something back (e.g. from a backup), while importing implies the loading of new information.

In your case either would be applicable depending upon whether you view your goDaddy site as a simple copy of the old one or a new entity in its own right.

04 Nov 2008, 21:58

#9

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: DataBase problem after moving site!!!!!!

PetesTown:
Everything is working fine except the DATABASE LOL! So the 64 million dollar question is whay its not pointing properly which they have not been able to answer.

You're probably using different table-prefixes between your imported data and their quick-click-install data.
Your DB_PREFIX settings in the configure.php files on the new server need to match the DB_PREFIX from the old server.

From the FAQ referenced earlier:

(when asked about the database-table-prefix during Database-Setup, use the same prefix that your old store uses)

And, once you've switched the prefixes, you'll want to go and delete all the tables they installed with the wrong prefix ... or else you'll have a bloated database with doubles of everything and one day you'll get confused by things not working because you used the wrong set of tables in the same database.

PetesTown:
WORLD CLASS SUPPORT is what they advertise :censored:

They advertise a lot of things. In fact, that's mostly what they do: Advertise.

04 Nov 2008, 23:31

#10

petestown

Zen Follower

Join Date:: Jul 2007
Posts:: 148
Plugin Contributions:: 0

Re: DataBase problem after moving site!!!!!!

Ok Thank's to both of you! I have tried a couple of diffrent things today! I will look at those issues in the morning and report back! I am determined to make this work LOL

04 Nov 2008, 23:42

#11

petestown

Zen Follower

Join Date:: Jul 2007
Posts:: 148
Plugin Contributions:: 0

Re: DataBase problem after moving site!!!!!!

Well Ok I FTP'd those configs down and the are prefexed "ZEN" where my origianls are prefixed " " nothing? So I guess I need to change their prefix to match mine "my old ones " No trying to be stupid just don't want to mess this up!

05 Nov 2008, 21:52

#12

petestown

Zen Follower

Join Date:: Jul 2007
Posts:: 148
Plugin Contributions:: 0

Re: DataBase problem after moving site!!!!!!

What does this error mean?

1146 Table 'petesdb.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

I was playing with the zencart prefix changer on the old site doing some experimenting

05 Nov 2008, 22:06

#13

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: DataBase problem after moving site!!!!!!

It means ZC is looking at the database named "petesdb" for the table named "configuration", but can't find it ... presumably because it's no longer named "configuration".

05 Nov 2008, 22:17

#14

petestown

Zen Follower

Join Date:: Jul 2007
Posts:: 148
Plugin Contributions:: 0

Re: DataBase problem after moving site!!!!!!

Well what I was doing was trying to experiment! I used the ad-on here from the forum db prefix changer! I loaded to root like the instructions said. I ran it in-order to ad the zen prefix to it. I then changed the admin/includes/config and the includes/ config to use the prefix "zen" it did not work and errored so then I ran it again and left the prefix blank and changed the config files back. ITS STILL ERRORING? What did I miss? PLEASE DOC PLEASE tell me I can fix this

05 Nov 2008, 22:28

#15

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: DataBase problem after moving site!!!!!!

If your DB_PREFIX is not set to blank, but all your tablenames have no prefix, you're going to get those errors.
If your DB_PREFIX is set to something, but all your tablenames do not have that at the beginning of the table names, you're also going to get "not found" errors.

I'm not familiar with the addon you're talking about. Remember, addons are use-at-own risk.

To fix the problem, you'll need to make sure all your tablenames have whatever prefix is in your DB_PREFIX setting. That may mean you need to manually rename them. phpMyAdmin lets you do that, although it's one-at-a-time.

Worst-case scenario, you could use the database-backup you made before you started making changes ...

06 Nov 2008, 18:14

#16

petestown

Zen Follower

Join Date:: Jul 2007
Posts:: 148
Plugin Contributions:: 0

Re: DataBase problem after moving site!!!!!!

Hey doc on Go Daddy does the version of PHP 4.1 or 5.0 have anything to do with it FINDING the database! SO say's GoDaddy support ? ALso I did prefix every field and it came up with garbled information under categories! ? It looked like descriptions from DB FIELDS instead of the category names!

06 Nov 2008, 18:44

#17

kuroi

Totally Zenned

Join Date:: Apr 2006
Posts:: 10,475
Plugin Contributions:: 9

Re: DataBase problem after moving site!!!!!!

DB prefix should only be attached to tables, not column fields.

Either of those versions of PHP should be fine. Sounds like they're grasping at straws.

06 Nov 2008, 18:59

#18

petestown

Zen Follower

Join Date:: Jul 2007
Posts:: 148
Plugin Contributions:: 0

Re: DataBase problem after moving site!!!!!!

I apologize that was my mistake with terminology! I prefixed each table with zen_tablenamehere. It still did not work LOL. THings that make ya say Hummmmm LOL!