Form timeout on Read Data from large table

Hi max,

After upgrading to version 29 and 30, I can no longer open the forms in Front view.

Even when I use the form on the website as a test, it does not work and after a while, I get the error message "503 service unavailabel".

The strange thing is that some work and others do not. What could be the reason?

Greetings 

Paul

please set the Joomla error reporting to Maximum, does it show a specific error message ?

No, no specific errors, can I send you tomorrow a userid and password so you can see it your self. What e-mail adres I use?

Paul

sure, you can send them using the Contact form

But the error means something went wrong with the script execution, so you may also check the server logs if possible

Hi Max,

I stil have the problem to show the forms in the front view. Maybe it is the configuration of PHP by the provider. So I install the form on another website. There I became the error:

0 Failed opening required '/home/kollau22/domains/atelier78.nl/public_html/components/com_chronoforms8/extension.php' (include_path='.:/opt/alt/php81/usr/share/pear:/opt/alt/php81/usr/share/php:/usr/share/pear:/usr/share/php')

Is that the problem I have with the front view ?

Can you help?

Greetings 

Paul

this error is on frontend or backend or both ?

do you have the latest update applied ?

The form works fine in the backend in the admin view, but the front view doesn't work there either and I get the error message 503. So I placed the form in the frontend menu and it doesn't work there. Placed the form on another site and there I got the above error.

The provider also increases the version of Php to 8.3. but that gives no result. The CF version is 8.0.33.

enable the joomla debug and access the page with the error and send me a screenshot of the debug report, it will show which file is calling the not found file

I became this:

This is what I have installed this moment.

is that a problem?

line 11 at the last file does not have a requirement as in the error, can you paste here the contents of the top file in the debug:

JROOT/components/com_chronoforms8/chronoforms8.php

JROOT/components/com_chronoforms8/chronoforms8.php

<?php/*** ChronoForms 8* Copyright (c) 2023 ChronoEngine.com, All rights reserved.* Author: (ChronoEngine.com Team)* license:     GNU General Public License version 2 or later; see LICENSE.txt* Visit http://www.ChronoEngine.com for regular updates and information.**/defined('_JEXEC') or die('Restricted access');

require_once(__DIR__."/extension.php");

ChronoApp::Instance("chronoforms8", "ChronoForms 8")->processExtension();

Paul

this is supposed to be in the admin folder, I do not understand why it's in your front folder, please download the v8.0.34 package and install it OVER yours, does it help file the issue ?

Hi Max,

I have installed the new version. The problem is the same. No front view in the backend and in the website is doesn't work and after a time the error 503 server not available.

In a mail I send you a userid and password so you can see it your self.

Greetings,

Paul

I tested it and some forms work fine but others no, I do not know why is that, all forms are created on v8 ? or some are imported ? which ones are imported ?

Hi Max,

The most forms are made in CF8, only "contact form" is imported.

Thanks for checking the forms.

It seems that as soon as I use the action "read database" the front view no longer works. Could that be the cause?

Maybe this will help solve the problem?

Greetings,Paul

yes, as soon as a table is selected it stops working, i could not enable the debug to check if it returns the same error you reported earlier or not

Can you enable the debug and test the form I created ? it does not work but I'm not sure if its the same error about the file path ?

Hello Max

The debug you asked. I hope that this will help you to find the solution.

Error log server

I was talking about the Joomla debug when the page times out like you did previously here:

https://www.chronoengine.com/forums/topics/view/111451/front-view#p404974

Hi Max,

I have tried it but no error. I put in a read database with a small table and it works. After that I read a lager table like Content from Joomla and yes again error 503.

I don't understand and in the error log nothing.

I give up hope and returned to CF 7

Greetings Paul

I forgot to say, when I remove the read database, no problem. So I think it is the read database that cause the problem!

Paul

Hi max,

I have found some log information about the error 503.

This I have found:

2024-12-29 20:19:32.637215 [INFO] [2370813] [T0] [2001:1c03:5113:ec00:d988:fd72:8979:892a:62663-H3:B4613A93FA1D04FA-12#APVH_www.fjdbc.nl:443] connection to [uds://usr/local/lsws/extapp-sock/APVH_dtouycuj_Suphp.sock] on request #0, confirmed, 1, associated process: 2609899, running: 1, error: Connection reset by peer!2024-12-29 20:19:32.637284 [NOTICE] [2370813] [T0] [2001:1c03:5113:ec00:d988:fd72:8979:892a:62663-H3:B4613A93FA1D04FA-12#APVH_www.fjdbc.nl:443] oops! 503 Service Unavailable

Give this some information for you?

Greetings

Paul

Hi Paul

Thank you for sharing the error, but unfortunately I do not think it gives me much information about the problem, but as I noted earlier, if you are reading hundreds of records at once then this may overflow the system memory and cause an error

Hi Max

i have put the limit on 40 the same problem. The provider where i host the site is also searching for the problem. The local environment with Apache, php 8.03 and Mysql gives no problem. So i think it is the provider where the problem lies. As soon as I know something you hear from me

Paul, have a good 2025

Hi Paul

Which limit ? the memory limit ?

I suggest that you do not read so many rows anyway, online servers will struggle with this even if it works locally, since online hosts will always have a limited memory and many requests, each PHP request consumes it's own memory which drains the total server memory very fast

Have a good 2025 too! 😊

Hi Max,

The error is found! Not Chronoforms 8 is the problem but the plugin from RegularLab email protector.

The provider from my Website has found this.

So let the new year start with CH 8

Thanks for your patient and good Luuk!

greetings 

Paul

Hi Paul

Great news, thank you too! 😊