scheduling 'server time'

[skyrun]

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...

 

[skyrun]

and i should have menitoned that i'm also happy to pay anyone for their time helping me debug it on my server also. i'm pretty sure it's some leftover db anomoly, so i wouldn't expect to be covered under subscription.

 

[cheesegrits]

Yeah, I remember you asking about this a while back.

I'd almost certainly have to take an Akeeba clone of your site, install it locally, set up a PHP Storm project on it, and xdebug it, stepping through the code, to see where that is coming from. That's a time consuming thing to do, so I'd have to charge for it, probably about $100.

If that's OK, let me know, make sure I have a login, and do an Akeeba backup for me.

-- hugh

 

[skyrun]

that's a deal. i'll pay you $200 up front for what is always more trouble than you think it's going to be... paypal to an email?

i can email you the link to the akeeba backup on some dropbox like thing too. it's 3gb.

 

[cheesegrits]

I'll get @mediaateam (Robbie) to invoice you.

OK, mail hugh dot messenger at gmail dot com.

Is there any way you can reduce the size? Does that archive include any other archive ZIPs, or is your site just huge?

-- hugh

 

[skyrun]

reduced the size by removing images (778Mb) and sent you an email with details. sorry already paid you on paypal... you can reject perhaps and they can invoice me. we can throw in the date sorting changes.

 

[cheesegrits]

OK, apply this ...

https://github.com/Fabrik/fabrik/commit/a7e21df1cce42baabd98f52cb9aa84135b45dac3

We weren't being careful enough when doing a replacement on the 'from' table for filters on join elements which are in joined groups. We have to swap the main table name for the join group table name, so in your case that would up doing str_replace of 'Reservations.' to 'Property_Reservations.', on the string 'Property_Reservations.id'. Basically, that line of code shouldn't have changed the table name. But because your main table name matched the trailing part of the joined table name .... it matched, and got replaced, where it shouldn't have.

Fix was to do a preg_replace(), and anchor the pattern to start of line ...

$elName = preg_replace('/^' . $origTable . '/', $fromTable, $elName2);

... instead of ...

$elName = str_replace($origTable . '.', $fromTable . '.', $elName2);

-- hugh

 

[cheesegrits]

Took about two hours, all told, from downloading the first (failed) archive, to committing the fix.

So you guessed about right on the payment.

-- hugh

 

[skyrun]

thanks hugh.

works beautifully.