Raised This Month: $159 Target: $400
 39% 

[BETA] SQL errors


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
2called-chaos
Senior Member
Join Date: Jul 2006
Old 02-13-2010 , 16:14   [BETA] SQL errors
Reply With Quote #1

Hi,

I just tried out the beta and therefore I tried the SQL version.

This is a sample error in the logs:
Quote:
L 02/13/2010 - 11:42:46: [gungame_with_sql.amxx] Could not execute query [SELECT wins,name,points,streak,wins_tp,points_tp,str eak_tp FROM `gg_stats` WHERE authid='BOT' AND serverip='88.198.XXX.XXX:27015' LIMIT 1;] -- err #1054 [Unknown column 'name' in 'field list']

..._with_sql.amxx] Could not execute query [SELECT wins,name,points,streak,wins_tp,points_tp,str eak_tp FROM `gg_stats` WHERE authid='STEAM_0:0:160XXXXX' AND serverip='88.198.XXX.XXX:27015' LIMIT 1;] -- err #1054 [Unknown column 'name' in 'field list']
The strikes will be saved but the stats doesn't work. The gg_players table is also empty.

Whats wrong?


Chaos
__________________


My post was useful? Than klick here, please. Tanks.
2called-chaos is offline
XxAvalanchexX
Veteran Member
Join Date: Oct 2004
Location: abort73.com
Old 02-14-2010 , 20:32   Re: [BETA] SQL errors
Reply With Quote #2

Hello,

Thanks for reporting this! Let's see if we can fix it.

As for gg_players, it only gets updated whenever someone wins a round. It only includes some information about the players who were playing when the win occurred, like what team they were on, how many points they got, etcetera, so that you can make your own custom MOTD win screen using SQL.

It's the gg_stats table that should include all of the meaty stats data. Do you have a way to view the structure of the table (like phpMyAdmin)? Can you verify that it really has a column named 'name' (it should)? When you switched to GG 2.13, did you use the website to convert your stats file to a SQL query to populate your database?
__________________
No longer around. Thanks your support, everyone! As always:
THIS ONES FOR YOU
3000 PTS
XxAvalanchexX is offline
viktor6
Junior Member
Join Date: Dec 2006
Old 02-15-2010 , 16:41   Re: [BETA] SQL errors
Reply With Quote #3

Quote:
Originally Posted by XxAvalanchexX View Post
Hello,

Thanks for reporting this! Let's see if we can fix it.

As for gg_players, it only gets updated whenever someone wins a round. It only includes some information about the players who were playing when the win occurred, like what team they were on, how many points they got, etcetera, so that you can make your own custom MOTD win screen using SQL.

It's the gg_stats table that should include all of the meaty stats data. Do you have a way to view the structure of the table (like phpMyAdmin)? Can you verify that it really has a column named 'name' (it should)? When you switched to GG 2.13, did you use the website to convert your stats file to a SQL query to populate your database?
Attached Files
File Type: txt gg_stats(2).sql.txt (2.7 KB, 202 views)
viktor6 is offline
Min2liz
AlliedModders Donor
Join Date: Feb 2008
Location: Street
Old 02-15-2010 , 21:27   Re: [BETA] SQL errors
Reply With Quote #4

With gg_players table, same to me. It's empty and nothing. gg_strikes everything working, but with gg_player - not.

Oh and:

Quote:
Originally Posted by 2called-chaos View Post
Hi,

I just tried out the beta and therefore I tried the SQL version.

This is a sample error in the logs:


The strikes will be saved but the stats doesn't work. The gg_players table is also empty.

Whats wrong?


