Page 1 of 1

Problem with Creating Categories After installation

Posted: 19 May 2014, 20:04
by 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

Re: Problem with Creating Categories After installation

Posted: 19 May 2014, 23:54
by 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

Re: Problem with Creating Categories After installation

Posted: 20 May 2014, 08:42
by 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

Re: Problem with Creating Categories After installation

Posted: 21 May 2014, 22:16
by mfan
Hi,
Can you advise PC OS requirements for Phoca compoents/modules? Thanks. - Diana

Re: Problem with Creating Categories After installation

Posted: 23 May 2014, 00:13
by 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 :idea:

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