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 {
_______________________________________________
TYPO3-german mailing list
TYPO3-german@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-german