Chaos
These errors from older GunGame mod SQL, because before GunGame SQL used: lastname and this version don't create new column name or just don't rename it (don't know why) I self with phpMyAdmin create these colums:
  • streak_tp
  • streak
  • wins_tp
  • points_tp

And rename lastename to name

But gg_players same to me - empty all the time

Sorry for bad English.

Last edited by Min2liz; 02-15-2010 at 21:29.
Min2liz is offline
XxAvalanchexX
Veteran Member
Join Date: Oct 2004
Location: abort73.com
Old 02-16-2010 , 15:29   Re: [BETA] SQL errors
Reply With Quote #5

Thanks, Min2liz, that's probably it! So if you delete your old gg_stats table or run this query to fix it, it should work:

Code:
ALTER TABLE `gg_stats`
CHANGE `authid` `authid` VARCHAR(31),
CHANGE `wins` `wins` SMALLINT(6) DEFAULT 0,
CHANGE `lastname` `name` VARCHAR(31) NOT NULL,
CHANGE `timestamp` `timestamp` INT(10) UNSIGNED DEFAULT 0,
CHANGE `points` `points` MEDIUMINT(9) DEFAULT 0,
ADD `streak` SMALLINT(6) DEFAULT 0 AFTER `points`,
ADD `wins_tp` SMALLINT(6) DEFAULT 0 AFTER `streak`,
ADD `points_tp` MEDIUMINT(9) DEFAULT 0 AFTER `wins_tp`,
ADD `streak_tp` SMALLINT(6) DEFAULT 0 AFTER `points_tp`,
DROP PRIMARY KEY,
ADD PRIMARY KEY (`authid`,`serverip`),
ADD INDEX (`wins`),
ADD INDEX (`points`),
ADD INDEX (`wins_tp`),
ADD INDEX (`points_tp`);
As for gg_players, I just looked into it. It looks like I wrote it so that it only bothers updating gg_players if you have a custom MOTD webpage for gg_winner_motd, as that is what it was designed for. Do you think I should have it update anyway? It's basically only the information you can find on the MOTD.
__________________
No longer around. Thanks your support, everyone! As always:
THIS ONES FOR YOU
3000 PTS
XxAvalanchexX is offline
Min2liz
AlliedModders Donor
Join Date: Feb 2008
Location: Street
Old 02-17-2010 , 08:40   Re: [BETA] SQL errors
Reply With Quote #6

About gg_players: In real maybe don't need to update because same information I can find in gg_stats if I correct understand, but if you can explain why gg_players exists and when/what it's writing on it.

And have question about gg_streaks. yesterday i looked into it, and was 5 or 7 rows, now just 2. How I understand type = 0R that's mean record? But Record was 6 done by Jurgen, now it's 3 by vmf. So at this point i confused. Can you explain what thats mean:

0C and 0R and how it's work.

Thanks XxAvalanchexX

P.S. Trying to create own web stats, but I just confused in some points
Min2liz is offline
2called-chaos
Senior Member
Join Date: Jul 2006
Old 02-17-2010 , 18:34   Re: [BETA] SQL errors
Reply With Quote #7

Thanks a lot, it works


Mfg

Chaos
__________________


My post was useful? Than klick here, please. Tanks.
2called-chaos is offline
edward0810
Member
Join Date: Mar 2009
Location: H.K.
Old 04-05-2010 , 01:19   Re: [BETA] SQL errors
Reply With Quote #8

I am running non-SQL but it only logs streaks.
Stats file is always empty.
Can anyone fix this,also?
__________________
I am a newbie. Don't blame for my stupid question
edward0810 is offline
XxAvalanchexX
Veteran Member
Join Date: Oct 2004
Location: abort73.com
Old 04-05-2010 , 21:21   Re: [BETA] SQL errors
Reply With Quote #9

Hi edward0810,

I assume you are using the beta? Could you please post your gungame.cfg? Also, does there exist a "gungame.stats" file that is empty, or does the file not exist at all?

Thanks,

Ava
__________________
No longer around. Thanks your support, everyone! As always:
THIS ONES FOR YOU
3000 PTS
XxAvalanchexX is offline
edward0810
Member
Join Date: Mar 2009
Location: H.K.
Old 04-06-2010 , 09:27   Re: [BETA] SQL errors
Reply With Quote #10

Quote:
Originally Posted by XxAvalanchexX View Post
Hi edward0810,

I assume you are using the beta? Could you please post your gungame.cfg? Also, does there exist a "gungame.stats" file that is empty, or does the file not exist at all?

Thanks,

Ava
Sorry I fixed that.
I created a empty file and it logs properly.
__________________
I am a newbie. Don't blame for my stupid question
edward0810 is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 02:21.


Powered by vBulletin®
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Theme made by Freecode