Alpha 2 to Alpha 3 - Create Events

by **Poil** » Wed Jan 28, 2009 10:32 am

Since my upgade to alpha I got this error when trying to create an event :

104 - Problems storing Event Detail

I had "setup the database" and run the 2 SQL and my Jevents component and module are enable

Linux : 2.6.18-6-686 #1 SMP Fri Dec 12 16:48:28 UTC 2008 i686
MySQL : 5.0.32-Debian_7etch8-log / utf8_general_ci
PHP: 5.2.0-8+etch13
Httpd: Apache/2.2.3 (Debian) PHP/5.2.0-8+etch13 mod_ssl/2.2.3 OpenSSL/0.9.8c
Joomla! 1.5.8 Production/Stable [ Wohnaiki ] 10-November-2008 23:00 GMT
Memory Limit : 32MB

by **Geraint** » Wed Jan 28, 2009 12:41 pm

Can you edit the file

components/com_jevents/libraries/iCalEvent.php and at line c. 855 change

Code: Select all: if (!$detailid){ JError::raiseError( 104, JText::_("Problems storing Event Detail")); echo $db->getErroMsg()."<br/>"; return false; }

to

Code: Select all: if (!$detailid){ JError::raiseError( 104, JText::_("Problems storing Event Detail")); echo $db->getErroMsg()."<br/>"; die(); return false; }

notice the extra "die();" statement.

And then tell me what error message you get when you try to save and event

Geraint

by **Poil** » Wed Jan 28, 2009 1:40 pm

I got the same thing :!:

I tryied to modify

Code: Select all: if (!$detailid){ $toto= $db->getErroMsg()."<br/>"; JError::raiseError( 104, JText::_("Problems storing Event Detail".$toto)); die(); return false; }

But I have :
class = iCalEvent
Fatal error: Call to undefined method JDatabaseMySQL::getErroMsg() in /opt/joomla/components/com_jevents/libraries/iCalEvent.php on line 86

EDIT :
OK you got an error getErroMsg => getErrorMSG

Here is the error :

Code: Select all: 104 - Problems storing Event Detail Unknown column 'color' in 'field list' SQL=INSERT INTO `jos_jevents_vevdetail` ( `dtstart`,`dtstartraw`,`duration`,`durationraw`,`dtend`,`dtendraw`,`dtstamp`,`class`,`categories`,`description`,`geolon`,`geolat`,`location`,`priority`,`status`,`summary`,`contact`,`organizer`,`url`,`created`,`sequence`,`extra_info`,`color` ) VALUES ( '1233123780','','0','','1233157620','','','','','gfd','','','','0','','gfd','','','','','','','' )

by **Poil** » Wed Jan 28, 2009 1:55 pm

I have add a "color" row now working :mrgreen:

by **Geraint** » Wed Jan 28, 2009 2:37 pm

Thanks for spotting that - I'll add it to the dbsetup function.

by **Poil** » Wed Jan 28, 2009 3:28 pm

Don't forget the getErrorMsg