Back-end : error with access images

[bouh]

hello,

In back-end when I try to acess to images, I have this error message :

* Error Loading ModulesMySQL server has gone away SQL=SELECT DISTINCTROW m.id, m.title, m.module, m.position, m.content, m.showtitle, m.control, m.params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_gmacl AS gm ON m.id = gm.axo AND gm.aco = "read" AND gm.axosection = "module" WHERE m.published = 1 AND (gm.aro IN ( 0,1 ) OR m.access <= 2 OR m.client_id = 1) AND m.client_id = 1 ORDER BY position, ordering


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/51b55e69966d0be56bb1c1c1de7ca397/web/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/51b55e69966d0be56bb1c1c1de7ca397/web/libraries/joomla/database/database/mysql.php on line 344

Warning: Invalid argument supplied for foreach() in /home/www/51b55e69966d0be56bb1c1c1de7ca397/web/administrator/components/com_phocagallery/helpers/phocagallery.php on line 1199

I see my images but not the top buttons ("Multiple adds" for instance).
It doesn't work for one week, before it was perfect.
I tried to upgrade (2.2.3) and I have the same message.
I have "yes" for "Pagination Thumbmails".
I have about 10000 images.

If you have any idea, please...

[Quarterhorse]

hi
see the following site:
Warning: mysql_num_rows():
https://www.phoca.cz/documents/2-phoca-g ... em-solving

[bouh]

Thanks but it doesn't solve my problem
I have already the 6 tables and the colums extlink1 and extlink2 in "phocagallery" table.

Another idea ?

All images are currently fine on my website but I can't add new images with this problem.

[caro84g]

Did you install something else, or changed something in your database table?

If I read the warning correctly, then it doesn't connect to the mysql database, and it has something to do with modules. The modules mentioned in the error message are no Phoca Gallery modules

Regards, Carolien

[bouh]

I installed two plugins last week : lazybackup and submitmailer.
I desinstall them but without success fo my problem.

[Quarterhorse]

I installed two plugins last week : lazybackup and submitmailer

you have no backup made previously?

[bouh]

I have back-ups but it doesn't solve my problem.
The plugins are not responsible of the error...

[bouh]

Has somebody just a small idea ?
Can it help to reinstall joomla and phocagallery ?
Is there a possibility to add images without using the back end ?

Thanks

[Quarterhorse]

I do not know how I could solve your problem.
at your place would I get a new test environment setup

[anthonytl]

I have a similar problem, slightly different line numbers:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/l/a/u/laundrie/html/cvtg/libraries/joomla/database/database/mysql.php on line 342

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/l/a/u/laundrie/html/cvtg/libraries/joomla/database/database/mysql.php on line 342

Warning: Invalid argument supplied for foreach() in /home/content/l/a/u/laundrie/html/cvtg/administrator/components/com_phocagallery/helpers/phocagallery.php on line 1244

My SQL tables look OK. The admin component was working fine last week. The only thing I've done is add hundreds of more images. Is some database access timing out because of too many images? My front end component works fine (although it sure takes a while to load my categories list). http://cvtg.org/index.php?option=com_ph ... &Itemid=84