invalid LIMIT for Postgres
nezroy - September 16, 2008 - 17:59
| Project: | Image FUpload |
| Version: | 6.x-3.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
On line 101 of image_fupload.module, there is an SQL statement with a LIMIT #, # format. This format is not supported by Postgres. A simple "LIMIT 1" is supported, however, and seems to be how limits are handled elsewhere in the code.

#1
Also, for that matter, on line 121, Postgres does not currently support LIMIT on UPDATE/DELETE SQL.
#2
OK, I will probably fix it, but you could provide a patch ;)
#3
Should be fixed in CVS Head now.
#4
Automatically closed -- issue fixed for two weeks with no activity.