Announcement

Collapse
No announcement yet.

Update Thread Info Problem after ubb import

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

  • Update Thread Info Problem after ubb import

    I imported my complete Ubb 6.0.5 BBS. everything went okay, but the Update Thread Info function gives me the following error :

    Database error in vBulletin Control Panel 2.3.0:


    Invalid SQL: UPDATE thread SET lastpost=1037231400,replycount=1,postusername='<jack69>', postuserid='0', lastposter='Freeones',attach= WHERE threadid=267
    mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE threadid=267' at line 1


    i noticed there's something wrong with the attach=. Its missing some quotes...

    i run php 4.3.1 and mysql 4.0.13 .

    Thanks in advance.

  • #2
    MySQL 4.0.13 appears to have introduced a new problem when returning the sum of a column not always returning an integer value.

    open up your admin/misc.php
    line 276
    replace
    Code:
    attach=$attachsum
    with
    Code:
    attach=" . intval($attachsum) . "
    Scott MacVicar

    My Blog | Twitter

    Comment


    • #3
      I did exactly what was described in the solution and it messed up my entire board. I am not getting MySQL error everywhere.

      Comment


      • #4
        Most likely you made a mistake in making the change. What errors are you getting?
        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.


        Comment


        • #5
          Is it ok to change this if we are still running 4.0.1.2?
          vBulletin - Sometimes, I'm just like, Wow, and then I'm like, Whoa, and then I'm like, Damn.

          vBulletin.org's ol' Moderator

          I have a lifetime terrorist hunting permit - #091101

          chmod a+x /bin/laden -- Allows anyone the permission to execute /bin/laden

          Comment


          • #6
            You shouldn't be having this same problem with 4.0.12. However it shouldn't hurt to change it. Keep a backup of misc.php just in case.
            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.


            Comment


            • #7
              Originally posted by Steve Machol
              You shouldn't be having this same problem with 4.0.12. However it shouldn't hurt to change it. Keep a backup of misc.php just in case.
              I'm not having any problems yet, but my host changed to 4.0.1.2 before I knew it so I expect the same for 4.0.1.3. I am currently running 2.2.9 but I went ahead and changed it anyway to try and avoid any future problems.
              vBulletin - Sometimes, I'm just like, Wow, and then I'm like, Whoa, and then I'm like, Damn.

              vBulletin.org's ol' Moderator

              I have a lifetime terrorist hunting permit - #091101

              chmod a+x /bin/laden -- Allows anyone the permission to execute /bin/laden

              Comment


              • #8
                Same problem I had. I made changes Steve suggested and it works great. Thanks

                Comment


                • #9
                  I've faceds the same problem w/ the thread info -like last poster, number of posts-.
                  After I changed that as suggested, everything is fine now.

                  Thanks for your help.

                  Comment


                  • #10
                    Thanks Steve for the code. I needed it this morning and it worked great.
                    iloco

                    Comment


                    • #11
                      What text editor are you guys using that shows the line # ?

                      Comment


                      • #12
                        nevermind, I got it

                        Comment


                        • #13
                          hmmmm, yesterday I d/l my daily site backup thru cpanel at 28mb, today it is only 15mb......and I've actually had a couple of new members today. Could fixing this problem and running update thread info make the backup that much smaller? The forums backup is a little bigger today as I would expect.

                          Comment


                          • #14
                            I reran the update thread info without any errors.....that problem seems to be fixed.


                            Now I'm getting a 404 when I click on 'get more' smilies in a reply

                            I tried reverting back to the smilie.php from yesterday but it didn't help.



                            HELP

                            Comment


                            • #15
                              Revert your vbcode_smilies_getmore template back to original.
                              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.


                              Comment

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