mysql_num_rows() error stopping me from getting into Manager.

[01-May-2009 11:39:26] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wynen/public_html/talesunion/manager/actions/welcome.static.php on line 89
[01-May-2009 11:39:26] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wynen/public_html/talesunion/manager/actions/welcome.static.php on line 158
[01-May-2009 11:39:26] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wynen/public_html/talesunion/manager/includes/user_settings.inc.php on line 17
[01-May-2009 11:39:26] PHP Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wynen/public_html/talesunion/manager/includes/user_settings.inc.php on line 19
[01-May-2009 11:39:26] PHP Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wynen/public_html/talesunion/manager/includes/user_settings.inc.php on line 17
[01-May-2009 11:39:26] PHP Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wynen/public_html/talesunion/manager/includes/user_settings.inc.php on line 19

Got this when I logged into the Manager this morning. The odd thing is sometimes it shows that in each of the frames, other times it doesn’t. Once it loads, it *seems* to work fine.

Any idea how I can fix this?

EDIT: It’ll have hanging issues when I’m trying to save content, delete content, etc. I basically can’t work on my site with this issue going on. x_x

Sounds like your host may be having database issues or changed something else in the configuration.

Quote from: OpenGeek at May 01, 2009, 11:14 PM

Sounds like your host may be having database issues or changed something else in the configuration.

They said they upgraded to MySQL 5.1, could that have caused any issues?

EDIT: Is there any issue if the modx_users_settings table doesn’t have a primary key set, and is like this...

http://i44.tinypic.com/4fznrt.png

Quote from: Soshite at May 02, 2009, 12:16 PM

Is there any issue if the modx_users_settings table doesn’t have a primary key set

No. A webuser can have multiple sets of settings + values. The id in this table refers to the webuser-id.
A good indicator if a table field is supposed to be a primary key, is to check if it’s set to auto-increment.

If id was a primary key, this would be illegal:

webuser setting_name setting_value
1 login_home 75
1 allowed_days 2,3,4,5,6

Seems my host finally resolved the issue, so case closed.