Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
Did you know that
Elxis 5.x
uses HTML5, CSS3 and pure javascript without external libraries such as jQuery?
Home
Help
Login
Register
Elxis CMS Forum
»
Support
»
Database
»
Problem with MYSQL (SOLVED)
« previous
next »
Print
Pages: [
1
]
Author
Topic: Problem with MYSQL (SOLVED) (Read 7606 times)
mmarch
Full Member
Posts: 194
Problem with MYSQL (SOLVED)
«
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?
«
Last Edit: June 27, 2007, 23:11:59 by mmarch
»
Logged
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Problem with MYSQL
«
Reply #1 on:
June 27, 2007, 22: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
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
mmarch
Full Member
Posts: 194
Re: Problem with MYSQL
«
Reply #2 on:
June 27, 2007, 23:11:36 »
Ok Many thank's
Logged
Print
Pages: [
1
]
« previous
next »
Elxis CMS Forum
»
Support
»
Database
»
Problem with MYSQL (SOLVED)