Elxis CMS Forum
Support => Database => Topic started by: mmarch on June 27, 2007, 21:04:09
-
Hi!!!
I instaled today
** Title........: myPMS II
** Description..: A Private Messaging System [PMS] for Mambo 4.5
everything is fine, only 2 error messages disturbing all time.
1. PHP: mysql_num_rows(): supplied argument is not a valid MySQL result resource
uri: index.php?option=com_pms&page=inbox
path: /components/com_pms/pms.php
version: Elxis 2006.4 Stable rev1080 [ Nestor ] 04-December-2006 23:08 GMT+2
WARNING(2): /home/schoolsi/public_html/components/com_pms/inbox.php, line 69
2. PHP: mysql_num_rows(): supplied argument is not a valid MySQL result resource
uri: index.php?option=com_pms&page=inboxYour%20message%20has%20been%20sent.
path: /components/com_pms/pms.php
version: Elxis 2006.4 Stable rev1080 [ Nestor ] 04-December-2006 23:08 GMT+2
WARNING(2): /home/schoolsi/public_html/components/com_pms/inbox.php, line 69
Line 69 in inbox.php
if (mysql_num_rows($result)<1)
How i can fix it????
-
You must not install incompatible components. MyPMS, as far as I know, is NOT compatible with Elxis. Elxis seems the same with mambo/joomla but it's core has huge differences like users access, database, language etc. Uninstall myPMS from Elxis!
Although I will give you a workarround to your problem:
Instead of using mysql_num_rows which is a mysql native function and is incompatible with Elxis you can simply count the rows using php's function "count(...)" or from the database query "SELECT COUNT(*) ..."
-
Ok Many thank's