sebaturen / blizzard-wow-guild-information-panel Goto Github PK

Erreur

Requête SQL :

CREATE TABLE `character_info` (
    `internal_id`       int NOT NULL,
    `battlegroup`       varchar(50) NOT NULL,
    `class`             int NOT NULL,
    `race`              int NOT NULL,
    `gender`            int NOT NULL,
    `level`             int NOT NULL,
    `achievementPoints` bigint(20) NOT NULL,
    `thumbnail`         varchar(70) NOT NULL,
    `calcClass`         varchar(2) NOT NULL,
    `faction`           int NOT NULL,
    `totalHonorableKills`   bigint(20) NOT NULL,
    `bestMythicPlusScore`   TEXT DEFAULT "{}",
    `mythicPlusScores`      TEXT DEFAULT "{}",
    `guild_name`            varchar(50) NOT NULL,
    `lastModified`          bigint(20) NOT NULL,
    PRIMARY KEY(internal_id),
    FOREIGN KEY(internal_id) REFERENCES gMembers_id_name(internal_id),
    FOREIGN KEY(`class`) REFERENCES playable_class(id),
    FOREIGN KEY(race) REFERENCES playable_races(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin

MySQL a répondu: Documentation
#1101 - BLOB 'bestMythicPlusScore' ne peut avoir de valeur par défaut

28-Jan-2019 18:07:32.470 INFOS [http-nio-8080-exec-4] org.apache.catalina.core.ApplicationContext.log HTMLManager: start: Starting web application '/Blizzard-WoW-Guild-information-panel'
28-Jan-2019 18:07:36.605 GRAVE [http-nio-8080-exec-4] org.apache.catalina.core.StandardContext.listenerStart Erreur lors de la configuration de la classe d'écoute de l'application (application listener) com.blizzardPanel.blizzardAPI.Upd$
java.lang.ClassNotFoundException: com.blizzardPanel.blizzardAPI.UpdateRunning
       at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)
       at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
       at org.apache.catalina.core.DefaultInstanceManager.loadClass(DefaultInstanceManager.java:511)
       at org.apache.catalina.core.DefaultInstanceManager.loadClassMaybePrivileged(DefaultInstanceManager.java:492)
       at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:118)
       at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4675)
       at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5215)
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
       at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1307)
       at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:669)
       at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:217)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:136)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:587)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
       at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
       at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
       at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
       at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
       at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1458)
       at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
       at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
       at java.lang.Thread.run(Thread.java:748)

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package test;

import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.TimeZone;
import org.json.simple.JSONObject;

/**
 *
 * @author 세바
 */
public class Test {
    public static final int RESET_DAY = Calendar.TUESDAY; //dey of week
    public static final int RESET_HOUR = 9; //hore of day (24h)

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        //quiero obtener el tiempo desde el ultimo dia del reset [fecha actual - {fecha hasta reset}]
        Date sTime = new Test().getServerTime();
        System.out.println("sTime> "+ sTime);
        Calendar c = Calendar.getInstance();
        c.setTime(sTime);
        System.out.println("C> "+ c.get(Calendar.DAY_OF_WEEK));
        
        long lastUpdate;
        if(c.get(Calendar.DAY_OF_WEEK) == RESET_DAY) //reset day
        {
            if(c.get(Calendar.HOUR_OF_DAY) >= RESET_HOUR) //is reset day
                lastUpdate = getLastReset(c, true);
            else //last reset day
                lastUpdate = getLastReset(c, false);
        }
        else //last reset day
            lastUpdate = getLastReset(c, false);
        
    }
    
    public static long getLastReset(Calendar time, boolean isMartes)
    {
        if(!isMartes)
        {
            do
            {
                time.add(Calendar.DAY_OF_WEEK, -1);                
            } while(time.get(Calendar.DAY_OF_WEEK) != RESET_DAY);
        }
        time.set(Calendar.HOUR_OF_DAY, RESET_HOUR);
        time.set(Calendar.MINUTE, 0);
        time.set(Calendar.SECOND, 0);
        System.out.println("Fecha> "+ time.get(Calendar.DAY_OF_MONTH) +"/"+ time.get(Calendar.MONTH)+1);
        System.out.println("Hora> "+ time.get(Calendar.HOUR_OF_DAY) +":"+ time.get(Calendar.MINUTE));
        System.out.println("Calendar> "+ time.getTimeInMillis());
        
        Date currentTime = null;
        try {
            currentTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(
                    time.get(Calendar.YEAR) +"-"+
                    (time.get(Calendar.MONTH)+1) +"-"+ //calendar object start month in 0
                    time.get(Calendar.DAY_OF_MONTH) +" "+
                    time.get(Calendar.HOUR_OF_DAY) +":"+
                    time.get(Calendar.MINUTE) +":"+
                    time.get(Calendar.SECOND));
        } catch (ParseException ex) {
            System.out.println("Error> "+ ex);
        }
        
        System.out.println("Calendar 2> "+ currentTime);
        System.out.println("Calendar 2> "+ currentTime.getTime());
        
        return time.getTimeInMillis();
    }
    
    public Date getServerTime()
    {
        Date currentTime = null;
        try {
            Calendar currentCalendar = Calendar.getInstance();
            currentCalendar.setTimeZone(TimeZone.getTimeZone("America/Los_Angeles"));
            currentTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(
                    currentCalendar.get(Calendar.YEAR) +"-"+
                    (currentCalendar.get(Calendar.MONTH)+1) +"-"+ //calendar object start month in 0
                    currentCalendar.get(Calendar.DAY_OF_MONTH) +" "+
                    currentCalendar.get(Calendar.HOUR_OF_DAY) +":"+
                    currentCalendar.get(Calendar.MINUTE) +":"+
                    currentCalendar.get(Calendar.SECOND));
        } catch (ParseException ex) {
            System.out.println("Error> "+ ex);
        }
        return currentTime;
    }
    
}