ZitatSQL Fehler [256] (1146) Table 'xxxxxxxxx.commerce_seo_url_names' doesn't exist
Query: SELECT cp.url_text AS url, cn.file_name AS file_name, cn.file_name_php AS php FROM commerce_seo_url_names AS cn LEFT OUTER JOIN commerce_seo_url_personal_links AS cp ON (cp.file_name = cn.file_name AND cp.language_id = '1')
Beim Aufruf der Datei /commerce_seo_url.php , PHP 5.2.17-0.dotdeb.0 (Linux)
Offenbar wird die Tabelle commerce_seo_url_names nicht durch die Upgrade_20_auf_21.sql nicht erstellt.
Nachdem ich folgendes aus der install.sql in der DB ausgeführt habe, ging es dann (War das in Ordnung so?):
PHP
DROP TABLE IF EXISTS commerce_seo_url_names;CREATE TABLE IF NOT EXISTS commerce_seo_url_names ( id INT(4) NOT NULL auto_increment, file_name VARCHAR(64) NOT NULL, file_name_php VARCHAR(32) NOT NULL, PRIMARY KEY (id));INSERT INTO commerce_seo_url_names VALUES('', 'FILENAME_ACCOUNT', 'account.php'),('', 'FILENAME_CHECKOUT_SHIPPING', 'checkout_shipping.php'),('', 'FILENAME_CHECKOUT', 'checkout.php'),('', 'FILENAME_SHOPPING_CART', 'shopping_cart.php'),('', 'FILENAME_SPECIALS', 'specials.php'),('', 'FILENAME_PRODUCTS_NEW', 'products_new.php'),('', 'FILENAME_ADVANCED_SEARCH', 'advanced_search.php'),('', 'FILENAME_LOGIN', 'login.php'),('', 'FILENAME_LOGOFF', 'logoff.php'),('', 'FILENAME_PASSWORD_DOUBLE_OPT', 'password_double_opt.php'),('', 'FILENAME_WISH_LIST', 'wish_list.php'),('', 'FILENAME_NEWSLETTER', 'newsletter.php'),('', 'FILENAME_ACCOUNT_EDIT', 'account_edit.php'),('', 'FILENAME_ADDRESS_BOOK', 'address_book.php'),('', 'FILENAME_CHECKOUT_CONFIRMATION', 'checkout_confirmation.php'),('', 'FILENAME_CHECKOUT_PAYMENT', 'checkout_payment.php'),('', 'FILENAME_CHECKOUT_PAYMENT_ADDRESS', 'checkout_payment_address.php'),('', 'FILENAME_CHECKOUT_SHIPPING_ADDRESS', 'checkout_shipping_address.php'),('', 'FILENAME_CHECKOUT_SUCCESS', 'checkout_success.php'),('', 'FILENAME_CREATE_ACCOUNT', 'create_account.php'),('', 'FILENAME_DOWNLOAD', 'download.php'),('', 'FILENAME_PRINT_PDF', 'print_pdf.php'),('', 'FILENAME_POPUP_CONTENT', 'popup_content.php'),('', 'FILENAME_REVIEWS', 'reviews.php'),('', 'FILENAME_POPUP_SEARCH_HELP', 'popup_search_help.php'),('', 'FILENAME_PRODUCT_REVIEWS', 'product_reviews.php'),('', 'FILENAME_PRODUCT_REVIEWS_INFO', 'product_reviews_info.php'),('', 'FILENAME_PRODUCT_REVIEWS_WRITE', 'product_reviews_write.php'),('', 'FILENAME_ACCOUNT_HISTORY', 'account_history.php'),('', 'FILENAME_PRINT_PRODUCT_INFO', 'print_product_info.php');
Und dann noch:
PHP
DROP TABLE IF EXISTS commerce_seo_url_personal_links;
CREATE TABLE IF NOT EXISTS commerce_seo_url_personal_links (
link_id INT(4) NOT NULL auto_increment,
url_text VARCHAR(128) NOT NULL,
file_name VARCHAR(64) NOT NULL,
language_id INT(2) NOT NULL,
PRIMARY KEY (link_id)
);
Und dann kommmt:
Die Abfrage wurde abgebrochen, kontaktieren Sie den Administrator...