XF 2.2 Which table in the database contains the board URL?

[Adam Bloch]

Just been liking for the site URL in the database. I thought it was in the xf_option table can't seem to find it there.

 

[Paul B]

What are you trying to do?

 

[Adam Bloch]

I'm still trying to sort out my redirects problem and just wanted to makes sure that the path was good in the database.

 

[Adam Bloch]

I know I have seen it but can't find it on here for a MYSQL script to change all the http:// to htpps:// in the database...

 

[Paul B]

If it's set correctly in the ACP then it will be correct in the DB.

There's an add-on to change post content but for 'simple' changes you can run a direct query.

UPDATE xf_post SET message = REPLACE(message, 'http://www.example', 'https://example');

Take a backup first.

 

[Adam Bloch]

What if I want to do more than the posts table?

 

[Paul B]

Change the name of the table and the column in the query

 

[Adam Bloch]

lol that upset the server, I got a 500

 

[Adam Bloch]

I'm guessing there is a timeout or too many for it to handle on the simulate. Works if it doesn't find anything