Category Error

[Jan]

Hi, enable debug mode to see more information about the error, seems like there is a problem with loading data from database.

See:
https://www.phoca.cz/documents/16-joomla ... rs-on-site

https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan

[slighted]

Hello,

after updating the phocagallery to version 2.7.5 there is no content (pictures) shown on my website anymore, it's just blank. the backend works well and all the pictures are there, but I cant access the category section of phocagallery. it tells me "Count of not authorized category(ies) in the gallery: 20" ... so I enabled debug mode and got a message I cant make any sense of. Can someone pls tell me what to do so my pictures are shown again? Thanks!

Error message I get after enabling debug mode when clicking on categories in the phocagallery backend:

JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.parent_id, count(*) AS countid FROM jos_phocagallery_c SQL=SELECT a.*, cc.title AS parentname, u.name AS editor, g.name AS groupname, v.average AS ratingavg, ua.username AS usercatname, c.countid AS countid FROM jos_phocagallery_categories AS a LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_groups AS g ON g.id = a.access LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = a.parent_id LEFT JOIN jos_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN jos_users AS ua ON ua.id = a.owner_id JOIN (SELECT c.parent_id, count(*) AS countid FROM jos_phocagallery_categories AS c GROUP BY c.parent_id ) AS c ON a.parent_id = c.parent_id WHERE a.published = 1 ORDER BY a.ordering

Call stack
# Function Location
1 jadministrator->dispatch() /homepages/34/d242649096/htdocs/administrator/index.php:67
2 jcomponenthelper::rendercomponent() /homepages/34/d242649096/htdocs/administrator/includes/application.php:136
3 require_once() /homepages/34/d242649096/htdocs/libraries/joomla/application/component/helper.php:162
4 phocagallerycpcontroller->execute() /homepages/34/d242649096/htdocs/administrator/components/com_phocagallery/admin.phocagallery.php:40
5 phocagallerycpcontroller->display() /homepages/34/d242649096/htdocs/libraries/joomla/application/component/controller.php:236
6 jcontroller::display() /homepages/34/d242649096/htdocs/administrator/components/com_phocagallery/controller.php:148
7 phocagallerycpviewphocagallerycs->display() /homepages/34/d242649096/htdocs/libraries/joomla/application/component/controller.php:310
8 phocagallerycpviewphocagallerycs->get() /homepages/34/d242649096/htdocs/administrator/components/com_phocagallery/views/phocagallerycs/view.html.php:36
9 phocagallerycpmodelphocagallerycs->getdata() /homepages/34/d242649096/htdocs/libraries/joomla/application/component/view.php:364
10 phocagallerycpmodelphocagallerycs->_getlist() /homepages/34/d242649096/htdocs/administrator/components/com_phocagallery/models/phocagallerycs.php:42
11 jdatabasemysql->loadobjectlist() /homepages/34/d242649096/htdocs/libraries/joomla/application/component/model.php:284
12 jdatabasemysql->query() /homepages/34/d242649096/htdocs/libraries/joomla/database/database/mysql.php:458
13 jerror::raiseerror() /homepages/34/d242649096/htdocs/libraries/joomla/database/database/mysql.php:231
14 jerror::raise() /homepages/34/d242649096/htdocs/libraries/joomla/error/error.php:171
15 jexception->jobject() /homepages/34/d242649096/htdocs/libraries/joomla/error/error.php:136
16 call_user_func_array() /homepages/34/d242649096/htdocs/libraries/joomla/base/object.php:48
17 jexception->__construct()

[Jan]

Hi, seems like your database is having problems with subset sql queries (on some servers, the upgrading myslq helped )

Jan

[slighted]

thanks for your quick reply.
since the website is hosted at a big company, it is not in my hands if mysql gets updated or not. guess I have to put up the older version of phocagallery again ... bummer.

thanks again though!

[slighted]

can you tell me where I can download a 2.5.x version of phocagallery? cant find it anywhere and I dont have the file on my computer anymore ... thanks!

[slighted]

nevermind, got it.

http://joomlacode.org/gf/project/phocag ... ge_id=3942

[Jan]

ok