SMF Support > Converting to SMF

Question on SQL + SMF2

<< < (2/2)

LakeXeno:
I tried and received this error:


--- Code: ---#1054 - Unknown column 'ID' in 'where clause'

--- End code ---

This what I used (a specific message ID)

--- Code: ---update smf_messages set FIELD= replace(FIELD,"\'","'") where ID=12335

--- End code ---

Tony Reid:
try this


--- Code: ---update smf_messages set FIELD= replace(FIELD,"\'","'") where id_msg=12335
--- End code ---

Also, are you sure thats the correct id - is that the message id or the topic id? if its the topic id then you would use id_topic instead

Navigation

[0] Message Index

[*] Previous page