Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Apr 16, 2008
  • Posts: 2

  Posted: Mar 20, 2008 - 04:48 PM

  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: Sep 07, 2002
  • Last visit: Apr 05, 2010
  • Posts: 72

  Posted: Apr 16, 2008 - 03:56 AM

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

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Apr 16, 2008
  • Posts: 2

  Posted: Apr 16, 2008 - 04:43 AM

  hi
  
  not yet , nobody reply about to resolve my problem

  • 
  •  
• bac
  
  

  • Rank: Registered User
  • Registered: Jan 26, 2005
  • Last visit: Oct 21, 2009
  • Posts: 22

  Posted: Apr 16, 2008 - 09:09 PM

  Have you put this problem in the bug zone?

  • 
  •  
• AmmoDump
  
  

  • Rank: Team Member
  • Registered: Dec 07, 2003
  • Last visit: May 09, 2010
  • Posts: 2703

  Posted: Apr 17, 2008 - 07:00 AM

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

  • 
  •  
• garou-69
  
  

  • Rank: Freshman
  • Registered: Sep 07, 2002
  • Last visit: Apr 05, 2010
  • Posts: 72

  Posted: May 05, 2008 - 09:44 PM

  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 on-line

• craigh,
• jmvaughn

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