Error 1048

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Bob Ricci
    Senior Member
    • May 2002
    • 143
    • 3.5.x

    Error 1048

    We have an older installation of vB that after being moved to a new server with a newer version of mySQL that now has a problem. The customer won't pay to upgrade vB


    <!-- Database error in vBulletin 2.3.2:
    Invalid SQL:
    INSERT INTO useractivation
    (useractivationid, userid, dateline, activationid, type, usergroupid)
    VALUES
    (NULL, 710, 1199997534, '7750881', 1, 6)

    mysql error: Column 'useractivationid' cannot be null
    mysql error number: 1048
  • Floris
    Senior Member
    • Dec 2001
    • 37767

    #2
    Auto increment fields shouldn't be set as NULL or even appear in a query. This could be a bug in vBulletin or a difference between older and newer MySQL versions.

    Comment

    • Bob Ricci
      Senior Member
      • May 2002
      • 143
      • 3.5.x

      #3
      This installation worked before the change in mySQL versions. I seem to recall a fix somehwere on this site that addressed this, but I can't find it.

      Comment

      • Bob Ricci
        Senior Member
        • May 2002
        • 143
        • 3.5.x

        #4
        Anything on this?

        Comment

        • peterska2
          Senior Member
          • Oct 2003
          • 8869
          • 3.7.x

          #5
          What PHP and MySQL versions are being used?

          Comment

          • Bob Ricci
            Senior Member
            • May 2002
            • 143
            • 3.5.x

            #6
            Thanks for asking. MySQL is 4.1.2 and PHP is 4.3.9. Previously, mySQL was 3.x.

            Comment

            • peterska2
              Senior Member
              • Oct 2003
              • 8869
              • 3.7.x

              #7
              The most likely reason for this error is either that your backup did not create correctly or restore correctly, or that you have modifications to your vBulletin.

              Please reupload the original vBulletin files overwriting the files on your server to remove any modifications. If the problem then persists, redo your database backup ensuring that you force the SQL compatibility option to make sure that your backup will restore without errors on the newer version of MySQL.

              Comment

              • Bob Ricci
                Senior Member
                • May 2002
                • 143
                • 3.5.x

                #8
                All files and databases were migrated using Plesk 8.2 and its migration scripts from Ensim 4.x and mySQL 3.28.x. We experienced many failures along these lines, since older versions of mySQL were LATIN-1 and newer versions are UTF-8. We have not modified files. We have only migrated to a new server. It seems that mySQL 4.x is the issue and since the server we were once on is no longer available I don't see how we can redo the database import.

                If I can get the database .sql from the prior provider what commands should be run to force compatibility?

                Comment

                • Bob Ricci
                  Senior Member
                  • May 2002
                  • 143
                  • 3.5.x

                  #9
                  It seems that many features invoke the same error. I'm not sure how to recover from this. Would an upgrade from 2.3.2 all the way to 3.7.x help?

                  Database error in vBulletin 2.3.2:
                  Invalid SQL: INSERT INTO search (searchid,query,dateline,querystring,showposts,userid,ipaddress) VALUES (NULL,'1=1 AND thread.lastpost>=1188847088 AND thread.open<>10',1200989408,'',0,1,'24.182.13.187')
                  mysql error: Column 'searchid' cannot be null
                  mysql error number: 1048

                  Comment

                  • peterska2
                    Senior Member
                    • Oct 2003
                    • 8869
                    • 3.7.x

                    #10
                    You should upgrade to 3.6.8 Patch Level 2 and then if the problem persists please submit a support ticket.

                    Comment

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