Zikula Community

• kakkerlakgly
  
  

  • Rank: Registered User
  • Registered: Nov 27, 2006
  • Last visit: Jan 13, 2009
  • Posts: 11

  Posted: Nov 15, 2008 - 02:53 AM

  I had the problem upgrading from 0.764.
  The root was that the primary key in _themes was theme_id and Zikula tried to add a new auto_increment row called pn_id.
  MySql 5.0.51 did not allow that and the upgrade failed.
  
  The solution was to rename the primary key to pn_id.

  • 
  •  
• kakkerlakgly
  
  

  • Rank: Registered User
  • Registered: Nov 27, 2006
  • Last visit: Jan 13, 2009
  • Posts: 11

  Posted: Nov 15, 2008 - 04:02 AM

  Next surpruce is that if you do not include the register_global off in the .htaccess, the upgrade will continue to cykle resulting in an error regarding pn_timezone_offset missing in _users

  • 
  •  
• emada
  
  

  • Rank: Softmore
  • Registered: Oct 05, 2008
  • Last visit: Feb 17, 2010
  • Posts: 144

  Posted: Nov 16, 2008 - 08:00 PM

  kakkerlakgly

  I had the problem upgrading from 0.764.
  The root was that the primary key in _themes was theme_id and Zikula tried to add a new auto_increment row called pn_id.
  MySql 5.0.51 did not allow that and the upgrade failed.
  
  The solution was to rename the primary key to pn_id.

  
  
  What table is this done in??
  
  pn_theme_addons
  pn_theme_blcontrol
  pn_theme_cache
  pn_theme_config
  pn_theme_layout
  pn_theme_palette
  pn_theme_skins
  pn_theme_tplfile
  pn_theme_tplsource
  pn_theme_zones
  
  
  
  edited by: emada, Nov 17, 2008 - 03:01 AM

  • 
  •  
• kakkerlakgly
  
  

  • Rank: Registered User
  • Registered: Nov 27, 2006
  • Last visit: Jan 13, 2009
  • Posts: 11

  Posted: Nov 16, 2008 - 09:45 PM

  It was in pn_themes (with nothing more added) and the row was themes_id not theme_id.

  • 
  •  
• nestormateo
  
  

  • Rank: Team Member
  • Registered: Sep 06, 2006
  • Last visit: May 09, 2010
  • Posts: 2446

  Posted: Nov 16, 2008 - 09:54 PM

  But it's weird. How can you change the primary key or even the index when the pn_themes table is created during the upgrade process? have you changed the Themes/pntables.php file?
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• emada
  
  

  • Rank: Softmore
  • Registered: Oct 05, 2008
  • Last visit: Feb 17, 2010
  • Posts: 144

  Posted: Nov 16, 2008 - 10:50 PM

  ok i dont seem to see pn_themes in my 7.6.4 DB. . . so you have to do a upgrade and let it fail then make the changes to the DB?? then what??

  • 
  •  
• kakkerlakgly
  
  

  • Rank: Registered User
  • Registered: Nov 27, 2006
  • Last visit: Jan 13, 2009
  • Posts: 11

  Posted: Nov 16, 2008 - 11:45 PM

  The site is from way back .724 or something (upgraded to .764 2 years ago), the table pn_themes might be some leftover garbage.
  I tried the upgrade which failed, found the error, changed the name of the primary key themes_id to pn_id which causes zikula to alter the row instead of trying to add a new.
  
  
  
  edited by: kakkerlakgly, Nov 17, 2008 - 11:51 AM

  • 
  •  
• nestormateo
  
  

  • Rank: Team Member
  • Registered: Sep 06, 2006
  • Last visit: May 09, 2010
  • Posts: 2446

  Posted: Nov 17, 2008 - 02:07 AM

  Ah, so it can work...
  emada, try this: perform a clean install of Zikula.
  Export the sctructure of the pn_themes table and copy it to your 0.764 database.
  Then perform the upgrade and let's see what happen
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• AmmoDump
  
  

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

  Posted: Nov 17, 2008 - 06:32 PM

  I agree with Mateo, clear out all of your themes, first. Then try the upgrade.
  
  The theme upgrade is a helper tool, not a definitive script to do theme upgrades. It only really works perfectly for XTE-cookie-cutter themes. Themes that have 'custom' workings fail the upgrade rather easily, as there are too many scenarios for which to account.
  
  --
  David Pahl
  Zikula Support Team

  • 
  •  
• emada
  
  

  • Rank: Softmore
  • Registered: Oct 05, 2008
  • Last visit: Feb 17, 2010
  • Posts: 144

  Posted: Nov 17, 2008 - 07:16 PM

  ok thanx guys will give it a go and see what happens

  • 
  •  
• emada
  
  

  • Rank: Softmore
  • Registered: Oct 05, 2008
  • Last visit: Feb 17, 2010
  • Posts: 144

  Posted: Nov 17, 2008 - 07:59 PM

  it didnt work :*( i dont know why zikula hates me so much.

  • 
  •  
• nestormateo
  
  

  • Rank: Team Member
  • Registered: Sep 06, 2006
  • Last visit: May 09, 2010
  • Posts: 2446

  Posted: Nov 17, 2008 - 09:44 PM

  Any detail of what happened with the pn_themes table and the old ones? were deleted successfully or not? no error message at all in the PHP error log?
  
  
  --
  - Mateo T. -
  Mis principios... son mis fines

  • 
  •  
• emada
  
  

  • Rank: Softmore
  • Registered: Oct 05, 2008
  • Last visit: Feb 17, 2010
  • Posts: 144

  Posted: Nov 17, 2008 - 11:17 PM

  all the old tables are still there. PHP logs to syslog and there is nothing :( i did find this in the apache logs:
  
  [Tue Nov 18 09:49:07 2008] [error] [client 10.10.5.227] File does not exist: /var/www/themes/ExtraLite/images/icon.png
  [Tue Nov 18 09:49:07 2008] [error] [client 10.10.5.227] File does not exist: /var/www/themes/ExtraLite/images/favicon.ico
  [Tue Nov 18 09:49:07 2008] [error] [client 10.10.5.227] File does not exist: /var/www/themes/ExtraLite/style/styleNN.css, referer: http://10.10.5.210/

  • 
  •  
• AmmoDump
  
  

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

  Posted: Nov 17, 2008 - 11:23 PM

  These errors are of little consequence. I would disregard these as problematic, ATM.
  
  --
  David Pahl
  Zikula Support Team

  • 
  •  
• emada
  
  

  • Rank: Softmore
  • Registered: Oct 05, 2008
  • Last visit: Feb 17, 2010
  • Posts: 144

  Posted: Nov 17, 2008 - 11:44 PM

  ok so...what next??

  • 
  •  
•  
•  

Users on-line

• mazdev,
• mesteele101

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