View Single Post
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