View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Missing database elements - ProjeQtOr
 

Missing database elements

More
18 Jul 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 Log in or Create an account to join the conversation.

More
19 Jul 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 Log in or Create an account to join the conversation.

More
19 Jul 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 Log in or Create an account to join the conversation.

More
22 Jul 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 Log in or Create an account to join the conversation.

More
23 Jul 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 Log in or Create an account to join the conversation.

More
26 Jul 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 Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.055 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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