Still problem after create queries manually
Posted: 03 Feb 2011, 13:32
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................"
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................"