Sehr geehrte SoSci Online Suppert Team,
bei der ersten Installation der DatenBank bekamen wir den Fehler:
Setting up SoSci Survey v3.2.33 (i1309) on 195.72.103.81.
The database soscisurvey has been created.
Initializing Database Tables
Creating database table for User Accounts (sosci_users).
Error: MySQL error MYSQL.1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET ascii COLLATE ascii_bin, UNIQUE login(login), loginID' at line 4
MySQL query: CREATE TABLE IF NOT EXISTS `soscisurvey`.`sosci_users`( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (id), login VARCHAR(63) NOT NULL CHARACTER SET ascii COLLATE ascii_bin, UNIQUE login(login), loginID VARCHAR(32), remote VARCHAR(64), clients VARCHAR(255), password VARCHAR(255) COLLATE utf8_bin, salt VARCHAR(64) COLLATE utf8_bin, title VARCHAR(32), firstName VARCHAR(64), lastName VARCHAR(64), titlePost VARCHAR(32), email VARCHAR(255), gender ENUM("female","male","other"), university VARCHAR(255), institute VARCHAR(255), company VARCHAR(255), unit VARCHAR(255), address TEXT, country VARCHAR(255), taxID VARCHAR(32), taxType ENUM("business","private"), serverAuth SET("adminServer","adminSurvey","sendMessage","isBanned","isFixed","int"), featureAuth SET("sendMailing","sendSMS","uploadImage","uploadMedia","sMail","sSMS","uIm","uMd","cFx","mIAT","qSrt","aTs","lSAP"), language ENUM("qaa","qab","qac","qca","qcb","qcc","ara","bul","chi","cze","dan","dut","ger","eng","est","fre","fin","gre","gle","gsw","hun","ita","jpn","kor","hrv","lav","lit","mlt","nds","nor","pol","por","rum","rus","swe","srp","slo","slv","spa","tur","aar","abk","ace","ach","ada","ady","afa","afh","afr","ain","aka","akk","alb","ale","alg","alt","amh","anp","apa","arg","arm","arn","arp","arw","asm","ast","ath","aus","ava","ave","awa","aym","aze","bad","bai","bak","bal","bam","ban","baq","bas","bat","bej","bel","bem","ben","ber","bho","bih","bik","bin","bis","bla","bnt","bos","bra","bre","btk","bua","bug","bur","byn","cad","cai","car","cat","cau","ceb","cel","cha","chb","che","chg","chk","chm","chn","cho","chp","chr","chv","chy","cmc","cop","cor","cos","cpe","cpf","cpp","cre","crh","crp","csb","cus","dak","dar","day","del","den","deu","dgr","din","div","doi","dra","dsb","dua","dyu","dzo","efi","eka","elx","epo","ewe","ewo","fan","fao","fas","fat","fij","fil","fiu","fon","frr","frs","fry","ful","fur","gaa","gay","gba","geo","gez","gil","gla","glg","glv","gon","gor","got","grb","grn","guj","gwi","hai","hat","hau","haw","heb","her","hil","him","hin","hit","hmn","hmo","hsb","hup","iba","ibo","ice","ido","iii","ijo","iku","ile","ilo","ina","inc","ind","ine","inh","ipk","ira","iro","jav","jbo","jpr","jrb","kaa","kab","kac","kal","kam","kan","kar","kas","kau","kaw","kaz","kbd","kha","khi","khm","kho","kik","kin","kir","kmb","kok","kom","kon","kos","kpe","krc","krl","kro","kru","kua","kum","kur","kut","lad","lah","lam","lao","lat","lez","lim","lin","lol","loz","ltz","lua","lub","lug","lui","lun","luo","lus","mac","mad","mag","mah","mai","mak","mal","man","mao","map","mar","mas","may","mdf","mdr","men","mic","min","mkh","mlg","mnc","mni","mno","moh","mon","mos","mun","mus","mwl","mwr","myn","myv","nah","nai","nan","nap","nau","nav","nbl","nde","ndo","nep","new","nia","nic","niu","nno","nob","nog","non","nqo","nso","nub","nwc","nya","nym","nyn","nyo","nzi","oci","oji","ori","orm","osa","oss","oto","paa","pag","pal","pam","pan","pap","pau","per","phi","pli","pon","pra","pus","que","raj","rap","rar","roa","roh","rom","run","rup","sad","sag","sah","sai","sal","sam","san","sas","sat","scn","sco","sel","sem","sgn","shn","sid","sin","sio","sit","sla","sma","sme","smi","smj","smn","smo","sms","sna","snd","snk","sog","som","son","sot","srd","srn","srr","ssa","ssw","suk","sun","sus","sux","swa","syc","syr","tah","tai","tam","tat","tel","tem","ter","tet","tgk","tgl","tha","tib","tig","tir","tiv","tkl","tlh","tli","tmh","tog","ton","tpi","tsi","tsn","tso","tuk","tum","tup","tut","tvl","twi","tyv","udm","uga","uig","ukr","umb","urd","uzb","vai","ven","vie","vol","vot","wak","wal","war","was","wel","wen","wln","wol","xal","xho","yao","yap","yid","yor","ypk","zap","zbl","zen","zha","zho","znd","zul","zun","zza"), infoOnMsg ENUM("no","yes") NOT NULL DEFAULT "yes", variableIP ENUM("no","yes") NOT NULL DEFAULT "no", status ENUM ("cNone","cData","cMail","cAdmin") NOT NULL DEFAULT "cNone", expirationDate DATE, receiveTerms DATE, acceptTerms DATE, acceptArchive DATE, acceptStore VARCHAR(255), registered DATETIME, customerID INT, UNIQUE customerID(customerID), customerREF INT, CONSTRAINT sosci_users_customerREF_CS FOREIGN KEY customerREF(customerREF) REFERENCES `soscisurvey`.`sosci_users`(customerID) ON DELETE SET NULL, last_login DATE, lastUpdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, adminNotice TEXT ) ENGINE = InnoDB, CHARACTER SET = utf8, COLLATE = utf8_unicode_ci
Error: An error has occurred while trying to create the table Account.
Wir benutzen "mysql Ver 8.0.26-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu))"
SoSci hat die Instalation mit ROOT Rechten durchgeführt.
Wie können wir das Problem beheben?
Mit freundlichen Grüßen