prior to upgrade from 2.0.16, SmartFAQ worked fine, after upgrade and updates, I cannot add a category to SmartFAQ and instead get the following error - and there seems to be nothing in the help/support forums on this site or on the SmartFactory website:

INSERT INTO smartfaq_categories (categoryid, parentid, name, description, total, weight, created) VALUES (NULL, 0, 'Uncategorized', 'Questions and FAQs that are uncategorized - as the number of questions grows, we will create categories as appropriate', 1, 1, 1247108461)
Error number: 1048
Error message: Column 'categoryid' cannot be null

server config is as follows:
XOOPS Version - XOOPS 2.3.3
PHP Version - 5.2.5
MySQL Version - 5.0.51a
Server API Version - apache2handler
OS Version - FreeBSD

safe_mode - Off
register_globals - Off
magic_quotes_gpc - Off
allow_url_fopen - On
fsockopen - On
allow_call_time_pass_reference - Off
post_max_size - 12M
max_input_time - 60
output_buffering - 4096
max_execution_time - 30
memory_limit - 24M
file_uploads - On
upload_max_filesize - 4M

Loaded PHP extensions «

* session
* Reflection
* date
* libxml
* apache2handler
* pcre
* standard
* ctype
* gd
* mcrypt
* mhash
* mysql
* openssl
* xml
* Zend Optimizer

Did you upgrade only XOOPS or did you change also other things?
You did add categories before?

Smartfaq reports that they updated the latest smartfaq to even out some problemes with php5.

Which version of smartfaq is yours ?

The version is the SmartFAQ 1.08 Final - I downloaded this from their website directly and did a complete uninstall/reinstall (and also cleared all the caches)

There were no categories before.

yes I see. In the MySQL file I see there are written

# Table structure for table `smartfaq_categories`
.....
`categoryid` int(11) NOT NULL auto_increment,
.....

So aparently this setting is set not to accept NULL at all, but give automatic id.

I dont know why your script tries to give null to id but I'll try to find out

Maybe you can change the query to orAnyway, you need to find out where the query is done in the source and adapt it there.
Other possibility might be to drop the 'not null' clause in the sql file (at reinstall of the module) or change the attribute of the field with phpMyAdmin.

The problem persist, but, as it has bugged me for a while, I have at least figured out how to fix it - problem may not be with the module, but somewhere else, since the

SQL file indicates, as noted by a reply above:
NOT NULL auto_increment,


but when I install the module, what gets written into the database is
NOT NULL default '0',

The solution, at least for me (and which I'm posting as it might help others), is that I download the database, manually edit the line to correct it, then restore the corrected database - it seems to work fine and the database seems to remain correct thereafter.

Not sure why this happens, that's the next problem to figure out - could be my server/php, could be some other module, but at least it seems to be fixable on a case by case basis.

Does anyone know how I can create tables in SmartFAQ?

The inability to create tables seems to be a problem in all Smartfactory stuff. You can't do it in SmartSection either