Update 9.5 to 10 failed

[VILLERE]

I just run the update and this i recieved an email saying the update failed. I tried to go to the panel and then i have this messages :

ERROR: Zend_Log_Exception
"/usr/local/psa/admin/logs/panel.log" cannot be opened with mode "a"

0: Stream.php:66
Zend_Log_Writer_Stream->__construct(string '/usr/local/psa/admin/logs/panel.log')
1: Abstract.php:84
CommonPanel_Application_Abstract->_initLog()
2: Abstract.php:31
CommonPanel_Application_Abstract->run()
3: Abstract.php:19
CommonPanel_Application_Abstract::init()
4: auth.php3:137

So i chmod 777 this files and try to run the panel and the i can login and enter but there is this message inside the left menu :

ERROR: Zend_Db_Statement_Exception
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.smb_apsInstances' doesn't exist

Additionally, an exception has occurred while trying to report this error: Zend_Db_Statement_Exception
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.smb_apsInstances' doesn't exist

0: Pdo.php:238
Zend_Db_Statement_Pdo->_execute(array)
1: Statement.php:283
Zend_Db_Statement->execute(array)
2: Abstract.php:433
Zend_Db_Adapter_Abstract->query(string 'DESCRIBE `smb_apsInstances`', array)
3: Abstract.php:230
Zend_Db_Adapter_Pdo_Abstract->query(string 'DESCRIBE `smb_apsInstances`')
4: Mysql.php:136
Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'smb_apsInstances', NULL null)
5: Abstract.php:696
Zend_Db_Table_Abstract->_setupMetadata()
6: Abstract.php:739
Zend_Db_Table_Abstract->_setupPrimaryKey()
7: Abstract.php:846
Zend_Db_Table_Abstract->info()
8: Select.php:99
Zend_Db_Table_Select->setTable(object of type Smb_Db_Table_Broker_ApsInstances)
9: Select.php:77
Zend_Db_Table_Select->__construct(object of type Smb_Db_Table_Broker_ApsInstances)
10: Abstract.php:881
Zend_Db_Table_Abstract->select()
11: ApsInstances.php:118
Smb_Db_Table_Broker_ApsInstances->getPackageInstances(integer '1', string 'osTicket')
12: Config.php:15
HelpDesk_Config::getHelpDeskInstances()
13: NavigationContext.php:324
NavigationContext->_fetchHelpDeskSectionNodes(object of type UserAdmin)
14: NavigationContext.php:201
NavigationContext->fetchCustomButtonsSectionNodes(object of type UserAdmin)
15: NavigationContext.php:69
NavigationContext->fetchSection(object of type UserAdmin, string 'custom_buttons', array)
16: NavigationContext.php:380
NavigationContext->get(object of type UserAdmin)
17: Navigation.php:558
Navigation->getContextMenu(object of type UserAdmin, object of type Skin)
18: left.php3:4

and in the main page appears this message :

Error
Internal error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.smb_productUpgrades' doesn't exist
Message SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.smb_productUpgrades' doesn't exist
File Pdo.php
Line 238
Type Zend_Db_Statement_Exception

PLease i need help to solve it

THank you for the help you could give to me !

 

[IgorG]

Try

# /usr/local/psa/bootstrapper/pp10.9.0-bootstrapper/bootstrapper.sh repair

 

[2danis2do]

Worked for me. Thx