Thread Details
  • State Verified Answer
  • Replies 6 replies
  • Subscribers 355 subscribers
  • Views 1243 views
  • Users 0 members are here
Forum Actions
Related

Listview display error

Bryan Hunt

Hello,

I recently imported a module my instance to a customer's sandbox instance using the Module Loader.

After import, I used module builder to make various changes to it.

I saved my work and deployed the module.  I see the module in studio and everything looks fine.

Finally I made the module visible in the Display Modules and Subpanels applet.

But, when I click on the tab to see my empty listview, I get this error instead:

HTTP: 500 Internal Server Error

An exception occurred while executing 'SELECT ccnwo_project_reports.id, ccnwo_project_reports.date_modified ccnwo_project_reports__date_modified FROM ccnwo_project_reports WHERE ccnwo_project_reports.deleted = ? ORDER BY ccnwo_project_reports.date_modified DESC, ccnwo_project_reports.id DESC LIMIT 21' with params [0]: Table 'db_somesite.ccnwo_project_reports' doesn't exist

Can anyone help me to understand why it would say that the table doesn't exist?  Is this some sort of rights issue?

The instance version is 10.0.4.

Thanks.

Bryan Hunt

Parents
  • +1

    Make sure you run "Quick Repair and Rebuild" from Admin -> Repair. Hopefully you will see a sql query to be executed in order to create such a table.

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    Andre,

    Wow, I think you've got it.  I ran the repair and it did see that the table was missing and it did generate some creation SQL.  Before I go further, let me ask a question:

    When I import a module like that, is the table not automatically generated in the database?  Is it just metadata that is imported that describes the table/fields and the table must be created separately?  Or was their some sort of error during import?

    In any case, unfortunately the sql execution failed with a Database failure. Please refer to sugarcrm.log for details message.  I don't see any entries in the log about the failure.  What should I try next?

    Thanks much for the assist.

    Bryan Hunt

Reply
  • 0 in reply to André Lopes

    Andre,

    Wow, I think you've got it.  I ran the repair and it did see that the table was missing and it did generate some creation SQL.  Before I go further, let me ask a question:

    When I import a module like that, is the table not automatically generated in the database?  Is it just metadata that is imported that describes the table/fields and the table must be created separately?  Or was their some sort of error during import?

    In any case, unfortunately the sql execution failed with a Database failure. Please refer to sugarcrm.log for details message.  I don't see any entries in the log about the failure.  What should I try next?

    Thanks much for the assist.

    Bryan Hunt

Children