No announcement yet.

database error

  • Filter
  • Time
  • Show
Clear All
new posts

  • database error

    can some1 help me wif this?

    Invalid SQL: INSERT INTO useractivation VALUES (NULL,'353','1058437983','2194823',1)
    mysql error: Column count doesn't match value count at row 1

    mysql error number: 1136

    Script: member.php
    Referer: member.php

  • #2
    You have upgraded to 2.3.0 but not uploaded all of the new php files. Upload the original files from the 2.3.0 zip file, making sure to overwrite your old ones.


    • #3
      but then wldnt it create more errors cos i have hacks installed on my board..


      • #4
        If you upgrade, you HAVE to upload ALL the new files from the new version. They include file changes etc.

        Hacks are not supported by Jelsoft, so you have to re-apply them. If you don't want that, don't upgrade.


        • #5
          been there done that, restored dbase and e error comes up. so wat gives?

          furthermore, i aint afraid of losing hacks but more afraid of havin more problems created, of cos i need to have my queries ans rite..?


          • #6
            That error would not occur if you are runnng the default vB files and you ran the appropriate upgrades scripts.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography

            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.