1. Fabrik 3.8 has been released. As usual, we strongly recommend that you backup your site (using Akeeba) before upgrading. Report any issues in the forums, we will answer promptly.

Export CSV not working -

Discussion in 'Standard Support' started by lownotes, Feb 22, 2012.

  1. lownotes

    lownotes Member

    Level: Community
    I'm using J.1.5.25 + Fabrik 2.1

    Trying to Export CSV from the backend table view.

    Popup modal window with options, then push "Export".

    Next window appears to stall and says...

    Export CSV

    0 / undefined.
    Saving to

    If I run firebug on the backend I see this.

    missing ) in parenthetical
    (getData:You have an error in your SQL syntax; check the manual that corresponds...

    If I try to export from the front end I get stuck at the same place.
  2. rob

    rob Administrator Staff Member

    Level: Community
    whats the full error? it seems like the export is trying to grab the data and its query is failing.
    Does the table itself render correctly?
    Does export work on other tables?

  3. lownotes

    lownotes Member

    Level: Community
    strange, now I get a different error from firebug:
    "NetworkError: 500 Internal Server Error - http://cah.weber.edu/administrator/index.php?option=com_fabrik&c=table&view=table&format=csv&tableid=2&task=viewTable&start=0"

    yes, the table renders correctly.
    no, there are no other tables, except for the sample events table. That does not render correclty though.

    Here is the full errror:
    getData: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 ' `jos_fabrik_tshirt`.`id` AS `__pk_val` FROM `jos_fabrik_tshirt` LIMIT 0, 100' at line 1 SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT , `jos_fabrik_tshirt`.`id` AS `__pk_val` FROM `jos_fabrik_tshirt` LIMIT 0, 100

    thanks Rob

    fyi, the table was small so I just copy and pasted from the admin side, so my task it actually done. But would like to know what is going on.
  4. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    What options did you select from the popup?

    From the error, it looks like you didn't select any fields to export.

    -- hugh
  5. lownotes

    lownotes Member

    Level: Community
    everything is default to yes. I tried a couple of variations to see if that would work but as far as I can tell, all options are set to yes as default.
  6. rob

    rob Administrator Staff Member

    Level: Community
    Can you check you have the Joomla 'System - mootools upgrade' plugin enabled.
    I think that is the issue

  7. ejw

    ejw Member

    Level: Community

    I did not start the threat but had the same issue with the same message and indeed, activating the mootools upgrade plugin corrected it

    thx Rob!

Share This Page