error after upgrade to joomla 4.2.1

Hi,
After upgrading to J4.2.1 I now get a 500 server error when using the form to add a record to a table.  The record is properly added however.  The page for editing a record works without problem.  This seems to be a bug in the latest update.  Any suggestions on how to fix this?

I note that of the 21 components, modules and plugins associated with visforms in my installation, some of them are listed as version 4.1.7 and others as 4.1.4.   Perhaps all need updating to 4.1.7?  Please advise.  

kind regards

Hello bstanton,

Visforms Base v4.17 and Visforms Subscription v4.1.4 is the correct current up-to-date version combination of both packages.
A file and extension mixture of different versions is correct and intended.

The version changes are documented here:
Base: www.vi-solutions.de/en/documentations/visforms/release-history
Subscription: www.vi-solutions.de/en/documentations/do...tion-release-history

In order to reproduce your error, I just updated a test instance to Joomla 4.2.1.
Visforms Base v4.17 and Visforms Subscription v4.1.4 are still working correctly after the Joomla update.
The form was sent without getting a 500 server error.

Visforms is used by tens of thousands of users.
All known bugs will be fixed immediately and no problems are currently known.
So if you use Visforms, you can assume that any problems that arise are not causally related to Visforms.
It is very likely that there is something fundamentally wrong with the Joomla instance.

A slightly more detailed bug report would be very helpful.
To get a verbose error report, enable maximum debugging in the Joomla administration before reproducing the error:

Dashboard --> Global Configuration, tab 'System', parameter 'Debug System' = 'Yes'
Dashboard --> Global Configuration, tab 'Server', parameter 'Error Reporting' = 'Maximum'

Best regards, Ingmar

Hi, thanks so much for your reply.  There was actually another update available today to 4.2.2,  however the problem persists with the new version.  The record is properly appended to the table, but I get this error.  Here is the result with debug turned on.  RuntimeException    InvalidArgumentException HTTP 500 Whoops, looks like something went wrong."500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3`
WHERE 1=1
&lt;?php if ($filters) : ?&gt;
and F16 = '{By_CountryState}'
&lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>" is not valid header value

• Exceptions 2
• Stack Traces 2

Laminas\Diactoros\Exception\InvalidArgumentException
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/HeaderSecurity.php  (line 146)
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php  :: assertValid (line 399)
Response->Laminas\Diactoros\{closure}('500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3` WHERE 1=1 &lt;?php if ($filters[\'By_CountryState\']) : ?&gt; and F16 = \'{By_CountryState}\' &lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>')
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php  array_map (line 402)
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php  -> filterHeaderValue (line 213)
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php  -> withHeader (line 243)
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/joomla/application/src/AbstractWebApplication.php  -> withAddedHeader (line 575)
AbstractWebApplication->setHeader('status', '500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3` WHERE 1=1 &lt;?php if ($filters[\'By_CountryState\']) : ?&gt; and F16 = \'{By_CountryState}\' &lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>')in  /home/ketamine/dev.ketaminecost.com/libraries/src/Document/ErrorDocument.php  (line 131)
ErrorDocument->render(false, array('template' => 'cassiopeia_child_template1', 'directory' => '/home/ketamine/dev.ketaminecost.com/templates', 'debug' => true, 'csp_nonce' => null, 'templateInherits' => 'cassiopeia', 'params' => object(Registry)))in  /home/ketamine/dev.ketaminecost.com/libraries/src/Error/Renderer/HtmlRenderer.php  (line 78)
HtmlRenderer->render(object(RuntimeException))in  /home/ketamine/dev.ketaminecost.com/libraries/src/Exception/ExceptionHandler.php  (line 121)
ExceptionHandler::render(object(RuntimeException))in  /home/ketamine/dev.ketaminecost.com/libraries/src/Exception/ExceptionHandler.php  (line 72)
ExceptionHandler::handleException(object(RuntimeException))in  /home/ketamine/dev.ketaminecost.com/libraries/src/Application/CMSApplication.php  (line 323)
CMSApplication->execute()in  /home/ketamine/dev.ketaminecost.com/includes/app.php  (line 61)
require_once('/home/ketamine/dev.ketaminecost.com/includes/app.php')in  /home/ketamine/dev.ketaminecost.com/index.php  (line 32)RuntimeExceptionDatabase is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3` WHERE 1=1 &lt;?php if ($filters) : ?&gt; and F16 = '{By_CountryState}' &lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>

Stack Traces:

 [2/2] InvalidArgumentExceptionLaminas\Diactoros\Exception\InvalidArgumentException:
"500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3`
WHERE 1=1
&lt;?php if ($filters) : ?&gt;
and F16 = '{By_CountryState}'
&lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>" is not valid header value

