THELIA Forum

Welcome to the THELIA support and discusssion forum

Announcement

Rejoignez la communauté sur le Discord Thelia : https://discord.gg/YgwpYEE3y3
  • Index
  • Thelia 2 - Section française
  • Utilisation
  • Lister les codes promos utilises sur la page Order-invoice

Offline

#1 Lister les codes promos utilises sur la page Order-invoice

(22-07-2014 16:04:34)

Bonjour,

j'aimerai afficher, au fur et a mesure que le client entre ses codes promos, la description des codes utilises
et permettre de deselectionner les codes non desires s'ils sont cumulables

je ne trouve pas un lien entre la boucle cart et order-coupon
et aussi pour le calcul du discount

Last edited by zzuutt (22-07-2014 16:05:09)

Offline

#2 Re: Lister les codes promos utilises sur la page Order-invoice

(22-07-2014 16:49:49)

je ne trouve pas un lien entre la boucle cart et order-coupon

Il n'y en a pas, car la boucle order-coupon ne fonctionne que sur des orders, or à ce moment (la saisie des coupons), il n'existe pas encore d'order.

Il faudrait soit créer une boucle "cart-coupons", qui permettrait de récupérer les coupons en cours d'utilisation (bof...), ou alors ajouter un paramètre à la boucle "coupon", qui ne retournerait que les coupons en cours d'utilisation.

OpenStudio Toulouse

Offline

#3 Re: Lister les codes promos utilises sur la page Order-invoice

(22-07-2014 18:07:16)

Et hop: https://github.com/thelia/thelia/pull/543

OpenStudio Toulouse

Offline

#4 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 08:07:08)

Merci pour cette tres grande reactivite   Comme toujours wink

Offline

#5 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 09:58:14)

ok je teste

j'ai reimporter le dosiier core/lib/thelia/coupon et le fichier core\lib\Thelia\Core\Template\Loop\Coupon.php

Last edited by zzuutt (23-07-2014 10:23:42)

Offline

#6 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 10:04:20)

Ici tous les tests passent, et j'utilise ce coupon sans problème. N'aurais tu pas viré la méthode clear() de la classe CouponAbstract en ajoutant la méthode isInUse() ?

OpenStudio Toulouse

Offline

#7 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 10:20:08)

la methode clear n'est pas implemente dans mon thelia v2.0.2
elle est arrive apres la mise a jour ?

cote front j'ai encore une erreur
Sorry, an error occured: Call to undefined method: isUsageUnlimited.

Last edited by zzuutt (23-07-2014 10:24:22)

Offline

#8 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 10:30:45)

Ha, effectivement, ce n'est pas encore implémenté en 2.0.2, il y a eu quelques ajustements sur les coupons entre 2.0.2 et 2.0.3.

OpenStudio Toulouse

Offline

#9 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 10:37:43)

j'ai trouve le fichier qu'il me manque
core\lib\Thelia\Model\Coupon.php

maintenant j'ai tout bon (enfin je crois)
je vais tester ton update smile

Offline

#10 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 12:59:47)

il y a tellement de changement entre la 2.0.2 et la 2.0.3 que ca bug

bon j'ai tente l'update en 2.0.3
mais j'ai des bug encore, lors de la sauvegarde d'un code promo

Désolé, une erreur est survenue: Unable to execute SELECT statement [SELECT coupon_version.ID, coupon_version.CODE, coupon_version.TYPE, coupon_version.SERIALIZED_EFFECTS, coupon_version.IS_ENABLED, coupon_version.EXPIRATION_DATE, coupon_version.MAX_USAGE, coupon_version.IS_CUMULATIVE, coupon_version.IS_REMOVING_POSTAGE, coupon_version.IS_AVAILABLE_ON_SPECIAL_OFFERS, coupon_version.IS_USED, coupon_version.SERIALIZED_CONDITIONS, coupon_version.PER_CUSTOMER_USAGE_COUNT, coupon_version.CREATED_AT, coupon_version.UPDATED_AT, coupon_version.VERSION, coupon_version.VERSION_CREATED_AT, coupon_version.VERSION_CREATED_BY FROM `coupon_version` WHERE coupon_version.ID=:p1 ORDER BY coupon_version.VERSION DESC LIMIT 1]

l'update officiel en 2.03 c'est pour quand ?

Offline

#11 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 13:15:00)

Il te faut mettre la base de données à niveau, en exécutant setup/update/2.0.3.sql. Si tu l'as déjà fait, je suis preneur du message d'erreur complet.

OpenStudio Toulouse

Offline

#12 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 13:20:01)

je l'ai fait
et le seul message d'erreur que j'ai c'est cote back qu'en j'enregistre un code promo

