Page 1 of 2
Back-end : error with access images
Posted: 10 Apr 2009, 20:47
by 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...
Re: Back-end : error with access images
Posted: 10 Apr 2009, 21:04
by Quarterhorse
Re: Back-end : error with access images
Posted: 10 Apr 2009, 21:25
by 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.
Re: Back-end : error with access images
Posted: 10 Apr 2009, 22:58
by 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
Re: Back-end : error with access images
Posted: 10 Apr 2009, 23:37
by bouh
I installed two plugins last week : lazybackup and submitmailer.
I desinstall them but without success fo my problem.
Re: Back-end : error with access images
Posted: 11 Apr 2009, 23:47
by Quarterhorse
bouh wrote:I installed two plugins last week : lazybackup and submitmailer
you have no backup made previously?
Re: Back-end : error with access images
Posted: 12 Apr 2009, 17:08
by bouh
I have back-ups but it doesn't solve my problem.
The plugins are not responsible of the error...
Re: Back-end : error with access images
Posted: 13 Apr 2009, 17:46
by 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
Re: Back-end : error with access images
Posted: 14 Apr 2009, 21:16
by Quarterhorse
I do not know how I could solve your problem.
at your place would I get a new test environment setup
Re: Back-end : error with access images
Posted: 16 Apr 2009, 16:05
by 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