Elxis CMS Forum
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Download Elxis CMS: Elxis 4.0 Nautilus
 
Pages: [1]
  Print  
Author Topic: Problem with MYSQL (SOLVED)  (Read 2782 times)
mmarch
Full Member
***
Offline Offline

Posts: 194


« on: June 27, 2007, 20: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?Huh
« Last Edit: June 27, 2007, 22:11:59 by mmarch » Logged
datahell
Elxis Team
Hero Member
*****
Offline Offline

Posts: 7601



WWW
« Reply #1 on: June 27, 2007, 21:07:37 »

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(*) ..."
Logged

mmarch
Full Member
***
Offline Offline

Posts: 194


« Reply #2 on: June 27, 2007, 22:11:36 »

Ok Many thank's
Logged
Pages: [1]
  Print  
 
Jump to: