[RÉSOLU] Site inaccessible (Page 1) / Utilisation / Thelia 2

Announcement

Rejoignez la communauté sur le Discord Thelia : https://discord.gg/YgwpYEE3y3

iSkean
Membre

Registered: 21-07-2008
Posts: 174
Istres
Website

Offline

#1 [RÉSOLU] Site inaccessible

(30-09-2014 15:41:58)

Bonjour,

J'ai voulu supprimer le module Paypal qui été activé, depuis le back office. Ça n'a pas marché, ça a simplement rechargé la page mais vide, et depuis toutes les pages de mon site affichent une page blanche...

Dans les logs, voici ce que j'ai:

1: ERROR [ModuleController.php:deleteAction()] {271} 2014-09-30 16:31:57: Error during module removal
2: ERROR [ModuleController.php:deleteAction()] {271} 2014-09-30 16:31:57: Propel\Runtime\ActiveQuery\ModelCriteria::delete is unable to delete. 
#0 /home3/iskean/public_html/GeneaPrint/store/core/lib/Thelia/Model/Base/ModuleQuery.php(1282): Propel\Runtime\ActiveQuery\ModelCriteria->delete(Object(Propel\Runtime\Connection\ConnectionWrapper))
#1 /home3/iskean/public_html/GeneaPrint/store/core/lib/Thelia/Model/Base/Module.php(977): Thelia\Model\Base\ModuleQuery->delete(Object(Propel\Runtime\Connection\ConnectionWrapper))
#2 /home3/iskean/public_html/GeneaPrint/store/core/lib/Thelia/Action/Module.php(106): Thelia\Model\Base\Module->delete(Object(Propel\Runtime\Connection\ConnectionWrapper))
#3 [internal function]: Thelia\Action\Module->delete(Object(Thelia\Core\Event\Module\ModuleDeleteEvent))
#4 /home3/iskean/public_html/GeneaPrint/store/core/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php(164): call_user_func(Array, Object(Thelia\Core\Event\Module\ModuleDeleteEvent))
#5 /home3/iskean/public_html/GeneaPrint/store/core/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php(53): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch(Array, 'thelia.module.d...', Object(Thelia\Core\Event\Module\ModuleDeleteEvent))
#6 /home3/iskean/public_html/GeneaPrint/store/core/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php(167): Symfony\Component\EventDispatcher\EventDispatcher->dispatch('thelia.module.d...', Object(Thelia\Core\Event\Module\ModuleDeleteEvent))
#7 /home3/iskean/public_html/GeneaPrint/store/core/lib/Thelia/Controller/BaseController.php(95): Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('thelia.module.d...', Object(Thelia\Core\Event\Module\ModuleDeleteEvent))
#8 /home3/iskean/public_html/GeneaPrint/store/core/lib/Thelia/Controller/Admin/ModuleController.php(261): Thelia\Controller\BaseController->dispatch('thelia.module.d...', Object(Thelia\Core\Event\Module\ModuleDeleteEvent))
#9 [internal function]: Thelia\Controller\Admin\ModuleController->deleteAction()
#10 /home3/iskean/public_html/GeneaPrint/store/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php(129): call_user_func_array(Array, Array)
#11 /home3/iskean/public_html/GeneaPrint/store/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php(73): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Thelia\Core\HttpFoundation\Request), 1)
#12 /home3/iskean/public_html/GeneaPrint/store/core/lib/Thelia/Core/TheliaHttpKernel.php(82): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Thelia\Core\HttpFoundation\Request), 1, true)
#13 /home3/iskean/public_html/GeneaPrint/store/core/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/Kernel.php(197): Thelia\Core\TheliaHttpKernel->handle(Object(Thelia\Core\HttpFoundation\Request), 1, true)
#14 /home3/iskean/public_html/GeneaPrint/store/web/index.php(26): Symfony\Component\HttpKernel\Kernel->handle(Object(Thelia\Core\HttpFoundation\Request))
#15 {main}

Une idée d'où cela pourrait venir?

Last edited by iSkean (30-09-2014 21:09:59)

boyquotes
Membre

Registered: 19-03-2010
Posts: 232
Montpellier
Website

Offline

#2 Re: [RÉSOLU] Site inaccessible

(30-09-2014 15:58:53)

Bonjour,

Dans un premier temps, passer par la ligne de commande pour désactiver ce module si tu le peux:
php Thelia module:deactivate NomDuModule

Ou par la base de donnée:
Table module, mettre à 0 le champs 'actif' du plugin à effacer.

La page blanche ne devrait plus apparaître maintenant.

Ensuite virer le répertoire depuis l'explorateur ou ligne de commande.

Cela ressemble à un bug sinon, peut-être ouvrir une issue si elle n'existe pas déjà ici avec version précise utilisé de thélia:
https://github.com/thelia/thelia/issues

Merci.

Linux-live-cd.org
Serveur Linux / Thélia 1.5.x.x / Thélia 2.x.x
PHP 5.4.x / Mysql 5.5.x
Compte Twitter

iSkean
Membre

Registered: 21-07-2008
Posts: 174
Istres
Website

Offline

#3 Re: [RÉSOLU] Site inaccessible

(30-09-2014 16:17:27)

J'ai désactivé le module via la BDD mais le site continu à afficher une page blanche.

Dans l'explorateur, le module Paypal n'y est plus. Il a donc bien été supprimé comme demandé, mais comme je l'ai supprimé avant de l'installer, je pense que ça a dû créer un conflit.

L'erreur est sur un site en ligne, pas en production donc je ne suis pas rassuré... Si vous avez d'autres idées, je suis preneur!

Pour Github, obligé de mettre l'issue en anglais?

iSkean
Membre

Registered: 21-07-2008
Posts: 174
Istres
Website

Offline

#4 Re: [RÉSOLU] Site inaccessible

(30-09-2014 16:21:27)

Par ailleurs, dans PhpMyAdmin, si je veux supprimer le module j'obtiens ce message d'erreur :

Requête SQL :

DELETE FROM `gp`.`module` WHERE `module`.`id` = 7

MySQL a répondu: 
#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`gp`.`order`, CONSTRAINT `fk_order_payment_module_id` FOREIGN KEY (`payment_module_id`) REFERENCES `module` (`id`))

boyquotes
Membre

Registered: 19-03-2010
Posts: 232
Montpellier
Website

Offline

#5 Re: [RÉSOLU] Site inaccessible

(30-09-2014 16:46:18)

iSkean wrote:

J'ai désactivé le module via la BDD mais le site continu à afficher une page blanche.

Le message d'erreur dans les logs sont le même?

iSkean wrote:

Pour Github, obligé de mettre l'issue en anglais?

