MantisBT - v3.4 Release (Current)
View Issue Details
0001640v3.4 Release (Current)Projectspublic2014-11-26 14:462019-01-03 12:53
Reportermateusfig 
Assigned Tocaseydk 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformLinuxOScentOSOS Version7.0
Product Version 
Target VersionFixed in Version 
Summary0001640: I can't update fields on Projects
DescriptionWhen I try to update any field of a project (but seems it aplies to whole or most of the system), it won't be updated in the database.

For Tasks, I got a bug when I register a Task Log and the task itself have not its percentual updated.
Steps To ReproduceFor Projects
- Try switch the project to Inactive
- Try switch the project Status to Complete

For Tasks

- Try to add a task log and after check the task percentual.
Additional InformationThe bug occurs with the follow scenary:

- MySQL 5.6.20 (It works flawless with 5.6.16 )
- PHP 5.4.16 (I don't think this is a negative point)
TagsNo tags attached.
Attached Files

Notes
(0003722)
caseydk   
2014-11-26 22:04   
If it works on mysql 5.6.16 but fails on 5.6.20, then the issue is there. Do you have any sort of error logs or transaction logs that might be useful?
(0003723)
mateusfig   
2014-11-27 04:28   
(Last edited: 2014-12-01 10:05)
Yes. I have other PHP system run on MySQL 5.6.20 and It works flawless.

Here is the log:

[27-Nov-2014 09:27:47 Etc/GMT+3] PHP Stack trace:
[27-Nov-2014 09:27:47 Etc/GMT+3] PHP 1. {main}() /var/www/html/web2project/index.php:0
[27-Nov-2014 09:27:47 Etc/GMT+3] PHP 2. require_once() /var/www/html/web2project/index.php:27
[27-Nov-2014 09:27:47 Etc/GMT+3] PHP 3. w2p_Database_Connection->connect() /var/www/html/web2project/includes/db_adodb.php:21
[27-Nov-2014 09:27:47 Etc/GMT+3] PHP 4. ADOConnection->Connect() /var/www/html/web2project/classes/w2p/Database/Connection.class.php:22
[27-Nov-2014 09:27:47 Etc/GMT+3] PHP 5. ADODB_mysqli->_connect() /var/www/html/web2project/lib/adodb/adodb.inc.php:525
[27-Nov-2014 09:27:47 Etc/GMT+3] PHP 6. mysqli_real_connect() /var/www/html/web2project/lib/adodb/drivers/adodb-mysqli.inc.php:113

(0003724)
mateusfig   
2014-12-01 10:05   
Was It usefull?
(0003725)
mateusfig   
2014-12-01 11:51   
It seems the issue was solved after removing STRICT MODE of MySQL with this command: SET @ @global.sql_mode = '';

Ok, but there are some non-ANSI compatible query causing this issue.
(0003728)
caseydk   
2014-12-11 22:17   
Resolved in latest development.
(0003929)
caseydk   
2019-01-03 12:53   
In the 31 Dec 2018 release: http://docs.web2project.net/release-notes/3.4.html

Issue History
2014-11-26 14:46mateusfigNew Issue
2014-11-26 22:04caseydkNote Added: 0003722
2014-11-26 22:04caseydkAssigned To => caseydk
2014-11-26 22:04caseydkStatusnew => feedback
2014-11-27 04:28mateusfigNote Added: 0003723
2014-11-27 04:28mateusfigStatusfeedback => assigned
2014-12-01 10:05mateusfigNote Edited: 0003723bug_revision_view_page.php?bugnote_id=3723#r121
2014-12-01 10:05mateusfigNote Added: 0003724
2014-12-01 11:51mateusfigNote Added: 0003725
2014-12-11 22:17caseydkNote Added: 0003728
2014-12-11 22:17caseydkStatusassigned => resolved
2014-12-11 22:17caseydkFixed in Version => 3.3
2014-12-11 22:17caseydkResolutionopen => fixed
2016-12-26 23:37caseydkProjectv3.3 Release => v3.4 Release (Current)
2019-01-03 12:53caseydkNote Added: 0003929
2019-01-03 12:53caseydkStatusresolved => closed