The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Query conflict with table prefix
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. |
#2
|
|||
|
|||
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: Code:
// ****** TABLE PREFIX ****** // Prefix that your vBulletin tables have in the database. $config['Database']['tableprefix'] = 'vb_'; Code:
UPDATE vb_usertextfield SET signature =....etc |
#3
|
|||
|
|||
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:
|
#4
|
|||
|
|||
Well, you still need the rest of it there, I just didn't want to type it all. But it would be:
Code:
UPDATE vb_usertextfield SET signature = REPLACE(signature, 'sigarettaeletronicaforum.it', 'sigarettaeletronicaforum.com') Hopefully I spelled those right. |
#5
|
|||
|
|||
It come this error.
is there the dot hide before "vb_usertextfield" |
#6
|
|||
|
|||
Quote:
No, if your table prefix is 'vb_', then I think that should have worked. Are you sure the prefix is vb_? |
#7
|
|||
|
|||
UPDATE `usertextfield` SET `signature`='text here'
if you are trying to put text in the sig field use the above query |
#8
|
|||
|
|||
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_' |
#9
|
||||
|
||||
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 |
#10
|
|||
|
|||
Ahh ok. Good to know.
Thanks So what I can do to fix this issue? |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|