Just tested now with a newly downloaded copy of eqitems (14.4.13) and newly installed OBDC drivers (3.51) to make sure i was up to date.
DB is still PEQ 946
It failed on saving an un-edited (non-copy) item, failed on saving an edited (non-copy) item, saving an un-edited copy, and saving an edited copy. (this time i tried on id 47344 (Abhorrent Brimestone of Charring)
could it be that MySQL 5.1.37 has something new that doesn't like that query?
Using NaviCat 8.2.11 i ran the query:
update items set range=0 where id=47344
it failed
"[SQL] update items set range=0 where id=47344
[Err] 1064 - 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 'range=0 where id=47344' at line 1"
|