Phoca Forum

Hi

Have had Phoca working on my website for several months now with no problems. Then I came to make one or two alterations yesterday and noticed that in the back end files administration where previously I would have a list of files all I now seem to have is this:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /hermes/bosweb26c/b597/nf.trickleupafricanet/public_html/libraries/joomla/database/database/mysqli.php on line 305

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /hermes/bosweb26c/b597/nf.trickleupafricanet/public_html/libraries/joomla/database/database/mysqli.php on line 305

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /hermes/bosweb26c/b597/nf.trickleupafricanet/public_html/libraries/joomla/database/database/mysqli.php on line 305

I recently upgraded from joomla 1.6 to 1.7 I don't know if this has caused the problem or if just something I have done! I am still able to download the files I have previously put on but I am going to need to use phoca more in the future. I am fairly new to Joomla, Phoca download and webdesign more broadly so any help ideas would be really appreciated!

Website is trickleout.net

Cheers!

Hi, enable debug mode to get information about the database error you get.
https://www.phoca.cz/documents/16-joomla ... rs-on-site
Jan

Hi Jan

Thanks for the reply.

This is a bit more info about the error I am getting

500 - **An error has occurred.**

JDatabaseMySQL::query: 1054 - Unknown column 'a.userid' ...

Thanks for any help!

Hi, the userid column is missing in your database, search this forum, as there are guides to solve it.

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

Hi Jan

Thanks for the info. Hopefully just a final question.

I seem to find two solutions to my problem. One is installing Phoca Download 2.0.0 STABLE. Where would I download a copy of Phoca Download 2.0.0 stable? Or does it mean a clean install of Phoca Download 2.1.1 Stable?

The other solution is posted here viewtopic.php?f=31&t=14956&start=10 and seems to involve me making some changes to my sites SQL database. Have looked at this and may be a stupid question but I cannot seem to find "jos_phocadownload". I can find "jml_phocadownload" are they the same thing? Also struggling to see SQL Command Box?

Cheers for any help.

David

jos_ and jml_ are the table prefixes, set during installation. So, "jos_phocadownload" and "jml_phocadownload" are the same tables, but installed using different prefixes (different installations of Joomla). Use your "jml_phocadownload".

OK thank you for the info. Will see if I can make some progress.

Probably me doing something silly or not doing something but I am now getting the following message:

SQL query:
ALTER TABLE `jml_phocadownload` ADD `userid` int( 11 ) NOT NULL Default '0' AFTER `description` ;
MySQL said:
#1046 - No database selected

Thanks for any advice/info.

David

In phpMyaAdmin, click on the Joomla database, click on 'jml_phocadownload' table. You'll see a SQL link at the top. Click on the link and enter the SQL command. This should resolve the error you reported.

Problem solved. Great. Thanks!