So I ran /install/tableprefix.php

[pixelpunk]

per this post: http://www.vbulletin.com/forum/showp...2&postcount=10




So this morning I ran /install/tableprefix.php to rename my tables...

Initially they had a prefix of 'sun' and i renamed the prefix to ' ', or I left the second field blank to remove the prefix. I downloaded the config.php and changed the line

$config['Database']['tableprefix'] = 'sun';

to read

$config['Database']['tableprefix'] = '';

Well now when I go to view my forum I get nothing, just a blank page . There's nothing in my browser window and when I view the source it's blank too.


So I ran /install/tableprefix.php again. The old table prefix is listed as a bar so I'm assumming it knows there's not one. I asked it to rename my tables back to include a prefix of 'sun' and then changed the config.php back to accomodate the prefix.

$config['Database']['tableprefix'] = 'sun';

Uploaded it and still all I get is a blank page for my vb index as well as my admin control panel.

What happened?

[G0F0RBR0KE]

Do you have a prefix in your database that contains - or _

try one of these

$config['Database']['tableprefix'] = '_';

or

$config['Database']['tableprefix'] = '-';

[Paul M]

Have you looked at what your tables are actually called.

[pixelpunk]

    //    ****** DATABASE NAME ******
    //    This is the name of the database where your vBulletin will be located.
    //    This must be created by your webhost.
$config['Database']['dbname'] = 'sunshine_sun';

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'sun';

After running the script I changed

$config['Database']['tableprefix'] = 'sun';
to
$config['Database']['tableprefix'] = '';





Should I have also changed

$config['Database']['dbname'] = 'sunshine_sun';
to
$config['Database']['dbname'] = 'sunshine';


?


here's how it looks from phpmyadmin

[Roms]

From looking at the phpadmin, this should be the correct setting:

PHP Code:

 // ****** DATABASE NAME ******
 // This is the name of the database where your vBulletin will be located.
 // This must be created by your webhost.
$config['Database']['dbname'] = 'sunshine_sun';
 // ****** TABLE PREFIX ******
 // Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'sun'; 


Try clearing your cookies and cache to see the effect...

[G0F0RBR0KE]

If that doesn't work

Try this

PHP Code:

 //    ****** DATABASE NAME ******
    //    This is the name of the database where your vBulletin will be located.
    //    This must be created by your webhost.
$config['Database']['dbname'] = 'sunshine_sun';

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '-'; 


PHP Code:

 //    ****** DATABASE NAME ******
    //    This is the name of the database where your vBulletin will be located.
    //    This must be created by your webhost.
$config['Database']['dbname'] = 'sunshine_sun';

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '_'; 


or

PHP Code:

 //    ****** DATABASE NAME ******
    //    This is the name of the database where your vBulletin will be located.
    //    This must be created by your webhost.
$config['Database']['dbname'] = 'sunshine_sun';

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';