Medal system sql error - ive had same problem! - PhpNuke Clan Themes - PhpNuke Themes, PhpNuke Tutorials, PhpNuke Downloads for Gamers

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.

Medal system sql error

7 Replies / 481 Views


www.clan-themes.co.uk Forum Index » Bugs/Issues	View previous topic :: View next topic

blackfox_us
Reputation: 276.3
votes: 1
Local time: 5:05 AM

Status: Offline
0.59 posts per day
Medals: 0

Joined: Oct 04, 2007
Last Visit: 16 May 2008
Posts: 133
Points: 3585

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: 913.3
votes: 17
Local time: 11:05 AM
Location: Great British Empire

Status: Offline
3.02 posts per day
Medals: 2 (View more...)

Clan Themes Theme Guru

Joined: Nov 13, 2006
Last Visit: 17 May 2008
Posts: 1663
Points: 5596

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

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: 276.3
votes: 1
Local time: 5:05 AM

Status: Offline
0.59 posts per day
Medals: 0

Joined: Oct 04, 2007
Last Visit: 16 May 2008
Posts: 133
Points: 3585

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: 276.3
votes: 1
Local time: 5:05 AM

Status: Offline
0.59 posts per day
Medals: 0

Joined: Oct 04, 2007
Last Visit: 16 May 2008
Posts: 133
Points: 3585

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: 913.3
votes: 17
Local time: 11:05 AM
Location: Great British Empire

Status: Offline
3.02 posts per day
Medals: 2 (View more...)

Clan Themes Theme Guru

Joined: Nov 13, 2006
Last Visit: 17 May 2008
Posts: 1663
Points: 5596

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

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: 514.7
votes: 2
Local time: 10:05 AM

Status: Offline
0.31 posts per day
Medals: 2 (View more...)

Site Helper

Joined: Mar 19, 2007
Last Visit: 15 May 2008
Posts: 132
Points: 8003

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

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.2
Local time: 5:05 AM

Status: Offline
0.19 posts per day
Medals: 0

Joined: Mar 16, 2008
Last Visit: 16 Mar 2008
Posts: 12
Points: 122

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: 4:05 AM

Status: Offline
0.04 posts per day
Medals: 0

Joined: Jan 09, 2008
Last Visit: 22 Mar 2008
Posts: 5
Points: 53

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

ive had same problem!

www.clan-themes.co.uk Forum Index » Bugs/Issues

7 Replies / 481 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