Visforms, "Column checked_out can not be null"

Bronco
Autor
Offline

Mehr

1 Woche 5 Tage her - 1 Woche 5 Tage her #10915 von Bronco

Visforms, "Column checked_out can not be null" wurde erstellt von Bronco

Visforms V5.1.2
Joomla V5.2.1
PHP V8.2

Problem nr 1:
In admin side I click Data of a form to edit. Then when I ONLY click the Close-button, NOT Save & Close-button, I get that error. It works when I use the Save & Close-button.
I can also view the details without problems.

Problem nr 2:
In Frontpage and trying to edit I get 404 Page not found. But that is only for one form. Other forms works.
I tried to edit in admin side and saved and tried again to open the same data in Frontpage but still gets the same error.

Both of these problems is for the same form I setup and it worked earlier as it should before I updated Visforms. It works on the others forms I have without any problems. Before update I installed vfsubscription_j4.0.0_4.4.3.zip

/Thomas

Letzte Änderung: 1 Woche 5 Tage her von Bronco.

Administrator IV
Offline

Mehr

1 Woche 2 Tage her #10916 von Administrator IV

Administrator IV antwortete auf Visforms, "Column checked_out can not be null"

Hello Thomas,

the error '1048 Column checked_out cannot be null' was a known error in earlier versions.
It does not occur on any other Visforms installation.

When updating to the latest Visforms versions, SQL statements are run and the Visforms tables are adjusted accordingly.
The error is then resolved.

If these SQL statements did not run successfully for you, for whatever reason, you can try to run the SQL statements manually afterwards.
Run the following SQL statements in one go:

Code:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
ALTER TABLE `#__visforms` modify checked_out int unsigned null;
ALTER TABLE `#__visforms` modify checked_out_time datetime null;
ALTER TABLE `#__visfields` modify checked_out int unsigned null;
ALTER TABLE `#__visfields` modify checked_out_time datetime null;
ALTER TABLE `#__vispdf` modify checked_out int unsigned null;
ALTER TABLE `#__vispdf` modify checked_out_time datetime null;

The two SQL statements

Code:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

are only sometimes necessary under certain database server settings.
In most cases they are not absolutely necessary.

Adaptation to your database:
Change the following into the above SQL statements.
#__ --> Your Joomla table name prefix.

The error should then be resolved.

Best regards, Ingmar

I recommend you the new and up-to-date documentation for Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/en/docs/
Most of this also applies retrospectively to Joomla 3.
Please only ask 1 question per topic :-)

Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 3.
Bitte immer nur 1 Frage pro Thema stellen :-)

Bronco
Autor
Offline

Mehr

1 Woche 2 Tage her #10917 von Bronco

Bronco antwortete auf Visforms, "Column checked_out can not be null"

Hi, nope didn't work. Same errors. I saw the same errors report in this forum earlier but that seemed to work when the user clicked Save & Close-button. For me it happens only when I click the Close-button.

Bronco
Autor
Offline

Mehr

1 Woche 2 Tage her #10918 von Bronco

Bronco antwortete auf Visforms, "Column checked_out can not be null"

Hi again.

It did work. I just hade to change all the "#__visforms_*" too

Administrator IV
Offline

Mehr

1 Woche 2 Tage her #10919 von Administrator IV

Administrator IV antwortete auf Visforms, "Column checked_out can not be null"

Hello Thomas,

I'm very happy that it worked.

Both processes and error messages mentioned here lead back to the same fact that 'null' values ??were suddenly allowed in the affected field during Joomla development (Joomla 4).
By explicitly allowing 'null' values ??in the table design, this fact is taken into account.
The SQL statements usually do this automatically with a total of 6 Visforms tables during the update.

Could you perhaps briefly list at least one of your changed final SQL statements here?
Simply so that it is clear what exactly you have changed and how?

Best wishes, Ingmar

Bronco
Autor
Offline

Mehr

1 Woche 23 Stunden her - 1 Woche 23 Stunden her #10928 von Bronco

Bronco antwortete auf Visforms, "Column checked_out can not be null"

Sure,

First I did what you wrote. Then this:

Code:

ALTER TABLE `d70do_visforms_2` modify checked_out int unsigned null;
ALTER TABLE `d70do_visforms_2` modify checked_out_time datetime null;
ALTER TABLE `d70do_visforms_8` modify checked_out int unsigned null;
ALTER TABLE `d70do_visforms_8` modify checked_out_time datetime null;

And so on.
I probably didn't need to change all the forms I had since it was only one that "malfunctioned".

/Thomas

Letzte Änderung: 1 Woche 23 Stunden her von Bronco.

Folgende Benutzer bedankten sich: Administrator IV

Moderatoren: Administrator AV, Administrator IV

Joomla 5 Mitteilung

Forum

Visforms, "Column checked_out can not be null"

Visforms Subscription

Visforms Erweiterungen