1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

domain_aliases fields missing after upgrade

Discussion in 'Plesk for Windows - 8.x and Older' started by eugenevdm, Jan 14, 2007.

  1. eugenevdm

    eugenevdm Silver Pleskian

    30
    68%
    Joined:
    Nov 11, 2003
    Messages:
    611
    Likes Received:
    0
    After upgrade from Plesk 7.5.6 to 8.1 I get the following error:

    Can't query SELECT da.id, da.name, da.displayName, da.web, da.mail, da.status FROM domain_aliases da WHERE (da.dom_id = 128): MySQLDatabaseProvider error 1054:Unknown column 'da.web' in 'field list'
    at (MySQLDatabaseProvider::query line 283)
    at addHosting(nimojadatours.co.za)(WebServerManager::addHosting line 2235)
    at execute console command --reconfigure-vhost(vconsoleapp::start line 128)
    at execute websrvmng.exe --reconfigure-vhost --vhost-name=nimojadatours.co.za(vconsoleapp::run line 138)
    Execute file name: C:\Program Files\SWsoft\Plesk\admin\bin\websrvmng.exe

    So it appears my domain_aliases table has missing fields. This worries me because what if other tables has missing fields. For now could someone please dump me structure of domain aliases on nice Plesk 8.1 Windows installation so that I can compare.

    I temporary worked around the problem by adding fields that are similar to Plesk Linux, i.e.:

    web (true, false, not null, default = false)
    mail (true, false, not null, default = false)
    status (int 10, not null)

    but I would still like a dump and advice on how I can check the whole structure.
     
  2. eugenevdm

    eugenevdm Silver Pleskian

    30
    68%
    Joined:
    Nov 11, 2003
    Messages:
    611
    Likes Received:
    0
    Still not working

    First I thought I got lucky when I saw this post, also person complaining about domain aliases not working, and apparent fix to install hotfix:

    http://forum.swsoft.com/showthread....erpage=15&highlight=domain alias&pagenumber=1

    However I just installed the hotfix and conclude that this hotfix was addressing something else because it's still not working.

    Then I found this post (it's similar to mine) talking about yet another hotfix that will sort it out:

    http://forum.swsoft.com/showthread.php?s=&threadid=39715&highlight=domain+alias

    Now I suppose all I have to do is wait.

    ps. subsequent my previous post I also found dns_zone_id was missing, but noticed also "status" field different in Plesk pre version 8. So I'm going to assume just manually adding the fields won't work because it probably has to convert "status" to the new format.
     
Loading...