Warning: mysql_num_rows(): supplied argument is not a valid

[zak_the_man]

Just installed Phoca Download 1.0.6 on Joomla 1.5.8. Installation seemed to be successful. But when I go to the Sections area in the Administrator I get the following error message:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lazerang/public_html/joomlarus/libraries/joomla/database/database/mysql.php on line 342

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lazerang/public_html/joomlarus/libraries/joomla/database/database/mysql.php on line 342

I added a section but it doesn't show up in the list.

If I go to Categories I get the following error messages:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lazerang/public_html/joomlarus/libraries/joomla/database/database/mysql.php on line 342

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lazerang/public_html/joomlarus/libraries/joomla/database/database/mysql.php on line 342

Warning: array_unshift() [function.array-unshift]: The first argument should be an array in /home/lazerang/public_html/joomlarus/administrator/components/com_phocadownload/views/phocadownloadcats/view.html.php on line 72

Warning: Invalid argument supplied for foreach() in /home/lazerang/public_html/joomlarus/libraries/joomla/html/html/select.php on line 68

Installation doesn't seem to have worked or something...

[Jan]

Hi, it seems like tables for Phoca Download were not created by installation, see the following site (it is for Phoca Gallery but it is the same as for Phoca Download):

https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan

[zak_the_man]

Thanks Jan!

That solved the problem. No tables were installed for some reason. Installing them manually and everything is great!

[Jan]

Thank you for such guide, Jan

[johk]

Hi,

I get the same message but only when I try to go to Users. I have added categories and uploade images and documents. I get the same message for both phoca download and gallery.

Code: Select all

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ?:\???\???\libraries\joomla\database\database\mysql.php on line 344

Please see below a screen dump of tables that are installed. When looking at the install.bak file it seems that all the tables are installed.


I am not sure what might be the issue.

The site is hosted on Windows server using IIS (not my choice).

Thanks,
J

[Jan]

Hi, did you enable debug mode to get more info about the database error?

Jan

[Jan]

Ok

[cchrisgates]

I solved this by uninstalling and re-installing. Took about two minutes.

[Acrossart]

i have the same issue. nothing helped me. i tryed the instal.bak stuff and recognised that my "phocadownload" Tables are empty.
can anyone help me?

i am using joomla 1.6.3 and the latetest beta component and plugin versions.

[Jan]

What says the debug mode?