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

Help! 7.5.4 autoupdate failed!

Discussion in 'Plesk for Linux - 8.x and Older' started by TheMatrix, Aug 27, 2005.

  1. TheMatrix

    TheMatrix Guest

    0
     
    Hello-

    *** NOTE I accidentally posted this in the "How do I" forum, and I can't delete it. ***

    I just tried to autoupdate Plesk 7.5.3 to 7.5.4, and it failed with:

    Trying to apply 7.5.4 changes to database... ERROR 1051 at line 1: Unknown table 'stat'

    ERROR while trying to run the following SQL query: DROP TABLE stat

    Aborting...

    What went wrong?

    TM
     
  2. TheMatrix

    TheMatrix Guest

    0
     
    After renaming /etc/httpd/conf/httpd.init.bak to httpd.init, things seem to be working temporarily.

    Plesk says it's up to date, but it stills ays 7.5.3. How can I force it to run the update again?

    Thanks.

    TM
     
  3. hardweb

    hardweb Guest

    0
     
    There is a problem with the database. You must correct it manually and then force the upgrade from command line using the RPM.
     
  4. TheMatrix

    TheMatrix Guest

    0
     
    Thanks...but how do I do that?

    a. What's wrong with the DB.
    b. How do I force it? It keeps saying its already updated when I try to install the RPM manually.

    Thanks!

    TM
     
  5. jamesyeeoc

    jamesyeeoc Guest

    0
     
    From the error you posted,
    Either the table does not exist, or the updater was not able to delete/drop the table by that name. Are you running on a VPS system or a dedicated server? And you were running the updater as the Server Admin, right?
     
  6. TheMatrix

    TheMatrix Guest

    0
     
    it's a dedicated box with nothing but Plesk 7.5 on it. In the past I was able to update to the minor revisions with no difficulty, leading up to 7.5.3.

    Thanks.

    TM
     
  7. jamesyeeoc

    jamesyeeoc Guest

    0
     
    Hmm, well you can use the command line mysql to try and manually drop the 'stat' table. Or if you have phpMyAdmin installed you can browse the psa database in a nice GUI (I recommend this method)

    As to your question "How do I force it?", to force any RPM, you would use:

    rpm -Uvh --force name-of-package.rpm

    If you get dependency errors, you could use:

    rpm -Uvh --force --nodeps name-of-package.rpm


    Note: Sometimes this can resolve errors, but personally I do not like doing this for a control panel or other critical type update/upgrade. Use at your own risk.
     
  8. TheMatrix

    TheMatrix Guest

    0
     
    How do I deal with all those packages? The instructions say to do them all at once, but Plesk is the only one that wasn't installed right to begin with, so it seems a bit illogical to force the install of everything else that's working.

    Thanks.

    TM
     
  9. jamesyeeoc

    jamesyeeoc Guest

    0
     
    All which packages? Did you first try installing phpMyAdmin and resolve the 'stat' table issue?
    Which instructions are you referring to?
    If you have packages which are running fine, then of course there would be no need to reinstall those.
    7.5.4 is not what I would call a minor update.... But if you want to force the re-install of Plesk itself, first find the file who's name begins with 'psa-7.5.4-yourOSversion', CD into that directory, then from the SSH shell prompt, do:

    rpm -Uvh --force name-of-file-goes-here

    If you get any 'dependency' errors, then you would have to add '--nodeps' to the command (without the quotes). Note: As I stated before, I do not recommend doing this method, just giving answers. It is better to find and fix the error in the first place, rather than forcing a package to re-install which may not solve the problem and possibly may cause further problems. Always make sure you have a full server backup!
     
  10. TheMatrix

    TheMatrix Guest

    0
     
    I haven't tried anything yet, but I will shortly.

    I do know the stat tables doesn't exist - that was the first thing I checked yesterday.

    I was referring to Plesk's upgrade instructions...where it says to do all the packages at once with one rpm command. I'll do as you suggested though.

    Thanks for your help.

    TM
     
  11. jamesyeeoc

    jamesyeeoc Guest

    0
     
    Hmm, then if it does not exist, what if you create an empty table 'stats', which would then satisfy the intaller's need to 'drop table stats'...? I don't know what created that table, I cannot find it on any 7.5.3 servers I can access.
     
Loading...