Désolé, une erreur est survenue: Unable to execute SELECT statement [SELECT coupon_version.ID, coupon_version.CODE, coupon_version.TYPE, coupon_version.SERIALIZED_EFFECTS, coupon_version.IS_ENABLED, coupon_version.EXPIRATION_DATE, coupon_version.MAX_USAGE, coupon_version.IS_CUMULATIVE, coupon_version.IS_REMOVING_POSTAGE, coupon_version.IS_AVAILABLE_ON_SPECIAL_OFFERS, coupon_version.IS_USED, coupon_version.SERIALIZED_CONDITIONS, coupon_version.PER_CUSTOMER_USAGE_COUNT, coupon_version.CREATED_AT, coupon_version.UPDATED_AT, coupon_version.VERSION, coupon_version.VERSION_CREATED_AT, coupon_version.VERSION_CREATED_BY FROM `coupon_version` WHERE coupon_version.ID=:p1 ORDER BY coupon_version.VERSION DESC LIMIT 1]

rien d'autre...

bizarre en haut cote back cela me marque version 2.0.2, pourtant dans ma table thelia_version = 2.0.3

Last edited by zzuutt (23-07-2014 13:42:00)

Offline

#13 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 14:37:15)

Merci de regarder dans le fichier de log (log/log-thelia.txt), tu as l'erreur complète.

OpenStudio Toulouse

Offline

#14 Re: Lister les codes promos utilises sur la page Order-invoice

(23-07-2014 21:01:42)

voici le log

