Phoca Gallery installation errors

[Manos]

After installing Photo Gallery component and went to "Images" menu, I saw the following errors:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/gameworld.gr/www/libraries/joomla/database/database/mysql.php on line 342

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/gameworld.gr/www/libraries/joomla/database/database/mysql.php on line 342

Warning: Invalid argument supplied for foreach() in /home/gameworld.gr/www/administrator/components/com_phocagallery/helpers/phocagallery.php on line 1244

What should I do?

[amonserrano]

you should read this:

https://www.phoca.cz/documents/2-phoca-g ... em-solving

[Manos]

Ok, then lets confirm.
Should I copy-paste and run the above SQL commands?

DROP TABLE IF EXISTS `#__phocagallery`;
CREATE TABLE `#__phocagallery` (
DROP TABLE IF EXISTS `#__phocagallery_categories`;
CREATE TABLE `#__phocagallery_categories` (
DROP TABLE IF EXISTS `#__phocagallery_votes`;
CREATE TABLE `#__phocagallery_votes` (
DROP TABLE IF EXISTS `#__phocagallery_comments`;
CREATE TABLE `#__phocagallery_comments` (
DROP TABLE IF EXISTS `#__phocagallery_votes_statistics`;
CREATE TABLE `#__phocagallery_votes_statistics` (
DROP TABLE IF EXISTS `#__phocagallery_user_category`;
CREATE TABLE `#__phocagallery_user_category` (

Are these commands correct? (Should I use only these?)

[caro84g]

I guess so.

If you're upgrading from Phoca Gallery 1.x you should only create the last 4 tables.

You could check in your database whether or not these tables exist. If they don't you have to create them. (And you can do that with these queries)

Regards, Carolien

[Manos]

I've looked in phpmyadmin and I think I'm lost. Now I'm looking at my database and I can't see any tables like these. Other applications also don't have their tables shown up here. I can only see joomla tables like jos_banner , jos_bannerclient etc.

Please help me. Should I copy-paste all these commands?

[caro84g]

Yes you should copy paste them

Regards, Carolien

[Manos]

Something else. I've been told that I might have problems installing your application cos I have Joomla Legacy 1.0 and not Native Mode.

Of course I have 1.5.8 so it's a good version.

Am I going to have problems or what?

[caro84g]

Hi,

I don't know. You could test it on a localhost of course. By the way, there is a Joomla! 1.5.9 released.

Regards, Carolien

[Manos]

I got these errors when I typed the second command
( CREATE TABLE `#__phocagallery` ( )

Take a look on where I've typed the command. I've typed it on the root directory in phpmyadmin.

[caro84g]

I'm sorry, I forgot something: instead of the #_ you should type the table prefix. You can find this in your global site settings. in my case that's jos - so then it's jos_phocagallery etc.

Regards, Carolien

P.S. it also says that in the article.