at /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/HeaderSecurity.php:146
at Laminas\Diactoros\HeaderSecurity::assertValid('500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3`
WHERE 1=1
&lt;?php if ($filters[\'By_CountryState\']) : ?&gt;
and F16 = \'{By_CountryState}\'
&lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>')
(/home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php:399)
at Laminas\Diactoros\Response->Laminas\Diactoros\{closure}('500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3`
WHERE 1=1
&lt;?php if ($filters[\'By_CountryState\']) : ?&gt;
and F16 = \'{By_CountryState}\'
&lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>')
at array_map(object(Closure), array('500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3`
WHERE 1=1
&lt;?php if ($filters[\'By_CountryState\']) : ?&gt;
and F16 = \'{By_CountryState}\'
&lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>'))
(/home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php:402)
at Laminas\Diactoros\Response->filterHeaderValue(array('500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3`
WHERE 1=1
&lt;?php if ($filters[\'By_CountryState\']) : ?&gt;
and F16 = \'{By_CountryState}\'
&lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>'))
(/home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php:213)
at Laminas\Diactoros\Response->withHeader('status', '500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3`
WHERE 1=1
&lt;?php if ($filters[\'By_CountryState\']) : ?&gt;
and F16 = \'{By_CountryState}\'
&lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>')
(/home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php:243)
at Laminas\Diactoros\Response->withAddedHeader('status', '500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3`
WHERE 1=1
&lt;?php if ($filters[\'By_CountryState\']) : ?&gt;
and F16 = \'{By_CountryState}\'
&lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>')
(/home/ketamine/dev.ketaminecost.com/libraries/vendor/joomla/application/src/AbstractWebApplication.php:575)
at Joomla\Application\AbstractWebApplication->setHeader('status', '500 Database is not available in constructor in 5.0.<br/><br/>Evaluated as:<br/><pre>select * from `jos1n_visforms_3`
WHERE 1=1
&lt;?php if ($filters[\'By_CountryState\']) : ?&gt;
and F16 = \'{By_CountryState}\'
&lt;?php endif; ?&gt; ORDER BY `F14` ASC</pre>')
(/home/ketamine/dev.ketaminecost.com/libraries/src/Document/ErrorDocument.php:131)
at Joomla\CMS\Document\ErrorDocument->render(false, array('template' => 'cassiopeia_child_template1', 'directory' => '/home/ketamine/dev.ketaminecost.com/templates', 'debug' => true, 'csp_nonce' => null, 'templateInherits' => 'cassiopeia', 'params' => object(Registry)))
(/home/ketamine/dev.ketaminecost.com/libraries/src/Error/Renderer/HtmlRenderer.php:78)
at Joomla\CMS\Error\Renderer\HtmlRenderer->render(object(RuntimeException))
(/home/ketamine/dev.ketaminecost.com/libraries/src/Exception/ExceptionHandler.php:121)
at Joomla\CMS\Exception\ExceptionHandler::render(object(RuntimeException))
(/home/ketamine/dev.ketaminecost.com/libraries/src/Exception/ExceptionHandler.php:72)
at Joomla\CMS\Exception\ExceptionHandler::handleException(object(RuntimeException))
(/home/ketamine/dev.ketaminecost.com/libraries/src/Application/CMSApplication.php:323)
at Joomla\CMS\Application\CMSApplication->execute()
(/home/ketamine/dev.ketaminecost.com/includes/app.php:61)
at require_once('/home/ketamine/dev.ketaminecost.com/includes/app.php')
(/home/ketamine/dev.ketaminecost.com/index.php:32)
Hoping that info can be of assistance to you.  

kindest regards!
 

Hier erstmal die Debug-Meldung etwas aufbereitet um sie besser lesen zu können:

RuntimeException    
InvalidArgumentException HTTP 500
Whoops, looks like something went wrong.
500 Database is not available in constructor in 5.0.


Evaluated as:
<pre>select * from `jos1n_visforms_3`
WHERE 1=1
<?php if ($filters) : ?>
and F16 = '{By_CountryState}'
<?php endif; ?> ORDER BY `F14` ASC</pre>" is not valid header value

    Exceptions 2
    Stack Traces 2

Laminas\Diactoros\Exception\InvalidArgumentException
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/HeaderSecurity.php  (line 146)
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php  :: assertValid (line 399)
Response->Laminas\Diactoros\{closure}('500 Database is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3` WHERE 1=1 <?php if ($filters[\'By_CountryState\']) : ?> and F16 = \'{By_CountryState}\' <?php endif; ?> ORDER BY `F14` ASC</pre>')
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php  array_map (line 402)
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php  -> filterHeaderValue (line 213)
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php  -> withHeader (line 243)
in  /home/ketamine/dev.ketaminecost.com/libraries/vendor/joomla/application/src/AbstractWebApplication.php  -> withAddedHeader (line 575)
AbstractWebApplication->setHeader('status', '500 Database is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3` WHERE 1=1 <?php if ($filters[\'By_CountryState\']) : ?> and F16 = \'{By_CountryState}\' <?php endif; ?> ORDER BY `F14` ASC</pre>')in  /home/ketamine/dev.ketaminecost.com/libraries/src/Document/ErrorDocument.php  (line 131)
ErrorDocument->render(false, array('template' => 'cassiopeia_child_template1', 'directory' => '/home/ketamine/dev.ketaminecost.com/templates', 'debug' => true, 'csp_nonce' => null, 'templateInherits' => 'cassiopeia', 'params' => object(Registry)))in  /home/ketamine/dev.ketaminecost.com/libraries/src/Error/Renderer/HtmlRenderer.php  (line 78)
HtmlRenderer->render(object(RuntimeException))in  /home/ketamine/dev.ketaminecost.com/libraries/src/Exception/ExceptionHandler.php  (line 121)
ExceptionHandler::render(object(RuntimeException))in  /home/ketamine/dev.ketaminecost.com/libraries/src/Exception/ExceptionHandler.php  (line 72)
ExceptionHandler::handleException(object(RuntimeException))in  /home/ketamine/dev.ketaminecost.com/libraries/src/Application/CMSApplication.php  (line 323)
CMSApplication->execute()in  /home/ketamine/dev.ketaminecost.com/includes/app.php  (line 61)
require_once('/home/ketamine/dev.ketaminecost.com/includes/app.php')in  /home/ketamine/dev.ketaminecost.com/index.php  (line 32)RuntimeExceptionDatabase is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3` WHERE 1=1 <?php if ($filters) : ?> and F16 = '{By_CountryState}' <?php endif; ?> ORDER BY `F14` ASC</pre>

Stack Traces:

 [2/2] InvalidArgumentExceptionLaminas\Diactoros\Exception\InvalidArgumentException:
"500 Database is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3`
WHERE 1=1
<?php if ($filters) : ?>
and F16 = '{By_CountryState}'
<?php endif; ?> ORDER BY `F14` ASC</pre>" is not valid header value

at /home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/HeaderSecurity.php:146
at Laminas\Diactoros\HeaderSecurity::assertValid('500 Database is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3`
WHERE 1=1
<?php if ($filters[\'By_CountryState\']) : ?>
and F16 = \'{By_CountryState}\'
<?php endif; ?> ORDER BY `F14` ASC</pre>')
(/home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php:399)
at Laminas\Diactoros\Response->Laminas\Diactoros\{closure}('500 Database is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3`
WHERE 1=1
<?php if ($filters[\'By_CountryState\']) : ?>
and F16 = \'{By_CountryState}\'
<?php endif; ?> ORDER BY `F14` ASC</pre>')
at array_map(object(Closure), array('500 Database is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3`
WHERE 1=1
<?php if ($filters[\'By_CountryState\']) : ?>
and F16 = \'{By_CountryState}\'
<?php endif; ?> ORDER BY `F14` ASC</pre>'))
(/home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php:402)
at Laminas\Diactoros\Response->filterHeaderValue(array('500 Database is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3`
WHERE 1=1
<?php if ($filters[\'By_CountryState\']) : ?>
and F16 = \'{By_CountryState}\'
<?php endif; ?> ORDER BY `F14` ASC</pre>'))
(/home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php:213)
at Laminas\Diactoros\Response->withHeader('status', '500 Database is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3`
WHERE 1=1
<?php if ($filters[\'By_CountryState\']) : ?>
and F16 = \'{By_CountryState}\'
<?php endif; ?> ORDER BY `F14` ASC</pre>')
(/home/ketamine/dev.ketaminecost.com/libraries/vendor/laminas/laminas-diactoros/src/MessageTrait.php:243)
at Laminas\Diactoros\Response->withAddedHeader('status', '500 Database is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3`
WHERE 1=1
<?php if ($filters[\'By_CountryState\']) : ?>
and F16 = \'{By_CountryState}\'
<?php endif; ?> ORDER BY `F14` ASC</pre>')
(/home/ketamine/dev.ketaminecost.com/libraries/vendor/joomla/application/src/AbstractWebApplication.php:575)
at Joomla\Application\AbstractWebApplication->setHeader('status', '500 Database is not available in constructor in 5.0.

Evaluated as:
<pre>select * from `jos1n_visforms_3`
WHERE 1=1
<?php if ($filters[\'By_CountryState\']) : ?>
and F16 = \'{By_CountryState}\'
<?php endif; ?> ORDER BY `F14` ASC</pre>')
(/home/ketamine/dev.ketaminecost.com/libraries/src/Document/ErrorDocument.php:131)
at Joomla\CMS\Document\ErrorDocument->render(false, array('template' => 'cassiopeia_child_template1', 'directory' => '/home/ketamine/dev.ketaminecost.com/templates', 'debug' => true, 'csp_nonce' => null, 'templateInherits' => 'cassiopeia', 'params' => object(Registry)))
(/home/ketamine/dev.ketaminecost.com/libraries/src/Error/Renderer/HtmlRenderer.php:78)
at Joomla\CMS\Error\Renderer\HtmlRenderer->render(object(RuntimeException))
(/home/ketamine/dev.ketaminecost.com/libraries/src/Exception/ExceptionHandler.php:121)
at Joomla\CMS\Exception\ExceptionHandler::render(object(RuntimeException))
(/home/ketamine/dev.ketaminecost.com/libraries/src/Exception/ExceptionHandler.php:72)
at Joomla\CMS\Exception\ExceptionHandler::handleException(object(RuntimeException))
(/home/ketamine/dev.ketaminecost.com/libraries/src/Application/CMSApplication.php:323)
at Joomla\CMS\Application\CMSApplication->execute()
(/home/ketamine/dev.ketaminecost.com/includes/app.php:61)
at require_once('/home/ketamine/dev.ketaminecost.com/includes/app.php')
(/home/ketamine/dev.ketaminecost.com/index.php:32)

Hi bstanton,
the text "Database is not available in constructor in 5.0." is a so-called deprecated message informing developers that a functionality will no longer be available in Joomla 5.

This message was added to the BaseDatabaseModel in Joomla 4.2.

I analyzed the call stack of your error messages carefully for a long time.
Unfortunately I cannot reproduce the error.
And unfortunately I don't know what exactly is causing the error.

There are a lot of things that strike me.
It looks like the installation is on a subdomain.
If so, is this possibly not set up correctly?
Why is there still php code in the mysql statement referenced in the error message?
Where does the pre-HTML tag come from, does it just come from displaying the error call stack?

My guess is that the problem doesn't arise with submitting the form, but with the structure of the page you are redirecting to after submitting the form.
I think this is a page that shows the saved data.
I think that this page shows visforms filters and that the error arises in building these filters.
So it could be an error that actually only occurs with your specific filter configuration.
But of course it can also be the case that there is ultimately a bug in Joomla 4.2.

I would like to take a closer look at the problem.
Would it be possible for you to provide us with an Akeeba backup of the website?
Then I could install it in our local development environment and see if the problem can be reproduced there.
If the problem can be reproduced, then I can debug it.

Best regards,
Aicha

Hello bstanton,

there is no visforms code listed in the error report call stack.

The only reference to visforms is that a visforms table is used: jos1n_visforms_3.
All code involved comes from Joomla (the late error handling) and mainly from the 'laminas' library: libraries/vendor/laminas/

So I think the Problem is not causally related to Visforms in any way.

Best regards, Ingmar