von XTC3.04SP2.1 auf C:SEO umsteigen

tuxie01

Jo muß ich jetzt auch zugeben wir sind auch Ahnungslos!! Scherz.

Gib doch mal bitte uns die Infos wann die Fehlermeldung auftritt bei welcher Aktion. Im Admin oder auf der Frontseite!

siekiera

Da das B wie blog ganz oben kommt, würde ich sagen, das das SQL Update fehlt.

admin

Also ich habe vor kurzem osCommerce nach commerce:SEO Plus migriert. Neuinstallation commerce:SEO Plus, DB Abzug von osCommerce auf die Struktur von commerce:SEO angepasst, Daten übernommen (reine Tabellen Migration). Hat funktioniert. Ist zwar ein wenig Fummelei, aber immer noch besser als osCommerce > xt:Commerce > commerce:SEO Migration. Die Bilder 1 x in den Original Images Ordner rein und Image Processing laufen lassen. Thats ist. Versand + Zahlung wurde neu eingestellt und ein paar wenige Handgriffe noch. Produkte, ca. 4000 Produkte.

wolfsauge

Zitat von tuxie01

Gib doch mal bitte uns die Infos wann die Fehlermeldung auftritt bei welcher Aktion. Im Admin oder auf der Frontseite!

Das kommt anstelle der Startseite, ins admin komm ich überhaupt nicht rein.

karl12345

Hallo,

Habe alles genau nach anleitung installiert und bekomme auch folgende fehlermeldung:

1146 - Table 'db230270844.TABLE_BLOG_CATEGORIES' doesn't exist

SELECT id, titel FROM TABLE_BLOG_CATEGORIES WHERE status = 1 AND language_id = '2' ORDER BY position ASC

[XT SQL Error]

Kann jemand helfen???

Danke.

admin

Code

DROP TABLE IF EXISTS blog_categories;
CREATE TABLE blog_categories (
  id int(11) NOT NULL default '0',
  language_id int(11) NOT NULL default '0',
  titel varchar(150) NOT NULL default '',
  status int(1) NOT NULL default '0',
  position int(11) NOT NULL default '0',
  date varchar(10) NOT NULL,
  update_date varchar(10) NOT NULL,
  meta_title text,
  meta_desc text,
  meta_key text,
  PRIMARY KEY  (id,language_id)
);


INSERT INTO blog_categories VALUES (1, 1, 'Categorie 1', 1, 1, '22.06.2009', '', 'Categorie 1', 'Categorie 1', 'Categorie 1');
INSERT INTO blog_categories VALUES (1, 2, 'Kategorie 1', 1, 1, '22.06.2009', '', 'Kategorie 1', 'Kategorie 1', 'Kategorie 1');




DROP TABLE IF EXISTS blog_comment;
CREATE TABLE blog_comment (
  id int(3) NOT NULL auto_increment,
  blog_id int(11) NOT NULL,
  name varchar(150) NOT NULL default '',
  text text,
  date varchar(10) NOT NULL,
  PRIMARY KEY  (id)
);


DROP TABLE IF EXISTS blog_items;
CREATE TABLE blog_items (
  id int(11) NOT NULL default '0',
  language_id int(11) NOT NULL default '0',
  categories_id int(11) NOT NULL default '0',
  title varchar(150) NOT NULL default '',
  name varchar(200) NOT NULL default '',
  description text NOT NULL,
  status int(1) NOT NULL default '0',
  position int(11) NOT NULL default '0',
  date varchar(10) NOT NULL,
  date_update varchar(10) NOT NULL,
  meta_title text,
  meta_keywords text,
  meta_description text,
  lenght int(5) default NULL,
  PRIMARY KEY  (id,language_id)
);


INSERT INTO blog_items VALUES (1, 1, 1, 'Thema 1', 'Thema 1', '<p>Thema 1</p>', 1, 1, '22.06.2009', '', 'Thema 1', 'Thema 1', 'Thema 1', 0);
INSERT INTO blog_items VALUES (1, 2, 1, 'Thema 1', 'Thema 1', '<p>Thema 1</p>', 1, 1, '22.06.2009', '', 'Thema 1', 'Thema 1', 'Thema 1', 0);






