Major Help Needed

[Battle_Ring]

How do i create a table with phpmyadmin

[Battle_Ring]

gettign this error on my forum

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT userid FROM usersonline WHERE userid=1
mysql error: Table 'chrisr_HipHopStreetz.usersonline' doesn't exist

mysql error number: 1146

Date: Thursday 01st of July 2004 11:30:46 PM
Script: http://www.hip-hop-streetz.com/forum...ncp/index.php?
Referer:

[Battle_Ring]

i renames one of my warnign Tables to usersonline now i get this

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT userid FROM usersonline WHERE userid=1
mysql error: Unknown column 'userid' in 'field list'

mysql error number: 1054

Date: Friday 02nd of July 2004 12:00:12 AM
Script: http://www.hip-hop-streetz.com/forums

[Jolten]

I don't know a lot about administration of MySql Ddatabases but just randomly renaming tables is a very very bad idea.

Sorry i can't help with the error.

[Reeve of shinra]

In your vb config file did you specify "chrisr_" as the table prefix?

It sounds like you did but when installing vb you didnt use a table prefix and vb can't find the files your looking for.

If this is your first install... you should start from scratch. Might be better that way. Otherwise -- undo the name changes and fix what I said above.

[Battle_Ring]

No its not a first isntal i was tryign to un instal a hack

[CJPC]

Im saying you screwedsomething up, hopefully you backed up your DB and can re-insert it , so you can get back to normal, and i would have someone that knows a tad bit more about sql throw it in!

Many hacks i put in my board i need to alter, you may need to do the same!