faq plugin

[doug2168]

installed this plugin and get this error when i try to create a category. have uninstalled and re-installed the plugin and have checked all paths to make sure everything is correct. all other plugins have installed without any problems. have searched this forum to find the answer to this and have come up empty.

Code: Select all

ERROR: 
INSERT INTO serendipity_faq_categorys (id,parent_id,language,category,introduction,catorder) values ('', '0', 'en', 'test', 'test', '1')
/ Out of range value adjusted for column 'id' at row 1

[garvinhicking]

Hi!

Which database version and type are you using? This does not look like a MySQL error?!

Best regards,
Garvin

[garvinhicking]

Hi!

I believe this is a postgre-error, so maybe this patch helps:

http://php-blog.cvs.sourceforge.net/php ... 11&r2=1.12

HTH,
Garvin

[doug2168]

it is a mysql error.

[doug2168]

ok, i'm out of work and looking so i had the time today to mess with this and i'm also an MCP so i guess that helps some.

i went to the mysql website and a few other places to see if i couldn't find the answer to this problem. thanks to garvin for pointing me into the right direction. i came to find out that when mysql was installed on my windows 2003 server, the my.ini file had a line in it that looked like this:

Code: Select all

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

and it should've looked like this:

Code: Select all

sql-mode="NO_UNSIGNED_SUBTRACTION,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

this got the faq plugin working just fine now and this is "not" a bug in mysql or anything like that. i had seen some argumentative stuff on mysql's site about it and don't quite understand it but the people from mysql say it's not a bug. it just has something to do with the way mysql is being used??? i have no idea...all i know is i found a fix, it works, i posted it. hope it helps someone else in the future.

[garvinhicking]

Hi Doug!

Wow, great you spent time on this to figure it out Sadly I have always only worked with the MySQL default settings, and don't even know what the sql-mode mode setting does.

Best regards,
Garvin