superschade
01.05.2006, 14:37
Hab die update.php nun nochmal durchlaufen lassen aber ohne Erfolg.
Hier mal ein Ausschnitt aus der DB, Tabelle "orders".
--
-- Tabellenstruktur für Tabelle `orders`
--
CREATE TABLE `orders` (
**`orders_id` int(11) NOT NULL auto_increment,
**`customers_id` int(11) NOT NULL default '0',
**`customers_cid` varchar(32) default NULL,
**`customers_vat_id` varchar(20) default NULL,
**`customers_status` int(11) default NULL,
**`customers_status_name` varchar(32) NOT NULL default '',
**`customers_status_image` varchar(64) default NULL,
**`customers_status_discount` decimal(4,2) default NULL,
**`customers_name` varchar(64) NOT NULL default '',
**`customers_company` varchar(32) default NULL,
**`customers_street_address` varchar(64) NOT NULL default '',
**`customers_suburb` varchar(32) default NULL,
**`customers_city` varchar(32) NOT NULL default '',
**`customers_postcode` varchar(10) NOT NULL default '',
**`customers_state` varchar(32) default NULL,
**`customers_country` varchar(32) NOT NULL default '',
**`customers_telephone` varchar(32) NOT NULL default '',
**`customers_email_address` varchar(96) NOT NULL default '',
**`customers_address_format_id` int(5) NOT NULL default '0',
**`delivery_name` varchar(64) NOT NULL default '',
**`delivery_company` varchar(32) default NULL,
**`delivery_street_address` varchar(64) NOT NULL default '',
**`delivery_suburb` varchar(32) default NULL,
**`delivery_city` varchar(32) NOT NULL default '',
**`delivery_postcode` varchar(10) NOT NULL default '',
**`delivery_state` varchar(32) default NULL,
**`delivery_country` varchar(32) NOT NULL default '',
**`delivery_address_format_id` int(5) NOT NULL default '0',
**`billing_name` varchar(64) NOT NULL default '',
**`billing_company` varchar(32) default NULL,
**`billing_street_address` varchar(64) NOT NULL default '',
**`billing_suburb` varchar(32) default NULL,
**`billing_city` varchar(32) NOT NULL default '',
**`billing_postcode` varchar(10) NOT NULL default '',
**`billing_state` varchar(32) default NULL,
**`billing_country` varchar(32) NOT NULL default '',
**`billing_address_format_id` int(5) NOT NULL default '0',
**`payment_method` varchar(32) NOT NULL default '',
**`cc_type` varchar(20) default NULL,
**`cc_owner` varchar(64) default NULL,
**`cc_number` varchar(64) default NULL,
**`cc_expires` varchar(4) default NULL,
**`cc_start` varchar(4) default NULL,
**`cc_issue` char(3) default NULL,
**`cc_cvv` varchar(4) default NULL,
**`comments` varchar(255) default NULL,
**`last_modified` datetime default NULL,
**`date_purchased` datetime default NULL,
**`orders_status` int(5) NOT NULL default '0',
**`orders_date_finished` datetime default NULL,
**`currency` char(3) default NULL,
**`currency_value` decimal(14,6) default NULL,
**`account_type` int(1) NOT NULL default '0',
**`payment_class` varchar(32) NOT NULL default '',
**`shipping_method` varchar(32) NOT NULL default '',
**`shipping_class` varchar(32) NOT NULL default '',
**`customers_ip` varchar(32) NOT NULL default '',
**`language` varchar(32) NOT NULL default '',
**`afterbuy_success` int(1) NOT NULL default '0',
**`afterbuy_id` int(32) NOT NULL default '0',
**`customers_firstname` varchar(64) NOT NULL default '',
**`customers_lastname` varchar(64) NOT NULL default '',
**`delivery_firstname` varchar(64) NOT NULL default '',
**`delivery_lastname` varchar(64) NOT NULL default '',
**`billing_firstname` varchar(64) NOT NULL default '',
**`billing_lastname` varchar(64) NOT NULL default '',
**`delivery_country_iso_code_2` char(2) NOT NULL default '',
**`billing_country_iso_code_2` char(2) NOT NULL default '',
**`refferers_id` varchar(32) NOT NULL default '',
**`conversion_type` int(1) NOT NULL default '0',
**`orders_ident_key` varchar(128) NOT NULL default '',
**PRIMARY KEY**(`orders_id`)
) TYPE=MyISAM AUTO_INCREMENT=200600637;
--
-- Daten für Tabelle `orders`
--
INSERT INTO `orders` VALUES (200600631, 405, '', '', 2, 'Kunde', 'customer_status.gif', 0.00, 'R. W.', '', 'We. 1', '', 'A.', '12345', '', 'Germany', '02', 'my@email.com', 5, 'R. W.', '', 'We. 1', 'A.', 'A.', '12345', '', 'Germany', 5, 'R. W.', '', 'We. 1', 'A.', 'A.', '12345', '', 'Germany', 5, 'cash', '', '', '', '', '', '', '', 'Anmerkung', '2006-04-28 18:08:46', '2006-04-27 22:24:30', 5, NULL, 'EUR', 0.000000, 0, 'cash', 'Selbstabholung (Selbstabholung d', 'selfpickup_selfpickup', '80.145.0.0', 'german', 0, 0, '', '', '', '', '', '', '', '', '', 0, '');
INSERT INTO `orders` VALUES (200600633, 406, '', '', 1, 'Gast', 'guest_status.gif', 0.00, 'Reinhard S.', '', 'Ir. 2', '', 'H.', '54321', '', 'Germany', '023', 'my@email.com', 5, 'Reinhard S.', '', 'Ir. 2', '', 'H.', '54321', '', 'Germany', 5, 'Reinhard S.', '', 'Ir. 2', '', 'H.', '54321', '', 'Germany', 5, 'cash', '', '', '', '', '', '', '', 'blablabla', NULL, '2006-04-30 12:47:14', 1, NULL, 'EUR', 0.000000, 0, 'cash', 'Selbstabholung (Selbstabholung d', 'selfpickup_selfpickup', '84.60.0.0', 'german', 0, 0, 'Reinhard', 'S.', 'Reinhard', 'S.', 'Reinhard', 'S.', 'DE', 'DE', '0', 1, '');
INSERT INTO `orders` VALUES (200600635, 407, '', '', 1, 'Gast', 'guest_status.gif', 0.00, 'Marcel S.', '', 'Ir. 2', '', 'H.', '54321', '', 'Germany', '023', 'my@email.com', 5, 'Marcel S.', '', 'Ir. 2', '', 'H.', '54321', '', 'Germany', 5, 'Marcel S.', '', 'Ir. 2', '', 'H.', '54321', '', 'Germany', 5, 'moneyorder', '', '', '', '', '', '', '', '', NULL, '2006-04-30 13:44:15', 1, NULL, 'EUR', 0.000000, 0, 'moneyorder', 'Deutsche Post AG (DHL) (Die Vers', 'freeamount_freeamount', '145.253.0.0', 'german', 0, 0, 'Marcel', 'S.', 'Marcel', 'S.', 'Marcel', 'S.', 'DE', 'DE', '0', 1, '');
INSERT INTO `orders` VALUES (200600636, 408, '', '', 1, 'Gast', 'guest_status.gif', 0.00, 'Marcel S.', '', 'Ir. 2', '', 'H.', '54321', '', 'Germany', '023', 'my@email.com', 5, 'Marcel S.', '', 'Ir. 2', '', 'H.', '54321', '', 'Germany', 5, 'Marcel S.', '', 'Ir. 2', '', 'H.', '54321', '', 'Germany', 5, 'moneyorder', '', '', '', '', '', '', '', '', NULL, '2006-05-01 01:10:39', 1, NULL, 'EUR', 0.000000, 0, 'moneyorder', 'Deutsche Post AG (DHL) (Die Vers', 'freeamount_freeamount', '145.253.0.0', 'german', 0, 0, 'Marcel', 'S.', 'Marcel', 'S.', 'Marcel', 'S.', 'DE', 'DE', '0', 1, '');
Das sieht doch ganz gut aus, oder? Die drei unteren Bestellungen sind die Gastbestellungen die überall angezeigt werden nur nicht im Admin -> Bestellungen...grrr...
Da die Bestellungen NUR in der orders.php unter Admin fehlen, muss ja dort etwas nicht stimmen.
Noch jemand eine Idee? Schonmal danke für Euren zahlreichen Posts!!
Superschade
vBulletin® v3.8.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.