| Author |
 Topic  |
|
CodeMan7
New Member
USA
88 Posts |
 Posted - 05 June 2007 : 09:26:48
|
There is a default "faq.asp" file with this mod, but there is nothing to show the changes in the file. This file is for v3.4.04.
I'm using Snitz v3.4.06. MySql database. The only mod I've added to my faq.asp file has been for the SmileManager mod.
My question is: Should I just use the default faq.asp which came with FAQ Admin mod, or try to make the changes to my faq.asp?
Thanks.
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 June 2007 : 10:51:53
|
| The FAQ Admin Mod is essentially a complete re-write of the faq.asp page. You are probably going to want to add the SmileManager changes to the faq.asp that came with the FAQ Admin Mod. |
 |
|
|
CodeMan7
New Member
USA
88 Posts |
Posted - 05 June 2007 : 11:11:00
|
| Thanks! |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 June 2007 : 12:23:36
|
Your welcome.  Let us know if you run into any problems. |
|
|
|
CodeMan7
New Member
USA
88 Posts |
Posted - 05 June 2007 : 13:55:42
|
Ok. I ran into a couple of errors.
When I went into FAQ Administration (Admin Options), I clicked on "Set the order of F.A.Q.s".
I got this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.26-nt]Unknown column 'F.FAQ_ID' in 'field list'
/forums/admin_faq_order.asp, line 144
When I set up this mod I clicked on the "Mod: FAQ Administration v1.1" first and then "Mod: FAQ Administration v1.1 - Add Default FAQs".
So the field "F.FAQ_ID" should have been added to the database.
Any idea why I am getting this?
I'm also getting a second bug, but it doesn't result in an error. |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 June 2007 : 14:06:45
|
Did you run the DBS script that came with it before you did any changes? (well, after backing up your DB and files  ) |
|
|
|
CodeMan7
New Member
USA
88 Posts |
Posted - 05 June 2007 : 14:07:58
|
Yes, I did that.
|
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 June 2007 : 15:14:53
|
And it ran without any errors?
Post a link to a .txt version of your admin_faq_order.asp page and I'll take a look. |
|
|
|
CodeMan7
New Member
USA
88 Posts |
Posted - 06 June 2007 : 07:31:25
|
Thanks, Anon.
Here's the link: www.mvco.us/admin_faq_order.txt
I tried several more things but still no go.
Edit: Fixed link |
Edited by - Podge on 06 June 2007 07:44:30 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 June 2007 : 08:56:31
|
| Try uncommenting line 143 (and removing the "###" as well), and commenting line 144. See if that works. |
|
|
|
CodeMan7
New Member
USA
88 Posts |
Posted - 06 June 2007 : 09:34:45
|
Anon, I am the one who commented out line 143 and made changes, and copied it to line 144.
It was producing the error with line 143 in there. (Line 143 is the original line.)
So if I make those changes, it will just take me back to where I was originally with the same error.
Any other thoughts? |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 June 2007 : 09:49:04
|
Have you gone into whatever MySQL Admin tools you are using and verified that the tables were created with all the columns? I ask because that column should be there (though the error indicates otherwise) and it won't work right the way you changed it as you are counting the wrong field.
Heh. Stupid me missed a typo ... I don't use MySQL so I never ran into it before...
The original:
strsql2 = "SELECT COUNT(F.FAQ_ID) AS PAGECOUNT FROM " & strTablePrefix & "FAQ F WHERE F.FAQ_CATEGORY = " & rs("FCAT_ID")
Should be:
strsql2 = "SELECT COUNT(F.F_ID) AS PAGECOUNT FROM " & strTablePrefix & "FAQ F WHERE F.FAQ_CATEGORY = " & rs("FCAT_ID")
There may be some similar errors in the MySQL-specific bits of the code. Somebody might want to let OWM know too. |
Edited by - AnonJr on 06 June 2007 09:55:28 |
|
|
|
CodeMan7
New Member
USA
88 Posts |
Posted - 06 June 2007 : 10:07:33
|
Thanks Anon. I had to make one small change in your line to get it to work.
Your line was:
strsql2 = "SELECT COUNT(F.F_ID) AS PAGECOUNT FROM " & strTablePrefix & "FAQ F WHERE F.FAQ_CATEGORY = " & rs("FCAT_ID")
I had to change it to:
strsql2 = "SELECT COUNT(F.F_ID) AS PAGECOUNT FROM " & strTablePrefix & "FAQ F WHERE F_FAQ_CATEGORY = " & rs("FCAT_ID")
Now it works!
Thanks for your help! |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 June 2007 : 10:39:46
|
| Glad its all sorted. |
|
|
|
CodeMan7
New Member
USA
88 Posts |
Posted - 06 June 2007 : 14:27:47
|
Well, almost but not quite.
I still can't get the FAQ to go to the Smilie answer when I click on it. No error appears and nothing seems to happen.
I applied the changes Leatherlips had in his post. That took care of moderation and the Smilie question shows.
I've tried tracing the code in faq.asp to see why the answer doesn't display but so far no luck. (This isn't something new. This has been happening since I installed the FAQ Admin mod. Before that, it was working.)
|
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 June 2007 : 16:20:14
|
| Got a link so we can take a look? |
|
|
|
Topic |
|
Topic Locked
