How to run this query?

M

monoxera

New Member
After import, IMG tag not working? - vBulletin Community Forum

in your db, execute the queries:
UPDATE vb_post SET pagetext=REPLACE(pagetext,"& #46;",".")
UPDATE vb_post SET pagetext=REPLACE(pagetext,"& #58;",":")

(remove whitespaces)
Click to expand...

I'm trying to run that. What does he mean by whitespaces?

Thank you

I'm familiar with phpmyadmin/running sql queries but never heard of that "slang".

Also do I need to run that in phpmyadmin or vBulletin >maintenance>run sql query?
 
You would run the queries in an SQL window.

You probably should run them one at a time or put a semicolon at the end of each line if you run them together. I believe the white space is what the query fixes.
 
bluescorpion said:
You would run the queries in an SQL window.

You probably should run them one at a time or put a semicolon at the end of each line if you run them together. I believe the white space is what the query fixes.
Click to expand...

PHPMYADMIN

or

vBulletin run SQL query in Maintenance?
 
vb_ is the DB table prefix change it for your own or remove if you have not set a prefix in includes/config.php
 
Yea my prefix is blank.

So it would look like:

Code: 
UPDATE post SET pagetext=REPLACE(pagetext,"& #46;",".")
UPDATE post SET pagetext=REPLACE(pagetext,"& #58;",":")

remove space between & #46 and #58

Edit I tried that but it said:

Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE post SET pagetext=REPLACE(pagetext,":",":")' at line 2
Click to expand...


Edit I just fixed it yay!

I had to run sql seperately

UPDATE post SET pagetext = REPLACE(pagetext,"& #46;",".");
UPDATE post SET pagetext = REPLACE(pagetext,"& #58;",":");
 
You must log in or register to reply here.
Back
Top