Query conflict with table prefix

[kh99]

Can you do this query:

show tables like '%usertextfield'

and post the result?

[markoroots]

Hi,
this is the result:

vb4_usertextfield

[kh99]

OK, then you want to do this:

UPDATE 
vb4_usertextfield
SET 
signature = REPLACE(signature, 'sigarettaeletronicaforum.it', 'sigarettaeletronicaforum.com')

You should have a backup of your database before trying things like this. A small mistake can cause you to lose data or cause your forum to break.

[markoroots]

Thanks Kevin.
Done.
And now?

[kh99]

Originally Posted by markoroots

And now?

I don't understand. When you say "Done", do you mean done making a backup? Then you're ready to try the query posted above.

[markoroots]

Ah sorry...
I mean that I have made what you have said.
Made a db backup and I have started also the query you tell me.

The response is:
"Lines processed: 0"
All is gone with no errors.

[markoroots]

Any news??

[kh99]

Sorry, I'm not sure what you need. It sounded to me like you got it to work.

[markoroots]

Wow sorry...
Was just finish what we were making about what I ask and everything is gone good.
Word changed.
Thanks again Kh99.