Announcement

Collapse
No announcement yet.

Error 1048

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #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


    • #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


      • #4
        Anything on this?

        Comment


        • #5
          What PHP and MySQL versions are being used?
          Kerry-Anne :)

          Twitter Blog

          www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

          Comment


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

            Comment


            • #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.
              Kerry-Anne :)

              Twitter Blog

              www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

              Comment


              • #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


                • #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


                  • #10
                    You should upgrade to 3.6.8 Patch Level 2 and then if the problem persists please submit a support ticket.
                    Kerry-Anne :)

                    Twitter Blog

                    www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

                    Comment

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