[bad custom templat] Invalid argument supplied for foreach()

masstox
Topic Author
Offline
Junior Member

12 years 3 months ago #41920 by masstox

[bad custom templat] Invalid argument supplied for foreach() was created by masstox

Bonjour,
j'ai une erreur dans la vue catégorie après un transfert d'un site d'un serveur à un autre.
Cette erreur s'affiche pour chaque article dans la vue catégorie en frontend.

Code:

Warning: Invalid argument supplied for foreach() in /homez.370/formaprof/www/components/com_flexicontent/classes/flexicontent.fields.php on line 775

Warning: Invalid argument supplied for foreach() in /homez.370/formaprof/www/components/com_flexicontent/classes/flexicontent.fields.php on line 391
Optimisez l'accueil physique 

Je n'avais pas de problème avant le transfert.

Merci de votre aide.

Cordialement.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 3 months ago #41922 by ggppdk

Replied by ggppdk on topic [bad custom templat] Invalid argument supplied for foreach()

Hello

1. which Joomla version and which FLEXIcontent version do you have?

2. and besides the displayed error, is the item displayed properly?

3. were you installation before or after was inside a subfolder ?

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

masstox
Topic Author
Offline
Junior Member

12 years 3 months ago #41932 by masstox

Replied by masstox on topic [bad custom templat] Invalid argument supplied for foreach()

J'utilise joomla 2.5.14.

Je viens de faire une mise à jour de flexicontent de la version 2.1.0 r1742 vers la version 2.1.1 r1793.

J'ai maintenant cette erreur etla page ne s'affiche pas.

Code:

500 - 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 ') AND value > "" ORDER BY item_id, field_id, valueorder' at line 1 SQL=SELECT field_id, value, item_id FROM hpstl_flexicontent_fields_item_relations WHERE item_id IN () AND value > "" ORDER BY item_id, field_id, valueorder

Vous ne pouvez pas visiter cette page car :

    bookmark/favori périmé
    Un moteur de recherche possède un listing périmé pour ce site
    une adresse erronée
    vous n'avez pas accès à cette page
    La ressource demandée n'a pas été trouvée
    Une erreur est survenue pendant l'exécution de la requête.

Veuillez essayer l'une des pages suivantes :

    Page d'accueil

Si les difficultés persistent, merci de contacter l'administrateur de ce site..

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 ') AND value > "" ORDER BY item_id, field_id, valueorder' at line 1 SQL=SELECT field_id, value, item_id FROM hpstl_flexicontent_fields_item_relations WHERE item_id IN () AND value > "" ORDER BY item_id, field_id, valueorder

Call stack	
#		Function		Location	
1		JSite->dispatch()		/homez.370/formaprof/www/index.php:42	
2		JComponentHelper::renderComponent()		/homez.370/formaprof/www/includes/application.php:197	
3		JComponentHelper::executeComponent()		/homez.370/formaprof/www/libraries/joomla/application/component/helper.php:351	
4		require_once()		/homez.370/formaprof/www/libraries/joomla/application/component/helper.php:383	
5		JController->execute()		/homez.370/formaprof/www/components/com_flexicontent/flexicontent.php:168	
6		FlexicontentController->display()		/homez.370/formaprof/www/libraries/joomla/application/component/controller.php:761	
7		JController->display()		/homez.370/formaprof/www/components/com_flexicontent/controller.php:803	
8		FlexicontentViewCategory->display()		/homez.370/formaprof/www/libraries/joomla/application/component/controller.php:722	
9		JView->display()		/homez.370/formaprof/www/components/com_flexicontent/views/category/view.html.php:694	
10		JView->loadTemplate()		/homez.370/formaprof/www/libraries/joomla/application/component/view.php:205	
11		include()		/homez.370/formaprof/www/libraries/joomla/application/component/view.php:649	
12		JView->loadTemplate()		/homez.370/formaprof/www/components/com_flexicontent/templates/fiche_formation/category.php:23	
13		include()		/homez.370/formaprof/www/libraries/joomla/application/component/view.php:649	
14		JView->loadTemplate()		/homez.370/formaprof/www/components/com_flexicontent/templates/fiche_formation/category_html5.php:95	
15		include()		/homez.370/formaprof/www/libraries/joomla/application/component/view.php:649	
16		FlexicontentFields::getFieldDisplay()		/homez.370/formaprof/www/components/com_flexicontent/templates/fiche_formation/category_items_html5.php:226	
17		FlexicontentFields::getFields()		/homez.370/formaprof/www/components/com_flexicontent/classes/flexicontent.fields.php:381	
18		FlexicontentFields::_getCustomValues()		/homez.370/formaprof/www/components/com_flexicontent/classes/flexicontent.fields.php:207	
19		JDatabase->loadObjectList()		/homez.370/formaprof/www/components/com_flexicontent/classes/flexicontent.fields.php:773	
20		JDatabaseMySQL->execute()		/homez.370/formaprof/www/libraries/joomla/database/database.php:1100	
21		JError::raiseError()		/homez.370/formaprof/www/libraries/joomla/database/database/mysql.php:548	
22		JError::raise()		/homez.370/formaprof/www/libraries/joomla/error/error.php:251

