Forum

Missing database el...
 
Notifications
Retirer tout

Missing database elements

9 Posts
3 Utilisateurs
0 Reactions
2,413 Vu
(@berthelemy)
Posts: 8
Active Member
Début du sujet
 
[#9529]

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


 
Posté : 19/07/2024 12:34 am
(@cecile)
Posts: 160
Membre Admin
 

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 ?


 
Posté : 19/07/2024 11:52 am
(@babynus)
Posts: 14952
Membre Admin
 

Install has many errors.
Please check errors logged during install, fix them then reinstall


 
Posté : 19/07/2024 8:49 pm
(@berthelemy)
Posts: 8
Active Member
Début du sujet
 

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?


 
Posté : 22/07/2024 7:01 pm
(@babynus)
Posts: 14952
Membre Admin
 

Check for errors in your DB logs to identify issue


 
Posté : 23/07/2024 12:33 pm
(@berthelemy)
Posts: 8
Active Member
Début du sujet
 

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.


 
Posté : 26/07/2024 11:25 am
(@cecile)
Posts: 160
Membre Admin
 

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.


 
Posté : 26/07/2024 11:34 am
(@berthelemy)
Posts: 8
Active Member
Début du sujet
 

Yes, unfortunately I don't have that level of access. I think we'd hoped the htaccess directive would have solved this.
No worries.


 
Posté : 26/07/2024 11:39 am
(@berthelemy)
Posts: 8
Active Member
Début du sujet
 

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


 
Posté : 26/07/2024 2:21 pm
Share:
Retour en haut