I'm not sure what's going on (Excuse my ignorance, I am a database newbie) but I am having some issues with adding sorting.
I FINALLY figured out how to import my CSV and add an ID Column.
Below is the code I am using to test with. Everything works fine until I try and sort, once I do that I get a big sad face and Error 1054 (Even with Error Reporting set as Development, I don't get additional information).
Once this happens, I cannot get it working again without deleting that table, reimporting the CSV, re-adding the ID column and deleting the table from JooDB admin.
Very confused as to why this is happening. I would like to have it so they can resort by whatever column they want.
The classes are from Warp7 (UIkit from YooTheme)
Am I missing something here?
<div class="uk-grid">
<div class="uk-width-1-3">
Number {joodb sortlink|COL 1|[sort]}
</div>
<div class="uk-width-1-3">
Vert Jump {joodb sortlink|COL 7|[sort]}
</div>
<div class="uk-width-1-3">
Leg Flex {joodb sortlink|COL 8|[sort]}
</div>
</div>
<!-- LOOP Start -->
{joodb loop}
<div class="uk-grid">
<div class="uk-width-1-3">
{joodb COL 1}
</div>
<div class="uk-width-1-3">
{joodb COL 7}
</div>
<div class="uk-width-1-3">
{joodb COL 8}
</div>
</div>
{joodb loop}
<!-- LOOP End -->
