Failing to install Testlink 1.9.1 and upgrade from 1.8.5

[yossie]

I see that testlink 1.9.1 came out.

I downloaded the tgz, unpacked into a seperate directory - testlink-1.9.1.

I copied the config_db.inc.php and custom_config.inc.php from the 1.8.5 version.

I edited the config_db.inc.php and changed the database name from testlink to testlink191

I used mysqldump to create a copy of the testlink db called testlink191 - I granted use on it to the same user/pass as in config_db.inc.php

I opened the app directory from safari and it made me login to the admin. I did that and got database errors

As an aside, I see this too (the file was created on Jan 22, not today, so I think it's in the distro!)
# cat /var/www/html/testlink-1.9.1/logs/config_check.txt
Install directory should be removed!
You should change the default password for the 'admin' account!
Unknown Schema version DB 1.4, please upgrade your Testlink Database to DB 1.3
Check following parameters of email feature:
tl_admin_email
from_email
return_path_email
smtp_host

Where to go from here?

- Yossie


==============================================================================
DB Access Error - debug_print_backtrace() OUTPUT START
==============================================================================
#0 database->exec_query( /* Class:tlUser- Method:getAccessibleTestPlans- */ SELECT NH.id, NH.name, TPLAN.is_public, COALESCE(USER_TPLAN_ROLES.testplan_id,0) AS has_role ,TPLAN.active, 0 AS selected FROM nodes_hierarchy NH JOIN testplans TPLAN ON NH.id=TPLAN.id LEFT OUTER JOIN user_testplan_roles USER_TPLAN_ROLES ON TPLAN.id = USER_TPLAN_ROLES.testplan_id AND USER_TPLAN_ROLES.user_id = 1 WHERE testproject_id = 41282 AND active = 1 AND (role_id IS NULL OR role_id != 3) ORDER BY name, -1) called at [/var/www/html/testlink-1.9.1/lib/functions/database.class.php:717]
#1 database->get_recordset( /* Class:tlUser- Method:getAccessibleTestPlans- */ SELECT NH.id, NH.name, TPLAN.is_public, COALESCE(USER_TPLAN_ROLES.testplan_id,0) AS has_role ,TPLAN.active, 0 AS selected FROM nodes_hierarchy NH JOIN testplans TPLAN ON NH.id=TPLAN.id LEFT OUTER JOIN user_testplan_roles USER_TPLAN_ROLES ON TPLAN.id = USER_TPLAN_ROLES.testplan_id AND USER_TPLAN_ROLES.user_id = 1 WHERE testproject_id = 41282 AND active = 1 AND (role_id IS NULL OR role_id != 3) ORDER BY name) called at [/var/www/html/testlink-1.9.1/lib/functions/tlUser.class.php:889]
#2 tlUser->getAccessibleTestPlans(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink191,[host] => localhost,[user] => testlink,[password] => testlink,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #40,[_errorMsg] => Unknown column 'TPLAN.is_public' in 'field list',[_errorCode] => ,[_queryID] => Resource id #54,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink191),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 14,[overallDuration] => 0.0082,[dbType] => mysql,[] => 0,[] => 0), 41282, ) called at [/var/www/html/testlink-1.9.1/lib/functions/common.php:355]
#3 initProject(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink191,[host] => localhost,[user] => testlink,[password] => testlink,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #40,[_errorMsg] => Unknown column 'TPLAN.is_public' in 'field list',[_errorCode] => ,[_queryID] => Resource id #54,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink191),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 14,[overallDuration] => 0.0082,[dbType] => mysql,[] => 0,[] => 0), Array ([PHPSESSID] => as80cddsacjrvhmj3m284hch53,[TL_lastTestPlanForUserID_1] => 51844)) called at [/var/www/html/testlink-1.9.1/lib/functions/common.php:415]
#4 testlinkInitPage(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink191,[host] => localhost,[user] => testlink,[password] => testlink,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #40,[_errorMsg] => Unknown column 'TPLAN.is_public' in 'field list',[_errorCode] => ,[_queryID] => Resource id #54,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink191),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 14,[overallDuration] => 0.0082,[dbType] => mysql,[] => 0,[] => 0), 1) called at [/var/www/html/testlink-1.9.1/lib/general/mainPage.php:36]
==============================================================================
==============================================================================
DB Access Error - debug_print_backtrace() OUTPUT START
==============================================================================
#0 database->exec_query( /* Class:tlUser- Method:getAccessibleTestPlans- */ SELECT NH.id, NH.name, TPLAN.is_public, COALESCE(USER_TPLAN_ROLES.testplan_id,0) AS has_role ,TPLAN.active, 0 AS selected FROM nodes_hierarchy NH JOIN testplans TPLAN ON NH.id=TPLAN.id LEFT OUTER JOIN user_testplan_roles USER_TPLAN_ROLES ON TPLAN.id = USER_TPLAN_ROLES.testplan_id AND USER_TPLAN_ROLES.user_id = 1 WHERE testproject_id = 41282 AND active = 1 AND (role_id IS NULL OR role_id != 3) ORDER BY name, -1) called at [/var/www/html/testlink-1.9.1/lib/functions/database.class.php:717]
#1 database->get_recordset( /* Class:tlUser- Method:getAccessibleTestPlans- */ SELECT NH.id, NH.name, TPLAN.is_public, COALESCE(USER_TPLAN_ROLES.testplan_id,0) AS has_role ,TPLAN.active, 0 AS selected FROM nodes_hierarchy NH JOIN testplans TPLAN ON NH.id=TPLAN.id LEFT OUTER JOIN user_testplan_roles USER_TPLAN_ROLES ON TPLAN.id = USER_TPLAN_ROLES.testplan_id AND USER_TPLAN_ROLES.user_id = 1 WHERE testproject_id = 41282 AND active = 1 AND (role_id IS NULL OR role_id != 3) ORDER BY name) called at [/var/www/html/testlink-1.9.1/lib/functions/tlUser.class.php:889]
#2 tlUser->getAccessibleTestPlans(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink191,[host] => localhost,[user] => testlink,[password] => testlink,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #40,[_errorMsg] => Unknown column 'TPLAN.is_public' in 'field list',[_errorCode] => ,[_queryID] => Resource id #56,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink191),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 17,[overallDuration] => 0.0098,[dbType] => mysql,[] => 0,[] => 0), 41282) called at [/var/www/html/testlink-1.9.1/lib/functions/common.php:359]
#3 initProject(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink191,[host] => localhost,[user] => testlink,[password] => testlink,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #40,[_errorMsg] => Unknown column 'TPLAN.is_public' in 'field list',[_errorCode] => ,[_queryID] => Resource id #56,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink191),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 17,[overallDuration] => 0.0098,[dbType] => mysql,[] => 0,[] => 0), Array ([PHPSESSID] => as80cddsacjrvhmj3m284hch53,[TL_lastTestPlanForUserID_1] => 51844)) called at [/var/www/html/testlink-1.9.1/lib/functions/common.php:415]
#4 testlinkInitPage(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink191,[host] => localhost,[user] => testlink,[password] => testlink,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #40,[_errorMsg] => Unknown column 'TPLAN.is_public' in 'field list',[_errorCode] => ,[_queryID] => Resource id #56,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink191),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 17,[overallDuration] => 0.0098,[dbType] => mysql,[] => 0,[] => 0), 1) called at [/var/www/html/testlink-1.9.1/lib/general/mainPage.php:36]
==============================================================================
==============================================================================
DB Access Error - debug_print_backtrace() OUTPUT START
==============================================================================
#0 database->exec_query( SELECT NH.id,NH.name,notes,active,is_public,testproject_id FROM nodes_hierarchy NH,testplans TPLAN WHERE NH.id=TPLAN.id AND (testproject_id = 41282 ) AND active = 1 ORDER BY name, -1) called at [/var/www/html/testlink-1.9.1/lib/functions/database.class.php:603]
#1 database->fetchRowsIntoMap( SELECT NH.id,NH.name,notes,active,is_public,testproject_id FROM nodes_hierarchy NH,testplans TPLAN WHERE NH.id=TPLAN.id AND (testproject_id = 41282 ) AND active = 1 ORDER BY name, id) called at [/var/www/html/testlink-1.9.1/lib/functions/testproject.class.php:1980]
#2 testproject->get_all_testplans(41282, Array ([plan_status] => 1)) called at [/var/www/html/testlink-1.9.1/lib/general/mainPage.php:90]
==============================================================================
==============================================================================
DB Access Error - debug_print_backtrace() OUTPUT START
==============================================================================
#0 database->exec_query( /* Class:tlUser- Method:getAccessibleTestPlans- */ SELECT NH.id, NH.name, TPLAN.is_public, COALESCE(USER_TPLAN_ROLES.testplan_id,0) AS has_role ,TPLAN.active, 0 AS selected FROM nodes_hierarchy NH JOIN testplans TPLAN ON NH.id=TPLAN.id LEFT OUTER JOIN user_testplan_roles USER_TPLAN_ROLES ON TPLAN.id = USER_TPLAN_ROLES.testplan_id AND USER_TPLAN_ROLES.user_id = 1 WHERE testproject_id = 41282 AND active = 1 AND (role_id IS NULL OR role_id != 3) ORDER BY name, -1) called at [/var/www/html/testlink-1.9.1/lib/functions/database.class.php:717]
#1 database->get_recordset( /* Class:tlUser- Method:getAccessibleTestPlans- */ SELECT NH.id, NH.name, TPLAN.is_public, COALESCE(USER_TPLAN_ROLES.testplan_id,0) AS has_role ,TPLAN.active, 0 AS selected FROM nodes_hierarchy NH JOIN testplans TPLAN ON NH.id=TPLAN.id LEFT OUTER JOIN user_testplan_roles USER_TPLAN_ROLES ON TPLAN.id = USER_TPLAN_ROLES.testplan_id AND USER_TPLAN_ROLES.user_id = 1 WHERE testproject_id = 41282 AND active = 1 AND (role_id IS NULL OR role_id != 3) ORDER BY name) called at [/var/www/html/testlink-1.9.1/lib/functions/tlUser.class.php:889]
#2 tlUser->getAccessibleTestPlans(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink191,[host] => localhost,[user] => testlink,[password] => testlink,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #40,[_errorMsg] => Unknown column 'TPLAN.is_public' in 'field list',[_errorCode] => ,[_queryID] => Resource id #68,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink191),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 29,[overallDuration] => 0.0172,[dbType] => mysql,[] => 0,[] => 0), 41282) called at [/var/www/html/testlink-1.9.1/lib/general/mainPage.php:93]
==============================================================================
There are security warnings for your consideration. See details on file: /var/www/html/testlink-1.9.1/logs/config_check.txt. To disable any reference to these checkings, set $tlCfg->config_check_warning_mode = SILENT;

Test Plan
Test Plan Management



Test Project
Test Project Management
Assign user roles
Define custom fields
Assign custom fields
Keyword Management

User Administration
User Management
Role Management


Test Specification
Edit Test Cases
Search Test Cases
Assign Keywords
Generate Test Specification document

Documentation

[Unhandled]

Did you run through the install pages:

Code: Select all

http://<server>/<testlink_base>/install/

There is a db migration script that must be run when upgrading from 1.8.5. Sounds to me like that did not happen.

The config_check.txt is there as part of the distro. I'm guessing that maybe testlink removes lines from the file as it verifies each item.

As for the Unknown Schema error, this is a bug in 1.9.1 See related forum post here:
http://teamst.org/forum/viewtopic.php?f=11&t=3885