• We value your experience with Plesk during 2024
    Plesk strives to perform even better in 2025. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2024.
    Please take this short survey:
    https://pt-research.typeform.com/to/AmZvSXkx
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

ERROR: Zend_Log_Exception

L

laztrix

Guest
After Upgrading Plesk from 9.5.3 to 10.0.1 I get this error when I login to my plesk account:

Code: 
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

How can we fix this problem, thanks.
 
I've changed the chmood

/usr/local/psa/admin/logs - panel.log from 644 to 777. After that, I saw the admin login page. But when I login I receive this error:

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:95
Navigation->getUserContextList(object of type UserAdmin)
18: Navigation.php:113
Navigation->getRoot(object of type UserAdmin)
19: Navigation.php:358
Navigation->buildPathbar(string '/plesk/license/', object of type plesk__license, object of type UserAdmin, string 'dashboard')
20: Navigation.php:349
Navigation->getPathbar(object of type plesk__license)
21: Navigation.php:144
Navigation->detectCurrentUpLevelURI()
22: class.Form.php:460
Form->_getUpLevelLink()
23: class.Form.php:469
Form->renderPathbarButton(object of type Navigation, object of type plesk__license)
24: class.Form.php:359
Form->assign()
25: KeyInfoForm.php:62
KeyInfoForm->assign()
26: key_info.php:20
 
Please click one of the Quick Reply icons in the posts above to activate Quick Reply.
 
same probleme, exactly ^^ debian 5 64bit, same upgrade 9.5.3 > 10.0.1
 
laztrix said:
I've changed the chmood

/usr/local/psa/admin/logs - panel.log from 644 to 777. After that, I saw the admin login page. But when I login I receive this error:

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:95
Navigation->getUserContextList(object of type UserAdmin)
18: Navigation.php:113
Navigation->getRoot(object of type UserAdmin)
19: Navigation.php:358
Navigation->buildPathbar(string '/plesk/license/', object of type plesk__license, object of type UserAdmin, string 'dashboard')
20: Navigation.php:349
Navigation->getPathbar(object of type plesk__license)
21: Navigation.php:144
Navigation->detectCurrentUpLevelURI()
22: class.Form.php:460
Form->_getUpLevelLink()
23: class.Form.php:469
Form->renderPathbarButton(object of type Navigation, object of type plesk__license)
24: class.Form.php:359
Form->assign()
25: KeyInfoForm.php:62
KeyInfoForm->assign()
26: key_info.php:20
Click to expand...


i get the same error message in plesk panel. it seems that the sql tables are not updated.. is there any way the reinstall the update 10.0.0 or manually update the sql tables or what is the error for this?
 
I have the same problem, i contact the support and they says me:

"
The reason of the issue is that plesk internal database was not upgraded properly.

Unfortunately I see no quick solution right now.

Our engineers will keep you updated."

and

"Yes, this looks like serious issue for me to.

I have passed all the details to developers.

We will update you as soon as we have any news."

if i have some solution or news i update this post


regards

arnaud
 
The solution

Charge the soft WInscp : http://winscp.net/eng/docs/lang:fr

And go in your serveur with it.

After, change with right click in property 06... in 0777 for the panle.log in /usr/local/psa/admin/logs/panel.log

That s all, now it is ok

Thierry
 
Hello

In my Plesk in Centos 5.5 _x64, upgrade from 9.5.2 to 10.1, have the error , but this solution (chmod) work for my

And now show other error:

ERROR: PleskFatalException

Components::componentUpdate() failed: Unable to exec utility packagemng: file does not exist or is not executable: /usr/local/psa/admin/bin/packagemng
 
Last edited by a moderator:
ArnaudM said:
I have the same problem, i contact the support and they says me:

"
The reason of the issue is that plesk internal database was not upgraded properly.

Unfortunately I see no quick solution right now.

Our engineers will keep you updated."

and

"Yes, this looks like serious issue for me to.

I have passed all the details to developers.

We will update you as soon as we have any news."

if i have some solution or news i update this post


regards

arnaud
Click to expand...

hope you get an aswer soon.. because the chmod 777 on panel.log doesnt work. so i think that the table really does not exist..
 
I think I have a solution that works - as Chris says, a reinstall/continued install appears to fix it.
What i did was:
1. Restore the PSA mysql database to the old one - I used a daily backup as opposed to a preupgrade backup, from when it was stable. (Details here: http://kb.odin.com/article_17_881_en.html)

2. Ran an upgrade using /usr/local/psa/admin/bin/autoinstaller with all options as default and installing 10.0.0.1 (as 10.0.0.0 wouldn't install as it was the current version - this may need to be switched if necessary)

Once this installation had completed, it appears to work.
If it hits any errors, these are probably the reason that it failed in the first place, so probably need to restore the database, fix the errors, and try again...
 
thanks. i gonna try it, i will post the resolution of this :-3
 
Hi


Parallels support repare my plesk i post you the reply


To complete configuration I executed the script manually:


"ns8:~# /opt/psa/bootstrapper/pp10.9.0-bootstrapper/bootstrapper.sh repair
...
All stages of the upgrade were successful.
psa is now running on your system."


regards

arnaud
 
for me there's no psa in /opt/
[root@XXX-XX-XXX-XX opt]# ls
[root@XXX-XX-XXX-XX opt]#
Click to expand...

and when i try to run: /usr/local/psa/bootstrapper/pp10.8.0-bootstrapper/bootstrapper.sh repair
I still get:
ERROR while trying to SMB database not created
Check the error reason(see log file: /tmp/pp10.8.0-bootstrapper.101105.10.35.log), fix and try again
Click to expand...

also note that i do not have 10.9.0 I only have 10.8.0 ?!
 
Last edited:
just used the command
/usr/local/psa/bootstrapper/pp10.9.0-bootstrapper/bootstrapper.sh repair
and now it works fine... thank you for all the good advises!
 
Strange - I tried it yesterday and it didn't work. Today, I tried it again and it worked fine. All is fixed. I must have done something wrong the first time. Thanks for that solution!
 
You must log in or register to reply here.

Similar threads

L
Issue Daily Maintenance Script Spawns Off A Bunch Of PHP-FPM processes Leading To Huge Load Spike
Replies
2
Views
417
Ladylinux
L
Christopher-James
Issue DB query failed: SQLSTATE[HY000] [2002] Connection refused: after Obsidian update 18.0.53
Replies
10
Views
6K
Peter Debik
P
C
Resolved Mariadb not working - DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
7
Views
2K
Crash79797
C
S
Question High server resource and mysql error
Replies
7
Views
2K
Peter Debik
P
nethubonline
Resolved Plesk install failure on AlmaLinux 9
Replies
3
Views
2K
nethubonline
nethubonline
Back
Top