• Welcome to Simple Machines Community Forum. Please login or sign up.
September 17, 2021, 04:21:23 PM

News:

Want to get involved in developing SMF, then why not lend a hand on our github!


SQL Database Error

Started by JayinGR, January 08, 2010, 01:13:29 PM

Previous topic - Next topic

JayinGR

I am getting this error when I try an upload the database into the SQL

QuoteError

SQL query:

CREATE TABLE `smf_3log_digest` (
id_topic mediumint( 8 ) unsigned NOT NULL default,
id_msg int( 10 ) unsigned NOT NULL default,
note_type varchar( 10 ) NOT NULL default 'post',
daily smallint( 3 ) unsigned NOT NULL default 0,
exclude mediumint( 8 ) unsigned NOT NULL default 0
) TYPE = MYISAM ;

MySQL said: Documentation
#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 '
  id_msg int(10) unsigned NOT NULL default ,
  note_type varchar(10) NOT NULL' at line 2

Can someone help me?

Thanks

feline

you have not defined a valur for default ...
id_topic mediumint( 8 ) unsigned NOT NULL default,
id_msg int( 10 ) unsigned NOT NULL default,

better:
id_topic mediumint( 8 ) unsigned NOT NULL default 0,
id_msg int( 10 ) unsigned NOT NULL default 0,

Fel

JayinGR

Thanks for your reply!  How would I fix that?

feline

if you use a mod, call the author. else look at the file on what the code is written...

Fel

Advertisement: