FAQ categories not displaying - admin or module

Joined: Jan 31, 2004 Posts: -88

Open /admin/modules/adminfaq.php
and /modules/FAQ/index.php

change all instances of _faqCategories to _faqcategories , and all instances of _faqAnswer to _faqanswer in the SQL statements (they're case sensitive)

AI

Sergeant Joined: Dec 10, 2003 Posts: 92

ahhh thank you!!! i was looking for this everywhere... if anyone is having the same problem i can assure this will fix it!

Posted: Sun Jan 11, 2004 11:07 am

Thanx alot guys, this was wat i was looking for. Works great now Smile

Posted: Sun Jan 11, 2004 6:02 pm

Be aware that somehow the Nuke7 sql is wrong.
I've checked all my nuke sql's and they all use faqAnswer.

To get rid of problem is just dropped faqanswer and faqcategories tables and created the case sensitive ones

Nuke Soldier Joined: Dec 11, 2003 Posts: 15

djmaze wrote:

Be aware that somehow the Nuke7 sql is wrong.
I've checked all my nuke sql's and they all use faqAnswer.

To get rid of problem is just dropped faqanswer and faqcategories tables and created the case sensitive ones

Please... how is this done in PhpMyAdmin?
Can you make a little step by step for newbies?

Posted: Wed Jan 14, 2004 3:03 pm

Code:

DROP TABLE IF EXISTS faqanswer;
DROP TABLE IF EXISTS faqcategories;

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;

CREATE TABLE nuke_faqCategories (
id_cat tinyint(3) NOT NULL auto_increment,
categories varchar(255) default NULL,
flanguage varchar(30) NOT NULL default '',
PRIMARY KEY (id_cat),
KEY id_cat (id_cat)
) TYPE=MyISAM;

Nuke Soldier Joined: Dec 11, 2003 Posts: 15

I got help from Raven. Check this out:

Raven wrote:

...just run this query in the SQL window

Code:

ALTER TABLE `nuke_faqanswer` RENAME `nuke_faqAnswer`

and

Code:

ALTER TABLE `nuke_faqcategories` RENAME `nuke_faqCategories`

It worked great!

Corporal Joined: Apr 29, 2003 Posts: 58 Location: USA

Agent001Fox wrote:

I got help from Raven. Check this out:

Raven wrote:

...just run this query in the SQL window

Code:

ALTER TABLE `nuke_faqanswer` RENAME `nuke_faqAnswer`

and

Code:

ALTER TABLE `nuke_categories` RENAME `nuke_faqCategories`

It worked great!

This did work for me too, however, I must point out your SQL query is a little off... you forgot the 'faq' before nuke_catagories on the second query. It should be this:

Quote:

ALTER TABLE `nuke_faqanswer` RENAME `nuke_faqAnswer`

And then:

Quote:

ALTER TABLE `nuke_faqcategories` RENAME `nuke_faqCategories'

Nuke Soldier Joined: Dec 11, 2003 Posts: 15

Sorry... changed it now... Very Happy

Sergeant Joined: Feb 04, 2004 Posts: 100

Yikes, I did something in phpMyAdmin. I had is all going and then did something twice and now I'm getting this:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/phpMyAdmin/lib.inc.php on line 507

Please help.

Sergeant Joined: Feb 04, 2004 Posts: 100

SQL-query:

SELECT * FROM nuke_faqCategories'

MySQL said: You have an error in your SQL syntax near ''' at line 1

Sergeant Joined: Feb 04, 2004 Posts: 100

I believe I (hopefully) found what happened but am still unsure how to fix this. There was a ' in: ALTER TABLE `nuke_faqcategories` RENAME `nuke_faqCategories'

shouldn't it be with a `

ALTER TABLE `nuke_faqcategories` RENAME `nuke_faqCategories`

I don't know how to fix this. If anyone could help me I would really appreciate it!

Sergeant Joined: Dec 10, 2003 Posts: 92

i honestly cant see the difference between the 2.... i am going to an optomistrist now.. lol

Sergeant Joined: Feb 04, 2004 Posts: 100

Hi, got some help... all works well now. Nuke... what a great program! Thanks for doing you hard work.

Cheers!

Corporal Joined: Jan 27, 2004 Posts: 54

Hello,

I did this and still get nothing on the admin screen just a plain white screen.

Checked mysql and index and adminfaq all use lower case letter

what to do now