Zikula Community

• bronto
  
  

  • Rank: Helper
  • Registered: Dec 31, 1969
  • Last visit: May 07, 2010
  • Posts: 507

  Posted: Mar 03, 2010 - 11:40 AM

  We have a custom module on a couple of our sites. I am doing the upgrade from zk1.1 to 1.2. All has gone well, and all is functional, but on the custom module the tables were not converted to UTF-8. During the upgrade, the page reported "SKIPPED..." for each of these tables. Why?
  
  All the other tables were converted. The upgrade is very conservative; only the core was upgraded, there are still quite a few 1.1 modules in it, so it wasn't just 1.2 specific modules that were converted.

  • 
  •  
• Teb
  
  

  • Rank: Team Member
  • Registered: Feb 27, 2005
  • Last visit: Apr 12, 2010
  • Posts: 665

  Posted: Mar 03, 2010 - 11:10 PM

  I guess those tables did not start with the zikula-prefix, which is defined in your config/config.php
  
  You can manually do the conversion yourself, replacing $table with your tablename, repeating for all tables:
  

  Code

  ANALYZE TABLE $table;
  REPAIR TABLE $table;
  OPTIMIZE TABLE $table;
  ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  ALTER TABLE $table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

  
  
  --
  -- Teb
  -- Dutch Zikula Community
  
  Support questions in a Personal Message will be ignored. Use the forums at all times!

  • 
  •  
• bronto
  
  

  • Rank: Helper
  • Registered: Dec 31, 1969
  • Last visit: May 07, 2010
  • Posts: 507

  Posted: Mar 04, 2010 - 05:28 AM

  That is correct, different non-conforming table names.
  
  Should I anticipate any problems with non-UTF8 tables for this module in 1.2.2? Another (desktop) application uses these tables and it would be nice if I could deal with it's UTF8 conversion at a later date.

  • 
  •  
• Teb
  
  

  • Rank: Team Member
  • Registered: Feb 27, 2005
  • Last visit: Apr 12, 2010
  • Posts: 665

  Posted: Mar 04, 2010 - 06:28 AM

  That completely depends on how your module was written and what it displays on the screen.
  
  I guess it wouldn't hurt to wait if you test your module properly. But there might be undesired or unexpected results if a page is rendered using utf8 and input is stored in latin.
  
  So, test it, and invest time in the long run by converting your app to UTF-8 if possible. This will probably be inevidable anyway.
  
  --
  -- Teb
  -- Dutch Zikula Community
  
  Support questions in a Personal Message will be ignored. Use the forums at all times!

  • 
  •  
•  
•  

Users on-line

• eledril

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