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................"
Still problem after create queries manually
-
sutcocuk
- Phoca Newbie

- Posts: 1
- Joined: 03 Feb 2011, 13:26
- Jan
- Phoca Hero

- Posts: 49297
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Still problem after create queries manually
Hi,
Jan
means, that the table phocagallery_votes still not exists in your database, so seems not all tables were pasted to the database.Table 'demir_joom1.joom_phocagallery_votes' doesn't exist
Jan
If you find Phoca extensions useful, please support the project