paginate_by_sql throwing error
-
Mark Booth
Probably should have mentioned that this is on Windows and using MS SQL as the database.
-
Chris Wanstrath
- State changed from new to open
- Assigned user changed from Chris Wanstrath to Mislav
-
Chris Wanstrath
- State changed from open to resolved
(from [299]) Will Paginate: in paginate_by_sql, do sanitize_sql before calling add_limit on the query string. This is because of SQL Sever adapter which does nasty hacks in add_limit_offset and it needs a full SQL string for that. Added a bang on wp_parse_options method, also. [Mark Booth] [#60 state:resolved]
-
Mislav
Thanks for the stack trace, it helped a lot. Otherwise I'd bang my head to the keyboard for hours.
I've worked around your problem which happened because sqlserver_adapter does some really nasty hacks here. It should resolve the issue; if it does not, please reopen this ticket with additional information. Thanks
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.