Query conflict with table prefix

[markoroots]

Hi there,
I have moved my forum to a new url.
Now I'm changing all the old value to the new.

So I was running a query to change in all the forum the old name of the forum with the new one, but when I run the query it says that is there an error relative to the table prefix.



So is there someone that can help me to fix this?

Thanks in advance.

[kh99]

The part before the dot is the database name. But if you have a table prefix defined in your includes/config.php file, then you need to include that before the table name.

For example, if your config.php has this:

	//	****** TABLE PREFIX ******
	//	Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'vb_';

Then you would need:

UPDATE 
vb_usertextfield
SET 
signature =....etc

[markoroots]

Hi Kh99 and many thanks for you reply.
The prefix in the config and also in the database is "vb_"

So I have to run the query in this way??

PHP Code:

UPDATE 
vb_usertextfield
SET 
signature =vb_ 


[kh99]

Well, you still need the rest of it there, I just didn't want to type it all. But it would be:

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

Hopefully I spelled those right.

[markoroots]

It come this error.



is there the dot hide before "vb_usertextfield"

[kh99]

Originally Posted by markoroots

It come this error.



is there the dot hide before "vb_usertextfield"

No, if your table prefix is 'vb_', then I think that should have worked. Are you sure the prefix is vb_?

[ForceHSS]

UPDATE `usertextfield` SET `signature`='text here'
if you are trying to put text in the sig field use the above query

[markoroots]

Hi guys and thanks for your replies.
Yes the prefix on the database and also in the config is "vb_"
for this look strange...
do you think that with this query I can fix this issue?

UPDATE `usertextfield` SET `signature`='vb_'

[bridge2heyday]

No , this will delete all signature text and set it to 'vb_' , I advice you not to do this yourself

--------------- Added [DATE]1425253065[/DATE] at [TIME]1425253065[/TIME] ---------------

If you are going to do it yourself , I recommend using this tool
https://github.com/interconnectit/Search-Replace-DB

[markoroots]

Ahh ok. Good to know.
Thanks
So what I can do to fix this issue?