CoreBOSBB

CoreBOSBB > Open > Open Discussions > add custom field in FAQ module
Full Version: add custom field in FAQ module
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

gongsl

07-10-2014, 08:20 AM
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

07-10-2014, 08:44 AM
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

07-10-2014, 10:50 PM
Done <!-- sBig Grin --><img src="{SMILIES_PATH}/icon_e_biggrin.gif" alt="Big Grin" title="Very Happy" /><!-- sBig Grin -->

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

gongsl

07-22-2014, 07:24 AM
It works.Thank you so much.

gongsl

07-24-2014, 04:00 AM
joebordes Wrote:Done <!-- sBig Grin --><img src="{SMILIES_PATH}/icon_e_biggrin.gif" alt="Big Grin" title="Very Happy" /><!-- sBig Grin -->

<!-- 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

07-24-2014, 10:17 PM
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

07-25-2014, 02:25 AM
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

07-25-2014, 04:18 AM
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

07-25-2014, 06:54 AM
Finally you are right. it's My fault that I forget creating the table. Now it works. Thank you so much.

joebordes

07-25-2014, 09:40 AM
<!-- sSmile --><img src="{SMILIES_PATH}/icon_e_smile.gif" alt="Smile" title="Smile" /><!-- sSmile -->

Have a nice weekend
CoreBOSBB > Open > Open Discussions > add custom field in FAQ module