I get this error message when transferring my site to another host:
1146 Table 'startswapping.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]
Anyone got any idea as to what this means? I know it has to do something with the database info (either old database or new one) but I have no clue about databases. If you've seen this before and know a quick fix, please reply. Any help would be much appreciated!!!
Thread: Transferring site ERROR
Results 1 to 6 of 6
-
21 Oct 2008, 08:05 PM #1
New Zenner
- Join Date
- Oct 2008
- Location
- Laie, Hawaii - Provo, Utah
- Posts
- 27
- Plugin Contributions
- 0
Transferring site ERROR
-
21 Oct 2008, 10:07 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: Transferring site ERROR
Did your old site have a DB_PREFIX value different than what you've got on your new site? Check your configure.php files for the DB_PREFIX setting.
.
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.
-
22 Oct 2008, 12:43 AM #3
New Zenner
- Join Date
- Oct 2008
- Location
- Laie, Hawaii - Provo, Utah
- Posts
- 27
- Plugin Contributions
- 0
Re: Transferring site ERROR
It looks like the prefix from my old site was different. Do I need to go through the transfer process all over again and change _DB_ to what my old prefix was?
Originally Posted by DrByte
-
22 Oct 2008, 04:05 AM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: Transferring site ERROR
If you edit the 2 configure.php files on your new site so that the DB_PREFIX matches the DB_PREFIX from the old site, that should be sufficient.
.
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.
-
22 Oct 2008, 05:03 AM #5
New Zenner
- Join Date
- Oct 2008
- Location
- Laie, Hawaii - Provo, Utah
- Posts
- 27
- Plugin Contributions
- 0
Re: Transferring site ERROR
I think with GoDaddy, they automatically give you some kind of prefix prefix (usually account name). I'll give it a go. Originally Posted by DrByte
-
22 Oct 2008, 05:08 AM #6
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: Transferring site ERROR
Many auto-installers choose "zen_". Doesn't matter what *they* selected. The key is what EXACTLY is ALREADY in YOUR old files ... since that's the prefix that was used to access the tables ALREADY in the database you exported.
In a perfect world, no prefix would be used, since prefixes only cause confusion. Sadly, cheap hosting companies which offer only one database make the use of prefixes required in those isolated cases. Thus the option exists..
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.
Similar Threads
-
v151 Internal server error after transferring site to new folder
By wagnerguy in forum Templates, Stylesheets, Page LayoutReplies: 1Last Post: 25 Jul 2014, 06:11 PM -
v150 Problem transferring my site! :(
By Serg in forum Installing on a Linux/Unix ServerReplies: 6Last Post: 9 Aug 2012, 04:42 PM -
v139h Transferring site to new domain now get 404 error when accessing admin on new site
By nikihaym314159 in forum Installing on a Linux/Unix ServerReplies: 2Last Post: 29 Jan 2012, 09:24 PM -
Transferring site from one cpanel to another
By webby2009 in forum Upgrading from 1.3.x to 1.3.9Replies: 2Last Post: 18 Dec 2009, 05:42 PM -
Transferring Hosting
By hduk in forum Templates, Stylesheets, Page LayoutReplies: 5Last Post: 19 Mar 2008, 10:24 PM
Bookmarks