How to change xoops sql table prefixes? [Installation Troubleshooting]

1

How to change xoops sql table prefixes?

2006/1/17 13:03
allnewtome
Not too shy to talk
Posts: 175
Since: 2005/11/30

When I installed XOOPS I omitted to change the sql table prefix from "xoops". I now understand that, security-wise, I should have changed this.

How can I change this now, without re-installing? Is it as simple as
1. Rename the tables
2. Change the constant in mainfile.php

If so, what's the easiest way to do number 1?

Thanks.

2

Re: How to change xoops sql table prefixes?

2006/1/17 13:15
bluenova
Posts: 1022
Since: 2004/4/10

If you install xoops protector, which I strongly suggest having on all XOOPS sites as well for added security, there is an option in there to change the table prefix.

3

Re: How to change xoops sql table prefixes?

2006/1/17 13:17
allnewtome
Not too shy to talk
Posts: 175
Since: 2005/11/30

Thank you very much for your quick reply.

Do you use Protector with XOOPS 2.2.3?

(I only ask becuase lots of modules don't seem to work with 2.2.3)

4

Re: How to change xoops sql table prefixes?

2006/1/20 23:56
allnewtome
Not too shy to talk
Posts: 175
Since: 2005/11/30

Anyone????

5

Re: How to change xoops sql table prefixes?

2006/1/21 0:00
jdseymour
Friend of XOOPS
Posts: 3782
Since: 2004/11/11

Yes protector does work with 2.2.3.

Get the latest
Here.

Proactive Support for Sites and Servers

WebServerMasters.com | XOOPS Tutorials

6

Re: How to change xoops sql table prefixes?

2006/1/21 0:03
allnewtome
Not too shy to talk
Posts: 175
Since: 2005/11/30

Ta!

Stats
Goal:	$100.00
Due Date:	May 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

How to change xoops sql table prefixes?

Re: How to change xoops sql table prefixes?

Re: How to change xoops sql table prefixes?

Re: How to change xoops sql table prefixes?

Re: How to change xoops sql table prefixes?

Re: How to change xoops sql table prefixes?

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}