View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Missing database elements - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

15 et 16 avril 2025 (9h-12h30)

14 et 15 mai 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

23 et 24 avril (9h-12h30)

20 et 21 mai (9h-12h30)

 

 

 

Missing database elements

More
18 Juil 2024 22:34 #1 by berthelemy
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
Attachments:

Please Connexion or Create an account to join the conversation.

More
19 Juil 2024 09:52 #2 by Plucks
Replied by Plucks on topic Missing database elements
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 ?

Please Connexion or Create an account to join the conversation.

More
19 Juil 2024 18:49 #3 by babynus
Replied by babynus on topic Missing database elements
Install has many errors.
Please check errors logged during install, fix them then reinstall

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
22 Juil 2024 17:01 #4 by berthelemy
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?

Please Connexion or Create an account to join the conversation.

More
23 Juil 2024 10:33 #5 by babynus
Replied by babynus on topic Missing database elements
Check for errors in your DB logs to identify issue

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
26 Juil 2024 09:25 #6 by berthelemy
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.

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.041 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.