new bug in vb2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alone in web

    new bug in vb2

    I found this error while trying to install vb2 on my web server.
    In all MySQL Database Version 4.1.7 and maybe an others CREATE TABLE queries (/admin/install.php?step=4) that have auto_increment and DEFAULT value
    such as
    Code:
    $query[]="CREATE TABLE word (
       wordid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
       title char(50) NOT NULL,
       PRIMARY KEY (wordid)
    )";
    the error was
    Code:
    mysql error: Invalid default value for 'wordid'
    
    mysql error number: 1067
    when I delete the DEFAULT '0' it works correctly.
    note that you can delete auto_increment field property (to let install works) but any query have this style
    INSERT INTO xxx VALUES(NULL,xxx,....,xxx)
    doesn't work

    So use this code
    Code:
    $query[]="CREATE TABLE word (
       wordid int(10) unsigned NOT NULL auto_increment,
       title char(50) NOT NULL,
       PRIMARY KEY (wordid)
    )";
    this type is used in vb3 and that's it.
    you must fix it as soon as you can
    I'm sure that I say the truth.
    Tables that have this error:
    1. adminlog
    2. announcement
    3. attachment
    4. avatar
    5. bbcode
    6. calendar_events
    7. forum
    8. forumpermission
    9. icon
    10. moderator
    11. poll
    12. pollvote
    13. post
    14. privatemessage
    15. profilefield
    16. replacement
    17. replacementset
    18. search
    19. setting
    20. settinggroup
    21. smilie
    22. style
    23. subscribeforum
    24. subscribethread
    25. template
    26. templateset
    27. thread
    28. threadrate
    29. user
    30. usergroup
    31. usertitle
    32. word

    and what make me marvelling that this table
    useractivation
    already fixed.
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    If you have a vBulletin license please enter your email that you used to register here with in the members area, if not what is the url to the board you are finding these errors with.

    Comment

    • alone in web

      #3
      And now I had add my email
      OKay

      Comment

      • Floris
        Senior Member
        • Dec 2001
        • 37767

        #4
        Yep, thank you. You now show up as licensed member.

        Comment

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