DROP TABLE IF EXISTS blog_settings;
CREATE TABLE blog_settings (
  id int(11) unsigned NOT NULL auto_increment,
  blog_key varchar(20) default NULL,
  wert varchar(20) default NULL,
  PRIMARY KEY  (id)
);




INSERT INTO blog_settings VALUES (1, 'social', 'nein');
INSERT INTO blog_settings VALUES (2, 'comments', 'ja');
INSERT INTO blog_settings VALUES (3, 'rate', 'nein');
INSERT INTO blog_settings VALUES (4, 'register_user', 'ja');
INSERT INTO blog_settings VALUES (5, 'session_rate', 'ja');
INSERT INTO blog_settings VALUES (6, 'blog_nav_ajax', 'nein');
INSERT INTO blog_settings VALUES (7, 'blog_captcha', 'nein');


DROP TABLE IF EXISTS blog_start;
CREATE TABLE blog_start (
id int(1) NOT NULL default '0',
language_id int(11) NOT NULL default '0',
description text NOT NULL,
date int(10) NOT NULL,
PRIMARY KEY (id,language_id)
) TYPE=MyISAM;


DROP TABLE IF EXISTS blog_vote;
CREATE TABLE blog_vote (
  id int(4) NOT NULL auto_increment,
  blog_id int(8) NOT NULL,
  vote_nr int(8) NOT NULL,
  img_nr varchar(100) default NULL,
  PRIMARY KEY  (id)
);

Alles anzeigen

karl12345

Danke für Deine schnelle hilfe. Habe den Code jetzt ausgeführt. Die Tabellen befinden sich jetzt in der Datenbank. Allerdings besteht der Fehler noch immer:

1146 - Table 'db230270844.TABLE_BLOG_CATEGORIES' doesn't exist

SELECT id, titel FROM TABLE_BLOG_CATEGORIES WHERE status = 1 AND language_id = '2' ORDER BY position ASC

[XT SQL Error]

Kanne ja eigentlich nicht sein - da die Tabelle jetzt ja vorhanden ist. Hast Du noch eine Idee?

Danke.

siekiera

Es fehlt das Update SQL. Da Du bei B bist fehlen dann immernoch etliche Tabellen.

Nutze bitte die Suchfunktion des Forums um das UpdateSQL zu finden.

karl12345

Hallo,

Danke für Deine Antwort - ich hatte aber das Update bereits ausgeführt und habe folgende Tabellen in der DB:

address_book
address_format
admin_access
banktransfer
banners
banners_history
blog_categories
blog_comment
blog_items
blog_settings
blog_start
blog_vote
campaigns
campaigns_ip
cao_log
card_blacklist
categories
categories_description
cm_file_flags
configuration
configuration_group
content_manager
counter
counter_history
countries
coupons
coupons_description
coupon_email_track
coupon_gv_customer
coupon_gv_queue
coupon_redeem_track
currencies
customers
customers_basket
customers_basket_attributes
customers_info
customers_ip
customers_memo
customers_sik
customers_status
customers_status_history
database_version
geo_zones
languages
manufacturers
manufacturers_info
media_content
module_newsletter
newsletters
newsletters_history
newsletter_recipients
orders
orders_products
orders_products_attributes
orders_products_download
orders_recalculate
orders_status
orders_status_history
orders_total
payment_moneybookers
payment_moneybookers_countries
payment_moneybookers_currencies
payment_qenta
paypal
paypal_status_history
personal_offers_by_customers_status_0
personal_offers_by_customers_status_1
personal_offers_by_customers_status_2
personal_offers_by_customers_status_3
products
products_attributes
products_attributes_download
products_content
products_description
products_graduated_prices
products_images
products_notifications
products_options
products_options_values
products_options_values_to_products_options
products_to_categories
products_vpe
products_xsell
products_xsell_grp_name
reviews
reviews_description
sessions
shipping_status
specials
tax_class
tax_rates
whos_online
zones
zones_to_geo_zones

Ich habe die Software nochmals mit einer neuen DB installiert (läuft dort einwandfrei) und finde den Fehler einfach nicht.

