[INFO] SBST fails to create the MySQL database

MysteryFCM · **Joined:** Thu May 28, 2009 11:25 am **Posts:** 3576

I've had a few people having issues with the SBST not creating the MySQL database. Sadly, I've not been able to reproduce this. If you experience this issue, you can create the database manually using the following. Please note you will need phpMyAdmin for this.

1. Load phpMyAdmin in your browser

If you do not have phpMyAdmin, you can get it here

2. Once logged into phpMyAdmin, if "Create new database" states "No Privileges", you will need to re-login as a user that does have such.

If however, there's a box to enter the database name, enter sbst in the box. Leave the dropdown as "Collation", and click Create.

If you have cPanel, you can use this instead, to create the database by scrolling to the MySQL database options.

ShadowPuterDude · **Joined:** Sat May 30, 2009 2:36 am **Posts:** 5

Once you have created the SBST SQL database, run the following SQL queries to create the necessary tables:

Code:

CREATE TABLE IF NOT EXISTS tblspammers(fldspammer_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY(fldspammer_id), fldspammer_name varchar(255), fldspammer_ip varchar(15), fldspammer_mail varchar(255), flddb_matched varchar(255), fldadded DATE, fldspammer_count int)

CREATE TABLE IF NOT EXISTS tblspamcount(fldspam_count int)

MysteryFCM · **Joined:** Thu May 28, 2009 11:25 am **Posts:** 3576

hehe cheers SPD ... knew I'd forgotten to mention something :oops:

[INFO] SBST fails to create the MySQL database

Who is online