1: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:47: 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
2: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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
3: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT `ID`, `CODE`, `TYPE`, `SERIALIZED_EFFECTS`, `IS_ENABLED`, `EXPIRATION_DATE`, `MAX_USAGE`, `IS_CUMULATIVE`, `IS_REMOVING_POSTAGE`, `IS_AVAILABLE_ON_SPECIAL_OFFERS`, `IS_USED`, `SERIALIZED_CONDITIONS`, `PER_CUSTOMER_USAGE_COUNT`, `CREATED_AT`, `UPDATED_AT`, `VERSION`, `VERSION_CREATED_AT`, `VERSION_CREATED_BY` FROM `coupon` WHERE `ID` = '3'
4: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT coupon_i18n.ID, coupon_i18n.LOCALE, coupon_i18n.TITLE, coupon_i18n.SHORT_DESCRIPTION, coupon_i18n.DESCRIPTION FROM `coupon_i18n` WHERE coupon_i18n.ID=3 AND coupon_i18n.LOCALE='fr_FR' LIMIT 1
5: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT coupon_country.COUPON_ID, coupon_country.COUNTRY_ID FROM `coupon_country` WHERE coupon_country.COUPON_ID=3
6: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT coupon_module.COUPON_ID, coupon_module.MODULE_ID FROM `coupon_module` WHERE coupon_module.COUPON_ID=3
7: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT currency.ID, currency.CODE, currency.SYMBOL, currency.RATE, currency.POSITION, currency.BY_DEFAULT, currency.CREATED_AT, currency.UPDATED_AT FROM `currency`
8: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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
9: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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`
10: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=1 AND country_i18n.LOCALE='en_US' LIMIT 1
11: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=2 AND country_i18n.LOCALE='en_US' LIMIT 1
12: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=3 AND country_i18n.LOCALE='en_US' LIMIT 1
13: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=4 AND country_i18n.LOCALE='en_US' LIMIT 1
14: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=5 AND country_i18n.LOCALE='en_US' LIMIT 1
15: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=6 AND country_i18n.LOCALE='en_US' LIMIT 1
16: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=7 AND country_i18n.LOCALE='en_US' LIMIT 1
17: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=8 AND country_i18n.LOCALE='en_US' LIMIT 1
18: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=9 AND country_i18n.LOCALE='en_US' LIMIT 1
19: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=10 AND country_i18n.LOCALE='en_US' LIMIT 1
20: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=11 AND country_i18n.LOCALE='en_US' LIMIT 1
21: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=12 AND country_i18n.LOCALE='en_US' LIMIT 1
22: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=13 AND country_i18n.LOCALE='en_US' LIMIT 1
23: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=14 AND country_i18n.LOCALE='en_US' LIMIT 1
24: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=15 AND country_i18n.LOCALE='en_US' LIMIT 1
25: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=16 AND country_i18n.LOCALE='en_US' LIMIT 1
26: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=17 AND country_i18n.LOCALE='en_US' LIMIT 1
27: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=18 AND country_i18n.LOCALE='en_US' LIMIT 1
28: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=19 AND country_i18n.LOCALE='en_US' LIMIT 1
29: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=20 AND country_i18n.LOCALE='en_US' LIMIT 1
30: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=21 AND country_i18n.LOCALE='en_US' LIMIT 1
31: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=22 AND country_i18n.LOCALE='en_US' LIMIT 1
32: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=23 AND country_i18n.LOCALE='en_US' LIMIT 1
33: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=24 AND country_i18n.LOCALE='en_US' LIMIT 1
34: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=25 AND country_i18n.LOCALE='en_US' LIMIT 1
35: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=26 AND country_i18n.LOCALE='en_US' LIMIT 1
36: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=27 AND country_i18n.LOCALE='en_US' LIMIT 1
37: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=28 AND country_i18n.LOCALE='en_US' LIMIT 1
38: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=29 AND country_i18n.LOCALE='en_US' LIMIT 1
39: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=30 AND country_i18n.LOCALE='en_US' LIMIT 1
40: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=31 AND country_i18n.LOCALE='en_US' LIMIT 1
41: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=32 AND country_i18n.LOCALE='en_US' LIMIT 1
42: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=33 AND country_i18n.LOCALE='en_US' LIMIT 1
43: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=34 AND country_i18n.LOCALE='en_US' LIMIT 1
44: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=35 AND country_i18n.LOCALE='en_US' LIMIT 1
45: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=37 AND country_i18n.LOCALE='en_US' LIMIT 1
46: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=38 AND country_i18n.LOCALE='en_US' LIMIT 1
47: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=39 AND country_i18n.LOCALE='en_US' LIMIT 1
48: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=40 AND country_i18n.LOCALE='en_US' LIMIT 1
49: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=41 AND country_i18n.LOCALE='en_US' LIMIT 1
50: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=42 AND country_i18n.LOCALE='en_US' LIMIT 1
51: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=43 AND country_i18n.LOCALE='en_US' LIMIT 1
52: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=44 AND country_i18n.LOCALE='en_US' LIMIT 1
53: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=45 AND country_i18n.LOCALE='en_US' LIMIT 1
54: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=46 AND country_i18n.LOCALE='en_US' LIMIT 1
55: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=47 AND country_i18n.LOCALE='en_US' LIMIT 1
56: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=48 AND country_i18n.LOCALE='en_US' LIMIT 1
57: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=49 AND country_i18n.LOCALE='en_US' LIMIT 1
58: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=50 AND country_i18n.LOCALE='en_US' LIMIT 1
59: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=51 AND country_i18n.LOCALE='en_US' LIMIT 1
60: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=52 AND country_i18n.LOCALE='en_US' LIMIT 1
61: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=53 AND country_i18n.LOCALE='en_US' LIMIT 1
62: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=54 AND country_i18n.LOCALE='en_US' LIMIT 1
63: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=55 AND country_i18n.LOCALE='en_US' LIMIT 1
64: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=56 AND country_i18n.LOCALE='en_US' LIMIT 1
65: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=57 AND country_i18n.LOCALE='en_US' LIMIT 1
66: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=58 AND country_i18n.LOCALE='en_US' LIMIT 1
67: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=59 AND country_i18n.LOCALE='en_US' LIMIT 1
68: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=61 AND country_i18n.LOCALE='en_US' LIMIT 1
69: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=62 AND country_i18n.LOCALE='en_US' LIMIT 1
70: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=63 AND country_i18n.LOCALE='en_US' LIMIT 1
71: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=64 AND country_i18n.LOCALE='en_US' LIMIT 1
72: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=65 AND country_i18n.LOCALE='en_US' LIMIT 1
73: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=66 AND country_i18n.LOCALE='en_US' LIMIT 1
74: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=67 AND country_i18n.LOCALE='en_US' LIMIT 1
75: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=68 AND country_i18n.LOCALE='en_US' LIMIT 1
76: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=69 AND country_i18n.LOCALE='en_US' LIMIT 1
77: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=70 AND country_i18n.LOCALE='en_US' LIMIT 1
78: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=71 AND country_i18n.LOCALE='en_US' LIMIT 1
79: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=72 AND country_i18n.LOCALE='en_US' LIMIT 1
80: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=73 AND country_i18n.LOCALE='en_US' LIMIT 1
81: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=74 AND country_i18n.LOCALE='en_US' LIMIT 1
82: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=75 AND country_i18n.LOCALE='en_US' LIMIT 1
83: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=76 AND country_i18n.LOCALE='en_US' LIMIT 1
84: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=77 AND country_i18n.LOCALE='en_US' LIMIT 1
85: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=78 AND country_i18n.LOCALE='en_US' LIMIT 1
86: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=79 AND country_i18n.LOCALE='en_US' LIMIT 1
87: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=80 AND country_i18n.LOCALE='en_US' LIMIT 1
88: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=81 AND country_i18n.LOCALE='en_US' LIMIT 1
89: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=82 AND country_i18n.LOCALE='en_US' LIMIT 1
90: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=83 AND country_i18n.LOCALE='en_US' LIMIT 1
91: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=84 AND country_i18n.LOCALE='en_US' LIMIT 1
92: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=85 AND country_i18n.LOCALE='en_US' LIMIT 1
93: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=86 AND country_i18n.LOCALE='en_US' LIMIT 1
94: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=87 AND country_i18n.LOCALE='en_US' LIMIT 1
95: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=88 AND country_i18n.LOCALE='en_US' LIMIT 1
96: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=89 AND country_i18n.LOCALE='en_US' LIMIT 1
97: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=90 AND country_i18n.LOCALE='en_US' LIMIT 1
98: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=91 AND country_i18n.LOCALE='en_US' LIMIT 1
99: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=92 AND country_i18n.LOCALE='en_US' LIMIT 1
100: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=93 AND country_i18n.LOCALE='en_US' LIMIT 1
101: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=94 AND country_i18n.LOCALE='en_US' LIMIT 1
102: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=95 AND country_i18n.LOCALE='en_US' LIMIT 1
103: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=96 AND country_i18n.LOCALE='en_US' LIMIT 1
104: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=97 AND country_i18n.LOCALE='en_US' LIMIT 1
105: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=98 AND country_i18n.LOCALE='en_US' LIMIT 1
106: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=99 AND country_i18n.LOCALE='en_US' LIMIT 1
107: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=100 AND country_i18n.LOCALE='en_US' LIMIT 1
108: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=101 AND country_i18n.LOCALE='en_US' LIMIT 1
109: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=102 AND country_i18n.LOCALE='en_US' LIMIT 1
110: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=103 AND country_i18n.LOCALE='en_US' LIMIT 1
111: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=104 AND country_i18n.LOCALE='en_US' LIMIT 1
112: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=105 AND country_i18n.LOCALE='en_US' LIMIT 1
113: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=106 AND country_i18n.LOCALE='en_US' LIMIT 1
114: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=107 AND country_i18n.LOCALE='en_US' LIMIT 1
115: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=108 AND country_i18n.LOCALE='en_US' LIMIT 1
116: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=109 AND country_i18n.LOCALE='en_US' LIMIT 1
117: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=110 AND country_i18n.LOCALE='en_US' LIMIT 1
118: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=111 AND country_i18n.LOCALE='en_US' LIMIT 1
119: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=112 AND country_i18n.LOCALE='en_US' LIMIT 1
120: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=113 AND country_i18n.LOCALE='en_US' LIMIT 1
121: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=114 AND country_i18n.LOCALE='en_US' LIMIT 1
122: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=115 AND country_i18n.LOCALE='en_US' LIMIT 1
123: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=116 AND country_i18n.LOCALE='en_US' LIMIT 1
124: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=117 AND country_i18n.LOCALE='en_US' LIMIT 1
125: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=118 AND country_i18n.LOCALE='en_US' LIMIT 1
126: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=119 AND country_i18n.LOCALE='en_US' LIMIT 1
127: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=120 AND country_i18n.LOCALE='en_US' LIMIT 1
128: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=121 AND country_i18n.LOCALE='en_US' LIMIT 1
129: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=122 AND country_i18n.LOCALE='en_US' LIMIT 1
130: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=123 AND country_i18n.LOCALE='en_US' LIMIT 1
131: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=124 AND country_i18n.LOCALE='en_US' LIMIT 1
132: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=125 AND country_i18n.LOCALE='en_US' LIMIT 1
133: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=126 AND country_i18n.LOCALE='en_US' LIMIT 1
134: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=127 AND country_i18n.LOCALE='en_US' LIMIT 1
135: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=128 AND country_i18n.LOCALE='en_US' LIMIT 1
136: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=129 AND country_i18n.LOCALE='en_US' LIMIT 1
137: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=130 AND country_i18n.LOCALE='en_US' LIMIT 1
138: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=131 AND country_i18n.LOCALE='en_US' LIMIT 1
139: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=132 AND country_i18n.LOCALE='en_US' LIMIT 1
140: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=133 AND country_i18n.LOCALE='en_US' LIMIT 1
141: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=134 AND country_i18n.LOCALE='en_US' LIMIT 1
142: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=135 AND country_i18n.LOCALE='en_US' LIMIT 1
143: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=136 AND country_i18n.LOCALE='en_US' LIMIT 1
144: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=137 AND country_i18n.LOCALE='en_US' LIMIT 1
145: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=138 AND country_i18n.LOCALE='en_US' LIMIT 1
146: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=139 AND country_i18n.LOCALE='en_US' LIMIT 1
147: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=140 AND country_i18n.LOCALE='en_US' LIMIT 1
148: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=141 AND country_i18n.LOCALE='en_US' LIMIT 1
149: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=142 AND country_i18n.LOCALE='en_US' LIMIT 1
150: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=143 AND country_i18n.LOCALE='en_US' LIMIT 1
151: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=144 AND country_i18n.LOCALE='en_US' LIMIT 1
152: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=145 AND country_i18n.LOCALE='en_US' LIMIT 1
153: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=146 AND country_i18n.LOCALE='en_US' LIMIT 1
154: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=147 AND country_i18n.LOCALE='en_US' LIMIT 1
155: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=148 AND country_i18n.LOCALE='en_US' LIMIT 1
156: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=149 AND country_i18n.LOCALE='en_US' LIMIT 1
157: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=150 AND country_i18n.LOCALE='en_US' LIMIT 1
158: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=151 AND country_i18n.LOCALE='en_US' LIMIT 1
159: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=152 AND country_i18n.LOCALE='en_US' LIMIT 1
160: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=153 AND country_i18n.LOCALE='en_US' LIMIT 1
161: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=154 AND country_i18n.LOCALE='en_US' LIMIT 1
162: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=155 AND country_i18n.LOCALE='en_US' LIMIT 1
163: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=156 AND country_i18n.LOCALE='en_US' LIMIT 1
164: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=157 AND country_i18n.LOCALE='en_US' LIMIT 1
165: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=158 AND country_i18n.LOCALE='en_US' LIMIT 1
166: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=159 AND country_i18n.LOCALE='en_US' LIMIT 1
167: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=160 AND country_i18n.LOCALE='en_US' LIMIT 1
168: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=161 AND country_i18n.LOCALE='en_US' LIMIT 1
169: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=162 AND country_i18n.LOCALE='en_US' LIMIT 1
170: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=163 AND country_i18n.LOCALE='en_US' LIMIT 1
171: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=164 AND country_i18n.LOCALE='en_US' LIMIT 1
172: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=165 AND country_i18n.LOCALE='en_US' LIMIT 1
173: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=166 AND country_i18n.LOCALE='en_US' LIMIT 1
174: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=167 AND country_i18n.LOCALE='en_US' LIMIT 1
175: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=168 AND country_i18n.LOCALE='en_US' LIMIT 1
176: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=169 AND country_i18n.LOCALE='en_US' LIMIT 1
177: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=170 AND country_i18n.LOCALE='en_US' LIMIT 1
178: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=171 AND country_i18n.LOCALE='en_US' LIMIT 1
179: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=172 AND country_i18n.LOCALE='en_US' LIMIT 1
180: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=173 AND country_i18n.LOCALE='en_US' LIMIT 1
181: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=174 AND country_i18n.LOCALE='en_US' LIMIT 1
182: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=175 AND country_i18n.LOCALE='en_US' LIMIT 1
183: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=176 AND country_i18n.LOCALE='en_US' LIMIT 1
184: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=177 AND country_i18n.LOCALE='en_US' LIMIT 1
185: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=178 AND country_i18n.LOCALE='en_US' LIMIT 1
186: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=179 AND country_i18n.LOCALE='en_US' LIMIT 1
187: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=180 AND country_i18n.LOCALE='en_US' LIMIT 1
188: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=181 AND country_i18n.LOCALE='en_US' LIMIT 1
189: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=182 AND country_i18n.LOCALE='en_US' LIMIT 1
190: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=183 AND country_i18n.LOCALE='en_US' LIMIT 1
191: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=184 AND country_i18n.LOCALE='en_US' LIMIT 1
192: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=185 AND country_i18n.LOCALE='en_US' LIMIT 1
193: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=186 AND country_i18n.LOCALE='en_US' LIMIT 1
194: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=187 AND country_i18n.LOCALE='en_US' LIMIT 1
195: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=188 AND country_i18n.LOCALE='en_US' LIMIT 1
196: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=189 AND country_i18n.LOCALE='en_US' LIMIT 1
197: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=191 AND country_i18n.LOCALE='en_US' LIMIT 1
198: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=192 AND country_i18n.LOCALE='en_US' LIMIT 1
199: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=193 AND country_i18n.LOCALE='en_US' LIMIT 1
200: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=196 AND country_i18n.LOCALE='en_US' LIMIT 1
201: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=197 AND country_i18n.LOCALE='en_US' LIMIT 1
202: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=198 AND country_i18n.LOCALE='en_US' LIMIT 1
203: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=199 AND country_i18n.LOCALE='en_US' LIMIT 1
204: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=200 AND country_i18n.LOCALE='en_US' LIMIT 1
205: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=201 AND country_i18n.LOCALE='en_US' LIMIT 1
206: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=202 AND country_i18n.LOCALE='en_US' LIMIT 1
207: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=203 AND country_i18n.LOCALE='en_US' LIMIT 1
208: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=204 AND country_i18n.LOCALE='en_US' LIMIT 1
209: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=205 AND country_i18n.LOCALE='en_US' LIMIT 1
210: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=206 AND country_i18n.LOCALE='en_US' LIMIT 1
211: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=207 AND country_i18n.LOCALE='en_US' LIMIT 1
212: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=208 AND country_i18n.LOCALE='en_US' LIMIT 1
213: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=209 AND country_i18n.LOCALE='en_US' LIMIT 1
214: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=210 AND country_i18n.LOCALE='en_US' LIMIT 1
215: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=211 AND country_i18n.LOCALE='en_US' LIMIT 1
216: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=212 AND country_i18n.LOCALE='en_US' LIMIT 1
217: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=213 AND country_i18n.LOCALE='en_US' LIMIT 1
218: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=214 AND country_i18n.LOCALE='en_US' LIMIT 1
219: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=215 AND country_i18n.LOCALE='en_US' LIMIT 1
220: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=216 AND country_i18n.LOCALE='en_US' LIMIT 1
221: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=217 AND country_i18n.LOCALE='en_US' LIMIT 1
222: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=218 AND country_i18n.LOCALE='en_US' LIMIT 1
223: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=219 AND country_i18n.LOCALE='en_US' LIMIT 1
224: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=220 AND country_i18n.LOCALE='en_US' LIMIT 1
225: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=221 AND country_i18n.LOCALE='en_US' LIMIT 1
226: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=222 AND country_i18n.LOCALE='en_US' LIMIT 1
227: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=223 AND country_i18n.LOCALE='en_US' LIMIT 1
228: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=224 AND country_i18n.LOCALE='en_US' LIMIT 1
229: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=225 AND country_i18n.LOCALE='en_US' LIMIT 1
230: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=226 AND country_i18n.LOCALE='en_US' LIMIT 1
231: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=227 AND country_i18n.LOCALE='en_US' LIMIT 1
232: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=228 AND country_i18n.LOCALE='en_US' LIMIT 1
233: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=229 AND country_i18n.LOCALE='en_US' LIMIT 1
234: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=230 AND country_i18n.LOCALE='en_US' LIMIT 1
235: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=231 AND country_i18n.LOCALE='en_US' LIMIT 1
236: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=232 AND country_i18n.LOCALE='en_US' LIMIT 1
237: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=233 AND country_i18n.LOCALE='en_US' LIMIT 1
238: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=234 AND country_i18n.LOCALE='en_US' LIMIT 1
239: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=235 AND country_i18n.LOCALE='en_US' LIMIT 1
240: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=236 AND country_i18n.LOCALE='en_US' LIMIT 1
241: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=237 AND country_i18n.LOCALE='en_US' LIMIT 1
242: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=238 AND country_i18n.LOCALE='en_US' LIMIT 1
243: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=239 AND country_i18n.LOCALE='en_US' LIMIT 1
244: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=240 AND country_i18n.LOCALE='en_US' LIMIT 1
245: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=241 AND country_i18n.LOCALE='en_US' LIMIT 1
246: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=242 AND country_i18n.LOCALE='en_US' LIMIT 1
247: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=243 AND country_i18n.LOCALE='en_US' LIMIT 1
248: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=244 AND country_i18n.LOCALE='en_US' LIMIT 1
249: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=245 AND country_i18n.LOCALE='en_US' LIMIT 1
250: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=246 AND country_i18n.LOCALE='en_US' LIMIT 1
251: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=247 AND country_i18n.LOCALE='en_US' LIMIT 1
252: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=248 AND country_i18n.LOCALE='en_US' LIMIT 1
253: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=249 AND country_i18n.LOCALE='en_US' LIMIT 1
254: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=250 AND country_i18n.LOCALE='en_US' LIMIT 1
255: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=251 AND country_i18n.LOCALE='en_US' LIMIT 1
256: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=252 AND country_i18n.LOCALE='en_US' LIMIT 1
257: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=253 AND country_i18n.LOCALE='en_US' LIMIT 1
258: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=254 AND country_i18n.LOCALE='en_US' LIMIT 1
259: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=255 AND country_i18n.LOCALE='en_US' LIMIT 1
260: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=256 AND country_i18n.LOCALE='en_US' LIMIT 1
261: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=257 AND country_i18n.LOCALE='en_US' LIMIT 1
262: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=258 AND country_i18n.LOCALE='en_US' LIMIT 1
263: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=259 AND country_i18n.LOCALE='en_US' LIMIT 1
264: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=260 AND country_i18n.LOCALE='en_US' LIMIT 1
265: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=261 AND country_i18n.LOCALE='en_US' LIMIT 1
266: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=262 AND country_i18n.LOCALE='en_US' LIMIT 1
267: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=263 AND country_i18n.LOCALE='en_US' LIMIT 1
268: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=264 AND country_i18n.LOCALE='en_US' LIMIT 1
269: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=265 AND country_i18n.LOCALE='en_US' LIMIT 1
270: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=266 AND country_i18n.LOCALE='en_US' LIMIT 1
271: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=267 AND country_i18n.LOCALE='en_US' LIMIT 1
272: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT country_i18n.ID, country_i18n.LOCALE, country_i18n.TITLE, country_i18n.DESCRIPTION, country_i18n.CHAPO, country_i18n.POSTSCRIPTUM FROM `country_i18n` WHERE country_i18n.ID=268 AND country_i18n.LOCALE='en_US' LIMIT 1
273: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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 AND module.TYPE=2
274: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT module_i18n.ID, module_i18n.LOCALE, module_i18n.TITLE, module_i18n.DESCRIPTION, module_i18n.CHAPO, module_i18n.POSTSCRIPTUM FROM `module_i18n` WHERE module_i18n.ID=2 AND module_i18n.LOCALE='en_US' LIMIT 1
275: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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=true LIMIT 1
276: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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=true LIMIT 1
277: ERROR [Propel.php:log()] {284} 2014-07-23 21:51:48: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'coupon_version.VERSION_CREATED_AT' in 'field list'
278: ERROR [CouponController.php:logError()] {463} 2014-07-23 21:51:48: Error during Coupon update process : Désolé, une erreur est survenue: Unable to execute SELECT statement [SELECT coupon_version.ID, coupon_version.CODE, coupon_version.TYPE, coupon_version.SERIALIZED_EFFECTS, coupon_version.IS_ENABLED, coupon_version.EXPIRATION_DATE, coupon_version.MAX_USAGE, coupon_version.IS_CUMULATIVE, coupon_version.IS_REMOVING_POSTAGE, coupon_version.IS_AVAILABLE_ON_SPECIAL_OFFERS, coupon_version.IS_USED, coupon_version.SERIALIZED_CONDITIONS, coupon_version.PER_CUSTOMER_USAGE_COUNT, coupon_version.CREATED_AT, coupon_version.UPDATED_AT, coupon_version.VERSION, coupon_version.VERSION_CREATED_AT, coupon_version.VERSION_CREATED_BY FROM `coupon_version` WHERE coupon_version.ID=:p1 ORDER BY coupon_version.VERSION DESC LIMIT 1]. Exception was Unable to execute SELECT statement [SELECT coupon_version.ID, coupon_version.CODE, coupon_version.TYPE, coupon_version.SERIALIZED_EFFECTS, coupon_version.IS_ENABLED, coupon_version.EXPIRATION_DATE, coupon_version.MAX_USAGE, coupon_version.IS_CUMULATIVE, coupon_version.IS_REMOVING_POSTAGE, coupon_version.IS_AVAILABLE_ON_SPECIAL_OFFERS, coupon_version.IS_USED, coupon_version.SERIALIZED_CONDITIONS, coupon_version.PER_CUSTOMER_USAGE_COUNT, coupon_version.CREATED_AT, coupon_version.UPDATED_AT, coupon_version.VERSION, coupon_version.VERSION_CREATED_AT, coupon_version.VERSION_CREATED_BY FROM `coupon_version` WHERE coupon_version.ID=:p1 ORDER BY coupon_version.VERSION DESC LIMIT 1]
279: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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
280: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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
281: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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
282: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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
283: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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.BY_DEFAULT=true ORDER BY currency.POSITION ASC LIMIT 2147483647
284: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='html_output_trim_level' LIMIT 1
285: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:48: 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=true LIMIT 1
286: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/897ec46.ico
287: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: 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
288: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img
289: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/css/28c690c.css
290: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/css
291: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: 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
292: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/js/libs/97aefeb.js
293: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/js/libs
294: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: 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='1' ORDER BY lang.POSITION ASC LIMIT 2147483647
295: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/dc26dcf.png
296: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
297: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: 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` ORDER BY lang.POSITION ASC LIMIT 2147483647
298: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/dc26dcf.png
299: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
300: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/b30288d.png
301: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
302: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/6c25fd7.png
303: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
304: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/079356a.png
305: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
306: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/4249205.png
307: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
308: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/5f97308.png
309: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
310: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT COUNT(*) FROM `order`
311: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT order_status.ID, order_status.CODE, order_status.CREATED_AT, order_status.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 `order_status` LEFT JOIN `order_status_i18n` `default_locale_i18n` ON (order_status.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = 'fr_FR') LEFT JOIN `order_status_i18n` `requested_locale_i18n` ON (order_status.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)) LIMIT 2147483647
312: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT COUNT(*) FROM `order` WHERE order.STATUS_ID IN ('1')
313: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT COUNT(*) FROM `order` WHERE order.STATUS_ID IN ('2')
314: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT COUNT(*) FROM `order` WHERE order.STATUS_ID IN ('3')
315: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT COUNT(*) FROM `order` WHERE order.STATUS_ID IN ('4')
316: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT COUNT(*) FROM `order` WHERE order.STATUS_ID IN ('5')
317: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/3043bc4.png
318: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img
319: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/dc26dcf.png
320: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
321: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/b30288d.png
322: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
323: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/6c25fd7.png
324: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
325: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/079356a.png
326: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
327: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/4249205.png
328: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
329: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/5f97308.png
330: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
331: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/dc26dcf.png
332: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
333: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/dc26dcf.png
334: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
335: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags/dc26dcf.png
336: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/img/flags
337: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/js/libs/8283b77.js
338: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/js/libs
339: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/js/bootstrap/25fde85.js
340: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/js/bootstrap
341: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/js/71bc949.js
342: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/js
343: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/js/6e5a3ae.js
344: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/js
345: DEBUG [AsseticAssetManager.php:processAsset()] {306} 2014-07-23 21:51:49: Asset destination full path: /home/zzuutt/www/shop/web/assets/backOffice/default/0/js/2b5d90e.js
346: DEBUG [AsseticAssetManager.php:processAsset()] {313} 2014-07-23 21:51:49: Writing asset to /home/zzuutt/www/shop/web/assets/backOffice/default/0/js
347: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT module.ID, module.CODE, module.TYPE, module.ACTIVATE, module.POSITION, module.FULL_NAMESPACE, module.CREATED_AT, module.UPDATED_AT FROM `module` WHERE module.CODE='Maintenance' LIMIT 1
348: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='com.omnitic.maintenance_mode' LIMIT 1
349: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='com.omnitic.maintenance_allowed_ips' LIMIT 1
350: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='com.omnitic.maintenance_message' LIMIT 1
351: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='com.omnitic.maintenance_class_name' LIMIT 1
352: INFO [ConnectionWrapper.php:log()] {653} 2014-07-23 21:51:49: SELECT config.ID, config.NAME, config.VALUE, config.SECURED, config.HIDDEN, config.CREATED_AT, config.UPDATED_AT FROM `config` WHERE config.NAME='com.omnitic.maintenance_wrapper_tag' LIMIT 1