Vielleicht kannst Du/könnt Ihr Anhand der oberen Tabellen erkennen, ob etwas fehl. Im Vorraus nochmals vielen Dank.

siekiera

Das geht nicht so einfach.

Viele Tabellen werden auch "nur" ergänzt.

admin

Das sieht aber fast si aus, als fehlen da Tabellendefinitionen. Du solltest die filenames.php database... und application_top (im Admin) prüfen. Dein Shop kennt die Tabelle nicht und die muss definiert sein in den benannten files.
as Beste ist, alle Dateien überschreiben!

karl12345

Danke für die Tips,

habe jetzt alle tabellen überprüft und bekomme jetzt folgenden Fehler:

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 'MAX_RANDOM_PRODUCTS' at line 15

SELECT * FROM products p, products_description pd, products_to_categories p2c, categories c where c.categories_status='1' and p.products_id = p2c.products_id and p.products_id=pd.products_id and p2c.categories_id = c.categories_id and p.products_status = '1' and pd.language_id = '2' order by rand() limit MAX_RANDOM_PRODUCTS

[XT SQL Error]

Kann mir einer von euch erklären, woran das liegt?

Danke im Voraus.

admin

Da fehlt der Eintrag in der Tabelle configuration für MAX_RANDOM_PRODUCTS:

INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'MAX_RANDOM_PRODUCTS', '3', 3, 23, NULL , '0000-00-00 00:00:00', NULL , NULL);

karl12345

Danke, jetzt der nächste Fehler:

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 'MAX_RANDOM_SELECT_NEW' at line 17

select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_price from products p, products_to_categories p2c, categories c where p.products_status=1 and p.products_id = p2c.products_id and p.products_id !='0' and c.categories_id = p2c.categories_id and c.categories_status=1 order by p.products_date_added desc limit MAX_RANDOM_SELECT_NEW

[XT SQL Error]

admin

Ja da fehlen die Neurerungen alle!
#Changes since 1.1.1
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'IBN_BILLNR', '1', '1', '99', NULL , '0000-00-00 00:00:00', NULL , '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'IBN_BILLNR_FORMAT', '{n}-{d}-{m}-{y}', '1', '99', NULL , '0000-00-00 00:00:00', NULL , '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'MAX_RANDOM_PRODUCTS', '3', 3, 23, NULL , '0000-00-00 00:00:00', NULL , NULL);
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order, last_modified , date_added , use_function , set_function ) VALUES ('', 'PHPIDS_SECURE', 'false', 365, 1, NULL, '', NULL, 'xtc_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_ACTIVATE_SUGGEST', 'true', 22, 7, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_PRODUCT_KEYWORDS', 'false', 22, 8, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_PRODUCT_DESCRIPTION', 'false', 22, 9, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_PROXIMITY_TRIGGER', '70', 22, 10, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_WEIGHT_LEVENSHTEIN', '0', 22, 11, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_WEIGHT_SIMILAR_TEXT', '100', 22, 12, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_WEIGHT_METAPHONE', '0', 22, 13, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_SPLIT_MINIMUM_LENGTH', '3', 22, 14, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_SPLIT_PRODUCT_NAMES', 'true', 22, 15, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_SPLIT_PRODUCT_CHARS', '[ ,.]', 22, 16, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_MAX_KEXWORD_SUGGESTS', '6', 22, 17, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_COUNT_PRODUCTS', 'true', 22, 18, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_ENABLE_PROXIMITY_COLOR', 'true', 22, 19, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_PROXIMITY_COLORS', '#9f6;#cf6;#ff6;#fc9;#f99', 22, 20, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_ENABLE_PRODUCTS_SUGGEST', 'true', 22, 21, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_MAX_PRODUCTS_SUGGEST', '15', 22, 22, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'SEARCH_SHOW_PARSETIME', 'false', 22, 23, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');

INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_BASE_DAYS', '30', 33, 10, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_REPORT_DAYS', '90', 33, 15, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_EMAIL_TTL', '90', 33, 20, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_EMAIL_FRIENDLY', 'true', 33, 30, NULL, NOW(), '', "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_EMAIL_COPIES_TO', '', 33, 35, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_SHOW_ATTRIBUTES', 'false', 33, 40, NULL, NOW(), '', "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_CHECK_SESSIONS', 'false', 33, 40, NULL, NOW(), '', "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_CURCUST_COLOR', '0000FF', 33, 50, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_UNCONTACTED_COLOR', '9FFF9F', 33, 60, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_CONTACTED_COLOR', 'FF9F9F', 33, 70, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_MATCHED_ORDER_COLOR', '9FFFFF', 33, 72, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_SKIP_MATCHED_CARTS', 'true', 33, 80, NULL, NOW(), '', "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_AUTO_CHECK', 'true', 33, 82, NULL, NOW(), '', "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_CARTS_MATCH_ALL_DATES', 'true', 33, 84, NULL, NOW(), '', "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_PENDING_SALE_STATUS', '1', 33, 85, NULL, NOW(), 'xtc_get_order_status_name', 'xtc_cfg_pull_down_order_statuses(');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_REPORT_EVEN_STYLE', 'dataTableRow', 33, 90, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_REPORT_ODD_STYLE', '', 33, 92, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_SHOW_BRUTTO_PRICE', 'true', 33, 94, NULL, NOW(), '', "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'DEFAULT_RCS_SHIPPING', '', 33, 95, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'DEFAULT_RCS_PAYMENT', '', 33, 96, NULL, NOW(), '', '');
INSERT INTO configuration ( configuration_id , configuration_key , configuration_value , configuration_group_id , sort_order , last_modified , date_added , use_function , set_function ) VALUES ('', 'RCS_DELETE_COMPLETED_ORDERS', 'true', 33, 97, NULL, NOW(), '', "xtc_cfg_select_option(array('true', 'false'),");

