Announcement

Collapse
No announcement yet.

Error Number : 1064

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

  • Error Number : 1064

    Database error in vBulletin 3.5.4:

    Invalid SQL:
    SELECT userid FROM post where threadid = AND userid = 1;

    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 'AND userid = 1' at line 1
    Error Number : 1064
    Date : Saturday, May 20th 2006 @ 10:18:20 AM
    Script : http://www.sa-w.com/vb/admincp/misc....=26001&pp=1000

  • #2
    First I recommend reuploading all the default vBulletin non-image files in ASCII mode, overwriting your current files. Also, turn off plugins globally in your vBulletin Options. Does this problem still occur then?
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      Could You Give Me An Example Of A Global Plugin?

      Comment


      • #4
        There's no such thing as a global plugin, I asked you to turn off all plugins for the entire board.
        There is a switch in your vBulletin Options to do this.
        Best Regards
        Colin Frei

        Please don't contact me per PM.

        Comment


        • #5
          I did what you recommended me to do and a new problem occured


          MySQL Error : Got a packet bigger than 'max_allowed_packet'
          Error Number : 1153
          Attached Files

          Comment


          • #6
            You'll have to set up the value for 'max_allowed_packet', or ask your host to do so.
            This is in your my.cnf (or my.ini for Windows systems)
            Best Regards
            Colin Frei

            Please don't contact me per PM.

            Comment


            • #7
              my server is linux based. but where can I find the file " my.cnf"?

              is it a php or apache related?

              Comment


              • #8
                It's a MySQL config file.
                Check in your /etc/ folder.
                Best Regards
                Colin Frei

                Please don't contact me per PM.

                Comment


                • #9
                  problem number 1153 has been solved . However problem number 1064 hasn't been solved yet

                  Comment


                  • #10
                    Did you reupload all the original vBulletin files in ASCII mode, overwriting your current files?
                    Best Regards
                    Colin Frei

                    Please don't contact me per PM.

                    Comment

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