skyrun
Active Member
is server time something you still do with professional subscriptions?
i have a very weird situation that i'm sure is something that's just in my environment (some stray join in the db or something like that). where i can only select (autocomplete) as the filter type for a database join on one of my lists.
https://testlocation.skyrun.com/skytrax-reservations/search if you still have a logon for my test server laying around. when element Property_ID is set to 'filter type = dropdown' for example, it does this. when set to filter type = autocomplete, it works fine. (but i prefer the dropdown unfortunately... and my users are gripeing about it too)
when i select anything other than 'autocomplete' for the filter, i get a 500 and this error:
filter query error: Property_ID Unknown column 'Property_Property_Reservations.Property_ID' in 'field list' SQL=SELECT DISTINCT(`#__cddir_jomholiday`.`title`) AS `text`, `Property_Property_Reservations`.`Property_ID` AS `value` FROM `Property_Reservations` INNER JOIN `#__cddir_jomholiday` AS `#__cddir_jomholiday` ON `#__cddir_jomholiday`.`old_id` = `Property_Reservations`.`Property_ID` WHERE `Property_Property_Reservations`.`Property_ID` IN ('1289','1314','1342','1299','1300','1298','1301','1303','1304','1302','1306','1305','1307','1308','1309','1310','1312','1311','1320','1315','1316','1313','1319','1321','1318','1322','1325','1323','1326','1328','1329','1334','1331','1332','1330','1333','1335','1336','1337','1338','1340','1341','1343','1344','1345','1348','1350','1351','1352','1349','1353','1347','1357','1358','1346','1359','1360','1356') ORDER BY `#__cddir_jomholiday`.`title` ASC LIMIT 0, 100
the name of the table joined to is Property_Reservations... no idea where the extra 'Property_....' on the front is coming from...
i have a very weird situation that i'm sure is something that's just in my environment (some stray join in the db or something like that). where i can only select (autocomplete) as the filter type for a database join on one of my lists.
https://testlocation.skyrun.com/skytrax-reservations/search if you still have a logon for my test server laying around. when element Property_ID is set to 'filter type = dropdown' for example, it does this. when set to filter type = autocomplete, it works fine. (but i prefer the dropdown unfortunately... and my users are gripeing about it too)
when i select anything other than 'autocomplete' for the filter, i get a 500 and this error:
filter query error: Property_ID Unknown column 'Property_Property_Reservations.Property_ID' in 'field list' SQL=SELECT DISTINCT(`#__cddir_jomholiday`.`title`) AS `text`, `Property_Property_Reservations`.`Property_ID` AS `value` FROM `Property_Reservations` INNER JOIN `#__cddir_jomholiday` AS `#__cddir_jomholiday` ON `#__cddir_jomholiday`.`old_id` = `Property_Reservations`.`Property_ID` WHERE `Property_Property_Reservations`.`Property_ID` IN ('1289','1314','1342','1299','1300','1298','1301','1303','1304','1302','1306','1305','1307','1308','1309','1310','1312','1311','1320','1315','1316','1313','1319','1321','1318','1322','1325','1323','1326','1328','1329','1334','1331','1332','1330','1333','1335','1336','1337','1338','1340','1341','1343','1344','1345','1348','1350','1351','1352','1349','1353','1347','1357','1358','1346','1359','1360','1356') ORDER BY `#__cddir_jomholiday`.`title` ASC LIMIT 0, 100
the name of the table joined to is Property_Reservations... no idea where the extra 'Property_....' on the front is coming from...