[TYPO3-german] 4.5.23: EXT realty crasht im BE

[André Rainer]

Hallo,

nach dem Update 4.5.22 -> 4.5.23 bekomme ich im BE in der Listenansicht mit 
den Datensätzen der EXT 'realty' folgenden Fehler:

"There was an error with the database query. 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 'AND 1 = 1 AND tx_realty_districts.deleted=0 
ORDER BY title ASC' at line 1 The last built query: SELECT * FROM 
tx_realty_districts WHERE city = 0 OR city = AND 1 = 1 AND 
tx_realty_districts.deleted=0 ORDER BY title ASC"

Das SQL-Statement scheint wohl was nicht zu stimmen. Die ausführliche 
Fehlermeldung habe ich unten angefügt.

Merkwürdig ist, dass das bis 4.5.22 alles noch problemlos lief, ich habe den 
alten Source jetzt erstmal zurückgespielt. Im FE funktioniert übrigens alles 
wie bisher. Weiss hier vielleicht jemand weiter?

MfG.,
A. Rainer

____________________________

Uncaught TYPO3 Exception
There was an error with the database query. 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 'AND 1 = 1 AND tx_realty_districts.deleted=0 
ORDER BY title ASC' at line 1 The last built query: SELECT * FROM 
tx_realty_districts WHERE city = 0 OR city = AND 1 = 1 AND 
tx_realty_districts.deleted=0 ORDER BY title ASC

tx_oelib_Exception_Database thrown in file
/home/lpwohnen/htdocs/typo3/typo3conf/ext/oelib/class.tx_oelib_db.php in 
line 326.
13 tx_oelib_db::select("*", "tx_realty_districts", "city = 0 OR city =  AND 
1 = 1 AND tx_realty_districts.deleted=0", "", "title ASC", "")

/home/lpwohnen/htdocs/typo3/typo3conf/ext/oelib/class.tx_oelib_db.php:
00393:   $dbResult = self::select(
00394:    $fieldNames, $tableNames, $whereClause, $groupBy, $orderBy, $limit
00395:   );
00396:
00397:   while ($recordData = 
$GLOBALS['TYPO3_DB']->sql_fetch_assoc($dbResult)) {

12 tx_oelib_db::selectMultiple("*", "tx_realty_districts", "city = 0 OR city 
=  AND 1 = 1 AND tx_realty_districts.deleted=0", "", "title ASC")

/home/lpwohnen/htdocs/typo3/typo3conf/ext/oelib/class.tx_oelib_DataMapper.php:
00961:    '',
00962:    $orderBy
00963:   );
00964:
00965:   return $this->getListOfModels($rows);

11 tx_oelib_DataMapper::findByWhereClause("city = 0 OR city = ", "title 
ASC")

/home/lpwohnen/htdocs/typo3/typo3conf/ext/realty/Mapper/class.tx_realty_Mapper_District.php:
00093:   */
00094:  public function findAllByCityUidOrUnassigned($uid) {
00095:   return $this->findByWhereClause('city = 0 OR city = ' . $uid, 
'title ASC');
00096:  }
00097:

10 tx_realty_Mapper_District::findAllByCityUidOrUnassigned(NULL)

/home/lpwohnen/htdocs/typo3/typo3conf/ext/realty/class.tx_realty_Tca.php:
00045:
00046:   $districs = 
tx_oelib_MapperRegistry::get('tx_realty_Mapper_District')
00047:    ->findAllByCityUidOrUnassigned($data['row']['city']);
00048:   foreach ($districs as $district) {
00049:    $items[] = array($district->getTitle(), $district->getUid());

9 tx_realty_Tca::getDistrictsForCity(array, t3lib_TCEforms)
8 call_user_func_array(array, array)

/home/typo3_src-4.5.22/t3lib/class.t3lib_div.php:
05207:       array(&$classObj, $parts[1]),
05208:       array(&$params, &$ref)
05209:      );
05210:     } else {
05211:      $errorMsg = "ERROR: No method name '" . $parts[1] . "' in class 
" . $parts[0];

7 t3lib_div::callUserFunction("tx_realty_Tca->getDistrictsForCity", array, 
t3lib_TCEforms)

/home/typo3_src-4.5.22/t3lib/class.t3lib_tceforms.php:
04606:   $params['field'] = $field;
04607:
04608:   t3lib_div::callUserFunction($config['itemsProcFunc'], $params, 
$this);
04609:   return $items;
04610:  }

6 t3lib_TCEforms::procItems(NULL, "tx_realty_Tca->getDistrictsForCity", 
array, "tx_realty_objects", array, "district")

/home/typo3_src-4/typo3/class.db_list_extra.inc:
00686:        $row,
00687:        $field
00688:       );
00689:      }
00690:     }

5 localRecordList::renderListRow("tx_realty_objects", array, 1, "title", 
NULL)

/home/typo3_src-4/typo3/class.db_list_extra.inc:
00551:       $cc++;
00552:       $this->translations = FALSE;
00553:       $iOut.= 
$this->renderListRow($table,$row,$cc,$titleCol,$thumbsCol);
00554:
00555:        // If localization view is enabled it means that the selected 
records are either default or All language and here we will not select 
translations which point to the main record:

4 localRecordList::getTable("tx_realty_objects", 38, "")

/home/typo3_src-4/typo3/class.db_list.inc:
00301: #debug($this->pidSelect,$tableName);
00302:      // Finally, render the list:
00303:     $this->HTMLcode.=$this->getTable($tableName, $this->id, 
implode(',',$fields));
00304:    }
00305:   }

3 recordList::generateList()

/home/typo3_src-4.5.22/typo3/sysext/recordlist/mod1/index.php:
00308:
00309:     // Render the list of tables:
00310:    $dblist->generateList();
00311:
00312:     // Write the bottom of the page:

2 SC_db_list::main()

/home/typo3_src-4.5.22/typo3/sysext/recordlist/mod1/index.php:
00512:
00513: $SOBE->clearCache();
00514: $SOBE->main();
00515: $SOBE->printContent();
00516:

1 require("/home/typo3_src-4.5.22/typo3/sysext/recordlist/mod1/index.php")

/home/typo3_src-4.5.22/typo3/mod.php:
00049:  require($temp_path . 'conf.php');
00050:  $BACK_PATH = '';
00051:  require($temp_path . 'index.php');
00052:  $isDispatched = TRUE;
00053: } else {