Problems with files admin

[gigglemash]

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!

[Jan]

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

[gigglemash]

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!

[Jan]

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

[gigglemash]

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

[gray]

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".

[gigglemash]

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

[gigglemash]

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

[gray]

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.

[gigglemash]

Problem solved. Great. Thanks!