SELECT staffel.*, REPLACE(REPLACE(staffel.staffel, " ",""), ".","") AS staff, LOWER(REPLACE(REPLACE(Liga.liga, " ",""), ".","")) AS league FROM (SELECT * FROM bmm1920.staffeln UNION SELECT * FROM bmm.staffeln) staffel JOIN bmm1920.ligen Liga ON (staffel.Liga) IN ((Liga.ID)) GROUP BY ID ORDER BY LOCATE(league, ?)=0, LOCATE(league, ?), LENGTH(REPLACE(REPLACE(?, league, ""), LOWER(staff), "")), LOCATE(staff, REPLACE(?, league, "")) DESC, staffel.IDEs ist ein Fehler aufgetreten.
8: Trying to get property 'ID' of non-object /var/customers/webs/bdaw/mattzug.de/bmm/php/classes/dao/id.php:55
#0 Bootstrap->errorHandler(8, Trying to get property 'ID' of non-object, /var/customers/webs/bdaw/mattzug.de/bmm/php/classes/dao/id.php, 55, Array ([select] => Bdaw_Sql_Coalesce Object ([Bdaw_Sql_Coalescetable] => Bdaw_Sql_Table Object ([schema] => bmm,[schemaSuffix] => 1920,[basename] => staffeln,[name] => bmm1920.staffeln,[alias] => staffel,[primaryKey] => ID),[*data] => Array ([0] => *,[staff] => REPLACE(REPLACE(staffel.staffel, " ",""), ".",""),[league] => LOWER(REPLACE(REPLACE(Liga.liga, " ",""), ".",""))),[*select] => Bdaw_Sql_Union Object ([*selects] => Array ([0] => Bdaw_Sql_Simple Object ([*selectColumns] => Array (),[*distinct] => ,[*group] => ,[*order] => ,[*limit] => ,[*tableName] => bmm1920.staffeln,[*conditions] => Array (),[*in] => Array (),[*inColumns] => Array (),[*now] => ,[*subs] => Array ()),[1] => Bdaw_Sql_Simple Object ([*selectColumns] => Array (),[*distinct] => ,[*group] => ,[*order] => ,[*limit] => ,[*tableName] => bmm.staffeln,[*conditions] => Array (),[*in] => Array (),[*inColumns] => Array (),[*now] => ,[*subs] => Array ()))),[*alias] => staffel,[*prefix] => staffel.,[*distinct] => ,[*from] => staffel staffel,[*group] => GROUP BY ID,[*order] => ORDER BY LOCATE(league, ?)=0, LOCATE(league, ?), LENGTH(REPLACE(REPLACE(?, league, ""), LOWER(staff), "")), LOCATE(staff, REPLACE(?, league, "")) DESC, staffel.ID,[*joins] => Array ([0] => Bdaw_Sql_Join Object ([joinColumns] => Array ([0] => Liga),[foreignColumns] => Array ([0] => ID),[*alias] => Liga,[*prefix] => Liga.,[*distinct] => ,[*from] => bmm1920.ligen Liga,[*group] => ,[*order] => ,[*joins] => Array (),[*leftJoins] => Array (),[*subJoins] => Array (),[*allJoins] => Array (),[*selectColumns] => Array (),[*limit] => ,[*tableName] => bmm1920.ligen,[*conditions] => Array (),[*in] => Array (),[*inColumns] => Array (),[*now] => ,[*subs] => Array ())),[*leftJoins] => Array (),[*subJoins] => Array (),[*allJoins] => Array ([0] => Bdaw_Sql_Join Object ([joinColumns] => Array ([0] => Liga),[foreignColumns] => Array ([0] => ID),[*alias] => Liga,[*prefix] => Liga.,[*distinct] => ,[*from] => bmm1920.ligen Liga,[*group] => ,[*order] => ,[*joins] => Array (),[*leftJoins] => Array (),[*subJoins] => Array (),[*allJoins] => Array (),[*selectColumns] => Array (),[*limit] => ,[*tableName] => bmm1920.ligen,[*conditions] => Array (),[*in] => Array (),[*inColumns] => Array (),[*now] => ,[*subs] => Array ())),[*selectColumns] => Array ([0] => *,[staff] => REPLACE(REPLACE(staffel.staffel, " ",""), ".",""),[league] => LOWER(REPLACE(REPLACE(Liga.liga, " ",""), ".",""))),[*limit] => ,[*tableName] => staffel,[*conditions] => Array (),[*in] => Array (),[*inColumns] => Array (),[*now] => ,[*subs] => Array ()),[parameters] => Array ([0] => stadtligaa,[1] => stadtligaa,[2] => stadtligaa,[3] => stadtligaa),[result] => ,[pk] => ID)) called at [/var/customers/webs/bdaw/mattzug.de/bmm/php/classes/dao/id.php:55] #1 DAO_Staffel::prefetchOne(Bdaw_Sql_Coalesce Object ([Bdaw_Sql_Coalescetable] => Bdaw_Sql_Table Object ([schema] => bmm,[schemaSuffix] => 1920,[basename] => staffeln,[name] => bmm1920.staffeln,[alias] => staffel,[primaryKey] => ID),[*data] => Array ([0] => *,[staff] => REPLACE(REPLACE(staffel.staffel, " ",""), ".",""),[league] => LOWER(REPLACE(REPLACE(Liga.liga, " ",""), ".",""))),[*select] => Bdaw_Sql_Union Object ([*selects] => Array ([0] => Bdaw_Sql_Simple Object ([*selectColumns] => Array (),[*distinct] => ,[*group] => ,[*order] => ,[*limit] => ,[*tableName] => bmm1920.staffeln,[*conditions] => Array (),[*in] => Array (),[*inColumns] => Array (),[*now] => ,[*subs] => Array ()),[1] => Bdaw_Sql_Simple Object ([*selectColumns] => Array (),[*distinct] => ,[*group] => ,[*order] => ,[*limit] => ,[*tableName] => bmm.staffeln,[*conditions] => Array (),[*in] => Array (),[*inColumns] => Array (),[*now] => ,[*subs] => Array ()))),[*alias] => staffel,[*prefix] => staffel.,[*distinct] => ,[*from] => staffel staffel,[*group] => GROUP BY ID,[*order] => ORDER BY LOCATE(league, ?)=0, LOCATE(league, ?), LENGTH(REPLACE(REPLACE(?, league, ""), LOWER(staff), "")), LOCATE(staff, REPLACE(?, league, "")) DESC, staffel.ID,[*joins] => Array ([0] => Bdaw_Sql_Join Object ([joinColumns] => Array ([0] => Liga),[foreignColumns] => Array ([0] => ID),[*alias] => Liga,[*prefix] => Liga.,[*distinct] => ,[*from] => bmm1920.ligen Liga,[*group] => ,[*order] => ,[*joins] => Array (),[*leftJoins] => Array (),[*subJoins] => Array (),[*allJoins] => Array (),[*selectColumns] => Array (),[*limit] => ,[*tableName] => bmm1920.ligen,[*conditions] => Array (),[*in] => Array (),[*inColumns] => Array (),[*now] => ,[*subs] => Array ())),[*leftJoins] => Array (),[*subJoins] => Array (),[*allJoins] => Array ([0] => Bdaw_Sql_Join Object ([joinColumns] => Array ([0] => Liga),[foreignColumns] => Array ([0] => ID),[*alias] => Liga,[*prefix] => Liga.,[*distinct] => ,[*from] => bmm1920.ligen Liga,[*group] => ,[*order] => ,[*joins] => Array (),[*leftJoins] => Array (),[*subJoins] => Array (),[*allJoins] => Array (),[*selectColumns] => Array (),[*limit] => ,[*tableName] => bmm1920.ligen,[*conditions] => Array (),[*in] => Array (),[*inColumns] => Array (),[*now] => ,[*subs] => Array ())),[*selectColumns] => Array ([0] => *,[staff] => REPLACE(REPLACE(staffel.staffel, " ",""), ".",""),[league] => LOWER(REPLACE(REPLACE(Liga.liga, " ",""), ".",""))),[*limit] => ,[*tableName] => staffel,[*conditions] => Array (),[*in] => Array (),[*inColumns] => Array (),[*now] => ,[*subs] => Array ()), Array ([0] => stadtligaa,[1] => stadtligaa,[2] => stadtligaa,[3] => stadtligaa)) called at [/var/customers/webs/bdaw/mattzug.de/bmm/php/classes/dao/staffel.php:41] #2 DAO_Staffel::suche(stadtligaa) called at [/var/customers/webs/bdaw/mattzug.de/bmm/php/classes/bmm/status.php:69] #3 Bmm_Status->fetchStaffel() called at [/var/customers/webs/bdaw/mattzug.de/bmm/php/classes/controller/bmm.php:142] #4 Controller_Bmm->init() called at [/var/customers/webs/bdaw/mattzug.de/bmm/php/classes/controller/bmm.php:115] #5 Controller_Bmm->dispatch() called at [/var/customers/webs/bdaw/mattzug.de/bmm/php/classes/bootstrap.php:64] #6 Bootstrap->__construct(bmm, Controller_Bmm) called at [/var/customers/webs/bdaw/mattzug.de/bmm/php/bmm.php:5]