Hello, I am installing the Phoca Gallery Extension and I have a MySQL error that is very common with this install. The work around is to change some tables around but MySQL is not my speciality. If this is something you can knock out quickly in phpmyadmin let me know. Here is the workaround. Mostly you get the following system message "Error while Saving Phoca Gallery Categories" or this PHP error message: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource ... while using Phoca Gallery. Getting this system message or php error message is caused by not installed Phoca Gallery tables in the Joomla!. Please take a look at your database (e.g. via phpMyAdmin) to see if the installation script created Phoca Gallery tables correctly. If not, you must create them manually. The SQL queries, which install Phoca Gallery tables into your database, are saved in install.bak file. You will find this file in the Phoca Gallery component ZIP package. If you are installing Phoca Gallery, just copy all SQL queries (except ALTER TABLE ... queries) and run them in e.g. phpMyAdmin. But beware, because the names of tables are prepared for system installation, so they contain '#__' instead of your table prefix, you must rename them, e.g.: #__phocagallery to TablePrefix_phocagallery TablePrefix is the prefix you selected while installing Joomla! 1.5 (it is mostly 'jos_' and it should differentiate the Joomla! tables from other tables used in your database). Make sure that you delete #_ at the start of the line; you only need one _ {underscore}. Do this for all queries.
Ha, not quite. It might work out if I format these tables right. I guess the install didn't create them automatically and now I may have to make them manually but MySQL is definitely not my area.