Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

  • Ben August 19
Database not updated when updating
  • Vote Up0Vote Down jonbachjonbach
    Posts: 1Sendy user

    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.

  • 1 Comment
  • Vote Up0Vote Down BenBen
    Posts: 3,289Sendy support

    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

This discussion has been closed.
All Discussions