Announcement

Collapse
No announcement yet.

this is the error message I get....

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

  • this is the error message I get....

    Invalid SQL:
    SELECT title, data
    FROM vb3datastore
    WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'rankphp', 'smiliecache', 'bbcodecache', 'mailqueue', 'hidprofilecache')

    mysql error: Can't open file: 'vb3datastore.MYD'. (errno: 145)
    mysql error number: 1016

    I have been getting this error message since my server did some upgrading. Can anyone tell me what this means & what I need to do to fix it.

    Thanks

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

    Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue
    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
      can;t access the admincp..

      I can't access the admincp...

      Comment


      • #4
        You can also repair tables in phpMyAdmin.
        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


        • #5
          phpmyadmin??

          I can access mysqls ...is that the same as my phpmyadmin?? I am lost here......

          Comment


          • #6
            I don't know if this is the same or not. You can try.
            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
              nope

              I did try........I can't find anywhere to repair tables in mysql ...

              Comment


              • #8
                Is there an area to run queries?
                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


                • #9
                  yes..

                  yes, there is an area to run queries.........I know very little about sql and php. Sorry to be such a pest.

                  Comment


                  • #10
                    Try this query:

                    REPAIR TABLE datastore;
                    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


                    • #11
                      It worked!!!

                      oh my gosh..........it worked. Thank you so much!!

                      Comment


                      • #12
                        You're welcome.
                        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