Update Thread Info Problem after ubb import

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Freeones
    Member
    • Jun 2003
    • 32

    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.
  • Scott MacVicar
    Former vBulletin Developer
    • Dec 2000
    • 13286

    #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

    • DanIAm
      Member
      • Jul 2002
      • 91

      #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

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #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

        • Boofo
          Senior Member
          • Apr 2002
          • 2033
          • 4.1.x

          #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

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #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

            • Boofo
              Senior Member
              • Apr 2002
              • 2033
              • 4.1.x

              #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

              • mark@sb.ws
                Senior Member
                • Apr 2002
                • 145

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

                Comment

                • SixthSense
                  New Member
                  • Dec 2002
                  • 25

                  #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

                  • iloco
                    Senior Member
                    • Jul 2002
                    • 130

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

                    Comment

                    • padmaster
                      Senior Member
                      • Mar 2003
                      • 203
                      • 3.0.0 Beta 5

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

                      Comment

                      • padmaster
                        Senior Member
                        • Mar 2003
                        • 203
                        • 3.0.0 Beta 5

                        #12
                        nevermind, I got it

                        Comment

                        • padmaster
                          Senior Member
                          • Mar 2003
                          • 203
                          • 3.0.0 Beta 5

                          #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

                          • padmaster
                            Senior Member
                            • Mar 2003
                            • 203
                            • 3.0.0 Beta 5

                            #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

                            • Steve Machol
                              Former Customer Support Manager
                              • Jul 2000
                              • 154488

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