Results 1 to 4 of 4

Thread: Upgrade 9.8.2

  1. #1
    New Pligger SRSWWi's Avatar
    Joined
    Oct 2006
    Posts
    29

    Upgrade 9.8.2

    Got this when I upgraded from a halting 9.8 to 9.8.2:

    PHP Code:
    Warningmysql_query(): Access denied for user 'www-data'@'localhost' (using passwordNOin /home/kunder/9/projekt.h.se/install/upgrade.php on line 45

    Warning
    mysql_query(): A link to the server could not be established in /home/kunder/9/projekt.h.se/install/upgrade.php on line 45

    Warning
    mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/kunder/9/projekt.h.se/install/upgrade.php on line 46

    Warning
    Duplicate entry '69' for key 1 in /home/kunder/9/projekt.h.se/libs/db.php on line 233

    Regenerating the totals table
    ...

    If 
    you see a "Duplicate key name `link_search`" warningjust ignore it.
    WarningDuplicate key name 'link_search' in /home/kunder/9/projekt.h.se/libs/db.php on line 233
    Clearing templates_c directory
    ...

    If 
    there were no errors displayedupgrade is complete
    When I test to see if the upgrade was ok, I got this:
    There is a problem with the categories table. Error CA:001.

    To tired to look for errors in the upgrade script just now. Hopes anyone else have found it.

    //J

  2. #2
    Mayor of PliggVille AshDigg's Avatar
    Joined
    Dec 2005
    Posts
    1,515
    Quote Originally Posted by SRSWWi View Post

    When I test to see if the upgrade was ok, I got this:
    There is a problem with the categories table. Error CA:001.

    To tired to look for errors in the upgrade script just now. Hopes anyone else have found it.

    //J
    Make sure...

    1) your categories table does still exist.
    2) you still have a category named 'all'
    3) the 'all' row has a 'category__auto_id' = 0

  3. #3
    New Pligger SRSWWi's Avatar
    Joined
    Oct 2006
    Posts
    29
    1) your categories table does still exist.
    categories still exist.

    2) you still have a category named 'all'
    Mine is called alla, but I will change to test.

    3) the 'all' row has a 'category__auto_id' = 0
    It had a value of 22.

    Did a new "Upgrade" and got this error:
    Code:
    Note: this is just a database upgrade, you still need to upload the new files.
    Upgrading Tables...
    
    Warning: mysql_query(): Access denied for user 'www-data'@'localhost' (using password: NO) in /home/kunder/9/projekt.h.se/install/upgrade.php on line 45
    
    Warning: mysql_query(): A link to the server could not be established in /home/kunder/9/projekt.h.se/install/upgrade.php on line 45
    
    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/kunder/9/projekt.h.se/install/upgrade.php on line 46
    
    Warning: Duplicate entry '69' for key 1 in /home/kunder/9/projekt.h.se/libs/db.php on line 233
    
    Regenerating the totals table...
    
    If you see a "Duplicate key name `link_search`" warning, just ignore it.
    Warning: Duplicate key name 'link_search' in /home/kunder/9/projekt.h.se/libs/db.php on line 233
    Clearing templates_c directory...
    But running pligg after that, causes no errors.

    Still confused, time for tea.

  4. #4
    Mayor of PliggVille AshDigg's Avatar
    Joined
    Dec 2005
    Posts
    1,515
    Your Pligg install should be fine, but if you'd like, you can download the updated upgrade.php file here and re-run the upgrade.

Similar Threads

  1. upgrade
    By weebit in forum Questions & Comments
    Replies: 0
    Last Post: 07-04-2010, 12:31 PM
  2. Upgrade from 9.9.5 to 1 RC3
    By hQcoder in forum Questions & Comments
    Replies: 1
    Last Post: 04-06-2009, 11:38 AM
  3. Upgrade from 9.6 to 9.8
    By rubber2002 in forum Questions & Comments
    Replies: 1
    Last Post: 10-25-2007, 08:11 PM
  4. how to upgrade to 9.7
    By cooldudeny in forum Questions & Comments
    Replies: 2
    Last Post: 08-25-2007, 02:03 AM
  5. 9.0 to 9.1 upgrade
    By mightyb in forum Questions & Comments
    Replies: 4
    Last Post: 02-26-2007, 09:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Pligg Modules and Pligg Templates from Pligg Pro Donate to Pligg CMS Dreamhost Web Hosting Host Gator Web Hosting