View Single Post
  #2  
Old 08-26-2009, 09:51 AM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 387
Default

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"
Reply With Quote