- Moderated by:
- Support
0.764->0.8 upgrade failed with module Blocks and Profile
-
- rank:
-
Freshman
- registered:
- September 2002
- Status:
- offline
- last visit:
- 22.08.08
- Posts:
- 24
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
-
- rank:
-
Freshman
- registered:
- September 2002
- Status:
- offline
- last visit:
- 22.08.08
- Posts:
- 24
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
|