Passe par translate.google.com pour avoir un message court et direct sur le problème, avec un lien vers ce post, reste à voir s'il ne faut pas mettre l'issu dans le github du module paypal...

Peut être vider le cache(si pas déjà fait) en ligne de commande ou par explorateur...

Linux-live-cd.org
Serveur Linux / Thélia 1.5.x.x / Thélia 2.x.x
PHP 5.4.x / Mysql 5.5.x
Compte Twitter

iSkean
Membre

Registered: 21-07-2008
Posts: 174
Istres
Website

Offline

#6 Re: [RÉSOLU] Site inaccessible

(30-09-2014 17:20:32)

Non effectivement les logs ont changés (c'est très long) :

1: INFO [ConnectionWrapper.php:log()] {653} 2014-09-30 17:34:59: SELECT module.ID, module.CODE, module.TYPE, module.ACTIVATE, module.POSITION, module.FULL_NAMESPACE, module.CREATED_AT, module.UPDATED_AT FROM `module` WHERE module.ACTIVATE=1 ORDER BY module.POSITION ASC
2: INFO [ConnectionWrapper.php:log()] {653} 2014-09-30 17:34:59: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='active-front-template' LIMIT 1
3: INFO [ConnectionWrapper.php:log()] {653} 2014-09-30 17:34:59: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='active-admin-template' LIMIT 1
4: INFO [ConnectionWrapper.php:log()] {653} 2014-09-30 17:34:59: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='active-pdf-template' LIMIT 1
5: INFO [ConnectionWrapper.php:log()] {653} 2014-09-30 17:34:59: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='active-mail-template' LIMIT 1
6: WARNING [Thelia.php:loadTranslation()] {284} 2014-09-30 17:34:59: loadTranslation: missing /home3/iskean/public_html/GeneaPrint/store/local/modules/TheliaDebugBar/I18n/backOffice/default directory
7: WARNING [Thelia.php:loadTranslation()] {284} 2014-09-30 17:34:59: loadTranslation: missing /home3/iskean/public_html/GeneaPrint/store/local/modules/Tinymce/I18n/backOffice/default directory
8: WARNING [Thelia.php:loadTranslation()] {284} 2014-09-30 17:34:59: loadTranslation: missing /home3/iskean/public_html/GeneaPrint/store/local/modules/ImportT1/I18n/backOffice/default directory
9: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='session_config.save_path' LIMIT 1 (0ms)
10: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='one_domain_foreach_lang' LIMIT 1 (0ms)
11: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT lang.ID, lang.TITLE, lang.CODE, lang.LOCALE, lang.URL, lang.DATE_FORMAT, lang.TIME_FORMAT, lang.DATETIME_FORMAT, lang.DECIMAL_SEPARATOR, lang.THOUSANDS_SEPARATOR, lang.DECIMALS, lang.BY_DEFAULT, lang.POSITION, lang.CREATED_AT, lang.UPDATED_AT FROM `lang` WHERE lang.BY_DEFAULT=1 LIMIT 1 (0ms)
12: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT currency.ID, currency.CODE, currency.SYMBOL, currency.RATE, currency.POSITION, currency.BY_DEFAULT, currency.CREATED_AT, currency.UPDATED_AT FROM `currency` WHERE currency.BY_DEFAULT=1 LIMIT 1 (0ms)
13: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='rewriting_enable' LIMIT 1 (0ms)
14: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT rewriting_argument.REWRITING_URL_ID, rewriting_argument.PARAMETER, rewriting_argument.VALUE, rewriting_argument.CREATED_AT, rewriting_argument.UPDATED_AT, `ru`.URL AS ru_url, `ru`.VIEW AS ru_view, `ru`.VIEW_LOCALE AS ru_locale, `ru`.VIEW_ID AS ru_viewId, `is_redirected`.URL AS ru_redirected_to_url FROM `rewriting_argument` RIGHT JOIN `rewriting_url` `ru` ON (rewriting_argument.REWRITING_URL_ID=ru.ID) LEFT JOIN `rewriting_url` `is_redirected` ON (ru.REDIRECTED=is_redirected.ID) WHERE `ru`.URL = '' (0ms)
15: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT rewriting_url.ID, rewriting_url.URL, rewriting_url.VIEW, rewriting_url.VIEW_ID, rewriting_url.VIEW_LOCALE, rewriting_url.REDIRECTED, rewriting_url.CREATED_AT, rewriting_url.UPDATED_AT FROM `rewriting_url` LEFT JOIN `rewriting_argument` `ra` ON (rewriting_url.ID=ra.REWRITING_URL_ID) WHERE ISNULL(`ra`.REWRITING_URL_ID) AND rewriting_url.VIEW='index' AND rewriting_url.VIEW_LOCALE IS NULL  AND rewriting_url.VIEW_ID IS NULL  AND rewriting_url.REDIRECTED IS NULL  ORDER BY rewriting_url.ID DESC LIMIT 1 (0ms)
16: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='asset_dir_from_web_root' LIMIT 1 (0ms)
17: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_name' LIMIT 1 (0ms)
18: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/css/c58deec.css
19: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='process_assets' LIMIT 1 (0ms)
20: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/9780c83.ico
21: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/0d71af7.png
22: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='form.secret' LIMIT 1 (0ms)
23: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT country.ID, country.AREA_ID, country.ISOCODE, country.ISOALPHA2, country.ISOALPHA3, country.BY_DEFAULT, country.SHOP_COUNTRY, country.CREATED_AT, country.UPDATED_AT FROM `country` WHERE country.BY_DEFAULT=1 LIMIT 1 (0ms)
24: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='cart.session_only' LIMIT 1 (0ms)
25: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: Begin transaction (0ms)
26: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: INSERT INTO `cart` (`ID`, `TOKEN`, `CURRENCY_ID`, `CREATED_AT`, `UPDATED_AT`) VALUES (NULL, '542acda4644399.63738241', 1, '2014-09-30 17:35:00', '2014-09-30 17:35:00') (0ms)
27: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: Commit transaction (0ms)
28: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT cart_item.ID, cart_item.CART_ID, cart_item.PRODUCT_ID, cart_item.QUANTITY, cart_item.PRODUCT_SALE_ELEMENTS_ID, cart_item.PRICE, cart_item.PROMO_PRICE, cart_item.PRICE_END_OF_LIFE, cart_item.PROMO, cart_item.CREATED_AT, cart_item.UPDATED_AT FROM `cart_item` WHERE cart_item.CART_ID=72 (0ms)
29: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='default_lang_without_translation' LIMIT 1 (0ms)
30: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT currency.ID, currency.CODE, currency.SYMBOL, currency.RATE, currency.POSITION, currency.BY_DEFAULT, currency.CREATED_AT, currency.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`NAME` ELSE `default_locale_i18n`.`NAME` END AS i18n_NAME FROM `currency` LEFT JOIN `currency_i18n` `default_locale_i18n` ON (currency.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `currency_i18n` `requested_locale_i18n` ON (currency.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE currency.ID=1 LIMIT 1 (0ms)
31: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/8fe7356.png
32: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT lang.ID, lang.TITLE, lang.CODE, lang.LOCALE, lang.URL, lang.DATE_FORMAT, lang.TIME_FORMAT, lang.DATETIME_FORMAT, lang.DECIMAL_SEPARATOR, lang.THOUSANDS_SEPARATOR, lang.DECIMALS, lang.BY_DEFAULT, lang.POSITION, lang.CREATED_AT, lang.UPDATED_AT FROM `lang` WHERE lang.ID NOT IN ('1') ORDER BY lang.POSITION ASC LIMIT 9223372036854775807 (0ms)
33: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT currency.ID, currency.CODE, currency.SYMBOL, currency.RATE, currency.POSITION, currency.BY_DEFAULT, currency.CREATED_AT, currency.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`NAME` ELSE `default_locale_i18n`.`NAME` END AS i18n_NAME FROM `currency` LEFT JOIN `currency_i18n` `default_locale_i18n` ON (currency.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `currency_i18n` `requested_locale_i18n` ON (currency.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND currency.ID NOT IN ('1') ORDER BY currency.POSITION ASC LIMIT 9223372036854775807 (0ms)
34: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/carousel/2a280d6.jpg
35: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/carousel/3424b50.jpg
36: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT currency.ID, currency.CODE, currency.SYMBOL, currency.RATE, currency.POSITION, currency.BY_DEFAULT, currency.CREATED_AT, currency.UPDATED_AT FROM `currency` WHERE currency.BY_DEFAULT=1 LIMIT 1 (0ms)
37: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT COUNT(*) FROM (SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY, ROUND(CASE WHEN `pse`.PROMO=1 THEN `price`.PROMO_PRICE ELSE `price`.PRICE END, 2) AS real_price, `price`.PRICE AS price, `price`.PROMO_PRICE AS promo_price, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_TITLE` ELSE `default_locale_i18n`.`META_TITLE` END AS i18n_META_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_DESCRIPTION` ELSE `default_locale_i18n`.`META_DESCRIPTION` END AS i18n_META_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_KEYWORDS` ELSE `default_locale_i18n`.`META_KEYWORDS` END AS i18n_META_KEYWORDS, `pse`.ID AS pse_id, `pse`.NEWNESS AS is_new, `pse`.PROMO AS is_promo, `pse`.QUANTITY AS quantity, `pse`.WEIGHT AS weight, `pse`.EAN_CODE AS ean_code FROM `product` INNER JOIN `product_sale_elements` `pse` ON (product.ID=pse.PRODUCT_ID AND `pse`.IS_DEFAULT=1) LEFT JOIN `product_price` `price` ON (pse.ID=price.PRODUCT_SALE_ELEMENTS_ID AND `price`.`currency_id` = 1) LEFT JOIN `product_i18n` `default_locale_i18n` ON (product.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `product_i18n` `requested_locale_i18n` ON (product.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND product.VISIBLE=1 GROUP BY product.ID) propelmatch4cnt (0ms)
38: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT currency.ID, currency.CODE, currency.SYMBOL, currency.RATE, currency.POSITION, currency.BY_DEFAULT, currency.CREATED_AT, currency.UPDATED_AT FROM `currency` WHERE currency.BY_DEFAULT=1 LIMIT 1 (0ms)
39: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY, ROUND(CASE WHEN `pse`.PROMO=1 THEN `price`.PROMO_PRICE ELSE `price`.PRICE END, 2) AS real_price, `price`.PRICE AS price, `price`.PROMO_PRICE AS promo_price, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_TITLE` ELSE `default_locale_i18n`.`META_TITLE` END AS i18n_META_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_DESCRIPTION` ELSE `default_locale_i18n`.`META_DESCRIPTION` END AS i18n_META_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_KEYWORDS` ELSE `default_locale_i18n`.`META_KEYWORDS` END AS i18n_META_KEYWORDS, `pse`.ID AS pse_id, `pse`.NEWNESS AS is_new, `pse`.PROMO AS is_promo, `pse`.QUANTITY AS quantity, `pse`.WEIGHT AS weight, `pse`.EAN_CODE AS ean_code FROM `product` INNER JOIN `product_sale_elements` `pse` ON (product.ID=pse.PRODUCT_ID AND `pse`.IS_DEFAULT=1) LEFT JOIN `product_price` `price` ON (pse.ID=price.PRODUCT_SALE_ELEMENTS_ID AND `price`.`currency_id` = 1) LEFT JOIN `product_i18n` `default_locale_i18n` ON (product.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `product_i18n` `requested_locale_i18n` ON (product.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE ((NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND `pse`.NEWNESS=1) AND product.VISIBLE=1 GROUP BY product.ID ORDER BY i18n_TITLE ASC LIMIT 4 (0ms)
40: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT `ID`, `IS_DEFAULT`, `CREATED_AT`, `UPDATED_AT` FROM `tax_rule` WHERE `ID` = 5 (0ms)
41: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax_rule_country.TAX_RULE_ID, tax_rule_country.COUNTRY_ID, tax_rule_country.TAX_ID, tax_rule_country.POSITION, tax_rule_country.CREATED_AT, tax_rule_country.UPDATED_AT FROM `tax_rule_country` WHERE tax_rule_country.COUNTRY_ID=64 AND tax_rule_country.TAX_RULE_ID=5 ORDER BY tax_rule_country.POSITION ASC (0ms)
42: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax.ID, tax.TYPE, tax.SERIALIZED_REQUIREMENTS, tax.CREATED_AT, tax.UPDATED_AT, tax_rule_country.POSITION AS taxRuleCountryPosition FROM `tax` INNER JOIN `tax_rule_country` ON (tax.ID=tax_rule_country.TAX_ID) WHERE ((tax_rule_country.TAX_RULE_ID=5 AND tax_rule_country.COUNTRY_ID=64) AND tax_rule_country.TAX_ID=5) ORDER BY taxRuleCountryPosition ASC (0ms)
43: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax_rule_country.TAX_RULE_ID, tax_rule_country.COUNTRY_ID, tax_rule_country.TAX_ID, tax_rule_country.POSITION, tax_rule_country.CREATED_AT, tax_rule_country.UPDATED_AT FROM `tax_rule_country` WHERE tax_rule_country.COUNTRY_ID=64 AND tax_rule_country.TAX_RULE_ID=5 ORDER BY tax_rule_country.POSITION ASC (0ms)
44: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax.ID, tax.TYPE, tax.SERIALIZED_REQUIREMENTS, tax.CREATED_AT, tax.UPDATED_AT, tax_rule_country.POSITION AS taxRuleCountryPosition FROM `tax` INNER JOIN `tax_rule_country` ON (tax.ID=tax_rule_country.TAX_ID) WHERE ((tax_rule_country.TAX_RULE_ID=5 AND tax_rule_country.COUNTRY_ID=64) AND tax_rule_country.TAX_ID=5) ORDER BY taxRuleCountryPosition ASC (0ms)
45: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product_category.PRODUCT_ID, product_category.CATEGORY_ID, product_category.DEFAULT_CATEGORY, product_category.CREATED_AT, product_category.UPDATED_AT FROM `product_category` WHERE product_category.PRODUCT_ID=305 AND product_category.DEFAULT_CATEGORY=1 LIMIT 1 (0ms)
46: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT rewriting_url.ID, rewriting_url.URL, rewriting_url.VIEW, rewriting_url.VIEW_ID, rewriting_url.VIEW_LOCALE, rewriting_url.REDIRECTED, rewriting_url.CREATED_AT, rewriting_url.UPDATED_AT FROM `rewriting_url` LEFT JOIN `rewriting_argument` `ra` ON (rewriting_url.ID=ra.REWRITING_URL_ID) WHERE ISNULL(`ra`.REWRITING_URL_ID) AND rewriting_url.VIEW='product' AND rewriting_url.VIEW_LOCALE='fr_FR' AND rewriting_url.VIEW_ID=305 AND rewriting_url.REDIRECTED IS NULL  ORDER BY rewriting_url.ID DESC LIMIT 1 (0ms)
47: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax_rule_country.TAX_RULE_ID, tax_rule_country.COUNTRY_ID, tax_rule_country.TAX_ID, tax_rule_country.POSITION, tax_rule_country.CREATED_AT, tax_rule_country.UPDATED_AT FROM `tax_rule_country` WHERE tax_rule_country.COUNTRY_ID=64 AND tax_rule_country.TAX_RULE_ID=5 ORDER BY tax_rule_country.POSITION ASC (0ms)
48: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax.ID, tax.TYPE, tax.SERIALIZED_REQUIREMENTS, tax.CREATED_AT, tax.UPDATED_AT, tax_rule_country.POSITION AS taxRuleCountryPosition FROM `tax` INNER JOIN `tax_rule_country` ON (tax.ID=tax_rule_country.TAX_ID) WHERE ((tax_rule_country.TAX_RULE_ID=5 AND tax_rule_country.COUNTRY_ID=64) AND tax_rule_country.TAX_ID=5) ORDER BY taxRuleCountryPosition ASC (0ms)
49: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax_rule_country.TAX_RULE_ID, tax_rule_country.COUNTRY_ID, tax_rule_country.TAX_ID, tax_rule_country.POSITION, tax_rule_country.CREATED_AT, tax_rule_country.UPDATED_AT FROM `tax_rule_country` WHERE tax_rule_country.COUNTRY_ID=64 AND tax_rule_country.TAX_RULE_ID=5 ORDER BY tax_rule_country.POSITION ASC (0ms)
50: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax.ID, tax.TYPE, tax.SERIALIZED_REQUIREMENTS, tax.CREATED_AT, tax.UPDATED_AT, tax_rule_country.POSITION AS taxRuleCountryPosition FROM `tax` INNER JOIN `tax_rule_country` ON (tax.ID=tax_rule_country.TAX_ID) WHERE ((tax_rule_country.TAX_RULE_ID=5 AND tax_rule_country.COUNTRY_ID=64) AND tax_rule_country.TAX_ID=5) ORDER BY taxRuleCountryPosition ASC (0ms)
51: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product_category.PRODUCT_ID, product_category.CATEGORY_ID, product_category.DEFAULT_CATEGORY, product_category.CREATED_AT, product_category.UPDATED_AT FROM `product_category` WHERE product_category.PRODUCT_ID=306 AND product_category.DEFAULT_CATEGORY=1 LIMIT 1 (0ms)
52: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT rewriting_url.ID, rewriting_url.URL, rewriting_url.VIEW, rewriting_url.VIEW_ID, rewriting_url.VIEW_LOCALE, rewriting_url.REDIRECTED, rewriting_url.CREATED_AT, rewriting_url.UPDATED_AT FROM `rewriting_url` LEFT JOIN `rewriting_argument` `ra` ON (rewriting_url.ID=ra.REWRITING_URL_ID) WHERE ISNULL(`ra`.REWRITING_URL_ID) AND rewriting_url.VIEW='product' AND rewriting_url.VIEW_LOCALE='fr_FR' AND rewriting_url.VIEW_ID=306 AND rewriting_url.REDIRECTED IS NULL  ORDER BY rewriting_url.ID DESC LIMIT 1 (0ms)
53: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax_rule_country.TAX_RULE_ID, tax_rule_country.COUNTRY_ID, tax_rule_country.TAX_ID, tax_rule_country.POSITION, tax_rule_country.CREATED_AT, tax_rule_country.UPDATED_AT FROM `tax_rule_country` WHERE tax_rule_country.COUNTRY_ID=64 AND tax_rule_country.TAX_RULE_ID=5 ORDER BY tax_rule_country.POSITION ASC (0ms)
54: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax.ID, tax.TYPE, tax.SERIALIZED_REQUIREMENTS, tax.CREATED_AT, tax.UPDATED_AT, tax_rule_country.POSITION AS taxRuleCountryPosition FROM `tax` INNER JOIN `tax_rule_country` ON (tax.ID=tax_rule_country.TAX_ID) WHERE ((tax_rule_country.TAX_RULE_ID=5 AND tax_rule_country.COUNTRY_ID=64) AND tax_rule_country.TAX_ID=5) ORDER BY taxRuleCountryPosition ASC (0ms)
55: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax_rule_country.TAX_RULE_ID, tax_rule_country.COUNTRY_ID, tax_rule_country.TAX_ID, tax_rule_country.POSITION, tax_rule_country.CREATED_AT, tax_rule_country.UPDATED_AT FROM `tax_rule_country` WHERE tax_rule_country.COUNTRY_ID=64 AND tax_rule_country.TAX_RULE_ID=5 ORDER BY tax_rule_country.POSITION ASC (0ms)
56: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax.ID, tax.TYPE, tax.SERIALIZED_REQUIREMENTS, tax.CREATED_AT, tax.UPDATED_AT, tax_rule_country.POSITION AS taxRuleCountryPosition FROM `tax` INNER JOIN `tax_rule_country` ON (tax.ID=tax_rule_country.TAX_ID) WHERE ((tax_rule_country.TAX_RULE_ID=5 AND tax_rule_country.COUNTRY_ID=64) AND tax_rule_country.TAX_ID=5) ORDER BY taxRuleCountryPosition ASC (0ms)
57: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product_category.PRODUCT_ID, product_category.CATEGORY_ID, product_category.DEFAULT_CATEGORY, product_category.CREATED_AT, product_category.UPDATED_AT FROM `product_category` WHERE product_category.PRODUCT_ID=282 AND product_category.DEFAULT_CATEGORY=1 LIMIT 1 (0ms)
58: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT rewriting_url.ID, rewriting_url.URL, rewriting_url.VIEW, rewriting_url.VIEW_ID, rewriting_url.VIEW_LOCALE, rewriting_url.REDIRECTED, rewriting_url.CREATED_AT, rewriting_url.UPDATED_AT FROM `rewriting_url` LEFT JOIN `rewriting_argument` `ra` ON (rewriting_url.ID=ra.REWRITING_URL_ID) WHERE ISNULL(`ra`.REWRITING_URL_ID) AND rewriting_url.VIEW='product' AND rewriting_url.VIEW_LOCALE='fr_FR' AND rewriting_url.VIEW_ID=282 AND rewriting_url.REDIRECTED IS NULL  ORDER BY rewriting_url.ID DESC LIMIT 1 (0ms)
59: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax_rule_country.TAX_RULE_ID, tax_rule_country.COUNTRY_ID, tax_rule_country.TAX_ID, tax_rule_country.POSITION, tax_rule_country.CREATED_AT, tax_rule_country.UPDATED_AT FROM `tax_rule_country` WHERE tax_rule_country.COUNTRY_ID=64 AND tax_rule_country.TAX_RULE_ID=5 ORDER BY tax_rule_country.POSITION ASC (0ms)
60: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax.ID, tax.TYPE, tax.SERIALIZED_REQUIREMENTS, tax.CREATED_AT, tax.UPDATED_AT, tax_rule_country.POSITION AS taxRuleCountryPosition FROM `tax` INNER JOIN `tax_rule_country` ON (tax.ID=tax_rule_country.TAX_ID) WHERE ((tax_rule_country.TAX_RULE_ID=5 AND tax_rule_country.COUNTRY_ID=64) AND tax_rule_country.TAX_ID=5) ORDER BY taxRuleCountryPosition ASC (0ms)
61: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax_rule_country.TAX_RULE_ID, tax_rule_country.COUNTRY_ID, tax_rule_country.TAX_ID, tax_rule_country.POSITION, tax_rule_country.CREATED_AT, tax_rule_country.UPDATED_AT FROM `tax_rule_country` WHERE tax_rule_country.COUNTRY_ID=64 AND tax_rule_country.TAX_RULE_ID=5 ORDER BY tax_rule_country.POSITION ASC (0ms)
62: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT tax.ID, tax.TYPE, tax.SERIALIZED_REQUIREMENTS, tax.CREATED_AT, tax.UPDATED_AT, tax_rule_country.POSITION AS taxRuleCountryPosition FROM `tax` INNER JOIN `tax_rule_country` ON (tax.ID=tax_rule_country.TAX_ID) WHERE ((tax_rule_country.TAX_RULE_ID=5 AND tax_rule_country.COUNTRY_ID=64) AND tax_rule_country.TAX_ID=5) ORDER BY taxRuleCountryPosition ASC (0ms)
63: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product_category.PRODUCT_ID, product_category.CATEGORY_ID, product_category.DEFAULT_CATEGORY, product_category.CREATED_AT, product_category.UPDATED_AT FROM `product_category` WHERE product_category.PRODUCT_ID=287 AND product_category.DEFAULT_CATEGORY=1 LIMIT 1 (0ms)
64: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT rewriting_url.ID, rewriting_url.URL, rewriting_url.VIEW, rewriting_url.VIEW_ID, rewriting_url.VIEW_LOCALE, rewriting_url.REDIRECTED, rewriting_url.CREATED_AT, rewriting_url.UPDATED_AT FROM `rewriting_url` LEFT JOIN `rewriting_argument` `ra` ON (rewriting_url.ID=ra.REWRITING_URL_ID) WHERE ISNULL(`ra`.REWRITING_URL_ID) AND rewriting_url.VIEW='product' AND rewriting_url.VIEW_LOCALE='fr_FR' AND rewriting_url.VIEW_ID=287 AND rewriting_url.REDIRECTED IS NULL  ORDER BY rewriting_url.ID DESC LIMIT 1 (0ms)
65: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY FROM `product` WHERE product.ID IN ('305') (0ms)
66: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY FROM `product` WHERE product.ID IN ('305') (0ms)
67: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product_image.ID, product_image.PRODUCT_ID, product_image.FILE, product_image.POSITION, product_image.CREATED_AT, product_image.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM FROM `product_image` LEFT JOIN `product_image_i18n` `default_locale_i18n` ON (product_image.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `product_image_i18n` `requested_locale_i18n` ON (product_image.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE product_image.PRODUCT_ID=305 ORDER BY product_image.POSITION ASC LIMIT 1 (0ms)
68: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='images_library_path' LIMIT 1 (0ms)
69: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='image_cache_dir_from_web_root' LIMIT 1 (0ms)
70: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/374d99e.png
71: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT category.ID, category.PARENT, category.VISIBLE, category.POSITION, category.CREATED_AT, category.UPDATED_AT, category.VERSION, category.VERSION_CREATED_AT, category.VERSION_CREATED_BY, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_TITLE` ELSE `default_locale_i18n`.`META_TITLE` END AS i18n_META_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_DESCRIPTION` ELSE `default_locale_i18n`.`META_DESCRIPTION` END AS i18n_META_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_KEYWORDS` ELSE `default_locale_i18n`.`META_KEYWORDS` END AS i18n_META_KEYWORDS FROM `category` LEFT JOIN `category_i18n` `default_locale_i18n` ON (category.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `category_i18n` `requested_locale_i18n` ON (category.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND category.ID IN ('25') AND category.VISIBLE=1 ORDER BY category.POSITION ASC LIMIT 9223372036854775807 (0ms)
72: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT rewriting_url.ID, rewriting_url.URL, rewriting_url.VIEW, rewriting_url.VIEW_ID, rewriting_url.VIEW_LOCALE, rewriting_url.REDIRECTED, rewriting_url.CREATED_AT, rewriting_url.UPDATED_AT FROM `rewriting_url` LEFT JOIN `rewriting_argument` `ra` ON (rewriting_url.ID=ra.REWRITING_URL_ID) WHERE ISNULL(`ra`.REWRITING_URL_ID) AND rewriting_url.VIEW='category' AND rewriting_url.VIEW_LOCALE='fr_FR' AND rewriting_url.VIEW_ID=25 AND rewriting_url.REDIRECTED IS NULL  ORDER BY rewriting_url.ID DESC LIMIT 1 (0ms)
73: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY FROM `product` WHERE product.ID IN ('306') (0ms)
74: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY FROM `product` WHERE product.ID IN ('306') (0ms)
75: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product_image.ID, product_image.PRODUCT_ID, product_image.FILE, product_image.POSITION, product_image.CREATED_AT, product_image.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM FROM `product_image` LEFT JOIN `product_image_i18n` `default_locale_i18n` ON (product_image.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `product_image_i18n` `requested_locale_i18n` ON (product_image.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE product_image.PRODUCT_ID=306 ORDER BY product_image.POSITION ASC LIMIT 1 (0ms)
76: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/374d99e.png
77: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY FROM `product` WHERE product.ID IN ('282') (0ms)
78: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT template.ID, template.CREATED_AT, template.UPDATED_AT FROM `template` WHERE template.ID IN (23) (0ms)
79: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT feature_i18n.ID AS "id" FROM `feature_i18n` WHERE feature_i18n.TITLE LIKE 'brand' (0ms)
80: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT feature.ID, feature.VISIBLE, feature.POSITION, feature.CREATED_AT, feature.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM, feature_template.POSITION AS position FROM `feature` LEFT JOIN `feature_i18n` `default_locale_i18n` ON (feature.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `feature_i18n` `requested_locale_i18n` ON (feature.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') INNER JOIN `feature_template` ON (feature.ID=feature_template.FEATURE_ID) WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND feature_template.TEMPLATE_ID IN (23) AND 1<>1 ORDER BY feature_template.POSITION ASC LIMIT 9223372036854775807 (0ms)
81: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY FROM `product` WHERE product.ID IN ('282') (0ms)
82: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT template.ID, template.CREATED_AT, template.UPDATED_AT FROM `template` WHERE template.ID IN (23) (0ms)
83: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT feature_i18n.ID AS "id" FROM `feature_i18n` WHERE feature_i18n.TITLE LIKE 'isbn' (0ms)
84: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT feature.ID, feature.VISIBLE, feature.POSITION, feature.CREATED_AT, feature.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM, feature_template.POSITION AS position FROM `feature` LEFT JOIN `feature_i18n` `default_locale_i18n` ON (feature.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `feature_i18n` `requested_locale_i18n` ON (feature.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') INNER JOIN `feature_template` ON (feature.ID=feature_template.FEATURE_ID) WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND feature_template.TEMPLATE_ID IN (23) AND 1<>1 ORDER BY feature_template.POSITION ASC LIMIT 9223372036854775807 (0ms)
85: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product_image.ID, product_image.PRODUCT_ID, product_image.FILE, product_image.POSITION, product_image.CREATED_AT, product_image.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM FROM `product_image` LEFT JOIN `product_image_i18n` `default_locale_i18n` ON (product_image.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `product_image_i18n` `requested_locale_i18n` ON (product_image.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE product_image.PRODUCT_ID=282 ORDER BY product_image.POSITION ASC LIMIT 1 (0ms)
86: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/374d99e.png
87: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT category.ID, category.PARENT, category.VISIBLE, category.POSITION, category.CREATED_AT, category.UPDATED_AT, category.VERSION, category.VERSION_CREATED_AT, category.VERSION_CREATED_BY, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_TITLE` ELSE `default_locale_i18n`.`META_TITLE` END AS i18n_META_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_DESCRIPTION` ELSE `default_locale_i18n`.`META_DESCRIPTION` END AS i18n_META_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_KEYWORDS` ELSE `default_locale_i18n`.`META_KEYWORDS` END AS i18n_META_KEYWORDS FROM `category` LEFT JOIN `category_i18n` `default_locale_i18n` ON (category.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `category_i18n` `requested_locale_i18n` ON (category.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND category.ID IN ('23') AND category.VISIBLE=1 ORDER BY category.POSITION ASC LIMIT 9223372036854775807 (0ms)
88: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT rewriting_url.ID, rewriting_url.URL, rewriting_url.VIEW, rewriting_url.VIEW_ID, rewriting_url.VIEW_LOCALE, rewriting_url.REDIRECTED, rewriting_url.CREATED_AT, rewriting_url.UPDATED_AT FROM `rewriting_url` LEFT JOIN `rewriting_argument` `ra` ON (rewriting_url.ID=ra.REWRITING_URL_ID) WHERE ISNULL(`ra`.REWRITING_URL_ID) AND rewriting_url.VIEW='category' AND rewriting_url.VIEW_LOCALE='fr_FR' AND rewriting_url.VIEW_ID=23 AND rewriting_url.REDIRECTED IS NULL  ORDER BY rewriting_url.ID DESC LIMIT 1 (0ms)
89: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY FROM `product` WHERE product.ID IN ('287') (0ms)
90: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY FROM `product` WHERE product.ID IN ('287') (0ms)
91: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT product_image.ID, product_image.PRODUCT_ID, product_image.FILE, product_image.POSITION, product_image.CREATED_AT, product_image.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM FROM `product_image` LEFT JOIN `product_image_i18n` `default_locale_i18n` ON (product_image.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `product_image_i18n` `requested_locale_i18n` ON (product_image.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE product_image.PRODUCT_ID=287 ORDER BY product_image.POSITION ASC LIMIT 1 (0ms)
92: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/374d99e.png
93: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT folder.ID, folder.PARENT, folder.VISIBLE, folder.POSITION, folder.CREATED_AT, folder.UPDATED_AT, folder.VERSION, folder.VERSION_CREATED_AT, folder.VERSION_CREATED_BY FROM `folder` WHERE folder.ID IN ('1') (0ms)
94: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT content.ID, content.VISIBLE, content.POSITION, content.CREATED_AT, content.UPDATED_AT, content.VERSION, content.VERSION_CREATED_AT, content.VERSION_CREATED_BY, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_TITLE` ELSE `default_locale_i18n`.`META_TITLE` END AS i18n_META_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_DESCRIPTION` ELSE `default_locale_i18n`.`META_DESCRIPTION` END AS i18n_META_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_KEYWORDS` ELSE `default_locale_i18n`.`META_KEYWORDS` END AS i18n_META_KEYWORDS FROM `content` LEFT JOIN `content_i18n` `default_locale_i18n` ON (content.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `content_i18n` `requested_locale_i18n` ON (content.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') INNER JOIN `content_folder` ON (content.ID=content_folder.CONTENT_ID) WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND 1<>1 AND content.VISIBLE=1 ORDER BY i18n_TITLE ASC LIMIT 1 (0ms)
95: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_address1' LIMIT 1 (0ms)
96: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_address2' LIMIT 1 (0ms)
97: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_address3' LIMIT 1 (0ms)
98: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_zipcode' LIMIT 1 (0ms)
99: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_city' LIMIT 1 (0ms)
100: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_country' LIMIT 1 (0ms)
101: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT country.ID, country.AREA_ID, country.ISOCODE, country.ISOALPHA2, country.ISOALPHA3, country.BY_DEFAULT, country.SHOP_COUNTRY, country.CREATED_AT, country.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM FROM `country` LEFT JOIN `country_i18n` `default_locale_i18n` ON (country.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `country_i18n` `requested_locale_i18n` ON (country.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND country.ID IN ('64') ORDER BY i18n_TITLE ASC LIMIT 9223372036854775807 (0ms)
102: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_phone' LIMIT 1 (0ms)
103: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_email' LIMIT 1 (0ms)
104: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/js/libs/fff13cd.js
105: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/js/7aefd6f.js
106: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/js/bootstrap/46eeee1.js
107: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/js/plugins/bootbox/79a17f1.js
108: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:00: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/js/aff1ecb.js
109: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:00: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='cart.cookie_lifetime' LIMIT 1 (0ms)
1: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='session_config.save_path' LIMIT 1 (0ms)
2: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='rewriting_enable' LIMIT 1 (0ms)
3: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT rewriting_argument.REWRITING_URL_ID, rewriting_argument.PARAMETER, rewriting_argument.VALUE, rewriting_argument.CREATED_AT, rewriting_argument.UPDATED_AT, `ru`.URL AS ru_url, `ru`.VIEW AS ru_view, `ru`.VIEW_LOCALE AS ru_locale, `ru`.VIEW_ID AS ru_viewId, `is_redirected`.URL AS ru_redirected_to_url FROM `rewriting_argument` RIGHT JOIN `rewriting_url` `ru` ON (rewriting_argument.REWRITING_URL_ID=ru.ID) LEFT JOIN `rewriting_url` `is_redirected` ON (ru.REDIRECTED=is_redirected.ID) WHERE `ru`.URL = 'creation-arbre-vierge' (0ms)
4: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT rewriting_url.ID, rewriting_url.URL, rewriting_url.VIEW, rewriting_url.VIEW_ID, rewriting_url.VIEW_LOCALE, rewriting_url.REDIRECTED, rewriting_url.CREATED_AT, rewriting_url.UPDATED_AT FROM `rewriting_url` LEFT JOIN `rewriting_argument` `ra` ON (rewriting_url.ID=ra.REWRITING_URL_ID) WHERE ISNULL(`ra`.REWRITING_URL_ID) AND rewriting_url.VIEW='creation-arbre-vierge' AND rewriting_url.VIEW_LOCALE IS NULL  AND rewriting_url.VIEW_ID IS NULL  AND rewriting_url.REDIRECTED IS NULL  ORDER BY rewriting_url.ID DESC LIMIT 1 (0ms)
5: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='asset_dir_from_web_root' LIMIT 1 (0ms)
6: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='active-front-template' LIMIT 1 (0ms)
7: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_name' LIMIT 1 (0ms)
8: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:57: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/css/c58deec.css
9: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='process_assets' LIMIT 1 (0ms)
10: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:57: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/9780c83.ico
11: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:57: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/0d71af7.png
12: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='form.secret' LIMIT 1 (0ms)
13: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT country.ID, country.AREA_ID, country.ISOCODE, country.ISOALPHA2, country.ISOALPHA3, country.BY_DEFAULT, country.SHOP_COUNTRY, country.CREATED_AT, country.UPDATED_AT FROM `country` WHERE country.BY_DEFAULT=1 LIMIT 1 (0ms)
14: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT `ID`, `TOKEN`, `CUSTOMER_ID`, `ADDRESS_DELIVERY_ID`, `ADDRESS_INVOICE_ID`, `CURRENCY_ID`, `DISCOUNT`, `CREATED_AT`, `UPDATED_AT` FROM `cart` WHERE `ID` = 72 (0ms)
15: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT cart_item.ID, cart_item.CART_ID, cart_item.PRODUCT_ID, cart_item.QUANTITY, cart_item.PRODUCT_SALE_ELEMENTS_ID, cart_item.PRICE, cart_item.PROMO_PRICE, cart_item.PRICE_END_OF_LIFE, cart_item.PROMO, cart_item.CREATED_AT, cart_item.UPDATED_AT FROM `cart_item` WHERE cart_item.CART_ID=72 (0ms)
16: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT `ID`, `TITLE`, `CODE`, `LOCALE`, `URL`, `DATE_FORMAT`, `TIME_FORMAT`, `DATETIME_FORMAT`, `DECIMAL_SEPARATOR`, `THOUSANDS_SEPARATOR`, `DECIMALS`, `BY_DEFAULT`, `POSITION`, `CREATED_AT`, `UPDATED_AT` FROM `lang` WHERE `ID` = 1 (0ms)
17: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='default_lang_without_translation' LIMIT 1 (0ms)
18: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT lang.ID, lang.TITLE, lang.CODE, lang.LOCALE, lang.URL, lang.DATE_FORMAT, lang.TIME_FORMAT, lang.DATETIME_FORMAT, lang.DECIMAL_SEPARATOR, lang.THOUSANDS_SEPARATOR, lang.DECIMALS, lang.BY_DEFAULT, lang.POSITION, lang.CREATED_AT, lang.UPDATED_AT FROM `lang` WHERE lang.BY_DEFAULT=1 LIMIT 1 (0ms)
19: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT currency.ID, currency.CODE, currency.SYMBOL, currency.RATE, currency.POSITION, currency.BY_DEFAULT, currency.CREATED_AT, currency.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`NAME` ELSE `default_locale_i18n`.`NAME` END AS i18n_NAME FROM `currency` LEFT JOIN `currency_i18n` `default_locale_i18n` ON (currency.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `currency_i18n` `requested_locale_i18n` ON (currency.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE currency.ID=1 LIMIT 1 (0ms)
20: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:57: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/img/8fe7356.png
21: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT lang.ID, lang.TITLE, lang.CODE, lang.LOCALE, lang.URL, lang.DATE_FORMAT, lang.TIME_FORMAT, lang.DATETIME_FORMAT, lang.DECIMAL_SEPARATOR, lang.THOUSANDS_SEPARATOR, lang.DECIMALS, lang.BY_DEFAULT, lang.POSITION, lang.CREATED_AT, lang.UPDATED_AT FROM `lang` WHERE lang.ID NOT IN ('1') ORDER BY lang.POSITION ASC LIMIT 9223372036854775807 (0ms)
22: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT currency.ID, currency.CODE, currency.SYMBOL, currency.RATE, currency.POSITION, currency.BY_DEFAULT, currency.CREATED_AT, currency.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`NAME` ELSE `default_locale_i18n`.`NAME` END AS i18n_NAME FROM `currency` LEFT JOIN `currency_i18n` `default_locale_i18n` ON (currency.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `currency_i18n` `requested_locale_i18n` ON (currency.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND currency.ID NOT IN ('1') ORDER BY currency.POSITION ASC LIMIT 9223372036854775807 (0ms)
23: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT folder.ID, folder.PARENT, folder.VISIBLE, folder.POSITION, folder.CREATED_AT, folder.UPDATED_AT, folder.VERSION, folder.VERSION_CREATED_AT, folder.VERSION_CREATED_BY FROM `folder` WHERE folder.ID IN ('1') (0ms)
24: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT content.ID, content.VISIBLE, content.POSITION, content.CREATED_AT, content.UPDATED_AT, content.VERSION, content.VERSION_CREATED_AT, content.VERSION_CREATED_BY, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_TITLE` ELSE `default_locale_i18n`.`META_TITLE` END AS i18n_META_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_DESCRIPTION` ELSE `default_locale_i18n`.`META_DESCRIPTION` END AS i18n_META_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_KEYWORDS` ELSE `default_locale_i18n`.`META_KEYWORDS` END AS i18n_META_KEYWORDS FROM `content` LEFT JOIN `content_i18n` `default_locale_i18n` ON (content.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `content_i18n` `requested_locale_i18n` ON (content.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') INNER JOIN `content_folder` ON (content.ID=content_folder.CONTENT_ID) WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND 1<>1 AND content.VISIBLE=1 ORDER BY i18n_TITLE ASC LIMIT 1 (0ms)
25: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_address1' LIMIT 1 (0ms)
26: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_address2' LIMIT 1 (0ms)
27: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_address3' LIMIT 1 (0ms)
28: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_zipcode' LIMIT 1 (0ms)
29: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_city' LIMIT 1 (0ms)
30: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_country' LIMIT 1 (0ms)
31: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT country.ID, country.AREA_ID, country.ISOCODE, country.ISOALPHA2, country.ISOALPHA3, country.BY_DEFAULT, country.SHOP_COUNTRY, country.CREATED_AT, country.UPDATED_AT, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM FROM `country` LEFT JOIN `country_i18n` `default_locale_i18n` ON (country.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `country_i18n` `requested_locale_i18n` ON (country.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = 'fr_FR') WHERE (NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND country.ID IN ('64') ORDER BY i18n_TITLE ASC LIMIT 9223372036854775807 (0ms)
32: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_phone' LIMIT 1 (0ms)
33: INFO [PropelCollector.php:log()] {118} 2014-09-30 17:35:57: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='store_email' LIMIT 1 (0ms)
34: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:57: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/js/libs/fff13cd.js
35: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:57: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/js/7aefd6f.js
36: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:57: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/js/bootstrap/46eeee1.js
37: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:57: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/js/plugins/bootbox/79a17f1.js
38: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-09-30 17:35:57: Asset destination full path: /home3/iskean/public_html/GeneaPrint/store/web/assets/frontOffice/default/0/js/aff1ecb.js

C'est peut-être dû au technicien de l'hébergeur qui a essayé de regarder...

Faut que ça m'arriver le jour où je bascule officiellement vers la nouvelle version de la boutique (Thelia 2)...

roadster31
Core Dev

Registered: 19-09-2009
Posts: 9,451
Toulouse
Website

Offline

#7 Re: [RÉSOLU] Site inaccessible

(30-09-2014 18:09:04)

Accède à ton site en mode développement, avec index_dev.php (http://www.gnagnagna.com/index_dev.php). Si ça te dit "Forbidden", ajoutes ton adresse IP à la liste qui se trouve dans le fichier web/index_dev.php.

Ceci fait, tu vas en principe voir une belle exception.

Poste-la ici.

(oui, gnagnagna.com est libre. Unbelievable !)

OpenStudio Toulouse

iSkean
Membre

Registered: 21-07-2008
Posts: 174
Istres
Website

Offline

#8 Re: [RÉSOLU] Site inaccessible

(30-09-2014 18:25:46)

Le site est étrangement accessible en mode développement avec mon IP ajoutée. Qu'est-ce qui change concrètement?

roadster31
Core Dev

Registered: 19-09-2009
Posts: 9,451
Toulouse
Website

Offline

#9 Re: [RÉSOLU] Site inaccessible

(30-09-2014 19:14:54)

1) Le cache de prod, qu'il faut vider, ou alors 2) une exception planquée dans le code source de la page.

Pour 1), copie ça dans le fichier web/clear-cache.php :

<?php
include __DIR__ . "/../core/bootstrap.php";

$fs = new \Symfony\Component\Filesystem\Filesystem();
$fs->remove(__DIR__ .'/../cache/prod');
$fs->remove(__DIR__ .'/../cache/dev');

echo "All caches cleared, boss.";

Et invoque ça dans ton navigateur.

Pour 2), mate le code source de ta page.

OpenStudio Toulouse

iSkean
Membre

Registered: 21-07-2008
Posts: 174
Istres
Website

Offline

#10 Re: [RÉSOLU] Site inaccessible

(30-09-2014 19:50:02)

Je n'ai aucun fichier clear-cache.php dans le dossier web. Tu es sûr que c'est bien ce nom? Faut-il le créer? Je ne voudrais pas écraser quelque chose... Merci pour ton aide.

roadster31
Core Dev

Registered: 19-09-2009
Posts: 9,451
Toulouse
Website

Offline

#11 Re: [RÉSOLU] Site inaccessible

(30-09-2014 20:57:27)

Je n'ai aucun fichier clear-cache.php dans le dossier web

Oui. C'est pour ça que je te demandes de le créer.

OpenStudio Toulouse

iSkean
Membre

Registered: 21-07-2008
Posts: 174
Istres
Website

Offline

#12 Re: [RÉSOLU] Site inaccessible

(30-09-2014 21:09:42)

Parfait! Ça remarche! Je garde le code sous le coude, sait-on jamais!
Merci à tout les 2 pour votre aide.