Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

DELETING - insert into sessions (sesskey, expiry,


syscon

Recommended Posts

Is it safe to delete the lines from database that starts with::blink:

insert into sessions (sesskey, expiry, value) values ('f373a25a24981bf45....

 

After someone's visit a strange line was inserted into database and restore the database did not work from withing web-page (everything crashed).

When I try to restore the same database from the command line I was able to restore it but it kept complaining about an error on one line. When I looked closer at this line it definitely looked different from other "insert into sessions..." lines.

 

Here is the strange line:

insert into sessions (sesskey, expiry, value) values ('f373a25a24981bf45bc11de4ad7e40d8', '1055365385', 'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:1:{i:206;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:5800;s:6:\"weight\";d:32;s:6:\"cartID\";s:5:\"90041\";s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:3:{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:\"f373a25a24981bf45bc11de4ad7e40d8\";}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:3:{s:11:\"products_id\";s:3:\"206\";s:6:\"action\";s:11:\"add_product\";s:6:\"osCsid\";s:32:\"f373a25a24981bf45bc11de4ad7e40d8\";}s:4:\"post\";a:4:{s:6:\"osCsid\";s:32:\"f373a25a24981bf45bc11de4ad7e40d8\";s:11:\"products_id\";s:3:\"206\";s:1:\"x\";s:2:\"60\";s:1:\"y\";s:2:\"14\";}}i:2;a:4:{s:4:\"page\";s:17:\"shopping_cart.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"f373a25a24981bf45bc11de4ad7e40d8\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}cod\');

 

#Joseph

#Joseph

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...