S
SJoWie
Guest
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:
and i get by the plesk sitebuilder admin module:
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
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