Upgrade from 0.8.7e to 0.8.7g

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
dustenatwork
Posts: 3
Joined: Wed Dec 01, 2010 8:58 pm

Upgrade from 0.8.7e to 0.8.7g

Post by dustenatwork »

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
dustenatwork
Posts: 3
Joined: Wed Dec 01, 2010 8:58 pm

Re: Upgrade from 0.8.7e to 0.8.7g

Post by dustenatwork »

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) "&nbsp;"
["emptyDate"]=>
string(6) "&nbsp;"
["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) "&nbsp;"
["emptyTimeStamp"]=>
string(6) "&nbsp;"
["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)
}
User avatar
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

Post by gandalf »

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.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests