Zikula Community

• dome88
  
  

  • Rank: Freshman
  • Registered: 20.03.08
  • last visit: 16.04.08
  • Posts: 2

  Posted: 21.03.2008, 04:48

  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

  • 
  •  
• garou-69
  
  

  • Rank: Freshman
  • Registered: 08.09.02
  • last visit: 11.03.09
  • Posts: 34

  Posted: 16.04.2008, 15:56

  hello,
  
  do you found solution ?
  
  i have the same problem with module Profile and module Blocks...
  
  thanks
  
  Manu

  • 
  •  
• dome88
  
  

  • Rank: Freshman
  • Registered: 20.03.08
  • last visit: 16.04.08
  • Posts: 2

  Posted: 16.04.2008, 16:43

  hi
  
  not yet , nobody reply about to resolve my problem

  • 
  •  
• bac
  
  

  • Rank: Freshman
  • Registered: 26.01.05
  • last visit: 27.03.09
  • Posts: 24

  Posted: 17.04.2008, 09:09

  Have you put this problem in the bug zone?

  • 
  •  
• AmmoDump
  
  

  • Rank: Team Member
  • Registered: 08.12.03
  • last visit: 29.06.09
  • Posts: 3062

  Posted: 17.04.2008, 19:00

  We are currently investigating this, thanks.
  
  --
  David Pahl
  Zikula Support Team

  • 
  •  
• garou-69
  
  

  • Rank: Freshman
  • Registered: 08.09.02
  • last visit: 11.03.09
  • Posts: 34

  Posted: 06.05.2008, 09:44

  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

  • 
  •  
•  
•  

Users online

• Simon,
• Teb,
• craigh,
• espaan,
• shyra

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