Problème d'affichage des contenus FLEXIcontent
13 years 5 months ago #32154
by micker
Replied by micker on topic Problème d'affichage des contenus FLEXIcontent
tu vois y a des erreurs
exemple
gatecameroun.com/index.php/restaurants/r...103-amhorec-traiteur
JDatabaseMySQLi::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 ' cr.rating_count, ((cr.rating_sum / cr.rating_count)*20) as score FROM gt_flexic' at line 1 SQL=SELECT t.access as type_access, t.name as typename, t.alias as typealias, , cr.rating_count, ((cr.rating_sum / cr.rating_count)*20) as score FROM gt_flexicontent_items_ext as ie JOIN gt_flexicontent_types AS t ON t.id = ie.type_id LEFT JOIN gt_content_rating AS cr ON cr.content_id = ie.item_id WHERE ie.item_id=103
Call stack
# Function Location
1 JSite->dispatch() /home/mygate/public_html/index.php:42
2 JComponentHelper::renderComponent() /home/mygate/public_html/includes/application.php:197
3 JComponentHelper::executeComponent() /home/mygate/public_html/libraries/joomla/application/component/helper.php:351
4 require_once() /home/mygate/public_html/libraries/joomla/application/component/helper.php:383
5 JController->execute() /home/mygate/public_html/components/com_flexicontent/flexicontent.php:119
6 FlexicontentController->display() /home/mygate/public_html/libraries/joomla/application/component/controller.php:761
7 JController->display() /home/mygate/public_html/components/com_flexicontent/controller.php:544
8 FlexicontentViewItem->display() /home/mygate/public_html/libraries/joomla/application/component/controller.php:722
9 ParentClassItem->getItem() /home/mygate/public_html/components/com_flexicontent/views/item/view.html.php:112
10 ParentClassItem->_loadItem() /home/mygate/public_html/administrator/components/com_flexicontent/models/parentclassitem.php:230
11 JDatabase->loadObject() /home/mygate/public_html/administrator/components/com_flexicontent/models/parentclassitem.php:752
12 JDatabaseMySQLi->execute() /home/mygate/public_html/libraries/joomla/database/database.php:1062
13 JError::raiseError() /home/mygate/public_html/libraries/joomla/database/database/mysqli.php:396
14 JError::raise() /home/mygate/public_html/libraries/joomla/error/error.php:251
Après je vois un composant de SEF .. desactive pour les tests ...
poste sur le forum de flexicontent pour que l'on puisse mieux t'aider
a+
exemple
gatecameroun.com/index.php/restaurants/r...103-amhorec-traiteur
JDatabaseMySQLi::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 ' cr.rating_count, ((cr.rating_sum / cr.rating_count)*20) as score FROM gt_flexic' at line 1 SQL=SELECT t.access as type_access, t.name as typename, t.alias as typealias, , cr.rating_count, ((cr.rating_sum / cr.rating_count)*20) as score FROM gt_flexicontent_items_ext as ie JOIN gt_flexicontent_types AS t ON t.id = ie.type_id LEFT JOIN gt_content_rating AS cr ON cr.content_id = ie.item_id WHERE ie.item_id=103
Call stack
# Function Location
1 JSite->dispatch() /home/mygate/public_html/index.php:42
2 JComponentHelper::renderComponent() /home/mygate/public_html/includes/application.php:197
3 JComponentHelper::executeComponent() /home/mygate/public_html/libraries/joomla/application/component/helper.php:351
4 require_once() /home/mygate/public_html/libraries/joomla/application/component/helper.php:383
5 JController->execute() /home/mygate/public_html/components/com_flexicontent/flexicontent.php:119
6 FlexicontentController->display() /home/mygate/public_html/libraries/joomla/application/component/controller.php:761
7 JController->display() /home/mygate/public_html/components/com_flexicontent/controller.php:544
8 FlexicontentViewItem->display() /home/mygate/public_html/libraries/joomla/application/component/controller.php:722
9 ParentClassItem->getItem() /home/mygate/public_html/components/com_flexicontent/views/item/view.html.php:112
10 ParentClassItem->_loadItem() /home/mygate/public_html/administrator/components/com_flexicontent/models/parentclassitem.php:230
11 JDatabase->loadObject() /home/mygate/public_html/administrator/components/com_flexicontent/models/parentclassitem.php:752
12 JDatabaseMySQLi->execute() /home/mygate/public_html/libraries/joomla/database/database.php:1062
13 JError::raiseError() /home/mygate/public_html/libraries/joomla/database/database/mysqli.php:396
14 JError::raise() /home/mygate/public_html/libraries/joomla/error/error.php:251
Après je vois un composant de SEF .. desactive pour les tests ...
poste sur le forum de flexicontent pour que l'on puisse mieux t'aider
a+
Please Connectez-vous or Create an account to join the conversation.
13 years 5 months ago #32156
by dakama
Qui possède l'information possède le pouvoir. Elle sauve mais elle tue aussi!
Replied by dakama on topic Problème d'affichage des contenus FLEXIcontent
D'accord, merci pour ton aide micker.
Je vais retourner sur le forum flexicontent.
A+
Crdlt,
Je vais retourner sur le forum flexicontent.
A+
Crdlt,
Qui possède l'information possède le pouvoir. Elle sauve mais elle tue aussi!
Please Connectez-vous or Create an account to join the conversation.
Time to create page: 0.130 seconds