Page 1 of 2
Phoca Gallery installation errors
Posted: 31 Jan 2009, 20:02
by 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?
Re: Phoca Gallery installation errors
Posted: 31 Jan 2009, 20:14
by amonserrano
Re: Phoca Gallery installation errors
Posted: 01 Feb 2009, 00:38
by 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?)
Re: Phoca Gallery installation errors
Posted: 01 Feb 2009, 15:00
by 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
Re: Phoca Gallery installation errors
Posted: 01 Feb 2009, 23:11
by 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?
Re: Phoca Gallery installation errors
Posted: 02 Feb 2009, 18:43
by caro84g
Yes you should copy paste them
Regards, Carolien
Re: Phoca Gallery installation errors
Posted: 11 Feb 2009, 23:28
by 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?
Re: Phoca Gallery installation errors
Posted: 12 Feb 2009, 10:33
by 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
Re: Phoca Gallery installation errors
Posted: 13 Feb 2009, 21:17
by 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.
Re: Phoca Gallery installation errors
Posted: 14 Feb 2009, 00:00
by 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.