Offline

#15 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 07:51:50)

277: ERROR [Propel.php:log()] {284} 2014-07-23 21:51:48: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'coupon_version.VERSION_CREATED_AT' in 'field list'

Nous y voilà.

Bien joué, Callaghan, il manque une mise à jour dans 2.0.3.sql :

ALTER TABLE `coupon_version` ADD `version_created_at` DATE AFTER `version`;
ALTER TABLE `coupon_version` ADD `version_created_by` VARCHAR(100) AFTER `version_created_at`;

OpenStudio Toulouse

Offline

#16 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 08:27:48)

parfait
je peux tester in_use 

Merci !! smile

Offline

#17 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 09:35:08)

le discount n'est plus calcule
est ce normal ?

{order attr="discount"}

et si je rajoute cette boucle

{loop name="coupon-use" type="coupon" in_use=true}
{$CODE}
{/loop}

tous les codes promo sont retournes, sans que le client n'est saisi de code

Edit
Aucun coupon n'est pris en compte
le code du coupon est accepte mais aucun discount n'est calcule
$DISCOUNT_AMOUNT ne me retourne rien

Last edited by zzuutt (24-07-2014 11:14:32)

Offline

#18 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 11:17:40)

le discount n'est plus calcule
est ce normal ?

Mais oui, bien sûr smile

