Phoca Forum

Hi, I installed some months ago phocagallery but I never used it. Yesterday I wanted to upload it because now I need it, so I choose to remove the old component from joomla and checked if tables or folders remained in the mysql database or in the ftp. Then I installed the new phocagallery component but I receive an error during the process. Then when I check in joomla I can see phocagallery in the components menu, but a lot of errors appears, for example when i click on "images":

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.xxxxxxxxxxxx/home/libraries/joomla/ ... /mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.xxxxxxxxxxxxxx/home/libraries/jooml ... /mysql.php on line 344

Warning: Invalid argument supplied for foreach() in /web/htdocs/xxxxxxxxxxxxxxxxxxxxxxxx/home/administrator/components/com_phocagallery/libraries/phocagallery/render/renderadmin.php on line 65

And, more, I cannot find phoca tables in the mysql database, this sounds strange for me.

So I tried this solution (https://www.phoca.cz/documents/2-phoca-g ... em-solving) but again it doesn't work. If I paste the code in phpmyadmin I get:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `jos_phocagallery` ( `id` int(11) unsigned NOT NULL auto_increme' at line 2

I don't know nothing of these things. To conclude, if I remove the component I cannot access my entire website.
Thank you for the help

Hi, try to enable error reporting.
https://www.phoca.cz/documents/16-joomla ... rs-on-site

Did you see this:
https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan

Yes I tried that solution, I forgot to write the link in the previous message.
I didn't forget to replace all the # with jos_
When I tried to paste the code from install.bak I got that message.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `jos_phocagallery` ( `id` int(11) unsigned NOT NULL auto_increme' at line 2

I'll try to enable the error reporting and let you know. Thank you

I've got the same mess here.

After running the same query (the right way I'm sure) I als get:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `jos_phocagallery` ( `id` int(11) unsigned NOT NULL auto_increme' at line 2

Was there any resolution in your case? Otherwise I'm reopening this discussion.

Thanks in advance!

Stan

Hi, really not idea what can be wrong there, I am trying it now and have added the sql into the database without any problem (only changing the #__ to jos_) ???

Which version of mysql you are running?

Somebody help me please, coz it start to make me crazy . I try to install Phocagallery on my website (I use Joomla 1.5.22), but it gives me error all the time
"Fatal error: Maximum execution time of 30 seconds exceeded in D:\Hosting\7137062\html\libraries\joomla\utilities\simplexml.php on line 177". What should I do to solve it?

Hi, seems like you have some memory problem on your site and Joomla! is not able to install large component.

Try to use ftp installtion method:
https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan