Is it really piCal 0.76?
piCal_xoops.php in 0.76 should be ...
// XOOPS Search module
$showcontext = empty( $_GET['showcontext'] ) ? 0 : 1 ;
$select4con = $showcontext ? "description" : "'' AS description" ;
Thus, $event->description should not be empty property.
Though it is an issue of an incompatibility between MySQL versions.
Here is a fix, which removes the useless '':
// XOOPS Search module
$showcontext = empty( $_GET['showcontext'] ) ? 0 : 1 ;
$select4con = $showcontext ? ", description" : "" ;
// SQL??????
$sql = "SELECT id,uid,summary,UNIX_TIMESTAMP(dtstamp) AS udtstamp, start, end, allday, start_date, end_date $select4con FROM $this->table WHERE\
admission>0 AND (rrule_pid=0 OR rrule_pid=id) AND ($whr_categories) AND ($whr_class) AND ($whr_text) AND ($whr_uid) ORDER BY dtstamp DESC LIMIT $offse\
t,$limit" ;
// ??????
$rs = mysql_query( $sql , $this->conn ) ;
$ret = array() ;
$context = '' ;
$myts =& MyTextSanitizer::getInstance();
The source of this problem is the '' in the query:
Quote:
SELECT id,uid,summary,UNIX_TIMESTAMP(dtstamp) AS udtstamp, start, end, allday, start_date, end_date, '' FROM x_pical_event WHERE admission>0 AND (rrule_pid=0 OR rrule_pid=id) AND (1) AND (1) AND (1) AND (uid=1) ORDER BY dtstamp DESC LIMIT 0,5;
If I trade this line out for mysql_fetch_array($rs), the fatal error is cleared, but this doesn't work with the loop, of course.
I can't seem to figure out why mysql_fetch_object() fails so miserably. Running the same query against the database produces:
Any thoughts on how to fix this, other than changing this to mysql_fetch_array() and editing the entire code loop to use the values from the array?