I just from 0.8.7e to 0.8.7g. I did this by rpm from rpmforge 0.8.7g-2.el4.rf. I am now getting an error like this was a new install. Does anyone have any ideas of what's going on here.
----------------------------------------
Error
You have created a new database, but have not yet imported the 'cacti.sql' file. At the command line, execute the following to continue:
mysql -u cactiuser -p cacti < cacti.sql
This error may also be generated if the cacti database user does not have correct permissions on the cacti database. Please ensure that the cacti database user has the ability to SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER, DROP, INDEX on the cacti database.
----------------------------------------
On a second look it seams that the install/index.php is doing a call for the version and not getting the data from this function.
$old_cacti_version = db_fetch_cell("select cacti from version");
So no matter where this function is called it's returning NULL.
Thanks
Upgrade from 0.8.7e to 0.8.7g
Moderators: Developers, Moderators
-
- Posts: 3
- Joined: Wed Dec 01, 2010 8:58 pm
Re: Upgrade from 0.8.7e to 0.8.7g
So I have found where this function is called and I have dumped the results of the query var.
$query = $db_conn->Execute($sql);
var_dump($query);
object(adorecordset_mysql)(29) {
["dataProvider"]=>
string(6) "native"
["fields"]=>
bool(false)
["blobSize"]=>
int(100)
["canSeek"]=>
bool(true)
["sql"]=>
string(25) "select cacti from version"
["EOF"]=>
bool(true)
["emptyTimeStamp"]=>
string(6) " "
["emptyDate"]=>
string(6) " "
["debug"]=>
bool(false)
["timeCreated"]=>
int(0)
["bind"]=>
bool(false)
["fetchMode"]=>
int(2)
["connection"]=>
&object(adodb_mysql)(77) {
["dataProvider"]=>
string(5) "mysql"
["databaseType"]=>
string(5) "mysql"
["database"]=>
string(0) ""
["host"]=>
string(0) ""
["user"]=>
string(0) ""
["password"]=>
string(0) ""
["debug"]=>
bool(false)
["maxblobsize"]=>
int(262144)
["concat_operator"]=>
string(1) "+"
["substr"]=>
string(9) "substring"
["length"]=>
string(6) "length"
["random"]=>
string(6) "rand()"
["upperCase"]=>
string(5) "upper"
["fmtDate"]=>
string(7) "'Y-m-d'"
["fmtTimeStamp"]=>
string(13) "'Y-m-d H:i:s'"
["true"]=>
string(1) "1"
["false"]=>
string(1) "0"
["replaceQuote"]=>
string(2) "\'"
["nameQuote"]=>
string(1) "`"
["charSet"]=>
bool(false)
["metaDatabasesSQL"]=>
string(0) ""
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["uniqueOrderBy"]=>
bool(false)
["emptyDate"]=>
string(6) " "
["emptyTimeStamp"]=>
string(6) " "
["lastInsID"]=>
bool(false)
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["hasTop"]=>
bool(false)
["hasLimit"]=>
bool(true)
["readOnly"]=>
bool(false)
["hasMoveFirst"]=>
bool(true)
["hasGenID"]=>
bool(true)
["hasTransactions"]=>
bool(false)
["genID"]=>
int(0)
["raiseErrorFn"]=>
bool(false)
["isoDates"]=>
bool(true)
["cacheSecs"]=>
int(3600)
["sysDate"]=>
string(9) "CURDATE()"
["sysTimeStamp"]=>
string(5) "NOW()"
["arrayClass"]=>
string(18) "ADORecordSet_array"
["noNullStrings"]=>
bool(false)
["numCacheHits"]=>
int(0)
["numCacheMisses"]=>
int(0)
["pageExecuteCountRows"]=>
bool(true)
["uniqueSort"]=>
bool(false)
["leftOuter"]=>
bool(false)
["rightOuter"]=>
bool(false)
["ansiOuter"]=>
bool(false)
["autoRollback"]=>
bool(false)
["poorAffectedRows"]=>
bool(true)
["fnExecute"]=>
bool(false)
["fnCacheExecute"]=>
bool(false)
["blobEncodeType"]=>
bool(false)
["rsPrefix"]=>
string(13) "ADORecordSet_"
["autoCommit"]=>
bool(true)
["transOff"]=>
int(0)
["transCnt"]=>
int(0)
["fetchMode"]=>
int(1)
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
bool(false)
["_errorMsg"]=>
bool(false)
["_errorCode"]=>
bool(false)
["_queryID"]=>
NULL
["_isPersistentConnection"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["metaColumnsSQL"]=>
string(20) "SHOW COLUMNS FROM %s"
["forceNewConnect"]=>
bool(false)
["clientFlags"]=>
int(0)
["_genIDSQL"]=>
string(38) "update %s set id=LAST_INSERT_ID(id+1);"
["_genSeqSQL"]=>
string(33) "create table %s (id int not null)"
["_genSeq2SQL"]=>
string(26) "insert into %s values (%s)"
["_dropSeqSQL"]=>
string(13) "drop table %s"
}
["_numOfRows"]=>
int(0)
["_numOfFields"]=>
int(0)
["_queryID"]=>
NULL
["_currentRow"]=>
int(-1)
["_closed"]=>
bool(false)
["_inited"]=>
bool(true)
["_obj"]=>
NULL
["_names"]=>
NULL
["_currentPage"]=>
int(-1)
["_atFirstPage"]=>
bool(false)
["_atLastPage"]=>
bool(false)
["_lastPageNo"]=>
int(-1)
["_maxRecordCount"]=>
int(0)
["datetime"]=>
bool(false)
["databaseType"]=>
string(5) "mysql"
["adodbFetchMode"]=>
int(1)
}
$query = $db_conn->Execute($sql);
var_dump($query);
object(adorecordset_mysql)(29) {
["dataProvider"]=>
string(6) "native"
["fields"]=>
bool(false)
["blobSize"]=>
int(100)
["canSeek"]=>
bool(true)
["sql"]=>
string(25) "select cacti from version"
["EOF"]=>
bool(true)
["emptyTimeStamp"]=>
string(6) " "
["emptyDate"]=>
string(6) " "
["debug"]=>
bool(false)
["timeCreated"]=>
int(0)
["bind"]=>
bool(false)
["fetchMode"]=>
int(2)
["connection"]=>
&object(adodb_mysql)(77) {
["dataProvider"]=>
string(5) "mysql"
["databaseType"]=>
string(5) "mysql"
["database"]=>
string(0) ""
["host"]=>
string(0) ""
["user"]=>
string(0) ""
["password"]=>
string(0) ""
["debug"]=>
bool(false)
["maxblobsize"]=>
int(262144)
["concat_operator"]=>
string(1) "+"
["substr"]=>
string(9) "substring"
["length"]=>
string(6) "length"
["random"]=>
string(6) "rand()"
["upperCase"]=>
string(5) "upper"
["fmtDate"]=>
string(7) "'Y-m-d'"
["fmtTimeStamp"]=>
string(13) "'Y-m-d H:i:s'"
["true"]=>
string(1) "1"
["false"]=>
string(1) "0"
["replaceQuote"]=>
string(2) "\'"
["nameQuote"]=>
string(1) "`"
["charSet"]=>
bool(false)
["metaDatabasesSQL"]=>
string(0) ""
["metaTablesSQL"]=>
string(11) "SHOW TABLES"
["uniqueOrderBy"]=>
bool(false)
["emptyDate"]=>
string(6) " "
["emptyTimeStamp"]=>
string(6) " "
["lastInsID"]=>
bool(false)
["hasInsertID"]=>
bool(true)
["hasAffectedRows"]=>
bool(true)
["hasTop"]=>
bool(false)
["hasLimit"]=>
bool(true)
["readOnly"]=>
bool(false)
["hasMoveFirst"]=>
bool(true)
["hasGenID"]=>
bool(true)
["hasTransactions"]=>
bool(false)
["genID"]=>
int(0)
["raiseErrorFn"]=>
bool(false)
["isoDates"]=>
bool(true)
["cacheSecs"]=>
int(3600)
["sysDate"]=>
string(9) "CURDATE()"
["sysTimeStamp"]=>
string(5) "NOW()"
["arrayClass"]=>
string(18) "ADORecordSet_array"
["noNullStrings"]=>
bool(false)
["numCacheHits"]=>
int(0)
["numCacheMisses"]=>
int(0)
["pageExecuteCountRows"]=>
bool(true)
["uniqueSort"]=>
bool(false)
["leftOuter"]=>
bool(false)
["rightOuter"]=>
bool(false)
["ansiOuter"]=>
bool(false)
["autoRollback"]=>
bool(false)
["poorAffectedRows"]=>
bool(true)
["fnExecute"]=>
bool(false)
["fnCacheExecute"]=>
bool(false)
["blobEncodeType"]=>
bool(false)
["rsPrefix"]=>
string(13) "ADORecordSet_"
["autoCommit"]=>
bool(true)
["transOff"]=>
int(0)
["transCnt"]=>
int(0)
["fetchMode"]=>
int(1)
["_oldRaiseFn"]=>
bool(false)
["_transOK"]=>
NULL
["_connectionID"]=>
bool(false)
["_errorMsg"]=>
bool(false)
["_errorCode"]=>
bool(false)
["_queryID"]=>
NULL
["_isPersistentConnection"]=>
bool(false)
["_bindInputArray"]=>
bool(false)
["_evalAll"]=>
bool(false)
["_affected"]=>
bool(false)
["_logsql"]=>
bool(false)
["metaColumnsSQL"]=>
string(20) "SHOW COLUMNS FROM %s"
["forceNewConnect"]=>
bool(false)
["clientFlags"]=>
int(0)
["_genIDSQL"]=>
string(38) "update %s set id=LAST_INSERT_ID(id+1);"
["_genSeqSQL"]=>
string(33) "create table %s (id int not null)"
["_genSeq2SQL"]=>
string(26) "insert into %s values (%s)"
["_dropSeqSQL"]=>
string(13) "drop table %s"
}
["_numOfRows"]=>
int(0)
["_numOfFields"]=>
int(0)
["_queryID"]=>
NULL
["_currentRow"]=>
int(-1)
["_closed"]=>
bool(false)
["_inited"]=>
bool(true)
["_obj"]=>
NULL
["_names"]=>
NULL
["_currentPage"]=>
int(-1)
["_atFirstPage"]=>
bool(false)
["_atLastPage"]=>
bool(false)
["_lastPageNo"]=>
int(-1)
["_maxRecordCount"]=>
int(0)
["datetime"]=>
bool(false)
["databaseType"]=>
string(5) "mysql"
["adodbFetchMode"]=>
int(1)
}
- gandalf
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
Re: Upgrade from 0.8.7e to 0.8.7g
You changed include/config.php to enter database credentials, did you?
If error persists, please use lib/database.php from SVN/0.8.7
R.
If error persists, please use lib/database.php from SVN/0.8.7
R.
Who is online
Users browsing this forum: No registered users and 3 guests