karl12345

Danke. Entsprechendes Update habe ich ausgeführt - an der Fehlermeldung ändert sich jedoch nichts.

karl12345

Habe jetzt nochmals ein Update erstellt und alles erneut nach Anleitung installiert.

Jetzt erschein mal wieder ein Fehler:

Warning: main(/kunden/homepages/19/d87252840/htdocs/XT_Sport/inc/xtc_checkout_site.inc.php) [function.main]: failed to open stream: No such file or directory in /homepages/19/d87252840/htdocs/xtcommerce/includes/application_top.php on line 105

Fatal error: main() [function.require]: Failed opening required '/kunden/homepages/19/d87252840/htdocs/XT_Sport/inc/xtc_checkout_site.inc.php' (include_path='.:/usr/lib/php') in /homepages/19/d87252840/htdocs/xtcommerce/includes/application_top.php on line 105

Könnte bitte nochmals jemand helfen??? Liegt es vielleicht an meinem Shop und dessen Erweiterungen???

Nochmals Danke.

karl12345

Habe es jetzt endlich doch hinbekommen und möchte mich herzlich für die Unterstützung bedanken - es war am Ende nur noch ein Denkfehler.

Danke!!! :D:D:D

admin

Ja, ist manchmal nicht so einfach mit dem Denken
Sah auch danach aus, als fehlt noch eine Datei im inc Ordner

karl12345

Muss mich leider nochmals melden. der Shop funktionierte soweit problemlos - habe nun aber die alten Bestellungen und Kundedaten importiert und bekomme folgende Meldung:

1054 - Unknown column 'ibn_pdfnotifydate' in 'field list'

select ibn_pdfnotifydate, ibn_billnr from orders where orders_id = '26046'

[XT SQL Error]

Habe daraufhin versucht das PDF Rechnungstool zu installieren - jedoch ist dies nicht möglich. Der Punkt ist unter Admin>cSEO Tools nicht vorhanden.

Weiteres Problem ist, das ich beim Versuch eine Testbestellung auszulösen, nun folgende Meldung erhalte:

1054 - Unknown column 'checkout_site' in 'field list'

SELECT checkout_site FROM customers_basket WHERE customers_id=1

[XT SQL Error]

Ich denke aber mal, dass beide Probleme zusammen hängen.

Könnte nochmals jemand helfen???

Danke.