Raised This Month: $48 Target: $400
 12% 

Shero w/ MySQL "error"?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
gui1porpis
Member
Join Date: Jan 2009
Location: Brodowski, SP, Brazil
Old 06-06-2017 , 10:57   Shero w/ MySQL "error"?
Reply With Quote #1

Hello, I'm having a comeback in the superhero debug and is talking about the tables, the problem is that I'm a bit of a layman on these table things, I wanted to know briefly what I have to do for the error to stop returning?

qconsole.log:
Quote:
L 06/05/2017 - 18:027: [superheromod.amxx] DEBUG: Error Making Tables: [1426] 'Too-big precision 14 specified for 'LAST_PLAY_DATE'. Maximum is 6.' - 'CREATE TABLE IF NOT EXISTS `sh_savexp` ( `SH_KEY` varchar(32) binary NOT NULL default '', `PLAYER_NAME` varchar(32) binary NOT NULL default '', `LAST_PLAY_DATE` timestamp(14) NOT NULL, `XP` int(10) NOT NULL default '0', `HUDHELP`
Note: I use MySQL because of Shero Stats.
__________________
gui1porpis is offline
Send a message via MSN to gui1porpis Send a message via Skype™ to gui1porpis
notusian
Junior Member
Join Date: Dec 2004
Old 06-11-2017 , 18:59   Re: Shero w/ MySQL "error"?
Reply With Quote #2

I'm not sure where this query is written but switch timestamp(14)

LAST_PLAY_DATE` timestamp(14) NOT NULL
to
LAST_PLAY_DATE` timestamp NOT NULL
notusian is offline
gui1porpis
Member
Join Date: Jan 2009
Location: Brodowski, SP, Brazil
Old 07-07-2018 , 23:49   Re: Shero w/ MySQL "error"?
Reply With Quote #3

Quote:
Originally Posted by notusian View Post
I'm not sure where this query is written but switch timestamp(14)

LAST_PLAY_DATE` timestamp(14) NOT NULL
to
LAST_PLAY_DATE` timestamp NOT NULL
Sorry for the delay, is that I was with my server unavailable for a few months, I came back now, and I went after this error and changed in .INC, but it is returning this error now:
Quote:
0069 L 07/08/2018 - 006:42: [superheromod.amxx] DEBUG: Error Making Tables: [1064] 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to us' - 'CREATE TABLE IF NOT EXISTS `sh_savexp` ( `SH_KEY` varchar(32) binary NOT NULL default '', `PLAYER_NAME` varchar(32) binary NOT NULL default '', `LAST_PLAY_DATE` timestamL 07/08/2018 - 006:42: [superheromod.amxx] DEBUG: Couldn't Clean Powers: [1146] 'Table 'site13658764927.sh_saveskills' doesn't exist' - 'DELETE FROM `sh_saveskills` USING `sh_saveskills`, `sh_savexp` WHERE sh_savexp.`SH_KEY` = sh_saveskills.`SH_KEY` AND sh_savexp.`LAST_PLAY_DATE` < (SYSDATE() - INTERVAL '14' DAY) AND NOT (sh_savexp.`HUDHELP` & '4')'
__________________
gui1porpis is offline
Send a message via MSN to gui1porpis Send a message via Skype™ to gui1porpis
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 09:17.


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