Clan Adverts

Sponsors

CT on Facebook

Latest Product

Battlefield 3 Stats Module
Battlefield 3 Stats Module

User Box

Anonymous
38.107.179.218
Nickname:

Password:

Security Code
Security Code
Type Security Code


PND Downloads Feed

Phpnuke Downloads
How to Delete or Reset yo...
How to Delete or Reset your PHPNuke Admin Account
Lost your admin password ?  Cant login to your admin account ?This sh...
Back Online & Stuff
Back Online & Stuff
Look at us with our nifty website back up and running… Seriousl...
How to edit the admins in...
How to edit the admins in the forums
Here is a way to make someone admin in your forums on your Evo site. I...
Demo Splash Screen
Demo Splash Screen
Ped @ Clan Themes has released a simple splash screen entrance hack. ...
Free Phpnuke Business The...
Free Phpnuke Business Theme 6
This is the 6th Business theme for Phpnuke that Clan Themes has releas...
Tricked Out Slider
Tricked Out Slider
We have seen some great new things come out of Tricked Out News and th...

Custom Work

PHP Nuke Custom Work

www.clanthemes.com :: View topic - Help needed with auc1.05 sql
Help needed with auc1.05 sql

4 Replies / 1234 Views
Post new topic   Reply to topic  

   www.clanthemes.com Forum Index » PHPBB

View previous topic :: View next topic

Jebo-Devil
Reputation: 455.9 Add RepSubtract Rep
votes: 1
Local time: 6:43 AM
Location: Antwerp
belgium.gif

 Armour Whore
Armour Whore

0.02 posts per day
Medals: 0
Joined: Jan 11, 2007
Last Visit: 15 Jun 2009
Posts: 42
Points: 4142 
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: 642.6 Add RepSubtract Rep
votes: 6
Local time: 6:43 AM
Location: Lommel
belgium.gif

 Stand-by Stand-by
Stand-by Stand-by

0.20 posts per day
Medals: 0
Joined: May 08, 2007
Last Visit: 31 Oct 2011
Posts: 347
Points: 22131 
Post Re: Help needed with auc1.05 sql Posted: Sun Nov 02, 2008 1:41 pm
Try changing: smallint( 2 ) to: int( 2 )
 

UDesigns.be  
View user's profileSend private messageSend e-mailVisit poster's website Reply with quote

Jebo-Devil
Reputation: 455.9 Add RepSubtract Rep
votes: 1
Local time: 6:43 AM
Location: Antwerp
belgium.gif

 Armour Whore
Armour Whore

0.02 posts per day
Medals: 0
Joined: Jan 11, 2007
Last Visit: 15 Jun 2009
Posts: 42
Points: 4142 
Post Help needed with auc1.05 sql Posted: Sun Nov 02, 2008 5:28 pm
will give it a try, thx

Nope doesnt work, still the same error ?
 

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


floppy
Reputation: 2087.2 Add RepSubtract Rep
votes: 22
Local time: 12:43 AM
Location: Jackson Mississippi
usa.gif

 Site Admin
Site Admin

1.73 posts per day
Medals: 2 (View more...)
Dedication (Amount: 1)
Scripts/Coder
Scripts/Coder
Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023 
Post Re: Help needed with auc1.05 sql Posted: Sun Nov 02, 2008 9:25 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version
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 ;
 

Phpnuke Downloads | VMaxxRx Male Enhancement  
View user's profileSend private messageVisit poster's website Reply with quote

Jebo-Devil
Reputation: 455.9 Add RepSubtract Rep
votes: 1
Local time: 6:43 AM
Location: Antwerp
belgium.gif

 Armour Whore
Armour Whore

0.02 posts per day
Medals: 0
Joined: Jan 11, 2007
Last Visit: 15 Jun 2009
Posts: 42
Points: 4142 
Post Help needed with auc1.05 sql Posted: Sun Nov 02, 2008 9:51 pm
Thx, that worked, just to find the typos i made, grrrrr...
 

 
View user's profileSend private messageSend e-mailVisit poster's websiteMSN Messenger Reply with quote
Post new topic   Reply to topic  
   www.clanthemes.com Forum Index » PHPBB


 
4 Replies / 1234 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
 

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke