Page 1 of 1

(resolved) MySQL error

Posted: 01 Dec 2008, 17:22
by ZwaZo
Hello,

I have installed the gallery without problem and batch imported 2500+ images withinn 140 categories.

right during the middle of thumbnails creation, I get now the following error in the "images" backend view and only if I do not select a specific category.

Pagination is not appearing as well.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /libraries/joomla/database/database/mysql.php on line 342


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /libraries/joomla/database/database/mysql.php on line 342


any idea ?

Best regards,

ZwaZo

Re: MySQL error

Posted: 02 Dec 2008, 16:54
by Jan
??? seems like some problem with tables, see them if they are ok, e.g. in phpmyadmin

Jan

Re: (resolved) MySQL error

Posted: 27 Jan 2009, 11:43
by ZwaZo
Hello

I have resolved the problem by reinstalling everything and checking the picture file names.

Apparently some file namings were causing troubles to the system. I have ensured that all the files are getting regular fonts only in their name.

All the library has been imported and thumbnails created perfectly.

note 1 : do not select "all" in the picture list with such an amount of pics as it will return a blank page. (clean the cache and cookies then it's ok again)


note 2 : If there is an " ' " font in the picture title, the overlib effect wil not work for the concerned picture.

cheers,

ZwaZo

Re: (resolved) MySQL error

Posted: 29 Jan 2009, 15:00
by Jan
ok, thank for this information...

Jan