Mysql dbase not correct

[SJoWie]

hello,

i just performed an update (3 to 4)
everything looks oke but its missing some mysql columns

when i login i get:

Internal SiteBuilder error.
File:

/opt/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php; Line: 156
Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_local' in 'where clause'; Code: 42S22

and i get by the plesk sitebuilder admin module:

PDOException Object ( [messagerotected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_local' in 'where clause' [stringrivate] => [coderotected] => 42S22 [filerotected] => /opt/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php [linerotected] => 156 [tracerivate] => Array ( [0] => Array ( [file] => /opt/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php [line] => 156 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /opt/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php [line] => 309 [function] => query [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => Zend_Db_Select Object ( [_adapterrotected] => Zend_Db_Adapter_Pdo_Mysql Object ( [_pdoTyperotected] => mysql [_configrotected] => Array ( [adapter] => PDO_MYSQL [host] => localhost [username] => sitebuilder_db [password] => 3d0a0353add985f83abfba58c4115788 [dbname] => sitebuilder3 ) [_fetchModerotected] => 2 [_profilerrotected] => Zend_Db_Profiler Object ( [_queryProfilesrotected] => Array ( ) [_enabledrotected] => [_filterElapsedSecsrotected] => [_filterTypesrotected] => ) [_connectionrotected] => PDO Object ( ) ) [_partsrotected] => Array ( [distinct] => [forUpdate] => [cols] => Array ( [0] => id [1] => parent_id [2] => plan_id [3] => role_id [4] => user_settings_id [5] => user_name [6] => user_password [7] => email [8] => first_name [9] => last_name [10] => creation_date [11] => auth_cookie [12] => must_migrate [13] => uuid ) [from] => Array ( [user] => ) [join] => Array ( ) [where] => Array ( [0] => user_name = 'admin' AND user_password = '7c63758540a7d1a7b4fa99b68dc4a040' AND is_local = '1' ) [group] => Array ( ) [having] => Array ( ) [order] => Array ( ) [limitCount] => 0 [limitOffset] => 0 ) [_tableColsrotected] => Array ( ) ) [1] => ) ) [2] => Array ( [file] => /opt/sitebuilder/include/Zend/Zend/Db/Table.php [line] => 401 [function] => fetchAll [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => Zend_Db_Select Object ( [_adapterrotected] => Zend_Db_Adapter_Pdo_Mysql Object ( [_pdoTyperotected] => mysql [_configrotected] => Array ( [adapter] => PDO_MYSQL [host] => localhost [username] => sitebuilder_db [password] => 3d0a0353add985f83abfba58c4115788 [dbname] => sitebuilder3 ) [_fetchModerotected] => 2 [_profilerrotected] => Zend_Db_Profiler Object ( [_queryProfilesrotected] => Array ( ) [_enabledrotected] => [_filterElapsedSecsrotected] => [_filterTypesrotected] => ) [_connectionrotected] => PDO Object ( ) ) [_partsrotected] => Array ( [distinct] => [forUpdate] => [cols] => Array ( [0] => id [1] => parent_id [2] => plan_id [3] => role_id [4] => user_settings_id [5] => user_name [6] => user_password [7] => email [8] => first_name [9] => last_name [10] => creation_date [11] => auth_cookie [12] => must_migrate [13] => uuid ) [from] => Array ( [user] => ) [join] => Array ( ) [where] => Array ( [0] => user_name = 'admin' AND user_password = '7c63758540a7d1a7b4fa99b68dc4a040' AND is_local = '1' ) [group] => Array ( ) [having] => Array ( ) [order] => Array ( ) [limitCount] => 0 [limitOffset] => 0 ) [_tableColsrotected] => Array ( ) ) ) ) [3] => Array ( [file] => /opt/sitebuilder/include/Base/DB/Table.php [line] => 27 [function] => _fetch [class] => Zend_Db_Table [type] => -> ) [4] => Array ( [file] => /opt/sitebuilder/include/Base/ORM/Broker.php [line] => 164 [function] => fetchAll [class] => Base_DB_Table [type] => -> ) [5] => Array ( [file] => /opt/sitebuilder/include/Base/ORM/Broker.php [line] => 108 [function] => select [class] => Base_ORM_Broker [type] => -> ) [6] => Array ( [file] => /opt/sitebuilder/include/SB/Login.php [line] => 46 [function] => getByFields [class] => Base_ORM_Broker [type] => -> ) [7] => Array ( [file] => /opt/sitebuilder/include/SB/Login.php [line] => 113 [function] => getLocalUser [class] => SB_Login [type] => :: ) [8] => Array ( [file] => /opt/sitebuilder/include/SB/WebService.php [line] => 72 [function] => getUserWithSsoLookup [class] => SB_Login [type] => :: ) [9] => Array ( [file] => /opt/sitebuilder/include/SB/WebService.php [line] => 107 [function] => login [class] => SB_WebService [type] => -> ) [10] => Array ( [file] => /opt/sitebuilder/include/Base/Soap/Server.php [line] => 49 [function] => CredentialsSoapHeader [class] => SB_WebService [type] => -> [args] => Array ( [0] => All [1] => user_name = 'admin' AND user_password = '7c63758540a7d1a7b4fa99b68dc4a040' AND is_local = '1' [2] => [3] => [4] => ) ) [11] => Array ( [file] => /opt/sitebuilder/include/Base/WebService.php [line] => 50 [function] => handle [class] => Base_Soap_Server [type] => -> ) [12] => Array ( [file] => /opt/sitebuilder/include/SB/WebService.php [line] => 223 [function] => processRequest [class] => Base_WebService [type] => -> ) [13] => Array ( [file] => /opt/sitebuilder/htdocs/ServiceFacade/4.0/SystemWebService.asmx [line] => 6 [function] => processRequest [class] => SB_WebService [type] => -> ) ) [errorInfo] => Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'is_local' in 'where clause' ) )

so i gues the database update didn`t worked.
is there anyway to update it ?
or where can i find the right sql file?


Kind regards,
SJoWie

 

[zero@]

I am having the same exact problem. Debian Sarge. I ugraded from SB 3.x to 4.0. If anyone has a solution, please feel free to share.

 

[zero@]

NOT the same problem

Sorry - I spoke too soon. I am not having the same issue. My error is this:

Internal SiteBuilder error.
File: /opt/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php; Line: 156
Message: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound; Code: HY093

I'll open up a new thread about this issue. Best of luck on yours. You may want to jsut try re-installing the upgrade to see if it will work itself out.

 

[Dmitry Frantsev]

It seems database was not really upgraded. Try to perform following actions:

# echo '3.0.2' > /opt/sitebuilder/migrate
# /opt/php52/bin/php5 /opt/sitebuilder/utils/migration.php

Let me know about the results.

Originally posted by SJoWie

 

[DavidKiel]

I too have missing column in database error

Internal SiteBuilder error.
File: /usr/local/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php; Line: 156
Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_local' in 'where clause'; Code: 42S22

So I tried running migration.php

[root@serv2 sitebuilder]# echo '3.0.2' >migrate
[root@serv2 sitebuilder]# /opt/php52/bin/php5 /usr/local/sitebuilder/utils/migration.php
[2008-01-26T15:57:07-08:00 - #0 - error] Exception : PHP Warning : Error parsing /usr/local/sitebuilder/config on line 71
; file: /usr/local/sitebuilder/include/SB/Migration/Utils.php; line: 39; code: 2

blows up on the line db_admin_passwd = xxxxx

It probably doesn't like the $ character in it.