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

Backup error (missing column in hotlink_prot)

Discussion in 'Plesk for Windows - 8.x and Older' started by Joost@, Mar 14, 2006.

  1. Joost@

    Joost@ New Pleskian

    22
    23%
    Joined:
    Feb 19, 2005
    Messages:
    6
    Likes Received:
    0
    Hello,

    When running a scheduled backup the backup process exits after only a minute and I recieve the following error by e-mail:

    - I recently upgraded to 7.5.6 and installed all available patches/updates.
    - The error doesn't depend on the settings for disabling domains/plesk control panel.
    - I tried a repair through the setup of plesk (using the 'add/remove software' item of the control panel). Didn't help.

    Of course I could add the missing column by hand, but I'd rather not change anything to the plesk database before I'm absolutely sure I'm not breaking anything else.

    When I open the 'Hotlink protection' page of a domain, I get the following error on top of the page:

    This also indicates a problem with the hotlink table.
     
  2. Gris@

    Gris@ Guest

    0
     
    how about current configuration of this table?
    you can get it by
    desc hotlink_prot
    query
     
  3. Joost@

    Joost@ New Pleskian

    22
    23%
    Joined:
    Feb 19, 2005
    Messages:
    6
    Likes Received:
    0
    Hi, my current table setup layout is:

    As you can see I added the missing column by hand. After adding it to this table, I noticed it was also missing from the hotlink_friends table. I also added the column to that table, and the backup is now running fine.

    But I do want to know what caused this, because there might be more issues (if there was something wrong with the updates) that might come up in the future.
     
  4. Rubal

    Rubal Guest

    0
     
    Do you have MySQL 5.x by chance ?
     
  5. Joost@

    Joost@ New Pleskian

    22
    23%
    Joined:
    Feb 19, 2005
    Messages:
    6
    Likes Received:
    0
    No, the version is 4.1.12-nt.
    It's the default version that came with Plesk.
     
  6. Rubal

    Rubal Guest

    0
     
    in my.ini change sql-mode="" and restart MySQL. After that check if it makes any difference.
     
Loading...