Forums

Form timeout on Read Data from large table

Pkoll 02 Dec, 2024

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

Max_admin 02 Dec, 2024

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

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 02 Dec, 2024

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

Max_admin 02 Dec, 2024

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

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 17 Dec, 2024

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

Max_admin 17 Dec, 2024

this error is on frontend or backend or both ?

do you have the latest update applied ?

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 17 Dec, 2024

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.

Max_admin 17 Dec, 2024

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

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 17 Dec, 2024

I became this:

Pkoll 17 Dec, 2024

This is what I have installed this moment.

is that a problem?

Max_admin 17 Dec, 2024

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

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 17 Dec, 2024

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

Max_admin 17 Dec, 2024

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 ?

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 18 Dec, 2024

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

Max_admin 19 Dec, 2024

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 ?

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 19 Dec, 2024

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

Max_admin 29d ago

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 ?

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 29d ago

Hello Max

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

Error log server

Pkoll 25d ago

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

Pkoll 25d ago

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

Max_admin 25d ago
Answer

Do you read the whole table ? if you read the whole table and the table is large then there will be a timeout, I did not try different tables on your website.

You must set a limit when you read the table records if the table has more than 100 rows

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 20d ago

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

Max_admin 19d ago

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

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 19d ago

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

Max_admin 18d ago

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! 😊

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Pkoll 18d ago

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

Max_admin 17d ago

Hi Paul

Great news, thank you too! 😊

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
You need to login to be able to post a reply.