Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    18
    Plugin Contributions
    0

    Default error of sessions table after I added more columns to it

    I am facing this error -

    1136 Column count doesn't match value count at row 1
    in:
    [insert into sessions values ('93a3e60394e1ba7edc3b8daa9a57308c', '1251293276', 'securityToken|s:32:\"cb8d5cc6a2a770a05c41aabb3ece6481\";customers_host_address| s:9:\"localhost\";cartID|s:0:\"\";cart|O:12:\"shoppingCart\":8:{s:8:\"contents\" ;a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;s:18:\"fre e_shipping_item\";i:0;s:20:\"free_shipping_weight\";i:0;s:19:\"free_shipping_pri ce\";i:0;s:9:\"observers\";a:0:{}}navigation|O:17:\"navigationHistory\":3:{s:4:\ "path\";a:1:{i:0;a:4:{s:4:\"page\";s:5:\"index\";s:4:\"mode\";s:6:\"NONSSL\";s:3 :\"get\";s:0:\"\";s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}s:9:\"observers\"; a:0:{}}check_valid|s:4:\"true\";language|s:7:\"english\";languages_id|s:1:\"1\"; languages_code|s:2:\"en\";currency|s:3:\"USD\";today_is|s:10:\"2009-08-26\";updateExpirations|b:1;session_counter|b:1;customers_ip_address|s:9:\"127.0. 0.1\";')]


    Due to this I can't add the products in my cart. I've add a new field named site_id in all tables.
    can anyone tell where this session makes and inserts the table data ?

    Thanks in advance

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: error of sessions table

    Quote Originally Posted by ajaysingh View Post
    I've add a new field named site_id in all tables.
    That'll be your problem.
    Why are you editing *all* tables' structures?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. v151 Duplicate entry error on sessions table with new install on Mountain Lion Server
    By jeffmic in forum Installing on a Mac Server
    Replies: 4
    Last Post: 26 Mar 2013, 08:37 AM
  2. v150 Added More info pages 5,6,7 after upgrade cannot find
    By genxnomad in forum Upgrading to 1.5.x
    Replies: 5
    Last Post: 1 Feb 2012, 12:12 PM
  3. Replies: 1
    Last Post: 29 Dec 2011, 11:27 AM
  4. sessions error after changing hosts
    By delia in forum General Questions
    Replies: 6
    Last Post: 29 Jul 2011, 08:47 PM
  5. table error please help: "table 'sessions' doesn't exist"
    By ebydrc in forum General Questions
    Replies: 3
    Last Post: 6 Apr 2008, 06:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR