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/O Code)
 Zuel's Avatar Addon
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 4

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 03 November 2005 :  19:16:04  Show Profile  Visit MarkJH's Homepage  Reply with Quote
quote:
i'm really excited by this, BTW... thanks for your hard work.
Yes, can't wait to see what you've accomplished with this. <

Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

Zuel
Average Member

USA
540 Posts

Posted - 03 November 2005 :  19:21:38  Show Profile  Visit Zuel's Homepage  Reply with Quote
quote:
Originally posted by vynsane

i take care of my folders independently of the admin home anyway, so it wouldn't bother me to not include it. also, i wouldn't want to delete the folder unless there was nothing in it anyway, and i would do that through FTP, so i guess that's my ten cents.

i'm really excited by this, BTW... thanks for your hard work.



Based on that, I made variables in the config above it whether or not to create and delete the folders when creating/deleteing the category in the Database.<

My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]

Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.

MSN / E-Mail: ucyimDa_Ruler@Hotmail.com

Personal Bookmarks: How to work a DBS File

Edited by - Zuel on 03 November 2005 19:22:09
Go to Top of Page

Zuel
Average Member

USA
540 Posts

Posted - 03 November 2005 :  20:58:38  Show Profile  Visit Zuel's Homepage  Reply with Quote
quote:
Originally posted by MarkJH

quote:
i'm really excited by this, BTW... thanks for your hard work.
Yes, can't wait to see what you've accomplished with this.



I'm getting scared to release it. My biggest fear is having you guys install it and it crashes everything or it doesn't work period.

Remote debugging isn't my speciality.

Having said that, I have been coding in semi failsafes so users should never get an Internal Server Error. Every Database Request and every File System Object Request has been tested and coated with customized error messages.

Update: I am currently building my temporary forum on my local host. If I can install the avatars mod with no problems then my mod with no problems then I shall test on my server. If that passes then I will release for user tests.

Update # 2

Localhost temporary forum passed!<

My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]

Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.

MSN / E-Mail: ucyimDa_Ruler@Hotmail.com

Personal Bookmarks: How to work a DBS File

Edited by - Zuel on 03 November 2005 21:53:41
Go to Top of Page

Zuel
Average Member

USA
540 Posts

Posted - 03 November 2005 :  23:06:06  Show Profile  Visit Zuel's Homepage  Reply with Quote


Server failed at two spots.

Assigning and Uploading. Cry.<

My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]

Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.

MSN / E-Mail: ucyimDa_Ruler@Hotmail.com

Personal Bookmarks: How to work a DBS File
Go to Top of Page

Zuel
Average Member

USA
540 Posts

Posted - 03 November 2005 :  23:27:34  Show Profile  Visit Zuel's Homepage  Reply with Quote
I have no **** debugging, makes it just impossible for me to determine the exact error. But with Response.Writes and Ends I think the problem is displayed in red below. All is good until it hits the red line.


Public Sub checkForErrors()
	'=== Clear Error Message ===
	Err_Msg = ""
			
	'=== Get Form Fields Values ===
	avatarURL = ChkString(Request.Form("AvatarURL"),"url")
	avatarName = ChkString(Request.Form("AvatarName"),"")
		
	'=== No Avatar URL ===
	if avatarURL = " "  then 
		Err_Msg = Err_Msg & "<li>You Must Enter a URL for your Avatar!</li>"
	end if
			
	'=== No Avatar Name ===
	if avatarName = " " then 
		Err_Msg = Err_Msg & "<li>You Must Enter a Name for your Avatar!</li>"
	end if	
			
	'=== Error Present - Inform User ===
	If Err_Msg <> "" then
		StringBuilder.AddString "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """>There Was A Problem With The Submission</font></p>" & vbNewLine & _
					"<table align=""center"" border=""0"">" & vbNewLine & _
					"	<tr>" & vbNewLine & _
					"	 <td><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><ul>" & vbNewLine & _
					" " & Err_Msg & " " & vbNewLine & _
					"	</ul></font></td>" & vbNewLine & _
					"	</tr>" & vbNewLine & _
					"</table>" & vbNewLine & _
					"<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><a href=""JavaScript:history.go(-1)"">Go Back To Enter Data</a></font></p>"
	else
		'=== No Errors - Build SQL Query ===
		strSql = "INSERT INTO " & strTablePrefix & "AVATAR ("
		strSql = strSql & "A_URL"
		strSql = strSql & ", A_NAME"
		strSql = strSql & ", A_MEMBER_ID"
		strSql = strSql & ") VALUES ("
		strSql = strSql & "'" & avatarURL & "'"
		strSql = strSql & ", '" & avatarName & "'"
		if Request.Form("AvatarMemberID") <> "" or Request.Form("AvatarMemberID") <> " " then
			strSql = strSql & ", " & ChkString(Request.Form("AvatarMemberID"),"")
		else
			strSql = strSql & ", " & 0
		end if	
		strSql = strSql & ")"
				
		'=== Execute SQL Query ===
		my_Conn.Execute (strSql)
				
		'=== Insert Complete - Print Results to User ===
		StringBuilder.AddString "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>Avatar " & avatarName & " Added!</font></p>" & vbCRLF
		StringBuilder.AddString "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>To start using your new avatar,<br>go to your profile and choose the new avatar!</font></p>" & vbCRLF
		StringBuilder.AddString "<p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><A href='javascript: self.close ()'>Close this Window</A></p><BR>" & vbCRLF
	end if
