Bonjour / Hi,
On a fresh install of 11.3.1 on a shared hosting site, I'm getting a lot of errors about missing tables and fields (see attached logs).
This was first exposed when I tried to add a new activity and received the error:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'control-panel-user_projeqtor.votingitem' doesn't exist.
It looks like the database is corrupted. What might have caused that?
Thanks,
Mark
Hello,
As I see your other message on the forum, it's highly possible there was a problem at the installation, this might be why some tables are missing.
Have you tried to install ProjeQtOr on a local server on your computer to see if everything is ok ?
Install has many errors.
Please check errors logged during install, fix them then reinstall
Thanks. I've tried installing twice on the same host, with similar issues - the database tables are not created fully.
I will try locally next.
What might cause the database problems? Perhaps a timeout?
Check for errors in your DB logs to identify issue
Hi,
A brief update on where I am with this:
- Projeqtor works brilliantly when run locally via Devilbox
- On PlanetHoster the installation script which populates the database tables is timing out with this error:
Error on sending request(POST /tool/loginCheck.php?destinationWidth=283.797&destinationHeight=100&isIE=&xhrPostDestination=loginResultDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1721852405381&csrfToken= HTTP/1.1); uri(/tool/loginCheck.php?destinationWidth=283.797&destinationHeight=100&isIE=&xhrPostDestination=loginResultDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1721852405381&csrfToken=) content-length(96): ReceiveAckHdr: timeout 300 is exceeded
- On PlanetHoster I've increased the hosting to 4 CPU, 8GB RAM and 9MB/s disk I/O. This has made no difference to the timeout. The number of tables created varies each time. The last time I tried, with the maximum CPUs actually ended up with fewer tables than previous attempts
- PlanetHoster support suggested adding these lines to .htaccess:
RewriteEngine On
RewriteRule .* - [E=noconntimeout:1]
This made no difference. The script still timed out.
Given that PlanetHoster can support a Moodle installation (creating over 300 tables), I'm thinking there's some specific incompatibility between the PlanetHoster platform and Projeqtor. So it looks like I'll need to look for a new host.
Hello,
If you have access to the php.ini file on your host service, please check which value you have for the max_execution_time parameter.
From what I read in your message "timeout 300 is exceeded", it might be related to this. You need a higher value, to let the scripts do their work.
Yes, unfortunately I don't have that level of access. I think we'd hoped the htaccess directive would have solved this.
No worries.
Another update.
I have now updated the max_execution_time to 3600. It seems to have made no difference. The script still stops without populating all the tables.
Symptom:
- Error: Invalid login parameters
Based on https://www.projeqtor.org/en/kunena-2/2-submit-issues/9628-invalid-login-parameters?start=12#37701 this is because there is a missing parameter in the table.
Any other thoughts about what might be causing this? It seems to be a PlanetHoster issue. I'd be happy to move to a new host. Is there a list of hosting providers that work with Projeqtor?
Thanks,
Mark