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.