Check Website
Inclusion Status
It is currently Tue Oct 16, 2018 3:10 pm

All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: [INFO] SBST fails to create the MySQL database
PostPosted: Sun Jun 14, 2009 8:00 pm 
Offline
Site Admin

Joined: Thu May 28, 2009 10:25 am
Posts: 6016
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.

_________________
Regards
Steven Burn
I.T. Mate / hpHosts
it-mate.co.uk / hosts-file.net

Keeping it FREE!



IP:
top
Top
 Profile  
Reply with quote  
 Post subject: Re: [INFO] SBST fails to create the MySQL database
PostPosted: Mon Jun 15, 2009 2:01 am 
Offline
User avatar

Joined: Sat May 30, 2009 1:36 am
Posts: 8
Location: Depauville, NY
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)

_________________
Kevin Zoll
Emsisoft Team - http://www.emsisoft.com



IP:
top
Top
 Profile  
Reply with quote  
 Post subject: Re: [INFO] SBST fails to create the MySQL database
PostPosted: Mon Jun 15, 2009 12:42 pm 
Offline
Site Admin

Joined: Thu May 28, 2009 10:25 am
Posts: 6016
hehe cheers SPD ... knew I'd forgotten to mention something :oops:

_________________
Regards
Steven Burn
I.T. Mate / hpHosts
it-mate.co.uk / hosts-file.net

Keeping it FREE!



IP:
top
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
hpHosts and hpHosts Online are copyright © Malwarebytes Corp - All Rights Reserved

Powered by phpBB © 2000-2009 phpBB Group