Error make database with phpMyAdin

Need help with fSpamList? Post here! (DO NOT post removal requests here)

Moderator: fspamlist

sm6gqw
Posts: 2
Joined: Sun Mar 13, 2011 3:55 am
experience: I can do more than turn on PC
PC time: Alot more than I should
Location: Sweden
Contact:

Error make database with phpMyAdin

Postby sm6gqw » Mon Mar 14, 2011 7:07 am

I have make sbst with phpMyAdmin and Added

Code: Select all

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
)

and get this error:

Code: Select all

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS tblspamcount(fldspam_count int)' at line 3


Using SpamBot Search Tool v0.52 - Any tips?
WinXP, XAMPP server (Apache php etz) Running PhpBB3 message board.

User avatar
MysteryFCM
Site Admin
Site Admin
Posts: 3721
Joined: Sun May 15, 2005 12:42 pm
Location: Newcastle, UK
Contact:

Re: Error make database with phpMyAdin

Postby MysteryFCM » Mon Mar 14, 2011 9:31 am

That's a bit strange.

I can't see anything obvious that would cause it, but PHP and MySQL seem to have their own fancy quirks that result in wierd behaviour occasionally.

Until It is resolved, you may want to consider creating the database manually.
Regards

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

Keeping it FREE!

sm6gqw
Posts: 2
Joined: Sun Mar 13, 2011 3:55 am
experience: I can do more than turn on PC
PC time: Alot more than I should
Location: Sweden
Contact:

Re: Error make database with phpMyAdin

Postby sm6gqw » Mon Mar 14, 2011 6:07 pm

I have try to creating the database manually but can not understand English enough. Have same setup on two computers with same result.

My phpbb3 forum and SBST work perfect together. But the UI have trouble. Ut will be on other treed .

/Björn
WinXP, XAMPP server (Apache php etz) Running PhpBB3 message board.

fspamlist
Spam Fighter
Spam Fighter
Posts: 42
Joined: Fri Jan 04, 2008 9:29 am
experience: I know the functions, OS settings, registry tweaks and more
PC time: Over an hour a day, give or take
Contact:

Re: Error make database with phpMyAdin

Postby fspamlist » Mon Apr 11, 2011 3:59 pm

Code: Select all

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

User avatar
MysteryFCM
Site Admin
Site Admin
Posts: 3721
Joined: Sun May 15, 2005 12:42 pm
Location: Newcastle, UK
Contact:

Re: Error make database with phpMyAdin

Postby MysteryFCM » Mon Apr 11, 2011 4:13 pm

Cheers Josh :) (I'd not noticed this post)
Regards

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

Keeping it FREE!


Return to “Help and Support”

Who is online

Users browsing this forum: No registered users and 1 guest