pflumm
commented
2 months ago It's the same on my Installation !
Perhaps this SQL-Statement (after installing " Displayed Required SQL" into the webcalendar-SQL-DB) helps to solve this issue: (Unfortunately in Germany!)
Fehler Statische Analyse: 3 Fehler wurden während der Analyse gefunden. Unerwarteter Statement-Anfang. (near "Description:" at position 13) Unerwarteter Statement-Anfang. (near "This" at position 28) Unerkannte Statement-Typ. (near "FILE" at position 33) SQL-Befehl: Kopieren / Description: This FILE IS used TO CREATE ALL TABLES used BY WebCalendar AND initialize SOME of those TABLES WITH the required DATA. The comments IN the TABLE definitions will be parsed TO generate a document(IN HTML) that describes these TABLES./ / Defines a WebCalendar user./ CREATE TABLE webcal_user( / the unique user login / cal_login VARCHAR(25) NOT NULL, / the user's password. (not used for http) / cal_passwd VARCHAR(255), / user's last name / cal_lastname VARCHAR(25), / user's first name / cal_firstname VARCHAR(25), / is the user a WebCalendar administrator ('Y' = yes, 'N' = no) / cal_is_admin CHAR(1) DEFAULT 'N', / user's email address / cal_email VARCHAR(75) NULL, / allow admin to disable account ('Y' = yes, 'N' = no) / cal_enabled CHAR(1) DEFAULT 'Y', / user's telephone / cal_telephone VARCHAR(50) NULL, / user's address / cal_address VARCHAR(75) NULL, / user's title / cal_title VARCHAR(75) NULL, / user's birthday / cal_birthday INT NULL, / user's last log in date */ cal_last_login INT NULL, PRIMARY KEY(cal_login) ); MySQL meldet: Dokumentation
1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei '/
* * * Description: * This FILE IS used TOCREATE ALL TABLES used BY WebC' in Zeile 1
MpmSys
When running the script to create the database for version 1.9.10 the first part of step 3 to create the database works. I am then presented with an update database button. That step just hangs.