Aucun coupon n'est pris en compte
le code du coupon est accepte mais aucun discount n'est calcule
$DISCOUNT_AMOUNT ne me retourne rien

1) Tu es bien sur une 2.0.3 ?
2) Tu as fait un clear du cache ?
3) Tu es sûr que ton coupon est applicable à ton panier (essaie avec un coupon "simple", sans conditions d'utilisation) ?

Tout semble OK de mon côté, avec un 1ere boucle in_use=true, une seconde avec in_use=false, et un dernière sans in_use :

6KHveoU3I

EDIT: il y a un problème avec la condition "Total du panier", qui prend en compte le total HT au lieu du total TTC. Vérifie donc le point 3) ci-dessus.

Fix: https://github.com/thelia/thelia/pull/548

OpenStudio Toulouse

Offline

#19 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 12:52:52)

bon j'ai regarde les logs voici l'erreur

8: ERROR [Propel.php:log()] {284} 2014-07-24 13:50:19: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zzuuttshop.coupon_customer_count' doesn't exist

Offline

#20 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 12:58:46)

Bravo, encore un truc qui manque dans le fichier 2.0.3.sql :

-- ---------------------------------------------------------------------
-- coupon_customer_count
-- ---------------------------------------------------------------------

DROP TABLE IF EXISTS `coupon_customer_count`;

