Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007905TestLinkDatabase MySQLpublic2017-03-30 00:012017-03-30 19:30
Reporterdreampet 
Assigned Tofman 
PrioritynormalSeveritycrashReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.9.16 (2016 Q4) 
Fixed in Version1.9.17 (2017 Q2) 
Summary0007905: use latest 1.9.16 hot-fixes cause DB Access Error
Descriptionafter get the latest 1.9.16 hot-fixes from 0007817 and do the database update with README, then cause DB Access Error when logging.

log:[>>][58db7e134a2d9266536693][DEFAULT][/index.php][17/Mar/29 09:27:47]
        [17/Mar/29 09:27:47][ERROR][vfg4usouni5dp8sgn5f4om07n0][DATABASE]
                ERROR ON exec_query() - database.class.php
1054 - Unknown column 'creation_ts' in 'field list' - SELECT id,login,password,cookie_string,first,last,email, role_id,locale, $
Query failed: errorcode[1054]
        errormsg:Unknown column 'creation_ts' in 'field list'

I found that the problem is missing two lines:

ALTER TABLE /*prefix*/users ADD COLUMN creation_ts timestamp NOT NULL DEFAULT now();
ALTER TABLE /*prefix*/users ADD COLUMN expiration_date date DEFAULT NULL;

in file "install/sql/alter_tables/1.9.17/mysql/DB.1.9.17/step1/db_schema_update.sql"

TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
Browser
PHP Version
TestCaseID
QA Team - Task Workflow StatusREADY FOR TESTING
Attached Files

- Relationships

-  Notes
(0026228)
fman (administrator)
2017-03-30 09:13

1.9.16 do not use creation_ts, latest code from git YES => you have to do fresh install
(0026231)
fman (administrator)
2017-03-30 19:30

fixed with
 https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/86790abf0a91677ace0913739a0d6b3531eb590d [^]

- Issue History
Date Modified Username Field Change
2017-03-30 00:01 dreampet New Issue
2017-03-30 09:13 fman Note Added: 0026228
2017-03-30 09:14 fman QA Team - Task Workflow Status => TBD
2017-03-30 09:14 fman Priority immediate => normal
2017-03-30 09:19 fman Status new => feedback
2017-03-30 19:30 fman Note Added: 0026231
2017-03-30 19:30 fman QA Team - Task Workflow Status TBD => READY FOR TESTING
2017-03-30 19:30 fman Status feedback => resolved
2017-03-30 19:30 fman Fixed in Version => 1.9.17 (2017 Q2)
2017-03-30 19:30 fman Resolution open => fixed
2017-03-30 19:30 fman Assigned To => fman



Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker