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.

https://vborg.vbsupport.ru/external/2015/03/37.png

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??

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.

https://vborg.vbsupport.ru/external/2015/03/36.png

is there the dot hide before "vb_usertextfield"

[kh99]

It come this error.

https://vborg.vbsupport.ru/external/2015/03/36.png

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 1425253065 at 1425253065 ---------------

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?

[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]

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.