Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Battlefield 3 Stats Module

User Box

Anonymous

38.107.179.220

PND Downloads Feed

How to Delete or Reset yo...

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

Back Online & Stuff

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

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 - Potm - can't add players - sql problem - Fixed

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

7 Replies / 3165 Views


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

texr6
Reputation: 461.5
Local time: 4:18 AM

Noob

0.01 posts per day
Medals: 0

Joined: Jun 19, 2007
Last Visit: 12 Apr 2008
Posts: 10
Points: 100

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: 7:18 PM

Noob

0.01 posts per day
Medals: 0

Joined: Feb 06, 2007
Last Visit: 01 Apr 2009
Posts: 17
Points: 433

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

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

texr6
Reputation: 461.5
Local time: 4:18 AM

Noob

0.01 posts per day
Medals: 0

Joined: Jun 19, 2007
Last Visit: 12 Apr 2008
Posts: 10
Points: 100

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: 3:18 AM
Location: Chicago, IL

Rocket Noob

0.02 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: 2087.2
votes: 22
Local time: 4:18 AM
Location: Jackson Mississippi

Site Admin

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

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Potm - can't add players - sql problem Posted: Thu Aug 30, 2007 2:40 am
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

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!

Phpnuke Downloads | VMaxxRx Male Enhancement

texr6
Reputation: 461.5
Local time: 4:18 AM

Noob

0.01 posts per day
Medals: 0

Joined: Jun 19, 2007
Last Visit: 12 Apr 2008
Posts: 10
Points: 100

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: 2087.2
votes: 22
Local time: 4:18 AM
Location: Jackson Mississippi

Site Admin

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

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Potm - can't add players - sql problem - Fixed Posted: Thu Aug 30, 2007 4:44 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

Uber job there. Thanks for updating your topic.

Hardware
Reputation: 461.9
Local time: 3:18 AM
Location: Chicago, IL

Rocket Noob

0.02 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.clanthemes.com Forum Index » Bugs/Issues

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

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work