Clan Themes, We Make Clans Look Good!

DirectClanHosting.com - Dedicated Servers - Colocation - Gam

www.clan-themes.co.uk :: View topic - Potm - can't add players - sql problem - Fixed

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.

Potm - can't add players - sql problem - Fixed

7 Replies / 1439 Views


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

texr6
Reputation: 461.6
Local time: 3:44 PM

Status: Offline
0.03 posts per day
Medals: 0

Joined: Jun 19, 2007
Last Visit: 12 Apr 2008
Posts: 13
Points: 5

Potm - can't add players - sql problem - Fixed Posted: Thu Aug 23, 2007 3:56 pm

Hi,

I installed the POTM module and today I was trying to use it for the first time, but to my surprise it wont let me add any players, when I try to do so I get the error:
Could not update: Incorrect integer value: '' for column 'id' at row 1
and nothing is added to the database.

I've tryed a couple of things but no go.

on the submit-player.php I saw that:
$query = "INSERT INTO nuke_potm_players VALUES ('','$pname','$uname','$ip','$date')";

does that has anything to do with the problem?

any help would be appreciate it.

Thanks in advance.

Last edited by texr6 on Thu Aug 30, 2007 4:25 pm; edited 1 time in total

rat
Reputation: 461.7
Local time: 6:44 AM

Status: Offline
0.03 posts per day
Medals: 0

Joined: Feb 06, 2007
Last Visit: 11 Aug 2008
Posts: 17
Points: 486

Potm - can't add players - sql problem Posted: Fri Aug 24, 2007 7:40 pm

try to reinstall it................

texr6
Reputation: 461.6
Local time: 3:44 PM

Status: Offline
0.03 posts per day
Medals: 0

Joined: Jun 19, 2007
Last Visit: 12 Apr 2008
Posts: 13
Points: 5

Re: Potm - can't add players - sql problem Posted: Mon Aug 27, 2007 4:13 pm

rat wrote:

try to reinstall it................

I already did that with no go.
even if i try to install it on a fresh nuke installation I still got this problem which I think the problem is on the POTM itself.

Any help would be appreciated.

Thank's in advance.

Hardware
Reputation: 461.9
Local time: 2:44 PM
Location: Chicago, IL

Status: Offline
0.06 posts per day
Medals: 0

Joined: Jun 03, 2007
Last Visit: 02 Jul 2008
Posts: 28
Points: 302

Potm - can't add players - sql problem Posted: Thu Aug 30, 2007 2:29 am
Shop Purchases:Clan Roster 2.0

Scorp posted what to do with this, but it is still not working for me at all. The first name I put on the PotM stays there even if the new names are added to the list when viewed.

floppy
Reputation: 2249.9
votes: 10
Local time: 3:44 PM
Location: Jackson Mississippi

Status: Offline
3.20 posts per day
Medals: 1 (View more...)

Clan Themes Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 20 Aug 2008
Posts: 2067
Points: 27067

Potm - can't add players - sql problem Posted: Thu Aug 30, 2007 2:40 am
Shop Purchases:Clan Roster 2.0

I gotta be honest. I don't want this responsibility on top of all the others I have, but since people seem to enjoy the application so much. I plan to completely revamp the way it works in an update.

Arghhhh!

Free Clan Links - Submit Yours today

texr6
Reputation: 461.6
Local time: 3:44 PM

Status: Offline
0.03 posts per day
Medals: 0

Joined: Jun 19, 2007
Last Visit: 12 Apr 2008
Posts: 13
Points: 5

Potm - can't add players - sql problem - Fixed Posted: Thu Aug 30, 2007 4:37 pm

Just in case that anyone else is having the same problem, I decided to share the solution to my problem to whoever needs it Angel

ok here it goes, on submit_player.php find:

Code:

$query = "INSERT INTO nuke_potm_players VALUES ('','$pname','$uname','$ip','$date')";

and change it to:

Code:

$query = "INSERT INTO nuke_potm_players (pname, uname, ip, date) values ('$pname',
'$uname', '$ip', '$date')";

Thats all, now I can add players to database and everything is working as it should now.

Cheers.

floppy
Reputation: 2249.9
votes: 10
Local time: 3:44 PM
Location: Jackson Mississippi

Status: Offline
3.20 posts per day
Medals: 1 (View more...)

Clan Themes Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 20 Aug 2008
Posts: 2067
Points: 27067

Potm - can't add players - sql problem - Fixed Posted: Thu Aug 30, 2007 4:44 pm
Shop Purchases:Clan Roster 2.0

Uber job there. Thanks for updating your topic.

Hardware
Reputation: 461.9
Local time: 2:44 PM
Location: Chicago, IL

Status: Offline
0.06 posts per day
Medals: 0

Joined: Jun 03, 2007
Last Visit: 02 Jul 2008
Posts: 28
Points: 302

Potm - can't add players - sql problem - Fixed Posted: Sun Sep 02, 2007 5:35 pm
Shop Purchases:Clan Roster 2.0

Worked, nice job man.

/salute

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

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

You can syndicate our news using the file backend.php or ultramode.txt

Distributed by Raven PHP Scripts

Page Generation: 1.29 Seconds