• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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

Christopher-James
Issue DB query failed: SQLSTATE[HY000] [2002] Connection refused: after Obsidian update 18.0.53
Replies
10
Views
4K
Peter Debik
P
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
1K
nethubonline
nethubonline
V
Resolved Error using git pull with an additional user
Replies
2
Views
144
vruiz
V
J
Resolved Zend Log Exception > not possible to reach the login page of Plesk
Replies
3
Views
1K
janm
J
Back
Top