v4.2.0d Module Problem (Please Help)

[CNSofADREVENUE]

» Operating system type and version (Linux Unknown Distribution)
» Sugar Suite version (4.2.0d)
» Webserver type and version (Apache 1.3.36)
» PHP version (4.4.2)
» MySQL server version (4.0.27-standard)


Greetings,

I am creating a module for sugar using v1.11 of Module Builder.

The module worked for a while till a random time while I was editting EditView.html, DetailView.html, ListView.html

Now in list view it is giving me the error saying it is ORDERing the SQL query by a custom field table that doesn't exist...

» Module Name : IO_USA
» Module Table : IO_USA

Error retrieving IO_USA list: Query Failed:SELECT users.user_name assigned_user_name, IO_USA.* , IO_USA_cstm.* FROM IO_USA LEFT JOIN users ON IO_USA.assigned_user_id=users.id LEFT JOIN IO_USA_cstm ON IO_USA.id = IO_USA_cstm.id_c WHERE IO_USA.deleted=0 ORDER BY uk_io_cstm.uk_io_number_c asc LIMIT 0,20::MySQL error 1109: Unknown table 'uk_io_cstm' in order clause

I've removed any thing that lists uk_io from the module folder, and cannot find where this custom field table is listed within sugar.


If you need any info from any file just ask.
Any help with this problem would be greatly appreciated.

[CNSofADREVENUE]

I can post any files relevant to this module if someone would please help me with this problem

[Olavo]

» Operating system type and version (Linux Unknown Distribution)
» Sugar Suite version (4.2.0d)
» Webserver type and version (Apache 1.3.36)
» PHP version (4.4.2)
» MySQL server version (4.0.27-standard)
...
I am creating a module for sugar using v1.11 of Module Builder.
The module worked for a while till a random time while I was editting EditView.html, DetailView.html, ListView.html

CNS,
What do you mean with editing? Are you changing the created module?
In this case I dont know exacltly what will happens as you add/delete new custom fields.
The best way is do every change on the template and build it again.

Regards,
Olavo