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!! :)
--
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.
