My Data Admin Module Isn't Working Properly

General
1

Summary of the Gibbon Export Issue

I am encountering an error when trying to export the ‘Timetable - Complete’ report using the Data Admin module on Gibbon version v29.0.00. The system is running on PHP 8.1.10 and MySQL 8.0.31.

The specific error message is:

Warning: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gibboncourse.gibbonCourse.nameShort' in 'field list'

I have confirmed that the gibbonCourse table exists (in my data base the name is gibboncourse if that makes a difference) and contains the nameShort column in my database. The issue appears to be a bug in the code that constructs the SQL query for this specific export, where the table name is being included twice in the column reference, resulting in an invalid gibboncourse.gibbonCourse.nameShort syntax that the database cannot recognize.

This error is unique to the ‘Timetable - Complete’ export, as all other exports are working correctly, suggesting the bug is localized to the definition of this one report.

I have already verified that the error is not in the Connection.php or export_run.php files, as these are generic scripts that only execute the query, not define it. The problem is in the specific file that defines the fields for the Timetable - Complete export, which is likely where the incorrect table reference is being generated.

I have one more installation of gibbon on a separate machine and it is version 28 of gibbon and I am experiencing the same error on that machine too, so this probably isnt a localized issue.

Fix DataAdmin Module
2

Hi @Hadiyah-Saeed

Thank you for your question. As displayed on the Manage Records Page under Data Admin, the full table export feature is still a beta feature. Due to limited resources, fixing this issue is challenging since it would require changes to the import function, which is a higher priority, especially for the complete timetable.

As a workaround, you can export the timetable fields individually using the other export options and then combine them in Excel. I hope this helps. Thank you.

1 Like
3

@Hadiyah-Saeed As you discovered, this error is unique to the Timetable - Complete import. This import happens to be the most complex import in the list, involving multiple tables. While the Data Admin tool attempts to reverse the importer to create export options, this particular import is currently too complex, resulting in the error you saw. The Data Admin tool itself was created long before the Timetable - Complete import even existed, so unfortunately at this time it is not able to handle an export this complex :sweat_smile:

1 Like
4

Thank you so much for the information, it really helps! Is there any way I can help solve this error in the Data Admin module? Again thanks a lot, i really appreciate it. I’m so sorry for not replying earlier, I didn’t actually check my mail until now :grinning_face:

5

I’ve posted a reply and a fix here: Fix DataAdmin Module - #2 by sandra