Error sorting by Categories by Parent Category

WARit · Post by **WARit** » 03 Feb 2008, 13:22

Hello, I have two main problems (phocagallery 1.3.2).
The first is that letting phocagallery autocreating the categories and it's nesting doesn't display them into the category section.
On top of that If I try to sort them by Parent Category, I'm getting this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/vhosts/www.xxxx.com/www/war/2/libraries/joomla ... /mysql.php on line 337 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/vhosts/www.xxxx.com/www/war/2/libraries/joomla ... /mysql.php on line 337

WARit · Post by **WARit** » 03 Feb 2008, 13:27

More:

Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: Invalid argument supplied for foreach() in /srv/vhosts/www.xxxxx.com/www/war/2/administrator/c ... ry/models/ phocagallerycs.php on line 63 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/vhosts/www.xxxxx.com/www/war/2/libraries/jooml ... /mysql.php on line 337 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/vhosts/www.xxxxx.com/www/war/2/libraries/jooml ... /mysql.php on line 337

Post by **Jan** » 03 Feb 2008, 20:08

Did you take a look at your database if Joomla have created the Phoca Gallery tables. See: https://www.phoca.cz/phocagallery/user-manual/

WARit · Post by **WARit** » 04 Feb 2008, 02:02

Yes it has been created, after unistalling and reinstalling it, solved the first problem (now categories are displayed correctly) but I still getting those error's while sorting by ID.

Post by **Jan** » 04 Feb 2008, 14:09

I did some changes with sorting in Phoca Guestbook and I will do the same changes in Phoca Gallery. I will let you know if they are ready. Maybe it will help...

Jan

Post by **Jan** » 04 Feb 2008, 22:00

There is new version. Fixed some problems with ordering. Please try version 1.3.3