Unable to save Faq Questions? Read this!

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

If you find that you are unable to save FAQ Q and A's, do this:

Check the next auto increment value. If it says 127, you will not be able to save any more entries. This is because the default nuke sql creates the field 'id' as a SIGNED tinyint, which means the values range from -128 to +127. The quick fix is to change it to UNSIGNED, using phpMyAdmin. This will give you a max value of 255. This is short sightedness on the part of the author, in a way. It assumes your FAQ's won't grow very big! Changing it to a smallint, unsigned will remedy it forever, unless you plan to have more than 65535 entries Smile

.

Nuke Soldier Joined: Nov 09, 2003 Posts: 16

Thats not exactly accurate.
If you are on a 32 bit Intel based processor thats correct, but some people aren't, for instance if you are on the new AMD 64 bit processor (running in full 64 bit mode) that number doubles, same thing with Itanium too I think. Also I think that SMNP (multi threaded multi processor systems) will give a different value.

If heaven forbid you are on a 16 bit processor (unlikely but I did see one not too long ago) that number is cut in half.

But the fix is absolutely right on, you can change that value from tiny int to int and get a MUCH bigger address space with which to work. Mr. Green

Nuke Cadet Joined: Nov 02, 2003 Posts: 4

Hello,

Ok i have this error which stops us from posting to the FAQ as admins.

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/renteam/public_html/includes/sql_layer.php on line 286

Now i went into the php admin and saw aht it was a tinyint with a 3 tinyint(3).

Ok i am editing cuz i found the signed part. Ok i did that but i am still getting the error from above.
This is on the 7.0 PHP_nuke with no faq's at all
Thank you for taking the time to help

Nuke Cadet Joined: Dec 05, 2003 Posts: 8

same problem here, doc

Nuke Cadet Joined: Nov 02, 2003 Posts: 4

Can some one help me please?

Nuke Cadet Joined: Dec 04, 2003 Posts: 5

EASY fix... in the table structure make sure faq_Answers and faq_Categories are both capitalized... by default they ARE NOT!

Nuke Cadet Joined: Nov 02, 2003 Posts: 4

Thank you very much it worked

Nuke Cadet Joined: Dec 15, 2003 Posts: 1

Worked like a champ. Thanks for the help.

Nuke Cadet Joined: May 21, 2003 Posts: 5

This may sound like a dumb question, but I just solved the same issue using this fix that says to uncapitalize all instances of _faqCategories & _faqAnswer in a few files.

So what is the *best* way to do it? Modify the files or the database?

Private Joined: Jan 17, 2004 Posts: 47

This is far more work to do.......

just apply these lines on your DB

Code:
ALTER TABLE `nuke_faqanswer` RENAME `nuke_faqAnswer`

and
Code:
ALTER TABLE `nuke_faqcategories` RENAME `nuke_faqCategories`

Nuke Cadet Joined: May 28, 2003 Posts: 7

Thank you Ewout! Worked great.

Nuke Soldier Joined: Jan 21, 2004 Posts: 18

I've altered both tables, but I still get the same error as stated above...

Using Php Nuke 7.0

Lieutenant Joined: Aug 23, 2003 Posts: 195

Ok so you edited the MYSQL Table to faAnswer and FaqCategories go into the admin>modules> folder and find AdminFaq.php check to make sure they are the same there as well as the module>faq it self this should do the trick

XtraX

Nuke Soldier Joined: Jan 21, 2004 Posts: 18

Yep, still get this error :

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/divinusf/public_html/phpmain/includes/sql_layer.php on line 286

I edited every notion of Faq_Categories and Faq_answers in the adminfaq.php and the index.php in the modules>faq directory.

Any thing that I missed?

Nuke Soldier Joined: Jan 21, 2004 Posts: 18

Ok, I got it fixed...

For some reason in the faq_categories table there was a...

' <--- can barely see it, but it was at the end of categories, once I took it out everything worked fine.