Problem with Creating Categories After installation

[mfan]

Hi,

I just installed Phocagallery on os window 7. After I installed Phoca Gallery and switched to the Phoca Gallery backend to create a category and to add images, there appears error message:

" Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\Website\www\main\libraries\joomla\database\database\mysqli.php on line 263

Warning: Invalid argument supplied for foreach() in C:\Website\www\main\administrator\components\com_phocagallery\libraries\phocagallery\render\renderadmin.php on line 70"

On category rating/comments, images rating/comments, there appeared error message as below:

"500 -
Table 'mfan.rfu6n_phocagallery_comments' doesn't exist ...

I thought the Phocgallery was not properly installed, so I intended to uninstall it from Manage in Extensions Manager of Joomla (version 2.5), the following error message appears:
"Fatal error: Maximum execution time of 30 seconds exceeded in C:\Website\www\main\libraries\joomla\string\string.php on line 399 "

Hence, I could not uninstall it. Please help advise how I can uninstall it so as to reinstall it. Or how I can repair it without the need to uninstall it.

Many thanks,
Diana Fan

[Jan]

Hi,

first - yes it seems like Phoca Gallery was not installed properly as some tables are missing in database.

second - extensions like Phoca Gallery are installed in Joomla! by Extension Manager (com_installer) - so if there is some problem while installing or uninstalling, all this needs to be solved there as in case Phoca Gallery was not installed, it cannot be managed by itself, all the steps which were done (e.g. wrongly, because there are some limits on the server (30 seconds limit - this can be to less for installing large components) needs to be done there.

You can try to do it manually, see:
https://www.phoca.cz/documents/16-joomla ... m-manually

Jan

[mfan]

Hi, Jan,
Thank you for you advice. I've seen the manual uninstallation guide. It happens that I have removed phoca Gallery component successfully after extending the execution time limit in the windows php.ini. Now my queries are:

1. I noticed that Phoca Gallery was installed in Administrator, but not Site, seen at the Joomla! Administrator Directory. And I don't find any Phoca Gallery files in Joomla! database at phpMyAdmin. So I wonder:
2. before I re-install the Phoca Gallery, do I still need to change the current Joomla! prefix to jos_? If yes, how? Could you advise SQL command?

Thanks.
Diana

[mfan]

Hi,
Can you advise PC OS requirements for Phoca compoents/modules? Thanks. - Diana

[Jan]

Hi,

1) really no idea, this should be question on joomla.org forum as Joomla! component com_install is the one who installs the extensions

2) you should use your prefix, which is used in your Joomla!

Requirements - just see Joomla! requirements, there is no specific requirements required, except if you want to install large components in your Joomla!, maybe php memory limit or time limit should be increased.

Jan