Zen Cart Logo
Forums / Installing on a Windows Server / Problem to move shop! 1146 Table...

Problem to move shop! 1146 Table...

Locked

Views: 1,391

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
27 Mar 2010, 4:43 PM
#1
teto89 avatar

teto89

New Zenner

Join Date:
Mar 2010
Posts:
5
Plugin Contributions:
0

Problem to move shop! 1146 Table...

hello, I am a rookie and this is my first post in the forum.

I moved my store to another hosting (free to premium) Byethost

the server Byethost I move all data from one account to another and the database, when I enter my shop appeared to me as a new installation, but I realized that the data files and includes configure.php in admin had not been changed in connection with data base and change but now I get this error!!

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

why this happens? thank you very much and greetings

28 Mar 2010, 12:30 AM
#2
teto89 avatar

teto89

New Zenner

Join Date:
Mar 2010
Posts:
5
Plugin Contributions:
0

Re: Problem to move shop! 1146 Table...

these are the data to modify...

old configuration on configure.php (/includes)

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', 'rin');
  define('DB_SERVER', 'sql201.xtreemhost.com');
  define('DB_SERVER_USERNAME', 'xth_4935510');
  define('DB_SERVER_PASSWORD', 'mypass');
  define('DB_DATABASE', 'xth_4935510_zenrin');
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', 'db');
  // for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage

and the modified configuration:

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', 'rin');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'rinconi1_rinuser');
  define('DB_SERVER_PASSWORD', 'mypass');
  define('DB_DATABASE', 'rinconi1_zenrin');
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', 'db');
  // for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage

still not working :frusty:

28 Mar 2010, 5:31 AM
#4
canopy avatar

canopy

Totally Zenned

Join Date:
Oct 2006
Posts:
625
Plugin Contributions:
0

Re: Problem to move shop! 1146 Table...

Seems like your table prefix is giving the problem. Try changing the following statement from:

define('DB_PREFIX', 'rin);
```to:

```php
define('DB_PREFIX', 'rincon);
```If that still doesn't work, go to your phpMyAdmin and look at the table prefix for your current database and compare it with the 'DB_PREFIX' define statement as show above.

Make sure you make changes to *both* "configure.php" files and not just one of them.
28 Mar 2010, 7:32 AM
#5
teto89 avatar

teto89

New Zenner

Join Date:
Mar 2010
Posts:
5
Plugin Contributions:
0

Re: Problem to move shop! 1146 Table...

I changed the prefix data in configure.php for "rincon"
but still the problems.
"Sorry! There seems to be a problem connecting to our data..."

as i see my prefix in phpMyAdmin?

thanks!

29 Mar 2010, 3:10 AM
#6
teto89 avatar

teto89

New Zenner

Join Date:
Mar 2010
Posts:
5
Plugin Contributions:
0

Re: Problem to move shop! 1146 Table...

my website is working properly. thanks for everything :clap: