Support Forum

hi,

i just upgrade my PN 764 to pn8 RC3 ,
but i got some problem here ,
during upgrade prosess i got the following errors ;

# Backing Up user database... done
# Users database structure upgraded.
# Module database structure upgraded.
# upgrade Theme: successful
# upgrade Profile: FAILED!
# upgrade Blocks: successful
# upgrade Users: successful
# Existing users have been activated
# Blocks tables upgraded
# Reset theme to ExtraLite

Unknown column 'pn_uda_id' in 'field list'
SELECT pn_uda_id AS "uda_id",pn_uda_propid AS "uda_propid",pn_uda_uid AS "uda_uid",pn_uda_value AS "uda_value" FROM nuke_user_data WHERE pn_uda_propid = '1' AND pn_uda_uid = '2'

Unknown column 'pn_uda_id' in 'field list'
SELECT pn_uda_id AS "uda_id",pn_uda_propid AS "uda_propid",pn_uda_uid AS "uda_uid",pn_uda_value AS "uda_value" FROM nuke_user_data WHERE pn_uda_propid = '3' AND pn_uda_uid = '2'

Unknown column 'pn_uda_id' in 'field list'
SELECT pn_uda_id AS "uda_id",pn_uda_propid AS "uda_propid",pn_uda_uid AS "uda_uid",pn_uda_value AS "uda_value" FROM nuke_user_data WHERE pn_uda_propid = '4' AND pn_uda_uid = '2'

Unknown column 'pn_uda_id' in 'field list'
SELECT pn_uda_id AS "uda_id",pn_uda_propid AS "uda_propid",pn_uda_uid AS "uda_uid",pn_uda_value AS "uda_value" FROM nuke_user_data WHERE pn_uda_propid = '5' AND pn_uda_uid = '2'

Unknown column 'pn_uda_id' in 'field list'
SELECT pn_uda_id AS "uda_id",pn_uda_propid AS "uda_propid",pn_uda_uid AS "uda_uid",pn_uda_value AS "uda_value" FROM nuke_user_data WHERE pn_uda_propid = '6' AND pn_uda_uid = '2'

Unknown column 'pn_uda_id' in 'field list'
SELECT pn_uda_id AS "uda_id",pn_uda_propid AS "uda_propid",pn_uda_uid AS "uda_uid",pn_uda_value AS "uda_value" FROM nuke_user_data WHERE pn_uda_propid = '13' AND pn_uda_uid = '2'






i have no idea about this.anyone can help me ? thanks

hello,

do you found solution ?

i have the same problem with module Profile and module Blocks...

thanks

Manu

hi

not yet , nobody reply about to resolve my problem

Have you put this problem in the bug zone?

We are currently investigating this, thanks.

-----
David Pahl
Zikula Support Team

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.

Kinds regards

Garou