Announcement

Collapse
No announcement yet.

Update thread title error

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

  • Update thread title error

    Database error in vBulletin 2.3.0:
    Invalid SQL: UPDATE forum SET lastthreadtitle = IF(forumid = 6, 'Battle Hack Installed', IF(forumid = 7, 'quierys', IF(forumid = 10, 'fgdfgdfgdfg', IF(forumid = 13, 'Wot Music Do u Like??', IF(forumid = 20, 'I rule!', IF(forumid = 21, 'Dese weirdos guys in a ba...', IF(forumid = 22, 'Before Posting', IF(forumid = 23, 'Before Posting', IF(forumid = 24, 'Bush, Cheney, and the Buc...', IF(forumid = 25, 'Andensum', IF(forumid = 26, 'DnA\'s problem', IF(forumid = 28, 'Favourite Game', IF(forumid = 33, 'Kings Of Chaos', IF(forumid = 35, 'Kerrang', IF(forumid = 36, 'Vision!', IF(forumid = 37, 'May ToTm Nominations', IF(forumid = 39, 'Hmm LOOSER - DnA (DnA) vs...', IF(forumid = 44, 'Timespliters 2', IF(forumid = 45, 'M G S', IF(forumid = 46, 'ISS Pro Evo', IF(forumid = 47, 'Gt', IF(forumid = 49, 'Championship Manager 4', IF(forumid = 51, 'Please All Mods', IF(forumid = 52, '[BUG] Last title on forum...', IF(forumid = , '', IF(forumid = , '', IF(forumid = , '', 'Unknown forumid!')))))))))))))))))))))))))))
    WHERE forumid IN (6, 7, 10, 13, 20, 21, 22, 23, 24, 25, 26, 28, 33, 35, 36, 37, 39, 44, 45, 46, 47, 49, 51, 52, , , )
    mysql error: You have an error in your SQL syntax near ' '', IF(forumid = , '', IF(forumid = , '', 'Unknown forumid!')))))))))))))))))))' at line 1
    mysql error number: 1064
    Date: Tuesday 15th of April 2003 03:42:49 PM
    Script: http://www.alixd.co.uk/forums/forums...adtitlecache=1
    Referer:
    This is what happens when i try to run report.php to update the thread titles on my homepage
    Unlike most, I don't think I'm always right, if I'm wrong, CORRECT me.... providing you have some evidence

  • #2
    How are you running report.php?
    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


    • #3
      typing it in thorugh my browser, i tried to do a cron job, but it never worked with that. i am using report.php?updatethreadtitlecache=1
      Unlike most, I don't think I'm always right, if I'm wrong, CORRECT me.... providing you have some evidence

      Comment


      • #4
        Originally posted by Breaker
        typing it in thorugh my browser, i tried to do a cron job, but it never worked with that. i am using report.php?updatethreadtitlecache=1
        report.php?updatethreadtitlecache=1 ?
        Is this a hack?
        You're my Prince of Peace
        And I will live my life for You

        Comment


        • #5
          As nuno says this sounds like a hack. It's certainly not a default vB function - nor is report.php supposed to be used directly like this.
          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


          • #6
            i was told by filbert @ vbulletintemplates.com to run this command as a cron job to update the thread titles for a script, when the cron job didn't do anything i ran the script myself but it came up as this error
            Unlike most, I don't think I'm always right, if I'm wrong, CORRECT me.... providing you have some evidence

            Comment


            • #7
              You'll need to ask him about this then.
              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