Clan Adverts

DarkForge Gaming

www.clan-themes.co.uk :: View topic - Help needed with auc1.05 sql

 Welcome To Clan Themes 

As the board grows please remember the Search Option and we hope you find our community useful.

We also monitor Private Messages to stop members from abusing our sites system.
If you are asking for assistance please provide your site link and nuke version, Thanks.
Help needed with auc1.05 sql

4 Replies / 178 Views
Post new topic   Reply to topic  

   www.clan-themes.co.uk Forum Index » PHPBB

View previous topic :: View next topic

Jebo-Devil
Reputation: 452.2
votes: 1
Local time: 10:06 PM
Location: Antwerp
belgium.gif

 Status: Offline
0.06 posts per day
Medals: 0
Joined: Jan 11, 2007
Last Visit: 19 Nov 2008
Posts: 42
Points: 5173 
Post Help needed with auc1.05 sql Posted: Sun Nov 02, 2008 10:19 am   
when i try to import the SQL thingy's after installing Ravennuke 2.30, i get the following error

Code:
Error
SQL query:

CREATE TABLE `nuke_bbadvanced_username_color` (

`group_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`group_name` varchar( 255 ) NOT NULL default '',
`group_color` varchar( 6 ) NOT NULL default '',
`group_weight` smallint( 2 ) NOT NULL default '',
PRIMARY KEY ( `group_id` )
) TYPE = MYISAM ;



MySQL said: 

#1067 - Invalid default value for 'group_weight'



Can someone fix this pls.
 

 
View user's profileSend private messageSend e-mailVisit poster's websiteMSN Messenger Reply with quote

Untergang
Reputation: 603
votes: 5
Local time: 10:06 PM
Location: Lommel
belgium.gif

 Status: Offline
0.50 posts per day
Medals: 0
Joined: May 08, 2007
Last Visit: 01 Dec 2008
Posts: 285
Points: 8204 
View user's profileSend private messageSend e-mailVisit poster's websiteMSN Messenger Reply with quote

Jebo-Devil
Reputation: 452.2
votes: 1
Local time: 10:06 PM
Location: Antwerp
belgium.gif

 Status: Offline
0.06 posts per day
Medals: 0
Joined: Jan 11, 2007
Last Visit: 19 Nov 2008
Posts: 42
Points: 5173 
View user's profileSend private messageSend e-mailVisit poster's websiteMSN Messenger Reply with quote




floppy
Reputation: 1794.6
votes: 10
Local time: 4:06 PM
Location: Jackson Mississippi
usa.gif

 Status: Offline
2.77 posts per day
Medals: 1 (View more...)
Dedicated User (Amount: 1)
Clan Themes Scripts/Coder
Clan Themes Scripts/Coder
Joined: Nov 14, 2006
Last Visit: 02 Dec 2008
Posts: 2074
Points: 4423 
Post Re: Help needed with auc1.05 sql Posted: Sun Nov 02, 2008 9:25 pm   
Shop Purchases:Clan Roster 2.0
You can't leave it as default '' when dealing with numbers like below which is what int and smallint reference. You have to set the default value simply because blank or default '' will not work.

Code:
CREATE TABLE `nuke_bbadvanced_username_color` (

`group_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`group_name` varchar( 255 ) NOT NULL default '',
`group_color` varchar( 6 ) NOT NULL default '',
`group_weight` smallint( 2 ) NOT NULL default '0',
PRIMARY KEY ( `group_id` )
) TYPE = MYISAM ;
 

 
View user's profileSend private messageVisit poster's website Reply with quote

Jebo-Devil
Reputation: 452.2
votes: 1
Local time: 10:06 PM
Location: Antwerp
belgium.gif

 Status: Offline
0.06 posts per day
Medals: 0
Joined: Jan 11, 2007
Last Visit: 19 Nov 2008
Posts: 42
Points: 5173 
View user's profileSend private messageSend e-mailVisit poster's websiteMSN Messenger Reply with quote
Post new topic   Reply to topic  
   www.clan-themes.co.uk Forum Index » PHPBB


 
4 Replies / 178 Views
Page 1 of 1
All times are GMT
Display posts from previous:   
 
Jump to:  
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 vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum