0.764->0.8 upgrade failed with module Blocks and Profile  Bottom

  • Hello,

    i test the upgrade of a website PN 0.764 to PN 0.8 (last SVN download).
    I keep the database.
    I delete all files.
    I upload the new files of 0.8.
    I chmod 777 the pntemp and sub-folders.
    I modify the config.php with database information and to indicate that webiste is already installed.
    I launch upgrade.php

    I encouter a problem with upgrade of Profile and Blocks modules.
    The message is :

    Quote

    Sauvegarde de la table "user"... fait
    Structure de la table "users" mise à jour.
    Structure de la table "module" mise à jour.
    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'theme_config'

    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'theme_layout'

    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'theme_skins'

    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'theme_palette'

    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'theme_zones'

    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'theme_cache'

    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'theme_blcontrol'

    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'theme_addons'

    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'theme_tplfile'

    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'theme_tplsource'

    upgrade Theme: avec succès
    upgrade Profile: ECHOUE !
    upgrade Blocks: ECHOUE !

    upgrade Users: avec succès
    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'session_info'

    Les utilisateurs existants ont été activés
    Les tables des blocs ont été mises à jour
    Table 'xxx.pn_block_placements' doesn't exist
    INSERT INTO pn_block_placements (pn_pid,pn_bid,pn_order)VALUES (1,'1',2)

    Mettre le thème ExtraLite par défaut
    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'users76x'

    Les données dynamiques des membres ont été migrées
    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'search_stat'

    Table 'xxx.pn_objectdata_attributes' doesn't exist
    DELETE FROM pn_objectdata_attributes WHERE oba_object_type = 'search_result'

    Rechercher les modules qui ont été réinstallés


    if i go to the end to the upgrade, i have on the homepage the errors :

    Quote


    Table 'xxx.pn_block_positions' doesn't exist
    SELECT pn_pid AS "pid",pn_name AS "name",pn_description AS "description" FROM pn_block_positions


    When i got in admin panel of modules, it saids that there are new versions installed for Profile and Blocks.
    I clic on upgrade and i have the error :

    Quote


    Exit-Handler: Exiting after SQL-error Stacktrace:
    --------------------------------------------------------------------------------
    Exit-Handler: Exiting after SQL-error Stacktrace:
    --------------------------------------------------------------------------------
    Erreur : Echec de la mise à jour de la table. (blocks, 1, 0 - )



    my host is :
    MySql 5.0.44
    PHP 5.2.5

    Thanks for your help
    Kind regards

    Garou
  • Hello,

    I solve my problem with not really good solution but it works.
    The problem is due to bad format of some of my MySQL tables (i don't know why)...
    Some items are "index" but shoudn't be.

    To solve my problem :
    - i make a backup of my tables
    - make a new PN 0.764 installation with temporary database
    - delete all datas inside this DB but not the tables
    - export only datas from my originale database
    - import datas in temporary base
    - delete bad tables in originale database
    - import tables from temporary DB to my original DB
    - start the upgrade process

    It work for me.

    Hopes that help some people with the same problem.

    Kind regards

    Garou

This list is based on users active over the last 60 minutes.