>MTSYSの中の人さん
>php_flag display_errors on
>はオプション/一般の「CGI 出力を検査」にチェックを入れることで「似た」ような結果を得られるかと思います。
Tue Jul 04 03:23:23 2006 Warning: connection reset during Recv() in ClientRead() for Thread 0 (ID = 3384) with WSAECONNRESET
Tue Jul 04 13:38:46 2006 Warning: CGI TerminateProcess 3184 error 5
Tue Jul 04 13:58:01 2006 Warning: CGI TerminateProcess 2412 error 5
このように出力されていますのでAN HTTPD自体の問題ではないようです。
osCommerceはもともとLinux用なのでAN HTTPDのようなWindows専用で使うには
無理があるみたいですね。
Windows+Apacheで動くのでAN HTTPDでも可能かと思ったのですが。
（同じ日に複数回の購入さえしなければ問題なく動くようなのです）
>一般的な環境でないもので運営する以上、ある程度 読替能力が必要です。
読替能力は残念ながら無しです・・・
よってosCommerceのような大掛かりなシステムの改造なんてとても無理です。
AN HTTPDは使いやすくてLinuxサーバからWindowsサーバにしたのですが残念。
たいした知識がないのでパソコンを自作するときの様に相性のよいパーツを組み合わせて使うしかないですね。
＞金子さん
ここで質問されても調査量が膨大すぎて回答はつかないかと思います、osCommerceのコミュニティにて質問するのが最善策です。
php_flag display_errors on
はオプション/一般の「CGI 出力を検査」にチェックを入れることで「似た」ような結果を得られるかと思います。
一般的な環境でないもので運営する以上、ある程度 読替能力が必要です。
お世話になります。
AN HTTPDでECサイト構築システム osCommerce を入れたのですが1日に1回しか買い物ができません。
エラー内容（2006年6月7日）
------------------------------------------------------
1062 - Duplicate entry '20060607' for key 1
[TEP STOP]
------------------------------------------------------
となります。
どうも2006年6月7日のデータはもうあるからだめだよ。といっているようです。
日付が変わるとまた買い物ができます。
どなたか情報をお持ちでしたらお教えください。
Apacheだと正常に動くのですが・・・。
osCommerceはphpで構成されていますのでphp.iniの設定が悪いのか？
環境
WindowsXP+SP2
AN HPPD ( httpd142n)
mysql-4.0.26-win32
php-4.4.2-Win32
oscommerce-2.2ms1j（http://www.bitscope.co.jp/tep/）
同じ日（7月４日）に買い物を2回したログの1部です。
-----------------------------------------------------------------よろしくお願いいたします。
1回目
QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group
RESULT Resource id #283
04/07/2006 18:28:34 - /shop/catalog/checkout_success.php (2.618s)
QUERY select count(*) as total from sessions where sesskey = '7b4af2ab23b172742193426e7c9a9d70'
RESULT Resource id #288
QUERY update sessions set expiry = '1152006754', value = 'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;}language|s:8:\"japanese\";languages_id|s:1:\"4\";currency|s:3:\"JPY\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:8:{i:0;a:4:{s:4:\"page\";s:11:\"default.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:2:\"26\";s:6:\"action\";s:11:\"add_product\";}s:4:\"post\";a:4:{s:2:\"id\";a:1:{i:3;s:1:\"8\";}s:11:\"products_id\";s:2:\"26\";s:1:\"x\";s:2:\"69\";s:1:\"y\";s:2:\"12\";}}i:2;a:4:{s:4:\"page\";s:17:\"shopping_cart.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:3;a:4:{s:4:\"page\";s:21:\"checkout_shipping.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:6:{s:6:\"action\";s:7:\"process\";s:8:\"shipping\";s:9:\"flat_flat\";s:8:\"comments\";s:0:\"\";s:14:\"comments_added\";s:3:\"YES\";s:1:\"x\";s:2:\"62\";s:1:\"y\";s:2:\"12\";}}i:4;a:4:{s:4:\"page\";s:20:\"checkout_payment.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:0:{}}i:5;a:4:{s:4:\"page\";s:25:\"checkout_confirmation.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:9:{s:8:\"cc_owner\";s:0:\"\";s:9:\"cc_number\";s:0:\"\";s:16:\"cc_expires_month\";s:2:\"01\";s:15:\"cc_expires_year\";s:2:\"06\";s:7:\"payment\";s:3:\"cod\";s:8:\"comments\";s:0:\"\";s:14:\"comments_added\";s:3:\"YES\";s:1:\"x\";s:2:\"44\";s:1:\"y\";s:2:\"12\";}}i:6;a:4:{s:4:\"page\";s:20:\"checkout_process.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:2:{s:1:\"x\";s:2:\"38\";s:1:\"y\";s:2:\"10\";}}i:7;a:4:{s:4:\"page\";s:20:\"checkout_success.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}customer_id|s:1:\"4\";customer_default_address_id|s:1:\"1\";customer_first_name|s:6:\"てすと\";customer_last_name|s:6:\"テスト\";customer_country_id|s:3:\"107\";customer_zone_id|s:3:\"182\";' where sesskey = '7b4af2ab23b172742193426e7c9a9d70'
RESULT 1
2回目
QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50'
RESULT Resource id #351
04/07/2006 18:41:21 - /shop/catalog/checkout_confirmation.php (2.066s)
QUERY select count(*) as total from sessions where sesskey = '7b4af2ab23b172742193426e7c9a9d70'
RESULT Resource id #356
QUERY update sessions set expiry = '1152007521', value = 'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:1:{i:19;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:5240;s:6:\"weight\";d:7;s:6:\"cartID\";s:5:\"52698\";s:12:\"content_type\";s:8:\"physical\";}language|s:8:\"japanese\";languages_id|s:1:\"4\";currency|s:3:\"JPY\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:6:{i:0;a:4:{s:4:\"page\";s:11:\"default.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:2:\"19\";s:6:\"action\";s:11:\"add_product\";}s:4:\"post\";a:3:{s:11:\"products_id\";s:2:\"19\";s:1:\"x\";s:2:\"46\";s:1:\"y\";s:1:\"5\";}}i:2;a:4:{s:4:\"page\";s:17:\"shopping_cart.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:3;a:4:{s:4:\"page\";s:21:\"checkout_shipping.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:6:{s:6:\"action\";s:7:\"process\";s:8:\"shipping\";s:9:\"flat_flat\";s:8:\"comments\";s:0:\"\";s:14:\"comments_added\";s:3:\"YES\";s:1:\"x\";s:2:\"51\";s:1:\"y\";s:2:\"14\";}}i:4;a:4:{s:4:\"page\";s:20:\"checkout_payment.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:0:{}}i:5;a:4:{s:4:\"page\";s:25:\"checkout_confirmation.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:9:{s:8:\"cc_owner\";s:0:\"\";s:9:\"cc_number\";s:0:\"\";s:16:\"cc_expires_month\";s:2:\"01\";s:15:\"cc_expires_year\";s:2:\"06\";s:7:\"payment\";s:3:\"cod\";s:8:\"comments\";s:0:\"\";s:14:\"comments_added\";s:3:\"YES\";s:1:\"x\";s:2:\"58\";s:1:\"y\";s:2:\"10\";}}}s:8:\"snapshot\";a:0:{}}customer_id|s:1:\"4\";customer_default_address_id|s:1:\"1\";customer_first_name|s:6:\"てすと\";customer_last_name|s:6:\"テスト\";customer_country_id|s:3:\"107\";customer_zone_id|s:3:\"182\";sendto|s:1:\"1\";cartID|s:5:\"52698\";comments|s:0:\"\";shipping|a:4:{s:2:\"id\";s:9:\"flat_flat\";s:5:\"title\";s:21:\"定額料金 (最良の方法)\";s:4:\"cost\";s:4:\"5.00\";s:8:\"timespec\";N;}billto|s:1:\"1\";payment|s:3:\"cod\";' where sesskey = '7b4af2ab23b172742193426e7c9a9d70'
RESULT 1
QUERY select value from sessions where sesskey = '7b4af2ab23b172742193426e7c9a9d70' and expiry > '1152006090'
RESULT Resource id #13
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #17
QUERY select customers_firstname, customers_lastname from customers where customers_id = '4'
RESULT Resource id #26
QUERY delete from whos_online where time_last_click < '1152005191'
RESULT 1
QUERY select count(*) as count from whos_online where session_id = '7b4af2ab23b172742193426e7c9a9d70'
RESULT Resource id #31
QUERY update whos_online set customer_id = '4', full_name = 'テスト てすと', ip_address = '127.0.0.1', time_last_click = '1152006091', last_page_url = '/shop/catalog/checkout_process.php' where session_id = '7b4af2ab23b172742193426e7c9a9d70'
RESULT 1
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #41
QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id
RESULT Resource id #44
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #48
QUERY select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, co.countries_id, co.countries_name, co.countries_iso_code_2, co.countries_iso_code_3, co.address_format_id, ab.entry_state from customers c, address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries co on (ab.entry_country_id = co.countries_id) where c.customers_id = '4' and ab.customers_id = '4' and c.customers_default_address_id = ab.address_book_id
RESULT Resource id #60
QUERY select ab.entry_firstname, ab.entry_lastname, ab.entry_telephone, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '4' and ab.address_book_id = '1'
RESULT Resource id #63
QUERY select ab.entry_firstname, ab.entry_lastname, ab.entry_telephone, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '4' and ab.address_book_id = '1'
RESULT Resource id #66
QUERY select ab.entry_country_id, ab.entry_zone_id from address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) where ab.customers_id = '4' and ab.address_book_id = '1'
RESULT Resource id #69
QUERY select p.products_id, pd.products_name, p.products_model, p.products_price, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id='19' and pd.products_id = p.products_id and pd.language_id = '4'
RESULT Resource id #72
QUERY select specials_new_products_price from specials where products_id = '19' and status = '1'
RESULT Resource id #75
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '107') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #78
QUERY select tax_description from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '107') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '182') and tr.tax_class_id = '1' order by tr.tax_priority
RESULT Resource id #81
QUERY insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_telephone, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, orders_id) values ('4', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', 'krk@mineral.ddo.jp', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', '代金後払い', '', '', '', '', now(), '1', 'JPY', '1.00000000', '20060704-67291544')
RESULT Duplicate entry '20060704' for key 1
QUERY insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_telephone, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, orders_id) values ('4', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', 'krk@mineral.ddo.jp', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', '代金後払い', '', '', '', '', now(), '1', 'JPY', '1.00000000', '20060704-67291560')
RESULT Duplicate entry '20060704' for key 1
QUERY insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_telephone, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, orders_id) values ('4', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', 'krk@mineral.ddo.jp', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', '代金後払い', '', '', '', '', now(), '1', 'JPY', '1.00000000', '20060704-67291575')
RESULT Duplicate entry '20060704' for key 1
QUERY insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_telephone, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, orders_id) values ('4', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', 'krk@mineral.ddo.jp', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', '代金後払い', '', '', '', '', now(), '1', 'JPY', '1.00000000', '20060704-67291591')
RESULT Duplicate entry '20060704' for key 1
QUERY insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_telephone, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, orders_id) values ('4', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', 'krk@mineral.ddo.jp', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', '代金後払い', '', '', '', '', now(), '1', 'JPY', '1.00000000', '20060704-67291607')
RESULT Duplicate entry '20060704' for key 1
QUERY insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_telephone, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, orders_id) values ('4', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', 'krk@mineral.ddo.jp', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', '代金後払い', '', '', '', '', now(), '1', 'JPY', '1.00000000', '20060704-67291621')
RESULT Duplicate entry '20060704' for key 1
QUERY insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_telephone, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, orders_id) values ('4', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', 'krk@mineral.ddo.jp', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', '代金後払い', '', '', '', '', now(), '1', 'JPY', '1.00000000', '20060704-67291637')
RESULT Duplicate entry '20060704' for key 1
QUERY insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_telephone, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, orders_id) values ('4', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', 'krk@mineral.ddo.jp', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', '代金後払い', '', '', '', '', now(), '1', 'JPY', '1.00000000', '20060704-67291652')
RESULT Duplicate entry '20060704' for key 1
QUERY insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_telephone, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, orders_id) values ('4', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', 'krk@mineral.ddo.jp', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', '代金後払い', '', '', '', '', now(), '1', 'JPY', '1.00000000', '20060704-67291668')
RESULT Duplicate entry '20060704' for key 1
QUERY insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_telephone, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, orders_id) values ('4', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', 'krk@mineral.ddo.jp', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', 'テスト てすと', '', 'てすとです', '', 'てすとです', '1234567', '北海道', 'Japan', '1234567', '7', '代金後払い', '', '', '', '', now(), '1', 'JPY', '1.00000000', '20060704-67291682')
RESULT Duplicate entry '20060704' for key 1
QUERY select count(*) as total from sessions where sesskey = '7b4af2ab23b172742193426e7c9a9d70'
RESULT Resource id #113
QUERY update sessions set expiry = '1152007531', value = 'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:1:{i:19;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:5240;s:6:\"weight\";d:7;s:6:\"cartID\";s:5:\"52698\";s:12:\"content_type\";s:8:\"physical\";}language|s:8:\"japanese\";languages_id|s:1:\"4\";currency|s:3:\"JPY\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:7:{i:0;a:4:{s:4:\"page\";s:11:\"default.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:2:\"19\";s:6:\"action\";s:11:\"add_product\";}s:4:\"post\";a:3:{s:11:\"products_id\";s:2:\"19\";s:1:\"x\";s:2:\"46\";s:1:\"y\";s:1:\"5\";}}i:2;a:4:{s:4:\"page\";s:17:\"shopping_cart.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:3;a:4:{s:4:\"page\";s:21:\"checkout_shipping.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:6:{s:6:\"action\";s:7:\"process\";s:8:\"shipping\";s:9:\"flat_flat\";s:8:\"comments\";s:0:\"\";s:14:\"comments_added\";s:3:\"YES\";s:1:\"x\";s:2:\"51\";s:1:\"y\";s:2:\"14\";}}i:4;a:4:{s:4:\"page\";s:20:\"checkout_payment.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:0:{}}i:5;a:4:{s:4:\"page\";s:25:\"checkout_confirmation.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:9:{s:8:\"cc_owner\";s:0:\"\";s:9:\"cc_number\";s:0:\"\";s:16:\"cc_expires_month\";s:2:\"01\";s:15:\"cc_expires_year\";s:2:\"06\";s:7:\"payment\";s:3:\"cod\";s:8:\"comments\";s:0:\"\";s:14:\"comments_added\";s:3:\"YES\";s:1:\"x\";s:2:\"58\";s:1:\"y\";s:2:\"10\";}}i:6;a:4:{s:4:\"page\";s:20:\"checkout_process.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"7b4af2ab23b172742193426e7c9a9d70\";}s:4:\"post\";a:2:{s:1:\"x\";s:2:\"52\";s:1:\"y\";s:1:\"7\";}}}s:8:\"snapshot\";a:0:{}}customer_id|s:1:\"4\";customer_default_address_id|s:1:\"1\";customer_first_name|s:6:\"てすと\";customer_last_name|s:6:\"テスト\";customer_country_id|s:3:\"107\";customer_zone_id|s:3:\"182\";sendto|s:1:\"1\";cartID|s:5:\"52698\";comments|s:0:\"\";shipping|a:4:{s:2:\"id\";s:9:\"flat_flat\";s:5:\"title\";s:21:\"定額料金 (最良の方法)\";s:4:\"cost\";s:4:\"5.00\";s:8:\"timespec\";N;}billto|s:1:\"1\";payment|s:3:\"cod\";' where sesskey = '7b4af2ab23b172742193426e7c9a9d70'
RESULT 1
----------------------------------------------