TOPIC: Undefined property: stdClass::$webinar

If I open a event I got the following message in the table of details:

Notice: Undefined property: stdClass::$webinar in httpdocs/components/com_matukio/views/event/tmpl/default.php on line 415

Installierte Version: 2.0.1
Joomla! 2.5.6

Any idea to solve this problem?

Hi Bigler,

did you update from 1.0 or install Matukio 2.0.1 on a fresh installation? Seems that the matukio table field "webinar" is missing in the database.

Best regards,

Yves

I've installed Version 2.0.1 over Version 2.00

Now i removed Matukio and i tried a fresh install with version 2.0.1
The following error ccours on installation:

JInstaller: :Install: SQL-Fehler DB-Funktion mit Fehlercode 1064 fehlgeschlagen!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '11.2 ) NOT NULL DEFAULT '0.00', `procent` TINYINT( 1 ) NOT NULL DEFAULT '1'' at line 4 SQL=CREATE TABLE IF NOT EXISTS `jos_matukio_booking_coupons` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `code` VARCHAR( 255 ) NOT NULL , `value` FLOAT( 11.2 ) NOT NULL DEFAULT '0.00', `procent` TINYINT( 1 ) NOT NULL DEFAULT '1', `published_up` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `published_down` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `published` TINYINT( 1 ) NOT NULL DEFAULT '0' ) COMMENT='Coupons';
SQL = CREATE TABLE IF NOT EXISTS `#__matukio_booking_coupons` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`code` VARCHAR( 255 ) NOT NULL ,
`value` FLOAT( 11.2 ) NOT NULL DEFAULT '0.00',
`procent` TINYINT( 1 ) NOT NULL DEFAULT '1',
`published_up` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`published_down` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`published` TINYINT( 1 ) NOT NULL DEFAULT '0'
) COMMENT='Coupons';

Hi Thomas,

when you uninstall Matukio the database tables (#__matukio_*) are not deleted (to protect your events data). You will have to remove these tables manually before installing again (through phpmyadmin for example).

Best regards,

Yves

No success.
I've cleared all tables and all entries in tables, but still the same error.

Hmm very strange, is the table field "webinar" existing in the #__matukio table?

Best regards,

Yves

P.S.: PHP Notices and error output should be turned off in production environments (security issue)

I tried now to create the table fields by hand.
I stuck always on the same error, the field "value can not be created because of the length of 11.2:

Fehler
SQL-Befehl:

ALTER TABLE `jos_matukio_booking_coupons` CHANGE `value` `value` FLOAT( 11.2 ) NOT NULL DEFAULT '0'

MySQL meldet:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '11.2) NOT NULL DEFAULT '0'' at line 1

I'm using PHP Version 5.2.6
The Installation of Matukio Version 2.0.0 worked fine.
After Upgrade to 2.0.1 errors were coming up (see post1)
Then uninstalled Matukio cleaned all DB entries.
Since then i'm not able to install anymore Version 2.0.0 nor 2.0.1

Halle Thomas,

there was a bug in the install.mysql.sql which causes the installation to break on MySQL < 5.0.4. You have to change the wrong line to FLOAT( 11, 2 ) - coma instead of point or install Matukio Version 2.0.2, which fixed that bug.

Best regards,

Yves Hoppe

Thanks a lot, that worked!

Regards Tom