DB Problems upgrading 8.0.1 to 8.1.0

[murdockdj]

Hi,

I can't create mailboxes because I get an error with the tables PSA.spamfilter & PSA.spamfilter_preferences, someone can get me the structure of these tables ?

I can't create domains because I think that the Awstats module isn't correctly installed:

hosting update failed: webstatmng is failed --unset-config --domain-name=undiez.es --stat-prog=true

When I tried this command at console, it shows that needs --stat-prog=awstats, but the plesk interface isn't working correctly.

Thanks.

 

[AS-N]

100% exactly the same problem here, you will find another missing things in the database.

Ciao
André

 

[murdockdj]

Problem solved without help

Hi, i solved the problem with this sql file:
/usr/local/psa/etc/db/psa_db_upgrade_800.sql

Its dangerous if you don't know mysql databases, but its easy to repair my BD, now is working all, stats and spamfilter.

Bye.

 

[AS-N]

Mmmh, I always get a error message, when I try to create or delete a domain:

ERROR: PleskException Shortcut erstellenShortcut erstellenEine Ebene höherEine Ebene höher


dnsmng::update() failed: dnsmng failed: dnsmng: Unable to open DNS config file: No such file or directory

System error 2: No such file or directory

--------------------------------------------------------------------------------

0: /usr/local/psa/admin/plib/dns/DNSManager.php:753
DNSManager::updateDNSZone(object of type DNSZone)
1: /usr/local/psa/admin/plib/class.PhDomain.php:710
PhDomain->restartServices()
2: /usr/local/psa/admin/plib/class.PhDomain.php:613
PhDomain->update()
3: /usr/local/psa/admin/plib/class.BsDomain.php:359
BsDomain->update()
4: /usr/local/psa/admin/htdocs/domains/create_domain.php:149


The db should be up to date now, maybe some files missing too?

Ciao
André

 

[Alexandre@]

same problem

OS fedora-core4

ERROR: PleskException
Create ShortcutCreate Shortcut
dnsmng::restart() failed: dnsmng failed: dnsmng: Unable to div2 ip-address in PTR

0: /usr/local/psa/admin/plib/dns/DNSManager.php:159
DNSManager::updateDefaultDNSZone(object of type DNSZone)
1: /usr/local/psa/admin/plib/dns/DNSManager.php:103
DNSManager::syncDNSZoneAdminEmail(boolean false, string '[email protected]')
2: /usr/local/psa/admin/htdocs/server/admin_ed.php3:84
admin_ed(array, array, array)
3: /usr/local/psa/admin/htdocs/server/admin_ed.php3:164


I've found the following article:
http://kb.swsoft.com/article_159_1360_en.html

but it doesn't help

 

[AS-N]

Hello,

same here, it does not solve this problem.
The dns entries in the db are correct if I create a new domain, but in the admin interface this message always appears.
Any other idea?

Ciao
André

 

[Alexandre@]

I think the problem is concluded in the new plesk 8.1.

I'm installing on the node 8.0.1 rpms and we'll recreate the new VPS with older versions.

 

[Alexandre@]

Plesk works fine with older templates.
I think 8.1. a bit soggy

 

[eugenevdm]

I had this problem:

Unable to update hosting preferences: hosting update is failed: webstatmng is failed --unset-config --domain-name=audiomatik.co.za --stat-prog=

And then followed this thread:

http://forum.swsoft.com/showthread.php?s=&postid=172006#post172006

that says:

UPDATE psa.hosting SET webstat = 'none' WHERE webstat = '';

and this sorted out my problem.