Announcement

Collapse
No announcement yet.

MySQL error-postings

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

  • MySQL error-postings

    I'm getting the following error in postings.php when trying to edit a thread through the admin options.
    Code:
    Database error in vBulletin 2.3.2:
    
    Invalid SQL: UPDATE forum SET replycount='1065',threadcount='222' ,lastpost='1075351098',last-Jʲer='hockyfan' WHERE forumid='9'
    mysql error: You have an error in your SQL syntax near '-Jʲer='hockyfan' WHERE forumid='9'' at line 1
    
    mysql error number: 1064
    
    Date: Thursday 29th of January 2004 04:42:17 AM
    Script: [url="http://otnforums.snooboo.com/forum/forum/postings.php"]http://otnforums.snooboo.com/forum/forum/postings.php[/url]
    Referer: [url="http://otnforums.snooboo.com/forum/postings.php"]http://otnforums.snooboo.com/forum/postings.php[/url]
    I've already tried deleting postings.php, and reuploading a clean version in ASCII mode. Any other suggestions?



    h

  • #2
    does this happen when trying to edit any other posts?

    Comment


    • #3
      Yes it does, happens with all threads.



      h

      Comment


      • #4
        Did you make sure to upload the files in ascii mode?

        Comment


        • #5
          Yes, ASCII mode and I re-unzipped them from my vB2 download to ensure it was a clean file. Additionally, I first deleted my file from the server before uploading the new one just in case.



          h

          Comment


          • #6
            If you have not installed any hacks, fill out a support ticket at:

            http://www.vbulletin.com/members/support_form.php

            Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. If you have installed hacks, then remove the hacks first then check and see if you still have this problem. If so, leave the default vB files in place and fill out the support request.
            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