search

itx-informationssysteme / jobapplications

This TYPO3 extension enables you to manage job postings, provides you with an application form and a backend module to manage incoming applications.
https://extensions.typo3.org/extension/jobapplications/
Other
7 stars 10 forks source link

DB-Analyzer can't handle SQL statement #145

Closed akohlheyer closed 2 months ago

akohlheyer commented 4 months ago

Is it possible to change 

message                   text         DEFAULT '' NOT NULL,

to

message                   text,

in this line, if this wasn't on purpose?

zenoussi commented 2 months ago

ALTER TABLE tx_jobapplications_domain_model_application CHANGE message message TEXT NOT NULL Current value: message TEXT CHARACTER SET utf8mb4 NOT NULL COLLATE utf8mb4_unicode_ci

@akohlheyer hope so too

lstitx commented 2 months ago

Hi, what's the issue exactly?

akohlheyer commented 2 months ago

Hi, what's the issue exactly?

as far as my requirement is concerned, I try to use the "Analyze Database Structure" function in the Install tool. The mentioned field won't disappear after exexuting the suggested actions. Changing the mentioned line above fixes this misbehaviour.