CREATE TABLE `coupon_customer_count`
(
    `coupon_id` INTEGER NOT NULL,
    `customer_id` INTEGER NOT NULL,
    `count` INTEGER DEFAULT 0 NOT NULL,
    INDEX `fk_coupon_customer_customer_id_idx` (`customer_id`),
    INDEX `fk_coupon_customer_coupon_id_idx` (`coupon_id`),
    CONSTRAINT `fk_coupon_customer_customer_id`
        FOREIGN KEY (`customer_id`)
        REFERENCES `customer` (`id`)
        ON UPDATE RESTRICT
        ON DELETE CASCADE,
    CONSTRAINT `fk_coupon_customer_coupon_id`
        FOREIGN KEY (`coupon_id`)
        REFERENCES `coupon` (`id`)
        ON UPDATE RESTRICT
        ON DELETE CASCADE
) ENGINE=InnoDB;

Merci zzuutt smile

OpenStudio Toulouse

Offline

#21 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 13:09:36)

je debugue l'install de la 2.0.3 wink

il faudrait rajouter lorsque l'on cree un coupon
et que l'on veut l'appliquer seulement a un produit
afficher dans la liste les combinaisons

Offline

#22 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 13:17:39)

dans order-invoice
j'ai mis cette boucle

                        {loop name="coupon-use" type="coupon" in_use="true"}
                            {$CODE}:{$DISCOUNT_AMOUNT}
                        {/loop}

tous les coupons s'affichent
1406204192-24-07-2014-14-16-09.jpg
rien en {$DISCOUNT_AMOUNT}
je n'ai utilise que 123456 et FreePort

Offline

#23 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 14:49:41)

Tu es sûr que tu as la bonne version de la boucle ? Celle qui prend en compte "in_use" ?

OpenStudio Toulouse

Offline

#24 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 15:13:34)

apparement quand j'ai copie le master il manquait la ligne in-use dans la boucle ligne 52
je retelecharge tout

Last edited by zzuutt (24-07-2014 15:30:47)

Offline

#25 Re: Lister les codes promos utilises sur la page Order-invoice

(24-07-2014 15:30:21)

maintenant cela marche mieux tongue

edit:
pour faire le clear, tu fais comment ?

Last edited by zzuutt (24-07-2014 15:42:43)

  • Index
  • Thelia 2 - Section française
  • Utilisation
  • Lister les codes promos utilises sur la page Order-invoice