SQL compatibility issue: {system} s
thekevinday - September 15, 2009 - 21:15
| Project: | Ajax |
| Version: | 6.x-1.14 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
The installer has a couple of update commands like so:
UPDATE {system} s SETNot specifying the AS will break any SQL languages that do not assume the AS keyword or have some sort of strict mode.
Please replace the code
UPDATE {system} s SETwith the following:
UPDATE {system} AS s SET