View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Error 500 (svnRevision Undefined variable) on fesh 12.0 install - Page 2 - ProjeQtOr
 

[SOLVED] Error 500 (svnRevision Undefined variable) on fesh 12.0 install

More
20 Dec 2024 08:28 #7 by arnocp
Thanks a lot for replying,
but it's not an apache server but a IIS.
And i do not have anything in the server logs :-(
Regards 

File Attachment:

File Name: u_ex241219.log
File Size:8 KB
Attachments:

Please Log in or Create an account to join the conversation.

More
20 Dec 2024 12:00 #8 by arnocp
After severals setting and try i have this error:
2024-12-20 11:57:32.025 ***** ERROR ***** [] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'manual int(1) unsigned DEFAULT 0 COMMENT '1'' at line 1
2024-12-20 11:57:32.028 ***** ERROR ***** []    For query : ALTER TABLE pl_assignment MODIFY manual int(1) unsigned DEFAULT 0 COMMENT '1';
2024-12-20 11:57:32.031 ***** ERROR ***** []    Strack trace :
2024-12-20 11:57:32.033 ***** ERROR ***** []    #0 Sql->query called at [C:\WWW2\db\maintenanceFunctions.php:72]
2024-12-20 11:57:32.034 ***** ERROR ***** []    #1 runScript called at [C:\WWW2\db\maintenance.php:1057]
2024-12-20 11:57:32.036 ***** ERROR ***** []    #2 include called at [C:\WWW2\tool\loginCheck.php:58]
2024-12-20 11:57:32.039 ===== TRACE =====
2024-12-20 11:57:32.040 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V8.6.0.mysql (see above message)
2024-12-20 11:57:32.042 ===== TRACE =====
2024-12-20 11:57:32.044 ===== TRACE ===== *************************************************
2024-12-20 11:57:32.045 ===== TRACE =====
Regards

Please Log in or Create an account to join the conversation.

More
20 Dec 2024 20:28 #9 by babynus
Hi,

Strange as Query should be

ALTER TABLE `pl_assignment` ADD `manual` int(1) unsigned DEFAULT '0';

With the reverse quotes.
This is important as manual seems to be a resereved key work in MySql 8.4, but was not on MySql8.0

Ensure you correctly selected "mysql" as DB type.
If this is already the case, only option seems to be to revert to older MySql DB version (8.0) or MariaDB or PostgreSql.

We'll study the option to fix the new incompatibility with MySql 8.4
 

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: arnocp

Please Log in or Create an account to join the conversation.

More
10 Jan 2025 14:51 #10 by arnocp
Hello,
Have an happy new years everybody ;-)
Sorry for the delay...
I set a maraidb server and all it's ok.
Thanks a lot.
Regards,

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.050 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.