Still problem after create queries manually

Phoca Gallery - image gallery extension
sutcocuk
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 03 Feb 2011, 13:26

Still problem after create queries manually

Post by sutcocuk »

I had a problem with installing phoca gallery 1.6.
The next code came "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Then i solved it to create queries manually in the database. But then i still get the error by the control panel

By images i still get: The next code came "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource ......./database/database/mysql.php on line 317

By categoriy rating i still get: "Table 'demir_joom1.joom_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `joom_phocagallery_votes` AS a LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS ua ON ua.id=a.userid LEFT JOIN joom_users AS uc ON uc.id=a.checked_out LEFT JOIN joom_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Table 'demir_joom1.joom_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_titl................"
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49297
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Still problem after create queries manually

Post by Jan »

Hi,
Table 'demir_joom1.joom_phocagallery_votes' doesn't exist
means, that the table phocagallery_votes still not exists in your database, so seems not all tables were pasted to the database.

Jan
If you find Phoca extensions useful, please support the project
Post Reply