Version
2.17.2-stable+timestamp.2018.10.06.18.54.02
(Running on gunicorn/19.0.0, Python 2.7.9)
El lunes, 24 de diciembre de 2018, 14:46:46 (UTC-6), Dave S escribió:
>
>
>
> On Sunday, December 23, 2018 at 8:29:50 PM UTC-8, Armando Hernandez wrote:
>>
>> Hello,
>>
>> i have an error when i try to export smartgrid data, smart grid displays
>> fine, but when i try to export data (click on the Export: [CSV] button) i
>> have the following error:
>>
>> <class 'gluon.contrib.pymysql.err.ProgrammingError'> (1064, u'You have an
>> error in your SQL syntax; check the manual that corresponds to your MySQL
>> server version for the right syntax to use near \'."record_id",
>> "doc"."object_name", "doc"."email_address", "doc"."deliverytime", \' at
>> line 1')
>>
>> i have logged the sql query that fails in mysql and this is it:
>>
>> SELECT "doc"."record_id", "doc"."object_name", "doc"."email_address",
>> "doc"."deliverytime", "doc"."status", "doc"."accepted_on",
>> "doc"."delivered_on", "doc"."failed_on", "doc"."opened_on",
>> "doc"."clicked_on" FROM `doc` WHERE ((`doc`.`id` IS NOT NULL) AND
>> (`doc`.`campaign` = 20)) ORDER BY `doc`.`id`
>>
>> i have manually replaced the double quotes (") with the backtick (`) :
>> `doc`.`record_id` ... and then the query runs fine in mysql console.
>>
>> i don't know which function is creating this query with double quotes
>> instead of the backtick, export to CSV used to work in older web2py
>> versions, what do you recommend?
>>
>>
>> Thanks
>>
>> Greetings from Mexico!! :)
>>
>>
> Feliz Navidad!
>
> Which verison of web2py are you running, and which version of Python are
> you running it on?
>
> /dps
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
