Announcement

Collapse
No announcement yet.

Admin CP Phrase Manager SQL error

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

  • Admin CP Phrase Manager SQL error

    PHP Code:
    Database error in vBulletin 3.8.2:

    Invalid SQL:

                    
    SELECT IF (pcustom.fieldname IS NOT NULLpcustom.fieldnamepmaster.fieldname) AS fieldname,
                        IF (
    pcustom.varname IS NOT NULLpcustom.varnamepmaster.varname) AS varname,
                        IF (
    pcustom.languageid IS NOT NULLpcustom.languageidpmaster.languageid) AS languageid,
                        IF (
    pcustom.text IS NOT NULLpcustom.textpmaster.text) AS text,
                        
    language.title
                    FROM language 
    AS language
                    INNER JOIN phrase 
    AS pmaster ON
                        
    (pmaster.languageid IN (-10))
                    
    LEFT JOIN phrase AS pcustom ON
                        
    (pcustom.languageid language.languageid AND pcustom.varname pmaster.varname AND pcustom.fieldname pmaster.fieldname)
                    
    WHERE 1=1
                        
                        
                    HAVING text LIKE 
    '%visitor%'
                    
    ORDER BY languageid DESCfieldname DESC;

    MySQL Error   Incorrect key file for table '/tmp/#sql_6513_0.MYI'; try to repair it
    Error Number  
    126
    Request Date  
    ThursdayApril 23rd 2009 10:16:37 PM
    Error Date    
    ThursdayApril 23rd 2009 10:16:37 PM
    Script        
    http://www.topzone.lt/forumas/admincp/phrase.php?do=dosearch
    Referrer      http://www.topzone.lt/forumas/admincp/phrase.php?do=search
    IP Address    blah
    Username      
    Original'as
    Classname     : vB_Database
    MySQL Version : 5.0.58-log 
    The phrase manager doesn't work.

    I went to php my admin > vb database > Check All > Repair tables
    that doesn't help, optimize tables either.
    Last edited by original'as; Thu 23rd Apr '09, 11:34pm.
    IT naujienos, apžvalgos ir diskusijos - topzone.lt

  • #2
    Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin Control Panel -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot access the Admin CP, then you can use phpMyAdmin to repair tables.

    If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

    http://www.vbulletin.com/forum/showt...threadid=44909

    You may have to ask your host to try and repair this for you.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      I can access Admin CP, but
      Admin Control Panel -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue
      or
      php my admin > vb database > Check All > Repair tables
      doesn't help. Both says all tables are OK, update, but Prase Manager gives an error.

      And it works, then a Phrase Type field is selected, but i want to search all phrase types, so i leave it blank and it gives me a SQL error then.
      Attached Files
      IT naujienos, apžvalgos ir diskusijos - topzone.lt

      Comment


      • #4
        Please follow the instructions in the rest of the post.

        Originally posted by Wayne Luke View Post
        If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

        http://www.vbulletin.com/forum/showt...threadid=44909

        You may have to ask your host to try and repair this for you.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.

        Comment


        • #5
          Please Wait...

          Results
          Table Action Žinutė
          access Check Status: OK
          access Optimize Status: Table is already up to date
          adminhelp Check Status: OK
          adminhelp Optimize Status: Table is already up to date
          administrator Check Status: OK
          administrator Optimize Status: Table is already up to date
          adminlog Check Status: OK
          adminlog Optimize Status: Table is already up to date
          adminmessage Check Status: OK
          adminmessage Optimize Status: Table is already up to date
          adminutil Check Status: OK
          adminutil Optimize Status: Table is already up to date
          album Check Status: OK
          album Optimize Status: Table is already up to date
          albumpicture Check Status: OK
          albumpicture Optimize Status: Table is already up to date
          albumupdate Check Status: OK
          albumupdate Optimize Status: Table is already up to date
          announcement Check Status: OK
          announcement Optimize Status: Table is already up to date
          announcementread Check Status: OK
          announcementread Optimize Status: Table is already up to date
          attachment Check Status: OK
          attachment Optimize Status: Table is already up to date
          attachmentpermission Check Status: OK
          attachmentpermission Optimize Status: Table is already up to date
          attachmenttype Check Status: OK
          attachmenttype Optimize Status: Table is already up to date
          attachmentviews Check Status: OK
          attachmentviews Optimize Status: Table is already up to date
          automediaembed Check Status: OK
          automediaembed Optimize Status: Table is already up to date
          avatar Check Status: OK
          avatar Optimize Status: Table is already up to date
          badwords Check Status: OK
          badwords Optimize Status: Table is already up to date
          bbcode Check Status: OK
          bbcode Optimize Status: Table is already up to date
          bookmarksite Check Status: OK
          bookmarksite Optimize Status: Table is already up to date
          calendar Check Status: OK
          calendar Optimize Status: Table is already up to date
          calendarcustomfield Check Status: OK
          calendarcustomfield Optimize Status: Table is already up to date
          calendarmoderator Check Status: OK
          calendarmoderator Optimize Status: Table is already up to date
          calendarpermission Check Status: OK
          calendarpermission Optimize Status: Table is already up to date
          cron Check Status: OK
          cron Optimize Status: Table is already up to date
          cronlog Check Status: OK
          cronlog Optimize Status: Table is already up to date
          customavatar Check Status: OK
          customavatar Optimize Status: Table is already up to date
          customprofilepic Check Status: OK
          customprofilepic Optimize Status: Table is already up to date
          datastore Check Status: OK
          datastore Optimize Status: Table is already up to date
          deletionlog Check Status: OK
          deletionlog Optimize Status: Table is already up to date
          discussion Check Status: OK
          discussion Optimize Status: Table is already up to date
          discussionread Check Status: OK
          discussionread Optimize Status: Table is already up to date
          editlog Check Status: OK
          editlog Optimize Status: Table is already up to date
          event Check Status: OK
          event Optimize Status: Table is already up to date
          externalcache Check Status: OK
          externalcache Optimize Status: Table is already up to date
          faq Check Status: OK
          faq Optimize Status: Table is already up to date
          forum Check Status: OK
          forum Optimize Status: Table is already up to date
          forumpermission Check Status: OK
          forumpermission Optimize Status: Table is already up to date
          forumprefixset Check Status: OK
          forumprefixset Optimize Status: Table is already up to date
          forumread Check Status: OK
          forumread Optimize Status: Table is already up to date
          games_cats Check Status: OK
          games_cats Optimize Status: Table is already up to date
          games_champs Check Status: OK
          games_champs Optimize Status: Table is already up to date
          games_league Check Status: OK
          games_league Optimize Status: Table is already up to date
          games_list Check Status: OK
          games_list Optimize Status: Table is already up to date
          games_savedGames Check Status: OK
          games_savedGames Optimize Status: Table is already up to date
          games_scores Check Status: OK
          games_scores Optimize Status: Table is already up to date
          games_session Check Status: OK
          games_session Optimize Status: Table is already up to date
          games_settings Check Status: OK
          games_settings Optimize Status: Table is already up to date
          groupmessage Check Status: OK
          groupmessage Optimize Status: Table is already up to date
          groupmessage_hash Check Status: OK
          groupmessage_hash Optimize Status: Table is already up to date
          groupread Check Status: OK
          groupread Optimize Status: Table is already up to date
          holiday Check Status: OK
          holiday Optimize Status: Table is already up to date
          humanverify Check Status: OK
          humanverify Optimize Status: Table is already up to date
          hvanswer Check Status: OK
          hvanswer Optimize Status: Table is already up to date
          hvquestion Check Status: OK
          hvquestion Optimize Status: Table is already up to date
          icon Check Status: OK
          icon Optimize Status: Table is already up to date
          imagecategory Check Status: OK
          imagecategory Optimize Status: Table is already up to date
          imagecategorypermission Check Status: OK
          imagecategorypermission Optimize Status: Table is already up to date
          infraction Check Status: OK
          infraction Optimize Status: Table is already up to date
          infractionban Check Status: OK
          infractionban Optimize Status: Table is already up to date
          infractiongroup Check Status: OK
          infractiongroup Optimize Status: Table is already up to date
          infractionlevel Check Status: OK
          infractionlevel Optimize Status: Table is already up to date
          language Check Status: OK
          language Optimize Status: Table is already up to date
          linkback Check Status: OK
          linkback Optimize Status: Table is already up to date
          macro Check Status: OK
          macro Optimize Status: Table is already up to date
          mailqueue Check Status: OK
          mailqueue Optimize Status: Table is already up to date
          mgc_chatbox Check Status: OK
          mgc_chatbox Optimize Status: Table is already up to date
          mgc_chatbox_ban Check Status: OK
          mgc_chatbox_ban Optimize Status: Table is already up to date
          moderation Check Status: OK
          moderation Optimize Status: Table is already up to date
          moderator Check Status: OK
          moderator Optimize Status: Table is already up to date
          moderatorlog Check Status: OK
          moderatorlog Optimize Status: Table is already up to date
          notice Check Status: OK
          notice Optimize Status: Table is already up to date
          noticecriteria Check Status: OK
          noticecriteria Optimize Status: Table is already up to date
          noticedismissed Check Status: OK
          noticedismissed Optimize Status: Table is already up to date
          passwordhistory Check Status: OK
          passwordhistory Optimize Status: Table is already up to date
          paymentapi Check Status: OK
          paymentapi Optimize Status: Table is already up to date
          paymentinfo Check Status: OK
          paymentinfo Optimize Status: Table is already up to date
          paymenttransaction Check Status: OK
          paymenttransaction Optimize Status: Table is already up to date
          phrase Check Status: OK
          phrase Optimize Status: Table is already up to date
          phrasetype Check Status: OK
          phrasetype Optimize Status: Table is already up to date
          picture Check Status: OK
          picture Optimize Status: Table is already up to date
          picturecomment Check Status: OK
          picturecomment Optimize Status: Table is already up to date
          picturecomment_hash Check Status: OK
          picturecomment_hash Optimize Status: Table is already up to date
          plugin Check Status: OK
          plugin Optimize Status: Table is already up to date
          pm Check Status: OK
          pm Optimize Status: Table is already up to date
          pmreceipt Check Status: OK
          pmreceipt Optimize Status: Table is already up to date
          pmtext Check Status: OK
          pmtext Optimize Status: Table is already up to date
          pmthrottle Check Status: OK
          pmthrottle Optimize Status: Table is already up to date
          podcast Check Status: OK
          podcast Optimize Status: Table is already up to date
          podcastitem Check Status: OK
          podcastitem Optimize Status: Table is already up to date
          poll Check Status: OK
          poll Optimize Status: Table is already up to date
          pollvote Check Status: OK
          pollvote Optimize Status: Table is already up to date
          post Check Status: OK
          post Optimize Status: Table is already up to date
          postedithistory Check Status: OK
          postedithistory Optimize Status: Table is already up to date
          posthash Check Status: OK
          posthash Optimize Status: Table is already up to date
          postindex Check Status: OK
          postindex Optimize Status: Table is already up to date
          postlog Check Status: OK
          postlog Optimize Status: Table is already up to date
          postparsed Check Status: OK
          postparsed Optimize Status: Table is already up to date
          prefix Check Status: OK
          prefix Optimize Status: Table is already up to date
          prefixpermission Check Status: OK
          prefixpermission Optimize Status: Table is already up to date
          prefixset Check Status: OK
          prefixset Optimize Status: Table is already up to date
          product Check Status: OK
          product Optimize Status: Table is already up to date
          productcode Check Status: OK
          productcode Optimize Status: Table is already up to date
          productdependency Check Status: OK
          productdependency Optimize Status: Table is already up to date
          profileblockprivacy Check Status: OK
          profileblockprivacy Optimize Status: Table is already up to date
          profilefield Check Status: OK
          profilefield Optimize Status: Table is already up to date
          profilefieldcategory Check Status: OK
          profilefieldcategory Optimize Status: Table is already up to date
          profilevisitor Check Status: OK
          profilevisitor Optimize Status: Table is already up to date
          ranks Check Status: OK
          ranks Optimize Status: Table is already up to date
          reminder Check Status: OK
          reminder Optimize Status: Table is already up to date
          reputation Check Status: OK
          reputation Optimize Status: Table is already up to date
          reputationlevel Check Status: OK
          reputationlevel Optimize Status: Table is already up to date
          rssfeed Check Status: OK
          rssfeed Optimize Status: Table is already up to date
          rsslog Check Status: OK
          rsslog Optimize Status: Table is already up to date
          search Check Status: OK
          search Optimize Status: Table is already up to date
          setting Check Status: OK
          setting Optimize Status: Table is already up to date
          settinggroup Check Status: OK
          settinggroup Optimize Status: Table is already up to date
          sigparsed Check Status: OK
          sigparsed Optimize Status: Table is already up to date
          sigpic Check Status: OK
          sigpic Optimize Status: Table is already up to date
          smilie Check Status: OK
          smilie Optimize Status: Table is already up to date
          socialgroup Check Status: OK
          socialgroup Optimize Status: Table is already up to date
          socialgroupcategory Check Status: OK
          socialgroupcategory Optimize Status: Table is already up to date
          socialgroupicon Check Status: OK
          socialgroupicon Optimize Status: Table is already up to date
          socialgroupmember Check Status: OK
          socialgroupmember Optimize Status: Table is already up to date
          socialgrouppicture Check Status: OK
          socialgrouppicture Optimize Status: Table is already up to date
          spamlog Check Status: OK
          spamlog Optimize Status: Table is already up to date
          stats Check Status: OK
          stats Optimize Status: Table is already up to date
          strikes Check Status: OK
          strikes Optimize Status: Table is already up to date
          style Check Status: OK
          style Optimize Status: Table is already up to date
          subscribediscussion Check Status: OK
          subscribediscussion Optimize Status: Table is already up to date
          subscribeevent Check Status: OK
          subscribeevent Optimize Status: Table is already up to date
          subscribeforum Check Status: OK
          subscribeforum Optimize Status: Table is already up to date
          subscribegroup Check Status: OK
          subscribegroup Optimize Status: Table is already up to date
          subscribethread Check Status: OK
          subscribethread Optimize Status: Table is already up to date
          subscription Check Status: OK
          subscription Optimize Status: Table is already up to date
          subscriptionlog Check Status: OK
          subscriptionlog Optimize Status: Table is already up to date
          subscriptionpermission Check Status: OK
          subscriptionpermission Optimize Status: Table is already up to date
          tachyforumcounter Check Status: OK
          tachyforumcounter Optimize Status: Table is already up to date
          tachyforumpost Check Status: OK
          tachyforumpost Optimize Status: Table is already up to date
          tachythreadcounter Check Status: OK
          tachythreadcounter Optimize Status: Table is already up to date
          tachythreadpost Check Status: OK
          tachythreadpost Optimize Status: Table is already up to date
          tag Check Status: OK
          tag Optimize Status: Table is already up to date
          tagsearch Check Status: OK
          tagsearch Optimize Status: Table is already up to date
          tagthread Check Status: OK
          tagthread Optimize Status: Table is already up to date
          template Check Status: OK
          template Optimize Status: Table is already up to date
          templatehistory Check Status: OK
          templatehistory Optimize Status: Table is already up to date
          thread Check Status: OK
          thread Optimize Status: Table is already up to date
          threadrate Check Status: OK
          threadrate Optimize Status: Table is already up to date
          threadread Check Status: OK
          threadread Optimize Status: Table is already up to date
          threadredirect Check Status: OK
          threadredirect Optimize Status: Table is already up to date
          threadviews Check Status: OK
          threadviews Optimize Status: Table is already up to date
          tournament_players Check Status: OK
          tournament_players Optimize Status: Table is already up to date
          tournament_players_statut Check Status: OK
          tournament_players_statut Optimize Status: Table is already up to date
          tournaments Check Status: OK
          tournaments Optimize Status: Table is already up to date
          upgradelog Check Status: OK
          upgradelog Optimize Status: Table is already up to date
          user Check Status: OK
          user Optimize Status: Table is already up to date
          useractivation Check Status: OK
          useractivation Optimize Status: Table is already up to date
          userban Check Status: OK
          userban Optimize Status: Table is already up to date
          userchangelog Check Status: OK
          userchangelog Optimize Status: Table is already up to date
          usercss Check Status: OK
          usercss Optimize Status: Table is already up to date
          usercsscache Check Status: OK
          usercsscache Optimize Status: Table is already up to date
          userfield Check Status: OK
          userfield Optimize Status: Table is already up to date
          usergroup Check Status: OK
          usergroup Optimize Status: Table is already up to date
          usergroupleader Check Status: OK
          usergroupleader Optimize Status: Table is already up to date
          usergrouprequest Check Status: OK
          usergrouprequest Optimize Status: Table is already up to date
          userlist Check Status: OK
          userlist Optimize Status: Table is already up to date
          usernote Check Status: OK
          usernote Optimize Status: Table is already up to date
          userpromotion Check Status: OK
          userpromotion Optimize Status: Table is already up to date
          usertextfield Check Status: OK
          usertextfield Optimize Status: Table is already up to date
          usertitle Check Status: OK
          usertitle Optimize Status: Table is already up to date
          visitormessage Check Status: OK
          visitormessage Optimize Status: Table is already up to date
          visitormessage_hash Check Status: OK
          visitormessage_hash Optimize Status: Table is already up to date
          word Check Status: OK
          word Optimize Status: Table is already up to date
          as i said that doesnt help, because all tables are OK and up to date.

          Fix Unique Indexes doesn't solve the problem either.

          Phrase manager still gives the same SQL error then Phrase type isn't selected. :/
          Last edited by original'as; Thu 23rd Apr '09, 1:17pm.
          IT naujienos, apžvalgos ir diskusijos - topzone.lt

          Comment


          • #6
            That's because the problem is in a temp file:

            MySQL Error : Incorrect key file for table '/tmp/#sql_6513_0.MYI'; try to repair it

            Your host will probably need to empty the tmp directory to fix 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


            • #7
              Originally posted by Steve Machol View Post
              That's because the problem is in a temp file:

              MySQL Error : Incorrect key file for table '/tmp/#sql_6513_0.MYI'; try to repair it

              Your host will probably need to empty the tmp directory to fix this.
              Yes, that was a server problem. Everything is fine now. Thanks.
              IT naujienos, apžvalgos ir diskusijos - topzone.lt

              Comment

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