Results 1 to 3 of 3

Thread: missing <module>_cstm table after module installation

  1. #1
    rogerSerieA is offline Junior Member
    Join Date
    Sep 2007
    Posts
    2

    Default missing <module>_cstm table after module installation

    Hello,

    i've got a problem by using a new module created by myself with the modulebuilder.

    Retrieving record by id canidates:5d4cd369-bed1-0e75-b571-46f8f16c840e found Query Failed:SELECT canidates.* , canidates_cstm.* FROM canidates LEFT JOIN canidates_cstm ON canidates.id = canidates_cstm.id_c WHERE canidates.id = '5d4cd369-bed1-0e75-b571-46f8f16c840e' AND canidates.deleted=0 LIMIT 0,1::MySQL error 1146:

    I found out that sugar is missing the _cstm table for this module, cause i created some custom fields with the modulebuilder. How can I make sure that the required table will be fully automatic generated using the module loader.
    Are there any modifications i've to do in the <module>.php file?

    I'm new in sugar and using the version 5.0

    Thx alot

  2. #2
    Superman's Avatar
    Superman is offline Sugar Community Member
    Join Date
    Oct 2005
    Location
    Kazakhstan
    Posts
    852

    Default Re: missing <module>_cstm table after module installation

    I've never used ModuleBuilder, but if it generates module package, then there should be manifest file which describes all custom fields. Can you show it?
    Farkhad Rakhimzhanov
    E-mail: farkhad@gmail.com
    Skype: rakikama

    SuperTimesheet and Invoicing — timesheet tool with invoicing for SugarCRM.
    Book time against Cases, Project Tasks and Projects.
    Create invoice regarding booked time, print it in PDF or HTML,
    customize template as you like.

  3. #3
    kbrill's Avatar
    kbrill is offline SugarCRM PS Engineer
    Join Date
    Jul 2004
    Location
    St Louis, MO
    Posts
    3,183

    Default Re: missing <module>_cstm table after module installation

    So you created the module and then deployed it and it immediately gave you this error? It may just be a bug in beta 1 of the module builder. I would just wait for the beta 2 at least of the module builder before I went and did a lot of custom coding.
    Kenneth Brill - Help Forum Moderator

    I do not respond to 'Private Messages'. Please email me directly instead

    When asking for help, PLEASE give us your Server Information and Version Numbers as asked for on the 'Post New Message' screen as well as any JavaScript errors shown at the bottom of the browser window.
    Help us Help You

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Module Builder 451c errors after installation
    By danhotb in forum Downloads
    Replies: 0
    Last Post: 2007-07-26, 02:49 PM
  2. Replies: 2
    Last Post: 2007-05-23, 03:01 PM
  3. missing column in a module in dashlet
    By sugarcare in forum Developer Help
    Replies: 0
    Last Post: 2006-10-04, 10:27 AM
  4. Installation fails with Mysql 5.0
    By tmoeller in forum General Discussion
    Replies: 5
    Last Post: 2005-06-22, 10:56 AM
  5. 3.0c MySQL Error creating table: bugs
    By lirakis in forum Help
    Replies: 6
    Last Post: 2005-05-20, 12:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •