Results 1 to 4 of 4

Thread: MySQL error 1194

  1. #1
    PavelK is offline Junior Member
    Join Date
    Jul 2008
    Posts
    3

    Default MySQL error 1194

    Hi,
    after I logged in I get this message:

    Error filling in additional detail fields Query Failed:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0::MySQL error 1194:

    thx for any advise

  2. #2
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: MySQL error 1194

    Quote Originally Posted by PavelK
    Hi,
    after I logged in I get this message:

    Error filling in additional detail fields Query Failed:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0::MySQL error 1194:

    thx for any advise
    Per http://dev.mysql.com/doc/refman/5.0/...es-server.html

    Error: 1194 SQLSTATE: HY000 (ER_CRASHED_ON_USAGE)

    Message: Table '%s' is marked as crashed and should be repaired

    Try repairing the table
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  3. #3
    PavelK is offline Junior Member
    Join Date
    Jul 2008
    Posts
    3

    Default Re: MySQL error 1194

    I've already tried to repair the table but it's still not working

  4. #4
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: MySQL error 1194

    Quote Originally Posted by PavelK
    I've already tried to repair the table but it's still not working

    Can you access the table from mysql?

    You could try duplicating it and drop the original & renaming the duplicate
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Query Failed: AND users.id = '1'::MySQL error 1064:
    By artco001 in forum Installation and Upgrade Help
    Replies: 63
    Last Post: 2009-05-07, 05:56 AM
  2. Replies: 5
    Last Post: 2007-11-13, 02:51 PM
  3. MySQL Database Not Available
    By luisamato in forum Help
    Replies: 4
    Last Post: 2007-06-27, 05:58 AM
  4. Huge backups -- normal?
    By Liam in forum Help
    Replies: 5
    Last Post: 2007-05-02, 05:36 AM
  5. MySQL error/no workflow notifications
    By rlbyrd in forum Help
    Replies: 1
    Last Post: 2006-09-11, 09:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •