Hallo, syntax mit mysql bei der instalation bekomme ich immer Fehlermeldungen,
ich habe die Datenbank wie beschrieben mit den rechten angelegt bei der Intalation bekomme ich folgende Fehlermeldung!

unable to init plugin syntax: Plugin "syntax" wurde aufgrund eines Fehlers bei der Initialisierung deaktiviert.
Fehlermeldung: error while installing service database; nested exception is:
java.rmi.RemoteException: java.sql.SQLException: exception while executing sql script: (conn=146) Table version already exists
Query is: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB. Current statement: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB; nested exception is:
de.willuhn.util.ApplicationException: java.sql.SQLException: exception while executing sql script: (conn=146) Table version already exists
Query is: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB. Current statement: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB

Du versuchst die SynTAX-Tabellen in einer MySQL-Datenbank anzulegen, die bereits Tabellen enthält. Entweder du verwendest hier die Hibiscus-Datenbank und es kommt zu dem Konflikt, weil es in Hibiscus ebenfalls eine Tabelle "version" gibt oder du hattest schonmal SynTAX installiert. Stelle sicher, dass die SynTAX-Datenbank noch keine Tabellen enthält.

komme nicht weiter tabele version gelöscht nei instaliert dann der nächste fehler tabele version wieder vorhanden!


error while checking database
java.rmi.RemoteException: java.sql.SQLException: exception while executing sql script: (conn=186) Table 'version' already exists
Query is: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB. Current statement: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB; nested exception is:
de.willuhn.util.ApplicationException: java.sql.SQLException: exception while executing sql script: (conn=186) Table 'version' already exists
Query is: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB. Current statement: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB
at de.willuhn.jameica.fibu.server.DBServiceImpl.start(DBServiceImpl.java:149)
at de.willuhn.jameica.fibu.gui.controller.FirstStartControl$FirstStart2.handleAction(FirstStartControl.java:463)
at de.willuhn.jameica.fibu.gui.controller.FirstStartControl.handleForward(FirstStartControl.java:395)
at de.willuhn.jameica.fibu.gui.views.FirstStart1CreateDatabase$1.handleAction(FirstStart1CreateDatabase.java:56)
at de.willuhn.jameica.gui.parts.Button$1$1.run(Button.java:174)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at de.willuhn.jameica.gui.GUI$6.run(GUI.java:916)
at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:183)
at org.eclipse.swt.widgets.Display.syncExec(Display.java:5960)
at de.willuhn.jameica.gui.GUI.startSync(GUI.java:912)
at de.willuhn.jameica.gui.parts.Button$1.widgetSelected(Button.java:168)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:265)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:91)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1617)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517)
at de.willuhn.jameica.gui.GUI.loop(GUI.java:933)
at de.willuhn.jameica.gui.GUI.init(GUI.java:335)
at de.willuhn.jameica.system.Application.init(Application.java:145)
at de.willuhn.jameica.system.Application.newInstance(Application.java:87)
at de.willuhn.jameica.Main.main(Main.java:78)
Caused by: de.willuhn.util.ApplicationException: java.sql.SQLException: exception while executing sql script: (conn=186) Table 'version' already exists
Query is: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB. Current statement: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB
at de.willuhn.sql.version.Updater.execute(Updater.java:249)
at de.willuhn.sql.version.Updater.execute(Updater.java:181)
at de.willuhn.jameica.fibu.server.DBServiceImpl.start(DBServiceImpl.java:140)
... 21 more
Caused by: java.sql.SQLException: exception while executing sql script: (conn=186) Table 'version' already exists
Query is: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB. Current statement: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB
at de.willuhn.sql.ScriptExecutor.execute(ScriptExecutor.java:195)
at de.willuhn.sql.version.Updater.execute(Updater.java:244)
... 23 more
Caused by: java.sql.SQLSyntaxErrorException: (conn=186) Table 'version' already exists
Query is: CREATE TABLE version (id int(10) AUTO_INCREMENT,name varchar(255) NOT NULL,version int(5) NOT NULL,UNIQUE (id),PRIMARY KEY (id)) ENGINE = InnoDB
at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:289)
at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:378)
at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:189)
at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:1246)
at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:1185)
at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:1104)
at org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:1028)
at org.mariadb.jdbc.Statement.executeInternal(Statement.java:1016)
at org.mariadb.jdbc.Statement.executeUpdate(Statement.java:996)
at org.mariadb.jdbc.Statement.executeUpdate(Statement.java:187)
at de.willuhn.sql.ScriptExecutor.execute(ScriptExecutor.java:166)
... 24 more