r40112 - /trunk/calendar/setup/tables_update.inc.php

[ralfbecker_sf]

Author: ralfbecker
Date: Mon Aug 13 15:13:57 2012
New Revision: 40112

URL: http://svn.stylite.de/viewvc/egroupware?rev=40112&view=rev
Log:
MAX(CHAR_LENGTH(cal_description)) returns NULL, if there are no rows --> casting to int

Modified:
    trunk/calendar/setup/tables_update.inc.php

Modified: trunk/calendar/setup/tables_update.inc.php
URL: http://svn.stylite.de/viewvc/egroupware/trunk/calendar/setup/tables_update.inc.php?rev=40112&r1=40111&r2=40112&view=diff
==============================================================================
--- trunk/calendar/setup/tables_update.inc.php (original)
+++ trunk/calendar/setup/tables_update.inc.php Mon Aug 13 15:13:57 2012
@@ -2134,7 +2134,8 @@
 {
  // only alter description to varchar(16384), if it does NOT contain longer input and it can be stored as varchar
  $max_description_length = $GLOBALS['egw']->db->query('SELECT MAX(CHAR_LENGTH(cal_description)) FROM egw_cal')->fetchColumn();
- if (is_numeric($max_description_length) && $max_description_length <= 16384 && $GLOBALS['egw_setup']->oProc->max_varchar_length >= 16384)
+ // returns NULL, if there are no rows!
+ if ((int)$max_description_length <= 16384 && $GLOBALS['egw_setup']->oProc->max_varchar_length >= 16384)
  {
  $GLOBALS['egw_setup']->oProc->AlterColumn('egw_cal','cal_description',array(
  'type' => 'varchar',


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
eGroupWare-cvs mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/egroupware-cvs