Hi Everyone! Thanks for visiting the blog post. I am Pranay (21 | Male | India). I am pursuing my Bachelors and Masters in Computer Science from Indian Institute of Technology Kharagpur and have just completed 4 years of undergraduate education. This is my first time at the prestigious Google Summer of Code programme and I am looking forward to a great FOSS-flavored summer.
Jarvis is such a cool name given to an AI-based assistant, isn't it ? I call my project - RepoBuilder. Its a highly responsive, light-weight and user-friendly module extension for generating reports within CiviCRM, aimed towards facilitating customers to customize the report template as they want - a significant and required improvement over the existing reporting module in CiviCRM. RepoBuilder will be equipped with a drag-and-drop (WYSIWYG) interface (for the content blocks) along with added support for data transformation - sorting, pivoting, filtering et cetera. I am fortunate to have Brian and Jaap to mentor me throughout the project.
Once that was done, the next task in hand was installation of CiviCRM on the WP CMS. Upon installing CiviCRM for the first time initially, I forgot to check the option with sample data. So, I decided to revert back to disabling the extension, deleting the civicrm folder within the plugins directory etc. and then finally re-installing CiviCRM, just to find that it still wasn't working. It gave the same error 500: could not handle the request. I requested the mentors if they could help me resolving the issue. Brian asked me to delete all the DB tables using the civicrm_drop.mysql file inside the civicrm/sql directory and to remove the civicrm.settings.php file, which will trigger a reinstall. I dropped all the tables, deleted the file but it still gave the same error 500. After spending hours on googling for finding a work-around I asked the mentors if they can help me one more time. Brian resolved the issue. He mentioned about a php error log file in the wp-admin directory that provided hints behind failures. He told, when CiviCRM installs, it creates a temp table that should be removed at the end of the process. On load, CiviCRM checks for its existence - if present it halts loading as it's an indication it may not have fully installed. He dropped the table and it resolved the issue.