Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-15-2007, 05:56 PM
pixelpunk's Avatar
pixelpunk pixelpunk is offline
 
Join Date: Apr 2002
Location: Memphis, Tn
Posts: 56
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default So I ran /install/tableprefix.php

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?
Reply With Quote
  #2  
Old 07-15-2007, 06:13 PM
G0F0RBR0KE G0F0RBR0KE is offline
 
Join Date: Mar 2005
Posts: 987
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

try one of these

Code:
$config['Database']['tableprefix'] = '_';
or

Code:
$config['Database']['tableprefix'] = '-';
Reply With Quote
  #3  
Old 07-15-2007, 08:34 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you looked at what your tables are actually called.
Reply With Quote
  #4  
Old 07-15-2007, 10:25 PM
pixelpunk's Avatar
pixelpunk pixelpunk is offline
 
Join Date: Apr 2002
Location: Memphis, Tn
Posts: 56
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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';

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

Reply With Quote
  #5  
Old 07-15-2007, 11:18 PM
Roms's Avatar
Roms Roms is offline
 
Join Date: Jun 2004
Location: Witness ProtectionProgram
Posts: 1,841
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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...
Reply With Quote
  #6  
Old 07-16-2007, 08:48 AM
G0F0RBR0KE G0F0RBR0KE is offline
 
Join Date: Mar 2005
Posts: 987
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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'] = ''
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:37 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03676 seconds
  • Memory Usage 2,223KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (4)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete