Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme

User Box

Anonymous

38.107.179.216

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ? This s...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriously...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Medal system sql error

Medal system sql error

7 Replies / 2497 Views


www.clanthemes.com Forum Index » Bugs/Issues	View previous topic :: View next topic

blackfox_us
Reputation: 283.7
votes: 1
Local time: 6:02 PM

OMG

0.07 posts per day
Medals: 1 (View more...)

Joined: Oct 04, 2007
Last Visit: 27 Nov 2008
Posts: 122
Points: 3979

Medal system sql error Posted: Fri Feb 08, 2008 5:36 pm

every time I try to run the Tables in the SQL thats what I get

Code:

Error

SQL query:

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_bbmedal_user` (
`issue_id` mediumint( 8 ) NOT NULL AUTO_INCREMENT ,
`medal_id` mediumint( 8 ) NOT NULL default '',
`user_id` mediumint( 8 ) NOT NULL default '',
`issue_reason` varchar( 255 ) NOT NULL default '',
`issue_time` int( 11 ) NOT NULL default '',
PRIMARY KEY ( `issue_id` )
) TYPE = MYISAM ;

MySQL said: Documentation
#1067 - Invalid default value for 'medal_id'

and thats the current SQL

Code:

#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_bbmedal` (
`medal_id` mediumint(8) NOT NULL auto_increment,
`medal_name` varchar(40) NOT NULL default '',
`medal_description` varchar(255) NOT NULL default '',
`medal_image` varchar(40) default NULL,
PRIMARY KEY (`medal_id`)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_bbmedal_user` (
`issue_id` mediumint(8) NOT NULL auto_increment,
`medal_id` mediumint(8) NOT NULL default '',
`user_id` mediumint(8) NOT NULL default '',
`issue_reason` varchar(255) NOT NULL default '',
`issue_time` int(11) NOT NULL default '',
PRIMARY KEY (`issue_id`)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_bbmedal_mod` (
`mod_id` mediumint(8) unsigned NOT NULL auto_increment,
`medal_id` mediumint(8) NOT NULL default '',
`user_id` mediumint(8) NOT NULL default '',
PRIMARY KEY (`mod_id`)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
INSERT INTO `nuke_bbconfig` VALUES ('allow_medal_dispaly', '0');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_row', '1');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_col', '1');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_width', '');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_height', '');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_order', '');

Please help me, I really want this mod ,

Ped
Reputation: 93.4
votes: 37
Local time: 12:02 AM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 24 May 2012
Posts: 3670
Points: 191811

Medal system sql error Posted: Fri Feb 08, 2008 5:52 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Try this, worked for me

Code:

CREATE TABLE `nuke_bbmedal_user` (
`issue_id` mediumint(8) NOT NULL auto_increment,
`medal_id` mediumint(8) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`issue_reason` varchar(255) NOT NULL default '0',
`issue_time` int(11) NOT NULL default '0',
PRIMARY KEY (`issue_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

CREATE TABLE `nuke_bbmedal` (
`medal_id` mediumint(8) NOT NULL auto_increment,
`medal_name` varchar(40) NOT NULL default '',
`medal_description` varchar(255) NOT NULL default '',
`medal_image` varchar(40) default NULL,
PRIMARY KEY (`medal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

CREATE TABLE `nuke_bbmedal_mod` (
`mod_id` mediumint(8) unsigned NOT NULL auto_increment,
`medal_id` mediumint(8) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
PRIMARY KEY (`mod_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

INSERT INTO `nuke_bbconfig` VALUES ('allow_medal_dispaly', '0');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_row', '1');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_col', '1');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_width', '');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_height', '');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_order', '');

blackfox_us
Reputation: 283.7
votes: 1
Local time: 6:02 PM

OMG

0.07 posts per day
Medals: 1 (View more...)

Joined: Oct 04, 2007
Last Visit: 27 Nov 2008
Posts: 122
Points: 3979

Medal system sql error Posted: Fri Feb 08, 2008 6:00 pm

thank you very much, this one worked for me too

blackfox_us
Reputation: 283.7
votes: 1
Local time: 6:02 PM

OMG

0.07 posts per day
Medals: 1 (View more...)

Joined: Oct 04, 2007
Last Visit: 27 Nov 2008
Posts: 122
Points: 3979

Medal system sql error Posted: Fri Feb 08, 2008 6:08 pm

but I still get theis error

Code:

Error getting medal information

DEBUG MODE

SQL Error : 1146 Table 'bhzclanc_nuke1.MEDAL_TABLE' doesn't exist

SELECT m.medal_id, m.medal_name, m.medal_image FROM MEDAL_TABLE m, MEDAL_USER_TABLE mu WHERE mu.user_id = '34' AND m.medal_id = mu.medal_id ORDER BY m.medal_name

Line : 1221
File : viewtopic.php

Ped
Reputation: 93.4
votes: 37
Local time: 12:02 AM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 24 May 2012
Posts: 3670
Points: 191811

Re: Medal system sql error Posted: Fri Feb 08, 2008 6:50 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

tHE TABLES BY DEFAULT OOPS CAPS

Are called nuke_

yours are called bhzclanc_nuke1_

so you need to replace them like so

Code:

CREATE TABLE `bhzclanc_nuke1_bbmedal_user` (
`issue_id` mediumint(8) NOT NULL auto_increment,
`medal_id` mediumint(8) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`issue_reason` varchar(255) NOT NULL default '0',
`issue_time` int(11) NOT NULL default '0',
PRIMARY KEY (`issue_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

CREATE TABLE `bhzclanc_nuke1_bbmedal` (
`medal_id` mediumint(8) NOT NULL auto_increment,
`medal_name` varchar(40) NOT NULL default '',
`medal_description` varchar(255) NOT NULL default '',
`medal_image` varchar(40) default NULL,
PRIMARY KEY (`medal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

CREATE TABLE `bhzclanc_nuke1_bbmedal_mod` (
`mod_id` mediumint(8) unsigned NOT NULL auto_increment,
`medal_id` mediumint(8) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
PRIMARY KEY (`mod_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

INSERT INTO `bhzclanc_nuke1_bbconfig` VALUES ('allow_medal_dispaly', '0');
INSERT INTO `bhzclanc_nuke1_bbconfig` VALUES ('medal_display_row', '1');
INSERT INTO `bhzclanc_nuke1_bbconfig` VALUES ('medal_display_col', '1');
INSERT INTO `bhzclanc_nuke1_bbconfig` VALUES ('medal_display_width', '');
INSERT INTO `bhzclanc_nuke1_bbconfig` VALUES ('medal_display_height', '');
INSERT INTO `bhzclanc_nuke1_bbconfig` VALUES ('medal_display_order', '');

Im not sure why its saying MEDAL_TABLE though as there is no MEDAL TABLE

try that first anyway

StevieH
Reputation: 609.4
votes: 4
Local time: 11:02 PM
Location: Bristol

0.08 posts per day
Medals: 2 (View more...)

Site Helper

Joined: Mar 19, 2007
Last Visit: 03 May 2012
Posts: 157
Points: 20891

Medal system sql error Posted: Wed Mar 12, 2008 12:49 am
Shop Purchases:Battlefield 2 Theme (Aviator V2) · Battlefield 2142 (Aviator v2) · Arnhem Multi Gaming Theme · Call of Duty 4 Ultimate Theme · Multi Gaming (Warrior) Theme · Topsites Manager V1 PhpNuke Module · Clan Roster v1.7 Php Nuke Module · Frontlines Fuel Of War Theme · Anzio Multi Gaming Theme · Left for Dead L4D PhpNuke Evo Theme · Battlefield: Bad Company 2 Theme · Clan Roster 2.0 · Call of Duty Black Ops Xtreme Theme

Im trying to install this myself after looking at this post, it deffinatly seems to be calling for medal_table wich does not exist. I tried replacing all the prefix nuke_bb wich diddent help, as in php admin i know for a fact that the prefix in my db is nuke_bb. I have a few other things im gona try and will post back with results tommorow after work ;) i garantee its something simple we are doing wrong blackfox.

rsalves
Reputation: 1.1
Local time: 6:02 PM

Noob

0.01 posts per day
Medals: 0

Joined: Mar 16, 2008
Last Visit: 16 Mar 2008
Posts: 11
Points: 100

Medal system sql error Posted: Sun Mar 16, 2008 6:30 pm

qual o objetivo deste forum se nao tem nada

epicam
Reputation: 2.8
Local time: 5:02 PM

Noob

0.00 posts per day
Medals: 0

Joined: Jan 09, 2008
Last Visit: 21 Aug 2008
Posts: 5
Points: 100

Medal system sql error Posted: Mon Mar 17, 2008 12:17 pm

ive had same problem!

www.clanthemes.com Forum Index » Bugs/Issues

7 Replies / 2497 Views
Page 1 of 1
All times are GMT

Display posts from previous:

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

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work