Change prefix

[Fréderic]

I've installed the CPG, but when I did this, I've chosen to use a prefix 'Gallery_'. But now, I want to rename it. There are a lot of pictures online, so is it OK to change te name in PHPmyadmin and then in config.php?
I've tried to open config.php.inc in the inc folder, but I get:

227 Entering Passive Mode (....).
    Opening data connection (....)
    RETR config.inc.php
550 config.inc.php: Permission denied
    NOOP
200 NOOP command successful
    PASV
227 Entering Passive Mode (....).
    Opening data connection (....)
    RETR config.inc.php
550 config.inc.php: Permission denied
    SITE CHMOD 777 config.inc.php
550 config.inc.php: Operation not permitted

[Casper]

You will have to edit your include/config.inc.php.  Try copying it to your harddrive, edit it there, and then overwrite the old one.

If you can't do this, then you should leave the table prefix alone.

[Joachim Müller]

why change it in the first place? Nobody will see it, except you. I wouldn't go through all these troubles, I recommend you leave it alone.

Joachim

[Fréderic]

You will have to edit your include/config.inc.php.  Try copying it to your harddrive, edit it there, and then overwrite the old one.

If you can't do this, then you should leave the table prefix alone.

Hmmm, I get the same error when I try to copie it... I want to change the prefix because there's a new part of my site with the name of the current prefix... Otherwise it will become pretty messy? Like this=

'Gallery' uses prefix 'Pictures'
'Coppermine' uses prefix 'Gallery'

[Joachim Müller]

if you encounter the error you mentioned above, this usually means that the file include/config.inc.php isn't owned by you, but the webserver (they appear to run under different permission level). This usually indicates improper (or poor) webserver setup. Contact your webhost and ask the to CHOWN the file for you - they will know what this means.

Joachim

[Fréderic]

OK, they've changed the permissions... But before I edit the config file, I need to make sure it's okay to edit the file and to just edit the databasetables names??

[Nibbler]

That is fine. If you get db errors remember to enable debug mode and see what they are. May be some probs if you specified the exact prefix in any mod somewhere,

[Fréderic]

Ow damn, I've visited my gallery, and since the permissions on config.inc.php have been changed, I get following eroor::

Warning: main(include/config.inc.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/........./include/init.inc.php on line 201

Warning: main(include/config.inc.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/........./include/init.inc.php on line 201

Fatal error: main(): Failed opening required 'include/config.inc.php' (include_path='.:/usr/local/psa/home/vhosts/..../httpdocs') in /usr/local/psa/home/vhosts/......../include/init.inc.php on line 201

Nothing changed Only the permissions

[Nibbler]

Looks like the file is gone. You can recreate it using the sample file.