Merci pour votre aide.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 3 months ago #41935 by ggppdk

Replied by ggppdk on topic [bad custom templat] Invalid argument supplied for foreach()

Hello

first please update to
v2.1.1 r1793
or to
v2.1.2 r1806 beta

code.google.com/p/flexicontent/downloads/list

Please Log in or Create an account to join the conversation.

masstox
Topic Author
Offline
Junior Member

12 years 3 months ago #41940 by masstox

Replied by masstox on topic [bad custom templat] Invalid argument supplied for foreach()

La mise à jour est déja faite, la version que j'utilise est 2.1.1 r1793.

La 1ère erreur apparaissait sur la version 2.1.0 r1742.

La 2nd erreur apparait sur la version 2.1.1 r1793, mais je n'ai plus la première erreur.

Cordialement.

Please Log in or Create an account to join the conversation.

masstox
Topic Author
Offline
Junior Member

12 years 3 months ago #41941 by masstox

Replied by masstox on topic [bad custom templat] Invalid argument supplied for foreach()

3. were you installation before or after was inside a subfolder ?

Pour répondre à cette question, l'installation sur le premier serveur de joomla était dans un sous dossier.
Sur ce serveur je n'ai pas d'erreur.

J'ai transféré le site avec akkeba backup sur un 2ème serveur. Sur ce serveur joomla n'est pas dans un sous dossier, Il est directement à la racine.
Ensuite sur le 2ème serveur j'ai fait la mise à jour de Flexicontent 2.1.1 r1793.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 3 months ago #41943 by ggppdk

Replied by ggppdk on topic [bad custom templat] Invalid argument supplied for foreach()

Hello

- have you checked the Joomla folder paths for tmp and logs are correct (Joomla global configuration)?
- are your items listed in backend items manager ?
- is your frontend category view empty or do it show items and gives warning ?

Please answer the above,
and then send me a PM with super admin login, and a link to the frontend category view that show the issue

Regards

Please Log in or Create an account to join the conversation.

masstox
Topic Author
Offline
Junior Member

12 years 3 months ago #41947 by masstox

Replied by masstox on topic [bad custom templat] Invalid argument supplied for foreach()

- have you checked the Joomla folder paths for tmp and logs are correct (Joomla global configuration)?

Oui, ils sont corrects.

- are your items listed in backend items manager ?

Oui

- is your frontend category view empty or do it show items and gives warning ?

Excusez-moi, je viens de me rendre compte que la 2ème erreur s'affiche lorsque j'active le Débogage système de joomla, et la 1ère lorsque le debogage n'est pas activé.

Donc lorsque le debogage n'est pas activé, les items s'affichent et il y a une erreur au dessus de chaque item.

Cordialement.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 3 months ago #41948 by ggppdk

Replied by ggppdk on topic [bad custom templat] Invalid argument supplied for foreach()

Hello

-- inside your custom template code of category view code you had bad code:
(category_items_html5.php)

Code:

<?php echo FlexicontentFields::getFieldDisplay($this->item, 'favourites'); ?>

... but $this->item does not exist in category view you should use what ever you have in your item loop
e.g in your case: $item
(now you can see a NEW extra favoroutes icon has appeared, if you don't want it, then remove the above code from your template)

-- if you have other templates please update them

the error existed in previous server but it was not printed, due to error_reporting level set to none

Regards

Please Log in or Create an account to join the conversation.