Liebes SoScisurvey Team,
wenn wir versuchen Kontaktdaten getrennt zu erheben, wird nichts in die Tabelle sosci_contacts in der DB von SoSci gespeichert.
Im Log steht die Fehlermeldung:
[28-Jan-2022 14:14:00 Europe/Berlin] SQL error 1054: Unknown column 'cnt' in 'field list'
INSERT INTO `soscisurvey`.`sosci_contacts`
SET project=36, cdata='test@gmx.de', selection='L', subgroup='A003', language='deu'
ON DUPLICATE KEY UPDATE selection='L', language='deu', cnt=cnt+1
show create table sosci_contacts zeigt:
| sosci_contacts | CREATE TABLE `sosci_contacts` (
`project` int NOT NULL,
`cdata` text COLLATE utf8_unicode_ci NOT NULL,
`selection` set('I','L','A','B','C','T') COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`subgroup` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`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') COLLATE utf8_unicode_ci DEFAULT NULL,
UNIQUE KEY `pe` (`project`,`cdata`(64),`subgroup`),
CONSTRAINT `sosci_contacts_project_CS` FOREIGN KEY (`project`) REFERENCES `sosci_projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci |
Wie man sehen kann, die Spalte cnt in der Tabelle fehlt.
Eventuell könnten Sie mir helfen, das Problem zu beseitigen? Muss die Spalte manuell von uns ergänzt werden, oder wurde von uns irgendwas falsch konfigurieren? Oder noch irgendwas?
Programm-Version 3.2.44
Danke Ihnen im Voraus!
Mit freundlichen Grüßen
Mit freundlichen