add custom field in FAQ module

[gongsl]

Other module such as product, organization,and contacts are all allowed to add custom field, so how can I add the similar function in the FAQ module? Is it easy to realize this function? thank you.

[joebordes]

Noted:

<!-- m --><a class="postlink" href="http://corebos.org/development/view.php?id=207">http://corebos.org/development/view.php?id=207</a><!-- m -->

we will attend as soon as possible.

[joebordes]

Done <!-- s --><img src="{SMILIES_PATH}/icon_e_biggrin.gif" alt="" title="Very Happy" /><!-- s -->

<!-- m --><a class="postlink" href="http://corebos.org/development/view.php?id=207">http://corebos.org/development/view.php?id=207</a><!-- m -->

[gongsl]

It works.Thank you so much.

[gongsl]

joebordes Wrote:Done <!-- s --><img src="{SMILIES_PATH}/icon_e_biggrin.gif" alt="" title="Very Happy" /><!-- s -->

<!-- m --><a class="postlink" href="http://corebos.org/development/view.php?id=207">http://corebos.org/development/view.php?id=207</a><!-- m -->

I find some problem about this today after I change the code, When I click the some Question in FAQ module, I cannot see the question information in detail. The page goes blank. Besides, I cannot delete the faq now. Wish somebody can help me, thank you.

[joebordes]

Hi

I just tried this again to make sure and it is working correctly for me.

If you have a running system you have to:
- make changes to modules/Faq/Faq.php, please be VERY careful the slightest letter change can break the code which I think is what happened
- make sure you have the vtiger_faqcf table in the database

there is not much more to it.

Let us know how it goes.

[gongsl]

Hi

In order to find the problem, I directly copy and paste build/changeSets/cffaq.php,modules/Faq/Faq.php,and schema/DatabaseSchema.xml to my vtiger 5.4. The problem still exists. The problem is listed as follow in details:
In the FAQ module,when I click the red button 'Delete', vtiger retrieve 'undefined'(popout window). If I choose the Question column to check the information in detail. It shows nothing after I click. The two buttons in action column also have the same problem.

By the way, the function about adding custom field works correctly. After I undo all the changes above, the problem doesn't happen any more. But I cannot add custom field in FAQ module.

Thank you.

[joebordes]

Have you created the database table?

Code:

CREATE TABLE IF NOT EXISTS vtiger_faqcf (
                        faqid int(19),
                        PRIMARY KEY (faqid),
                        CONSTRAINT fk_1_vtiger_faqcf FOREIGN KEY (faqid) REFERENCES vtiger_faq(id) ON DELETE CASCADE
                        ) ENGINE=InnoDB DEFAULT CHARSET=utf8

[gongsl]

Finally you are right. it's My fault that I forget creating the table. Now it works. Thank you so much.

[joebordes]

<!-- s --><img src="{SMILIES_PATH}/icon_e_smile.gif" alt="" title="Smile" /><!-- s -->

Have a nice weekend