Apache: [16/May/2024:08:48:14 -0700] "GET /cart HTTP/1.1" 200]
MySQL: 2024-05-16T13:48:14.918250Z 15638 Connect foobar@localhost on foobar_devel using Socket
PHP: $Session->login_check()
MySQL: 2024-05-16T13:48:14.918619Z 15638 Query select SQL_NO_CACHE s.user_id as user_id, s.securityString as string, l.status from sessions s inner join logins l on l.id = s.user_id where user_session =''
PHP: $User->countShopList();
MySQL: 2024-05-16T13:48:14.918895Z 15638 Query select SQL_NO_CACHE items from cart where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->init();
MySQL: 2024-05-16T13:48:14.919076Z 15638 Query select SQL_NO_CACHE * from cart where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->setStatus();
MySQL: 2024-05-16T13:48:14.919481Z 15638 Query update cart set status = 'working', timestamp=UNIX_TIMESTAMP() where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:14.920526Z 15638 Query FLUSH TABLES cart_items
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:14.921088Z 15638 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItemData();
MySQL: 2024-05-16T13:48:14.921804Z 15638 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:14.922170Z 15638 Query FLUSH TABLES cart_items
MySQL: 2024-05-16T13:48:14.922544Z 15638 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItemData();
MySQL: 2024-05-16T13:48:14.922927Z 15638 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Cart->update();
MySQL: 2024-05-16T13:48:14.923062Z 15638 Query delete from cart_items where qty = 0
MySQL: 2024-05-16T13:48:14.923179Z 15638 Query select SQL_NO_CACHE SUM(qtyprice) as total, sum(qty) as itemct from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:14.923334Z 15638 Query update cart set timestamp = 1715867294, items = 1, total = 46.80 where sessid = '061gfh5oov60dkbfhdqfmd6ber'
$Shipping->removeFromCart();
MySQL: 2024-05-16T13:48:14.923509Z 15638 Query delete from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber' and itemnum='SHIPCOST'
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:14.923625Z 15638 Query FLUSH TABLES cart_items
MySQL: 2024-05-16T13:48:14.924057Z 15638 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItemData();
MySQL: 2024-05-16T13:48:14.924378Z 15638 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Cart->update();
MySQL: 2024-05-16T13:48:14.924500Z 15638 Query delete from cart_items where qty = 0
MySQL: 2024-05-16T13:48:14.924616Z 15638 Query select SQL_NO_CACHE SUM(qtyprice) as total, sum(qty) as itemct from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:14.924770Z 15638 Query update cart set timestamp = 1715867294, items = 1, total = 46.80 where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Session->login_check()
MySQL: 2024-05-16T13:48:14.925028Z 15638 Query select SQL_NO_CACHE s.user_id as user_id, s.securityString as string, l.status from sessions s inner join logins l on l.id = s.user_id where user_session =''
PHP: $User->countShopList()
MySQL: 2024-05-16T13:48:14.925184Z 15638 Query select SQL_NO_CACHE items from cart where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:14.926176Z 15638 Quit
Apache: [16/May/2024:08:48:16 -0700] "GET /checkout HTTP/1.1" 200
MySQL: 2024-05-16T13:48:16.923897Z 15639 Connect foobar@localhost on foobar_devel using Socket
PHP: $User->login_check()
MySQL: 2024-05-16T13:48:16.924478Z 15639 Query update sessions set last_time = UNIX_TIMESTAMP() where user_session = 'ekRyRnpYSjgzcEdKM2ltdG4vM1dGWTJmVHArbjFEMUtSK1p6VWlGcWdOc3BxTHJLMzIvRXUzRmVWanM3U0Z1NA=='
MySQL: 2024-05-16T13:48:16.926207Z 15639 Query select user_id, user_session, securityString from sessions where user_session = 'ekRyRnpYSjgzcEdKM2ltdG4vM1dGWTJmVHArbjFEMUtSK1p6VWlGcWdOc3BxTHJLMzIvRXUzRmVWanM3U0Z1NA==' and ip_ssl = '173.25.70.145'
MySQL: 2024-05-16T13:48:16.926458Z 15639 Query select user_id from sessions where user_session = 'ekRyRnpYSjgzcEdKM2ltdG4vM1dGWTJmVHArbjFEMUtSK1p6VWlGcWdOc3BxTHJLMzIvRXUzRmVWanM3U0Z1NA=='
MySQL: 2024-05-16T13:48:16.926678Z 15639 Query select SQL_NO_CACHE s.user_id as user_id, s.securityString as string, l.status from sessions s inner join logins l on l.id = s.user_id where user_session =''
PHP: $User->countShopList()
MySQL: 2024-05-16T13:48:16.926818Z 15639 Query select SQL_NO_CACHE items from cart where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->init();
MySQL: 2024-05-16T13:48:16.927134Z 15639 Query select SQL_NO_CACHE * from cart where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->setStatus();
MySQL: 2024-05-16T13:48:16.927288Z 15639 Query update cart set status = 'working', timestamp=UNIX_TIMESTAMP() where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:16.928445Z 15639 Query FLUSH TABLES cart_items
MySQL: 2024-05-16T13:48:16.928986Z 15639 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItemData();
MySQL: 2024-05-16T13:48:16.929419Z 15639 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Cart->update();
MySQL: 2024-05-16T13:48:16.929554Z 15639 Query delete from cart_items where qty = 0
MySQL: 2024-05-16T13:48:16.929714Z 15639 Query select SQL_NO_CACHE SUM(qty*price) as total, sum(qty) as itemct from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:16.929894Z 15639 Query update cart set timestamp = 1715867296, items = 1, total = 46.80 where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:16.930017Z 15639 Query FLUSH TABLES cart_items
MySQL: 2024-05-16T13:48:16.930442Z 15639 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItemData();
MySQL: 2024-05-16T13:48:16.930814Z 15639 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Cart->is_order OR PHP: $Order->is_valid_id();
MySQL: 2024-05-16T13:48:16.930963Z 15639 Query select * from orders where order_id = 2024051601
PHP: $Cart->init BOGUS NOT USING SESSION???
MySQL: 2024-05-16T13:48:16.931100Z 15639 Query select SQL_NO_CACHE * from cart where uid = 0
MySQL: 2024-05-16T13:48:16.931239Z 15639 Query replace into cart values (0, '0',0, 'init', UNIX_TIMESTAMP(), 0.00)
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:16.931967Z 15639 Query FLUSH TABLES cart_items
MySQL: 2024-05-16T13:48:16.932720Z 15639 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where cart_id = 0
PHP: $Cart->getItemData() ON INVALID CART!
MySQL: 2024-05-16T13:48:16.933066Z 15639 Query select SQL_NO_CACHE itemnum as name, description from products where id = 18506
MySQL: 2024-05-16T13:48:16.933205Z 15639 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17298
MySQL: 2024-05-16T13:48:16.933314Z 15639 Query select SQL_NO_CACHE itemnum as name, description from products where id = 14420
MySQL: 2024-05-16T13:48:16.933440Z 15639 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17298
MySQL: 2024-05-16T13:48:16.933545Z 15639 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Order->__construct() ... existing order. Check error_log to see if there was an error (e.g. multiple order_statuses with this id).
MySQL: 2024-05-16T13:48:16.933708Z 15639 Query select distinct(status) from orders where order_id = 2024051601
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:16.933917Z 15639 Query FLUSH TABLES cart_items
MySQL: 2024-05-16T13:48:16.934301Z 15639 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:16.934649Z 15639 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Order->already_has_shipping();
MySQL: 2024-05-16T13:48:16.934795Z 15639 Query select * from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber' and itemnum='SHIPCOST'
PHP: $Order->addShipping (previous function returned FALSE)
MySQL: 2024-05-16T13:48:16.934938Z 15639 Query insert into cart_items values(NULL,0,'061gfh5oov60dkbfhdqfmd6ber',11111111,'SHIPCOST','Ship via USPS',1,6.74)
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:16.935727Z 15639 Query FLUSH TABLES cart_items
MySQL: 2024-05-16T13:48:16.936363Z 15639 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItemData()
MySQL: 2024-05-16T13:48:16.936689Z 15639 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Cart->update();
MySQL: 2024-05-16T13:48:16.936831Z 15639 Query delete from cart_items where qty = 0
MySQL: 2024-05-16T13:48:16.937001Z 15639 Query select SQL_NO_CACHE SUM(qtyprice) as total, sum(qty) as itemct from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:16.937172Z 15639 Query update cart set timestamp = 1715867296, items = 2, total = 53.54 where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Order->setOrderStatus();
MySQL: 2024-05-16T13:48:16.937843Z 15639 Query update orders set status
= 'incart' where order_id = 2024051601
PHP: $Cart->getTotal();
MySQL: 2024-05-16T13:48:16.937970Z 15639 Query select SQL_NO_CACHE SUM(qtyprice) as total, sum(qty) as itemct from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $User->login_check();
MySQL: 2024-05-16T13:48:16.938233Z 15639 Query select SQL_NO_CACHE s.user_id as user_id, s.securityString as string, l.status from sessions s inner join logins l on l.id = s.user_id where user_session =''
PHP: $User->countShopList();
MySQL: 2024-05-16T13:48:16.938418Z 15639 Query select SQL_NO_CACHE items from cart where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:16.939324Z 15639 Quit
Apache: [16/May/2024:08:48:19 -0700] "GET /cart?from_checkout=1 HTTP/1.1" 200
MySQL: 2024-05-16T13:48:19.318200Z 15640 Connect foobar@localhost on foobar_devel using Socket
PHP: $User->login_check()
MySQL: 2024-05-16T13:48:19.318409Z 15640 Query select SQL_NO_CACHE s.user_id as user_id, s.securityString as string, l.status from sessions s inner join logins l on l.id = s.user_id where user_session =''
PHP: $User->countShopList()
MySQL: 2024-05-16T13:48:19.318656Z 15640 Query select SQL_NO_CACHE items from cart where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:19.319479Z 15640 Quit
Apache: [16/May/2024:08:48:21 -0700] "GET /cart HTTP/1.1" 200
MySQL: 2024-05-16T13:48:21.263083Z 15641 Connect foobar@localhost on foobar_devel using Socket
PHP: $User->login_check();
MySQL: 2024-05-16T13:48:21.263543Z 15641 Query select SQL_NO_CACHE s.user_id as user_id, s.securityString as string, l.status from sessions s inner join logins l on l.id = s.user_id where user_session =''
PHP: $User->countShopList()
MySQL: 2024-05-16T13:48:21.263853Z 15641 Query select SQL_NO_CACHE items from cart where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->init();
MySQL: 2024-05-16T13:48:21.264077Z 15641 Query select SQL_NO_CACHE * from cart where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->setStatus();
MySQL: 2024-05-16T13:48:21.264259Z 15641 Query update cart set status = 'working', timestamp=UNIX_TIMESTAMP() where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:21.265692Z 15641 Query FLUSH TABLES cart_items
MySQL: 2024-05-16T13:48:21.266271Z 15641 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:21.266809Z 15641 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:21.266984Z 15641 Query FLUSH TABLES cart_items
MySQL: 2024-05-16T13:48:21.267445Z 15641 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItemData()
MySQL: 2024-05-16T13:48:21.268004Z 15641 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Cart->update();
MySQL: 2024-05-16T13:48:21.268156Z 15641 Query delete from cart_items where qty = 0
MySQL: 2024-05-16T13:48:21.268286Z 15641 Query select SQL_NO_CACHE SUM(qtyprice) as total, sum(qty) as itemct from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:21.268535Z 15641 Query update cart set timestamp = 1715867301, items = 2, total = 53.54 where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Shipping->removeFromCart();
MySQL: 2024-05-16T13:48:21.268707Z 15641 Query delete from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber' and itemnum='SHIPCOST'
MySQL: 2024-05-16T13:48:21.269733Z 15641 Query flush tables cart_items
PHP: $Cart->getItems();
MySQL: 2024-05-16T13:48:21.270340Z 15641 Query FLUSH TABLES cart_items
MySQL: 2024-05-16T13:48:21.270733Z 15641 Query select SQL_NO_CACHE id, item_id, qty, price from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Cart->getItemData()
MySQL: 2024-05-16T13:48:21.271229Z 15641 Query select SQL_NO_CACHE itemnum as name, description from products where id = 17352
PHP: $Cart->update();
MySQL: 2024-05-16T13:48:21.271374Z 15641 Query delete from cart_items where qty = 0
MySQL: 2024-05-16T13:48:21.271520Z 15641 Query select SQL_NO_CACHE SUM(qtyprice) as total, sum(qty) as itemct from cart_items where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:21.271731Z 15641 Query update cart set timestamp = 1715867301, items = 1, total = 46.80 where sessid = '061gfh5oov60dkbfhdqfmd6ber'
PHP: $Session->login_check()
MySQL: 2024-05-16T13:48:21.273008Z 15641 Query select SQL_NO_CACHE s.user_id as user_id, s.securityString as string, l.status from sessions s inner join logins l on l.id = s.user_id where user_session =''
PHP: $User->countShopList();
MySQL: 2024-05-16T13:48:21.273203Z 15641 Query select SQL_NO_CACHE items from cart where sessid = '061gfh5oov60dkbfhdqfmd6ber'
MySQL: 2024-05-16T13:48:21.274009Z 15641 Quit
MySQL: 2024-05-16T13:48:27.667329Z 15637 Query set GLOBAL general_log="OFF"