Database not updated when updating

jonbach

After migrating from version 2.1.2.8 to 3.1.0.1, I can no longer view reports of past campaigns. Since the code is in PHP, I conveniently can troubleshoot this myself. I have found it is because this line is returning no result: $limit = get_app_data('campaign_report_rows');

In digging into the code, that code is looking for a campaign_report_rows column in the apps table. That column doesn't exist. Was it supposed to be added in the move to 3.1.0.1 ? It seems as if there is a database migration step that didn't happen.

Ben

Hi,

Yes there should be a campaign_report_rows column in the apps table.

Your MySQL database user probably does not have ALTER privilege granted to the user. Please ensure you've granted full privileges to the MySQL database user for your MySQL database. Then Sendy can create columns etc without any problems.

Best regards,
Ben