Raised This Month: $32 Target: $400
 8% 

Player Status in DB


Post New Thread Reply   
 
Thread Tools Display Modes
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-05-2020 , 07:46   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #111

Now working Status Pages.
__________________
GitHub
SteamWishlist

六四天安門事件

Last edited by +ARUKARI-; 04-05-2020 at 07:49.
+ARUKARI- is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-05-2020 , 23:21   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #112

Update and top upload v1.0!
__________________
GitHub
SteamWishlist

六四天安門事件
+ARUKARI- is offline
DragosHh
Junior Member
Join Date: Jul 2008
Old 04-14-2020 , 06:45   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #113

I'm getting this:
" ( 23) Error: Invalid default value for 'date' "

Do you have any workaround for this? I know is a MySQL issue, probably strict_mode thing.
DragosHh is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-14-2020 , 07:24   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #114

Quote:
Originally Posted by DragosHh View Post
I'm getting this:
" ( 23) Error: Invalid default value for 'date' "

Do you have any workaround for this? I know is a MySQL issue, probably strict_mode thing.
Try Replace " DEFAULT '0000-00-00 00:00:00', " to " DEFAULT NULL, "
__________________
GitHub
SteamWishlist

六四天安門事件
+ARUKARI- is offline
DragosHh
Junior Member
Join Date: Jul 2008
Old 04-17-2020 , 06:30   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #115

You can't have DEFAULT NULL for primary keys, I would suggest you to review SQL queries for creating the table for MySQL compatibility as I have a feeling I might not be the only one with this issue. I will came back with an edit for a workaround hopefully today

Last edited by DragosHh; 04-17-2020 at 06:30.
DragosHh is offline
aim.dll
Junior Member
Join Date: Jul 2017
Old 04-22-2020 , 19:37   Re: Player Status in DB
Reply With Quote #116

Hey. I keep getting those errors.

L 04/23/2020 - 025:44: [AMXX] Plugin ("psd_104.amxx") is setting itself as failed.
L 04/23/2020 - 025:44: [AMXX] Plugin says: Incorrect database name ''
L 04/23/2020 - 025:44: [AMXX] Run time error 1 (plugin "psd_104.amxx") - forced exit
aim.dll is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-22-2020 , 19:53   Re: Player Status in DB
Reply With Quote #117

Have you set up MySQL?
Then check "amxmodx/configs/sql.cfg".
PHP Code:
amx_sql_host    "127.0.0.1"
amx_sql_user    "root"
amx_sql_pass    ""
amx_sql_db      "amx" 
database name is amx_sql_db.
"Incorrect database name."
=> Does the database exist?
__________________
GitHub
SteamWishlist

六四天安門事件
+ARUKARI- is offline
Canti87
New Member
Join Date: May 2020
Old 05-18-2020 , 17:14   Re: Player Status in DB
Reply With Quote #118

Hello,

I am trying to install the plugin. The data is being dumped into the SQL database, and after mounting the web it is generated as follows:

https://prnt.sc/sj8srt

Some spaces are blank and the URL returns errors:

Code:
Notice: Undefined index: Pablo in C:\xampp\htdocs\StatsX\includes\page_main.inc on line 41

Notice: Trying to access array offset on value of type null in C:\xampp\htdocs\StatsX\includes\page_main.inc on line 41

Notice: Undefined index: Pablo in C:\xampp\htdocs\StatsX\includes\page_main.inc on line 42

Notice: Trying to access array offset on value of type null in C:\xampp\htdocs\StatsX\includes\page_main.inc on line 42

Notice: Undefined index: Canti in C:\xampp\htdocs\StatsX\includes\page_main.inc on line 41

Notice: Trying to access array offset on value of type null in C:\xampp\htdocs\StatsX\includes\page_main.inc on line 41

Notice: Undefined index: Canti in C:\xampp\htdocs\StatsX\includes\page_main.inc on line 42

Notice: Trying to access array offset on value of type null in C:\xampp\htdocs\StatsX\includes\page_main.inc on line 42

Do you know what it could be?
Canti87 is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 05-18-2020 , 18:44   Re: Player Status in DB
Reply With Quote #119

@Canti87
show me the contents of the table.
(total_stats and user_info.)
__________________
GitHub
SteamWishlist

六四天安門事件
+ARUKARI- is offline
Canti87
New Member
Join Date: May 2020
Old 05-18-2020 , 19:46   Re: Player Status in DB
Reply With Quote #120

+ARUKARI-,
thanks for answering. I leave you captures of the database and how the web looks.

total_stats
https://prnt.sc/sjay1k

user_info
https://prnt.sc/sjaycv


Web:
https://prnt.sc/sjaymg

Thanks in advance
Canti87 is offline
Reply



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 03:06.


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