Bitte Um Hilfe. Fehlermeldung Datenbank

[fleischmann]

hallo,

ich habe meine alte datenbank in eine neue kopiert und erhalte beim aufruf des shops folgende fehlermeldung:
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 '-motivazioneconfiguration' at line 2
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from br_auto-motivazioneconfiguration]


kann mir bitte jemand sagen was das heisen soll?

[webchills]

Du hast anscheinend im SQL Dump ein oder mehrere underline _ vergessen.
Wenn das Präfix br_auto-motivazione_ ist dann heißt die Tabelle br_auto-motivazione_configuration und nicht br_auto-motivazioneconfiguration

[fleischmann]

ich habe die ganze sql im ultraedit nach
br_auto-motivazioneconfiguration abgesucht aber nichts gefunden

wo könnte das sein?

[webchills]

Wie heißt das Präfix genau?

br_auto-motivazione_

Dann muss es die Table br_auto-motivazione_configuration aber schon geben

Hast Du in den configure.php dasselbe Präfix eingetragen?

[fleischmann]

ja der prefix heisst:
br_auto-motivazione_

und das verzeichnis:
br_auto-motivazione

hab das in beiden configure.php angepasst

[fleischmann]

meine configure.php sieht so aus:

// Define the webserver and path parameters
  // HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
  // HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
  define('HTTP_SERVER', 'http://www.br.auto-motivazione.com');
  define('HTTPS_SERVER', 'https://www.ssl-url.net/www.br.auto-motivazione.com');
  // Use secure webserver for checkout procedure?
  define('ENABLE_SSL', 'true');
// 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', '/');
  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', '/mnt/web6/23/69/52104469/htdocs/br_auto-motivazione/');
  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', 'br_auto-motivazione_');
  define('DB_SERVER', 'xxx');
  define('DB_SERVER_USERNAME', 'xxxxx');
  define('DB_SERVER_PASSWORD', 'xxxx');
  define('DB_DATABASE', 'xxxxx');
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', 'db');
  // for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage
  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache 
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash  
  define('SQL_CACHE_METHOD', 'none'); 
  define('DIR_FS_SQL_CACHE', '/mnt/web6/23/69/52104469/htdocs/br_auto-motivazione/cache');
// EOF 

[fleischmann]

der fehler ist dieser:
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 '-motivazione_configuration' at line 2
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from br_auto-motivazione_configuration]


habe mich vorher vertippt (es fehlte der "_")