Announcement

Collapse
No announcement yet.

slight problem with the database...

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

  • George L
    replied
    no probs

    Leave a comment:


  • jeeperosstaff
    replied
    WOW! that did it!!


    thanks a lot!! I really mean it, you made my weekend!

    Leave a comment:


  • George L
    replied
    run query box type

    REPAIR TABLE user;

    Leave a comment:


  • jeeperosstaff
    replied
    In the Querry space on phpMyAdmin I found this:


    ---------------------------------------------------------
    SQL-query :

    PMA_mysql_list_fields(

    vbulletin, user
    )

    MySQL said:


    Can't open file: 'user.MYD'. (errno: 145)
    ---------------------------------------------------------

    My database is : vbulletin

    So I just go to the

    Run SQL query/queries on database vbulletin [Documentation] :

    Square and type: REPAIR TABLE vbulletin

    is that right?

    thanks a lot!!
    "

    Leave a comment:


  • jeeperosstaff
    replied
    BTW I have phpmyadmin and can log in, so if you could tell me a few steps on how to do it maybe I can tackle it?

    thanks again!!

    Leave a comment:


  • jeeperosstaff
    replied
    WOW thanks a lot for the fast answer Eva2000,

    Do you know if there is a manual for Dumbs on "HOW TO" do any of those? I dont have a clue how to use mysql or any other tool you mentioned before. Or know anyone who would do it for me? (even if I have to pay for it)

    again thanks a lot!

    Leave a comment:


  • George L
    replied
    you have a corrupted table, you need to repair it via one of the following methods
    ===================
    1. via phpmyadmin

    using query

    REPAIR TABLE user;

    2. or using mysqlcheck repair for 3.23.38 and above

    i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

    mysqlcheck -r -u mysqlusername -p databasename

    3. or via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

    myisamchk -r -u root -p databasename

    option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.

    Leave a comment:


  • jeeperosstaff
    started a topic slight problem with the database...

    slight problem with the database...

    I woke up this morning and found that my forums give this error:

    -----------------------------------------------------------------------------
    -----------------------------------------------------------------------------
    There seems to have been a slight problem with the Jeeperos.com database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.
    -----------------------------------------------------------------------------
    -----------------------------------------------------------------------------

    and from the source I get:


    -----------------------------------------------------------------------------
    -----------------------------------------------------------------------------
    <!-- Database error in vBulletin 2.2.8:

    Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
    mysql error: Can't open file: 'user.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Friday 24th of January 2003 09:28:02 AM
    Script: http://www.jeeperos.com/foros/foros/
    Referer:
    -->
    -----------------------------------------------------------------------------
    -----------------------------------------------------------------------------

    Any help will be appreciated, I have no clue whats going on. Also tried to get into the /admin and wouldnt let me, gives the same error.

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