Skip to content

Instantly share code, notes, and snippets.

View jbq's full-sized avatar

Jean-Baptiste Quenot jbq

View GitHub Profile
Traceback (most recent call last):
File "/Users/jbq/Dropbox/CML-ID/Lib/pycmlid/scripts/excel_writer_stats_by_month", line 49, in <module>
wb.save("%s.xlsx" % table)
File "/Library/Python/2.7/site-packages/openpyxl/workbook.py", line 263, in save
save_dump(self, filename)
File "/Library/Python/2.7/site-packages/openpyxl/writer/dump_worksheet.py", line 254, in save_dump
writer.save(filename)
File "/Library/Python/2.7/site-packages/openpyxl/writer/excel.py", line 170, in save
self.write_data(archive)
File "/Library/Python/2.7/site-packages/openpyxl/writer/excel.py", line 76, in write_data
SQL> select count(*) a, trim(oachid) from oohead where oaadid='ÚÚÚÚÚÚ' and oaordt like '2014%' group by trim(oachid) order by a desc
+------------+-----------+
| A | 00002 |
+------------+-----------+
| 175 | FACTURELV |
| 93 | MANDRE |
| 53 | AHONCZARUK|
| 40 | SMORAND |
| 20 | SVALCROZE |
| 19 | AIVARS |
SQL> select count(*) a, okcfc1, cttx40 from oohead left join ocusma on oacuno=okcuno left join csytab on ctstco='CFC1' and ctstky=okcfc1 where oaadid='ÚÚÚÚÚÚ' and oaordt like '2014%' group by okcfc1, cttx40 order by a desc
+------------+-----------+-----------------------------------------+
| A | OKCFC1 | CTTX40 |
+------------+-----------+-----------------------------------------+
| 152 | 400DC | André Myriam |
| 91 | 400VK | Morand Stéphanie |
| 57 | 400M1 | Valcroze Sandrine |
| 42 | 400F1 | Ivars Amandine |
| 36 | 400ND | Deschamp Nelly |
| 32 | 400Y1 | Nguyen Véronique |
Nov 24 09:12:47 127.0.0.1 Accès refusé
Désolé, vous n'êtes pas autorisé à accéder à ce document. Seuls les utilisateurs avec les niveaux d'accès suivants sont actuellement autorisé à faire cela:
- Purchases/User
- Purchases/Manager
- Warehouse/User
(Modèle de document: purchase.order)
Traceback (most recent call last):
File "/srv/dropbox/Dropbox (CML-ID)/OpenCMLRepo/Prod/odoo/openerp/netsvc.py", line 298, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
2014-11-28T10:07:50+01:00 EMERG (0): 14 MB | () [23]: [Exception] with message: Call to undefined method getFournisseur in class Object_FamilleAGE
In file: /srv/pimcore/data/pimcore/lib/Pimcore/Model/Abstract.php on line 225
#0 /srv/pimcore/data/pimcore/models/Object/Abstract.php(1021): Pimcore_Model_Abstract->__call('getFournisseur', Array)
#1 /srv/dropbox/Dropbox (CML-ID)/PimcoreRepo/Prod/ExtendedList/controllers/ExtendedlistController.php(663): Object_Abstract->__call('getFournisseur', Array)
#2 /srv/dropbox/Dropbox (CML-ID)/PimcoreRepo/Prod/ExtendedList/controllers/ExtendedlistController.php(663): Object_FamilleAGE->getFournisseur()
#3 /srv/pimcore/data/pimcore/lib/Zend/Controller/Action.php(516): ExtendedList_ExtendedlistController->gridProxyAction()
#4 /srv/pimcore/data/pimcore/lib/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('gridProxyAction')
#5 /srv/pimcore/data/pimcore/lib/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Con
<br />
<b>Warning</b>: usort() expects parameter 1 to be array, null given in <b>/srv/pimcore/data/pimcore/models/Object/Class/Data/ObjectsMetadata.php</b> on line <b>560</b><br />
<br />
<b>Warning</b>: Invalid argument supplied for foreach() in <b>/srv/pimcore/data/pimcore/models/Object/Class/Data/ObjectsMetadata.php</b> on line <b>564</b><br />
<br />
<b>Warning</b>: usort() expects parameter 1 to be array, null given in <b>/srv/pimcore/data/pimcore/models/Object/Class/Data/ObjectsMetadata.php</b> on line <b>560</b><br />
<br />
<b>Warning</b>: Invalid argument supplied for foreach() in <b>/srv/pimcore/data/pimcore/models/Object/Class/Data/ObjectsMetadata.php</b> on line <b>564</b><br />
<br />
<b>Warning</b>: usort() expects parameter 1 to be array, null given in <b>/srv/pimcore/data/pimcore/models/Object/Class/Data/ObjectsMetadata.php</b> on line <b>560</b><br />
{
"uwsgi": {
"socket": "127.0.0.1:3030",
"php-allowed-ext": [".php"],
"plugins": ["php"],
"uid": "www-data",
"gid": "www-data"
}
}
server {
listen 80;
server_name my.server.name;
root /srv/pimcore/data;
# no limit on upload size
client_max_body_size 0;
# allow access to plugin-data and core assets ( done by excluding .*/static and static)
@jbq
jbq / gist:784c2734cdadcbe71917
Last active August 29, 2015 14:11
Working response
$ curl -i -b pimcore_admin_sid=afp... http://localhost/admin/asset/get-image-thumbnail/id/12704/treepreview/true_dc=1418114770601
HTTP/1.1 200 OK
Server: nginx/1.4.6 (Ubuntu)
Date: Tue, 09 Dec 2014 09:16:16 GMT
Content-Type: image/pjpeg
Content-Length: 2
Connection: keep-alive
Cache-Control: public, max-age=300
Expires: Tue, 09 Dec 2014 10:21:16 +0100
Pragma:
@jbq
jbq / gist:28f647858b9cc59acb5a
Last active August 29, 2015 14:11
Bad response
$ curl -i -b pimcore_admin_sid=qsn... http://localhost/admin/asset/get-image-thumbnail/id/12704/treepreview/true_dc=1418114770601
HTTP/1.1 200 OK
Server: nginx/1.4.6 (Ubuntu)
Date: Tue, 09 Dec 2014 09:17:50 GMT
Content-Type: image/pjpeg
Content-Length: 2
Connection: keep-alive
Cache-Control: public, max-age=300
Expires: Tue, 09 Dec 2014 10:22:50 +0100
Pragma: