1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice
  2. If you update to Joomla 3.9.16, you will have to update Fabrik from the latest GitHub version, to fix a bug introduced in Joomla, which makes it impossible to list front end folder locations in backend JForms. This affects things like template selection.
    Dismiss Notice

Databasejoin - incomplete data

Discussion in 'Community' started by urbido, Mar 13, 2020.

  1. urbido

    urbido New Member

    Level: Community
    Hello, I have databasejoin on areas in my site. Each area contains number of parcels (databasejoin). I save elements to DB with ajax, everything is fine until certain number (54) of elements. I tried to print_r $data in my custom element plugin, which showed this:

    [ubd_areas___parcel] => Array
    (
    [0] => 219/1
    [1] => 348
    .
    .
    .
    [68] => 1145/8
    [69] => 745/2
    [70] => 745/1
    [71] => 754
    [72] => 346/1
    [73] => 346/2//..*..
    )
    [ubd_areas___parcel_raw] => Array
    (
    [0] => 1303118607
    [1] => 1303242607
    [2] => 1303399607
    .
    .
    .
    [51] => 1304627607
    [52] => 1304628607
    [53] => 1304629607//..*..
    )

    First element renders only 74 elements, second is only 54, but total number is like 80+. What could be the problem? There is exactly "//..*.." in print_r($data);die(); result.
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    Do you have "Big selects" enabled in Fabrik Options?
    Check also your php settings, maybe you are hitting some max xy (input vars, post max size...)
    Is it ok in the database?
     
  3. urbido

    urbido New Member

    Level: Community
    Thanks for the answer, big selects worked for detail. But now saving them is problem, I always get nginx time out, but I only save like 100 repeat records in that big select, which is not that much, or is it? Any way to debug this? Thank you for ideas.
     
  4. troester

    troester Well-Known Member Staff Member

    Level: Community
    Did you try to increase php limits like max_execution_time, memory_limit etc?
    Do you have set Joomla's error reporting to max?
     
  5. urbido

    urbido New Member

    Level: Community
    I increased execution time, it worked, but it is saving for almost 2 minutes. It's just one multiselect with +-100 records, it cannot take that long...
     

Share This Page