18.3.1. How to add more than 127 FAQ answers

You have 127 Q&A. You cannot add more, if you delete one, you can add one.

Cause: Looking at the sql/nuke.sql script that creates the PHP-Nuke tables on installation, we see the following for the structure of the nuke_faqAnswer table:

# # Table structure for table `nuke_faqAnswer` # CREATE TABLE nuke_faqAnswer ( id tinyint(4) NOT NULL auto_increment, id_cat tinyint(4) NOT NULL default '0', question varchar(255) default ", answer text, PRIMARY KEY  (id), KEY id (id), KEY id_cat (id_cat) ) TYPE=MyISAM;

From the MySQL manual on column types, we see:

TINYINT[(M)] [UNSIGNED] [ZEROFILL]

A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.

so that tinyint is a very small integer indeed in this case.

Solution: Change the length of id and id_cat of nuke_faqAnswer. You can do this with phpMyAdmin, or by logging into MySQL from the console and, after choosing the PHP-Nuke database ("use xxxx;"), by typing:

alter table nuke_faqAnswer modify id SMALLINT unsigned;
alter table nuke_faqAnswer modify id_cat SMALLINT unsigned;

See also FAQ problem.