I recently installed XOOPS onto my system. I have been having difficulties getting the modules to work correctly. I suspect that I have something set up incorrectly.

Module Name/Version: XOOPS 2.0.15
PHP Version: PHP 5
MySQL Version: MySQL 5.0
Web Server Software (Apache/IIS/Other): Apache 2.2
Operating System: Windows XP
Theme you are using: 7dana-clean
Custom template: No
A full description of the issue:


When I work with the SmartFAQ module, I recieve an error when attempting to make a new category. The error message is:
An error occured while saving the category. Here is a list of errors...

The debugger gives me this message

SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = 'sa8omr377cm6rk8vfsj1tshhb0'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'smartfaq'
SELECT * FROM xoops_config WHERE (conf_modid = '3') ORDER BY conf_order ASC
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '4') ORDER BY conf_order ASC
INSERT INTO xoops_smartfaq_categories (categoryid, parentid, name, description, total, weight, created) VALUES ('', 0, 'travel', '', 1, 1, 1163065061)
Error number: 1366
Error message: Incorrect integer value: '' for column 'categoryid' at row 1

---------------------------

When I try to work with the Forum module, all I get is a blank page. I don't get any errors

---------------------------

When I open the Content module the (Add Content, Add PageWrap, Edit/Delete Content, Order Site Menu Block, Order Site Menu Block, and Preferences) links appear. However, clicking on add content just reloads the same page. There is no way to enter in new content.

----------------------------

When I try to use the SmartPartners module I also get an error. After inputting the partners info, I get this error message:
An error occured. The partner was not updated.

The debugger gives me this message:

SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = 'sa8omr377cm6rk8vfsj1tshhb0'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'smartpartner'
SELECT * FROM xoops_config WHERE (conf_modid = '6') ORDER BY conf_order ASC
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '4') ORDER BY conf_order ASC
INSERT INTO xoops_smartpartner_partner (id, weight, hits, hits_page, url, image, image_url, title, summary, description, contact_name, contact_email, contact_phone, adress, `status`) VALUES ('', 0, 0, 0, '', '-1', '', 'U', 'adfaksdj', 'dskjfals', '', '', '', '', 2)
Error number: 1264
Error message: Out of range value adjusted for column 'id' at row 1
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_redirect.html') ORDER BY tpl_refid
Total: 8 queries

-------------------------

All of the other modules that I have used seem to be working correctly.


I'm sorry, I'm kinda new to this and I'm afraid I'm in a little over my head. Any help would be appreciated!

Did you replace the file /class/xoopsform/form.php with this one?

Check the forums for SmartFAQ and SmartPartner at SmartFactory for more information.

I already replaced the form.php file. It did not help.

I fix SmartFAQ. Thank you CCeye (www.cceye.com) at SmartFactory.com

change line 287 of smartfaq\class\category.php


from
$sql = sprintf("INSERT INTO %s (categoryid, parentid, name, description, total, weight, created) VALUES ("", %u, %s, %s, %u, %u, %u)", $this->db->prefix('smartfaq_categories'), $parentid, $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, time());

to

$sql = sprintf("INSERT INTO %s (categoryid, parentid, name, description, total, weight, created) VALUES (0, %u, %s, %s, %u, %u, %u)", $this->db->prefix('smartfaq_categories'), $parentid, $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, time());

Did you install frameworks and editors?