Errors after Update to Joomla 3.3

[uschmi]

I first read this post about not to update to Joomla 3.3 after having already done it.

With latest version from Github I?m able to open form views, but not list views. The following error occurs while opening list views in frontend as well as in backend:

500 Fabrik has generated an incorrect query for the list :

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 'COLLATE utf8_general_ci LIMIT 0, 10' at line 30 SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `vk_personen`.`id` AS `vk_personen___id`,
`vk_personen`.`id` AS `vk_personen___id_raw`,
`vk_personen`.`new_date` AS `vk_personen___new_date`,
`vk_personen`.`new_date` AS `vk_personen___new_date_raw`,
`vk_personen`.`pers_nr` AS `vk_personen___pers_nr`,
`vk_personen`.`pers_nr` AS `vk_personen___pers_nr_raw`,
`vk_personen`.`nachname` AS `vk_personen___nachname`,
`vk_personen`.`nachname` AS `vk_personen___nachname_raw`,
`vk_personen`.`vorname` AS `vk_personen___vorname`,
`vk_personen`.`vorname` AS `vk_personen___vorname_raw`,
`vk_personen`.`geschlecht` AS `vk_personen___geschlecht`,
`vk_personen`.`geschlecht` AS `vk_personen___geschlecht_raw`,
`vk_personen`.`familienstand` AS `vk_personen___familienstand`,
`vk_personen`.`familienstand` AS `vk_personen___familienstand_raw`,
`vk_personen`.`geb_datum` AS `vk_personen___geb_datum`,
`vk_personen`.`geb_datum` AS `vk_personen___geb_datum_raw`,
`vk_personen`.`team` AS `vk_personen___team`,
`vk_personen`.`team` AS `vk_personen___team_raw`,
`vk_personen`.`email` AS `vk_personen___email`,
`vk_personen`.`email` AS `vk_personen___email_raw`,
`vk_personen`.`ersthelfer` AS `vk_personen___ersthelfer`,
`vk_personen`.`ersthelfer` AS `vk_personen___ersthelfer_raw`,
`vk_personen`.`bemerkung_dms` AS `vk_personen___bemerkung_dms`,
`vk_personen`.`bemerkung_dms` AS `vk_personen___bemerkung_dms_raw`,
`vk_personen`.`id` AS slug
, `vk_personen`.`id` AS `__pk_val`

FROM `vk_personen`
LEFT JOIN `jos_users` AS `jos_users` ON `jos_users`.`id` = `vk_personen`.`user_id`
ORDER BY `vk_personen`.`nachname` ASC, `vk_personen`.`vorname` ASC COLLATE utf8_general_ci LIMIT 0, 10​

 

[felixkat]

Can you provide your exact PHP version so we can have it for reference. Thanks.

 

[uschmi]

PHP 5.3.28
mySQL 5.5.35

 

[cheesegrits]

Do you have "Force collation" set in the list's Advanced settings? If so ... what are you trying to achieve?

We seem to be generating incorrect syntax with that option (i'm working on that now) but if you don't need it .... turn that feature off.

-- hugh

 

[uschmi]

sorry for late answer.
It was my fault - "force collation" was the problem - all is fine now.
Thanks!

 

[troester]

You can close solved threads by unchecking "open" in "Thread Tools" (you can alway re-open later).

 

[uschmi]

closed