Need help asap!

Discussion in 'Troubleshooting' started by riskymedia, Jul 29, 2011.

  1. riskymedia

    riskymedia New Member

    Joined:
    Aug 7, 2010
    Messages:
    15
    When in the admin searching for phone (which was setup as an additional field), I'm getting the following errors:

    WARNING: mysql_query() [function.mysql-query]: Unable to save result set in line 3178 of file mysql.inc.php

    MYSQL Error happened, script stopped. Website admin can find more details about the problem at CP -> Error Log

    In the actual error logs I see the following:

    <b>WARNING:</b> mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set
    in line 3178 of file /home/sitename/public_html/join/plugins/db/mysql/mysql.inc.php

    Per another thread I tried repairing the tables but it didn't help. This just started happening and nothing was changed to have caused this error to start appearing. Any ideas?
  2. riskymedia

    riskymedia New Member

    Joined:
    Aug 7, 2010
    Messages:
    15
    Also, I have 2 instances of amember running on the same dedicated box (2 different sites), and the other one works fine when searching for this same additional field. So at first I thought maybe it was related to the server, but I don't believe this to be the case.

    Any thoughts are greatly appreciated!
  3. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    This error usually mean that there is a problem with database.
    Try to repair all tables within your amember database

Share This Page