Raised This Month: $40 Target: $400
 10% 

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 , 11: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.
__________________

Hosting Services BR/EUA? Click here (exclusive to AMXBANS).
gui1porpis is offline
Send a message via MSN to gui1porpis Send a message via Skype™ to gui1porpis
notusian
Junior Member
Join Date: Dec 2004
Location: CA
Old 06-11-2017 , 19: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-08-2018 , 00: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')'
__________________

Hosting Services BR/EUA? Click here (exclusive to AMXBANS).
gui1porpis is offline
Send a message via MSN to gui1porpis Send a message via Skype™ to gui1porpis
notusian
Junior Member
Join Date: Dec 2004
Location: CA
Old Yesterday , 10:05   Re: Shero w/ MySQL "error"?
Reply With Quote #4

looks like youre missing the table from your site db. You will need to make the sh_saveskills table. I would guess you missed part of whatever setup was necessary. http://www.mysqltutorial.org/mysql-create-table/ fyi. Look for whatever step runs the create table statement and run it.
notusian 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:02.


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