Announcement

Collapse
No announcement yet.

repair.php -> error 1064

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

  • repair.php -> error 1064

    Hi,

    following error message I got after using repair. Could someone tell me what I should think about it? Don`t know...

    Hope for help...

    May

    Database error in vBulletin Control Panel: Invalid SQL: CHECK TABLE access
    mysql error: You have an error in your SQL syntax near 'CHECK TABLE access' at line 1
    mysql error number: 1064
    Date: Thursday 20th of September 2001 01:30:47 AM
    Script: /forum/admin/repair.php?html=1&check=1
    Referer:

  • #2
    This thread might help you. I beleive its the version of mysql you are running. Are you running 3.22??

    http://vbulletin.com/forum/showthrea...or+number+1064
    Board of the Month: November
    Websites: Pixeljunction , vBulletin.org
    Button Sets: XP and Aqua Button sets! FREE!
    vB Customization: My sig is now vbulletin compliant. Contact me to make yours compliant too!

    Comment


    • #3
      Hi Sinecure,

      indeed, mySQL is 3.22.25.

      I've followed your link advice and compared what Ed asked:

      PRIMARY KEY (threadid),
      KEY iconid (iconid),
      KEY forumid (forumid, visible, sticky, lastpost)


      mine are..

      Name Unique Feld Aktion
      PRIMARY Ja threadid Löschen
      iconid Nein iconid Löschen
      forumid Nein forumid Löschen
      forumid Nein visible Löschen
      forumid Nein sticky Löschen
      forumid Nein lastpost Löschen
      [Dokumentation]


      Ed's statement: "Ok, you don't have MySQL 3.23... isamchk..."

      My site is remotely hosted and I'm not able to use isamchk extern utility, so would it be the best to ask my hoster to make an update of MySQL to 3.23 ?

      May

      Comment


      • #4
        Yeah, send them a trouble ticket or something and suggest they upgrade. There is no reason for not upgrading, perhaps they were lazy hehe
        Board of the Month: November
        Websites: Pixeljunction , vBulletin.org
        Button Sets: XP and Aqua Button sets! FREE!
        vB Customization: My sig is now vbulletin compliant. Contact me to make yours compliant too!

        Comment


        • #5
          Thanks for help!!!

          They will get the message (with a flower or Carlsberger :-)

          May

          Comment


          • #6
            Im getting this error.

            Any recommendations? Im very new to database work.

            Database error in vBulletin: Invalid SQL: SELECT *,INSTR(',7,-1,', CONCAT(',', forumid, ',') ) AS ordercontrol FROM access WHERE userid= AND (forumid='7' OR forumid='-1') ORDER BY ordercontrol LIMIT 1
            mysql error: You have an error in your SQL syntax near 'AND (forumid='7' OR forumid='-1') ORDER BY ordercontrol LIMIT 1' at line 1
            mysql error number: 1064
            Date: Thursday 20th of September 2001 03:13:18 PM
            Script: /forums/forumdisplay.php?s=&forumid=7
            Referer:

            Comment


            • #7
              OrganiC, please enter your customer info into your profile. See link in sig for more info. Thanks!

              Comment

              Loading...
              Working...
              X