Exit Sub
End Sub
<

My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]

Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.

MSN / E-Mail: ucyimDa_Ruler@Hotmail.com

Personal Bookmarks: How to work a DBS File
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 04 November 2005 :  04:19:13  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
Before that line, add this:

Response.Write strSql
Response.End

Tell us what is shown.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Zuel
Average Member

USA
540 Posts

Posted - 04 November 2005 :  10:17:48  Show Profile  Visit Zuel's Homepage  Reply with Quote
INSERT INTO FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID) VALUES ('http://www.twistingshadows.com/forum/avatars/Blizzard/MaleGnome.gif', 'MaleGnome.gif', 1)<

My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]

Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.

MSN / E-Mail: ucyimDa_Ruler@Hotmail.com

Personal Bookmarks: How to work a DBS File
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 04 November 2005 :  13:00:09  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
What error do you get when you remove the code I suggested?<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Zuel
Average Member

USA
540 Posts

Posted - 04 November 2005 :  14:26:53  Show Profile  Visit Zuel's Homepage  Reply with Quote
On the server:

Internal Server Error

On my Localhost:

Nothing, works fine.

If I can't get it to work tonight then I'll zip it up and host it up here so you guys can give it a try.<

My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]

Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.

MSN / E-Mail: ucyimDa_Ruler@Hotmail.com

Personal Bookmarks: How to work a DBS File

Edited by - Zuel on 04 November 2005 14:28:22
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 04 November 2005 :  14:33:41  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
The SQL shown is correct. I don't see how it would cause an error.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Zuel
Average Member

USA
540 Posts

Posted - 04 November 2005 :  15:39:03  Show Profile  Visit Zuel's Homepage  Reply with Quote
Do I need to open a connection?

<

My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]

Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.

MSN / E-Mail: ucyimDa_Ruler@Hotmail.com

Personal Bookmarks: How to work a DBS File
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 04 November 2005 :  17:17:52  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
No, the code is correct.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Zuel
Average Member

USA
540 Posts

Posted - 07 November 2005 :  10:06:23  Show Profile  Visit Zuel's Homepage  Reply with Quote
After looking through everything and failing at everything trying to fix it, I am going to ZIP up everything and post on Snitz forums for more testing.

I need testers. This MOD will crash in two instances that I am aware of. I need someone who has debugging enabled on their server to relay the error messages back to me.

I tested:
OS: Windows 2003 Server
DB: Access 2003

I need these tested:
OS: W/e Else
DB: MySQL and SQLServer

It should fail on Assigning Avatars and Uploading. Funny thing is, Uploading fails but still uploads. Assigning is just broke period on the server.

Everything works perfect on my localhost. Get ready for a link on Wednesdayish.<

My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]

Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.

MSN / E-Mail: ucyimDa_Ruler@Hotmail.com

Personal Bookmarks: How to work a DBS File
Go to Top of Page

vynsane
New Member

73 Posts

Posted - 07 November 2005 :  14:01:19  Show Profile  Visit vynsane's Homepage  Reply with Quote
wish i could help you there, but just following directions on mods makes my palms sweat. debugging ain't my strong suit...<

why do you not have something to drink... choose one making you better feeling...

my snitz's:

www.vynsane.com/forum - l:guest p:guest (limited access account...)

www.WallCrawlersWeb.com/forum - The Spidey Database
Go to Top of Page

Zuel
Average Member

USA
540 Posts

Posted - 08 November 2005 :  14:04:27  Show Profile  Visit Zuel's Homepage  Reply with Quote
Gah, I am ready to give up. I just logged on this morning and my whole snitz board was down. Internal server, 500 errors left and right.

I found the error log and checked through it. Over 5000 internal server errors from 6 am to 11 am.



I contacted my host which is my co worker and we saw the hosting company has been going under some maintence. After going through we found the problems. My board no longer errors out and if it does, I can isolate the problem.

Debugging was enabled and I found the bugs that I couldn't find before. I shall attempt finish this tonight.

I won't give up that easy.<

My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]

Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.

MSN / E-Mail: ucyimDa_Ruler@Hotmail.com

Personal Bookmarks: How to work a DBS File
Go to Top of Page
Page: of 4 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.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07