Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Greeting Card Mod 3.6 (RC1)
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 6

mdelcour2000
Junior Member

United States
133 Posts

Posted - 01 July 2008 :  23:01:43  Show Profile  Visit mdelcour2000's Homepage  Reply with Quote
thanks Carefree, I will do that. Also, when deleting the images, the thumb seems to not be there.<

http://lacledeforum.com/

"Never get so busy doing the work of the kingdom that you forget who the King is"
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 01 July 2008 :  23:08:47  Show Profile  Reply with Quote
That's a permissions error. In Windows Explorer, browse to the forum directory. Right-click, select properties. Select the Security tab.

Look in the top window of the security tab for "Internet Guest Account" or IUSR-(Computer Name).

If it's not there, you'll have to add it. Click "Add", type in IUSR and click check names. It'll show up. Give it "read" permission only.

After it's there, click the "advanced" button on bottom right.
Check the box "Replace permission entries on all child objects ...".
Click apply. When it's done, your photos will show up.<
Go to Top of Page

texanman
Junior Member

United States
410 Posts

Posted - 01 July 2008 :  23:15:26  Show Profile  Reply with Quote
quote:
Originally posted by Carefree

quote:
Originally posted by mdelcour2000

ok, when I try to delete a card, that I added, I am getting this error:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/default/greeting_cards_remcardcat.asp, line 109

cat = trim(chkStringRequest("catid"),"SQLString"))
-------------------------------------------------^




That one's rather obvious, there are differing quantities of opening and closing parentheses. Eliminate the final closing parenthesis.



Now a new error:

Microsoft VBScript runtime error '800a000d'
Type mismatch: 'chkStringRequest'
/greeting_cards_remcardcat.asp, line 109





<
Go to Top of Page

mdelcour2000
Junior Member

United States
133 Posts

Posted - 01 July 2008 :  23:43:08  Show Profile  Visit mdelcour2000's Homepage  Reply with Quote
yeah I'm getting the same error<

http://lacledeforum.com/

"Never get so busy doing the work of the kingdom that you forget who the King is"
Go to Top of Page

mdelcour2000
Junior Member

United States
133 Posts

Posted - 01 July 2008 :  23:48:54  Show Profile  Visit mdelcour2000's Homepage  Reply with Quote
ok, I am also getting this error when trying to delete dead cards:

Greeting Cards Cleaned
Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near '#'.

/default/greeting_cards_clean.asp, line 92


The line above is:
& "< #" & rev & "#;"<

http://lacledeforum.com/

"Never get so busy doing the work of the kingdom that you forget who the King is"
Go to Top of Page

texanman
Junior Member

United States
410 Posts

Posted - 01 July 2008 :  23:53:32  Show Profile  Reply with Quote
Try ruirib's fix above and see if it works for you. I tried and it didn't fix the problem.<
Go to Top of Page

mdelcour2000
Junior Member

United States
133 Posts

Posted - 01 July 2008 :  23:57:01  Show Profile  Visit mdelcour2000's Homepage  Reply with Quote
Yeah, it only gave me this error when I did that. I had the same error you had before I applied Ruirib's fix
<

http://lacledeforum.com/

"Never get so busy doing the work of the kingdom that you forget who the King is"

Edited by - mdelcour2000 on 01 July 2008 23:58:00
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 02 July 2008 :  00:14:41  Show Profile  Reply with Quote
Ok, in greeting_cards_clean.asp, change the whole block of instruction from lines 90-92:

Search for:

	strSQL = "DELETE * FROM " & strTablePrefix & "GREETING_SENT WHERE SENTDATE" _
	& "< #" & rev & "#;"
	set rs = conn.execute (strsql)	


Change that to say:


	strSQL = "DELETE * FROM " & strTablePrefix & "GREETING_SENT WHERE SENTDATE< #" & rev & "#"
	set rs = conn.execute(strSQL)	
	if rs.EOF or rs.BOF then ' Not Found
		Response.Write	"Deleted"
	end if
	rs.Close
	set rs = Nothing


At the end of that file, search for:


	rs.close

%>


Delete the line saying:

rs.close
<

Edited by - Carefree on 02 July 2008 00:17:38
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 02 July 2008 :  00:21:15  Show Profile  Reply with Quote
quote:
Originally posted by texanman

quote:
Originally posted by Carefree

quote:
Originally posted by mdelcour2000

ok, when I try to delete a card, that I added, I am getting this error:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/default/greeting_cards_remcardcat.asp, line 109

cat = trim(chkStringRequest("catid"),"SQLString"))
-------------------------------------------------^




That one's rather obvious, there are differing quantities of opening and closing parentheses. Eliminate the final closing parenthesis.



Now a new error:

Microsoft VBScript runtime error '800a000d'
Type mismatch: 'chkStringRequest'
/greeting_cards_remcardcat.asp, line 109









Sorry, I was blinded by parentheses. The correct line 109 should read:


cat = trim(chkString(Request("catid"),"SQLString"))
<
Go to Top of Page

texanman
Junior Member

United States
410 Posts

Posted - 02 July 2008 :  00:47:11  Show Profile  Reply with Quote
Thanks carefree
greeting_cards_clean.asp fix still doesn't work.
The fix for greeting_cards_remcardcat.asp works only after you remove the "*" after "delete" from lines 112 and 113 (The ruirib's fix above)<
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 02 July 2008 :  01:58:01  Show Profile  Reply with Quote
I installed it, tested the cleaning file, works perfectly with my change. Here's my file in .txt format: greeting_cards_clean<
Go to Top of Page

texanman
Junior Member

United States
410 Posts

Posted - 02 July 2008 :  02:12:42  Show Profile  Reply with Quote
why is this giving me a security warning? LOL<
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 02 July 2008 :  02:48:22  Show Profile  Reply with Quote
Don't worry about the security warning, just means the certificate wasn't issued by someone that MS recognizes as having authority. A txt file cannot hurt your browser.<
Go to Top of Page

Maxime
Average Member

France
521 Posts

Posted - 02 July 2008 :  02:49:14  Show Profile  Visit Maxime's Homepage  Reply with Quote
And what the original file of this MOD at summer updated with touts post for that of the forum. In order to not seek too much. Thank you<

Cordially,
Maxime

Taxation consists in so plucking the goose to get the most out of feathers with the least possible cries.(Jean-Baptiste Colbert)

Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 02 July 2008 :  03:42:45  Show Profile  Reply with Quote
I put it through a heap of testing on 2 installs of Snitz to make sure it was working on a fresh install of Snitz that was using Access and MS SQL and never had the errors that some are having.<

Cheers,

David Greening
Go to Top of Page
Page: of 6 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07