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 [email protected].
For more options, visit https://groups.google.com/d/optout.
