Microsoft.AspNetCore.Mvc.Localization.LocalizedHtmlStringHelp with Zuel's Avatar addon, please!!

Author : connietalk
Subject : Help with Zuel's Avatar addon, please!!
Posted : 29 October 2007, 15:51
Message :

Hi -

I implemented Zuel's Avatar addon, but I cannot get into the settings for it in the Admin panel, because I get this:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-max-log]Table 'ctwordpress.FORUM_Avatar_Extension' doesn't exist

/forum/incAvatarFunctions.asp, line 672

ctwordpress is the name of my MySQL table.
Could someone pleeeeeeease help?
Thanks!

Connie<

Reply Author: ruirib
Replied on: 29 October 2007, 16:11
Message:

Did you execute the dbs file?<

Reply Author: connietalk
Replied on: 29 October 2007, 21:06
Message:

Yes, although I think I had a few code errors I had to correct since, and reuploaded config, topic, adminhome, a few files. Does that matter? Should I put the dbs back and do it again?<

Reply Author: ruirib
Replied on: 30 October 2007, 03:26
Message:

Yeah, you should try that again. Probably you will have errors for the existing tables, but you need to take notice of the errors regarding non existing tables.<

Reply Author: connietalk
Replied on: 31 October 2007, 00:30
Message:

Weird - okay, I did it, and I got no errors, it said table creations were all successful. But then when I try to go into "Zuel's Avatar Addon" in the Avatar Setup, I still get the same message.
Do I maybe need to specify where my current Avatars folder is somewhere, could that be why? Here's what shows around line 672 on the incAvatarFunctions.asp:

Code:

	' =======================================================================
	' ===        Grab all the Current Extensions from the Database        ===
	' =======================================================================
	Function getExtensionValues()
		Dim getExtensionRS, strSql
	
		'=== Set Database Connection ===
		Set getExtensionRS = Server.CreateObject("ADODB.RecordSet")

		'=== Build SQL Query ===
		strSql = "SELECT EXTENSION_NAME, EXTENSION_ID FROM " & strTablePrefix & "Avatar_Extension"

		'=== Open Database Connection ===
		getExtensionRS.open strSql, my_Conn 
		
		Select Case (getExtensionRS.EOF)
			Case True : extensionErrors    = True
			Case Else :	getExtensionValues = getExtensionRS.GetRows()
		End Select
		
		'=== Close Connection and Clear Memory ===
		getExtensionRS.Close
		Set getExtensionRS = Nothing
	Exit Function
	End Function

Thank you so much, ruirib!

<

Reply Author: ruirib
Replied on: 31 October 2007, 04:21
Message:

Can you have a look at the DB and see if the table is there, maybe using PhpMyAdmin? If it's not there, execute this in PHPMyAdmin:

Code:


CREATE TABLE `forum_avatar_extension` (
  `EXTENSION_ID` int(11) NOT NULL auto_increment,
  `EXTENSION_NAME` varchar(100) NOT NULL default '',
  KEY `FORUM_AVATAR_EXTENSION_EXTENSION_ID` (`EXTENSION_ID`)
) ENGINE=MyISAM;

<

Reply Author: connietalk
Replied on: 01 November 2007, 00:21
Message:

Yup, I checked, and it's showing that the table is there:

My logon for FTP (hosting logon) is different from the one I use for MySQL/php admin and Snitz. Does that matter? I made the MySQL logon and my Snitz admin logon the same, though. Do I have to somehow specify allow privileges in the pHp admin for that table?
I'm also wondering - was I supposed to type a value in the forum_avatar_extension table for what file type extensions are allowed? Like jpg and gif, somewhere?

I maybe should mention that my hosting is with GoDaddy...sometimes they tend to have very specific conflicts, so just thought I'd mention in case it's a red flag. I'm out of ideas

Also, since I implemented Zuel's add-on, members require approval before getting access and show up in the "Members Pending" folder...I want them to be approved automatically. Any idea how to switch that back?
Thank you so much, you are an absolute gem!!

<

Reply Author: ruirib
Replied on: 01 November 2007, 05:31
Message:

connie, I'm thinking it may be a name case issue. Your tables have names all in uppercase and the code is using lowercase. Try changing the name of the problem table to uppercase in that piece of code causing you troubles.<

Reply Author: connietalk
Replied on: 01 November 2007, 16:24
Message:

You're a GENIUS!! That is exactly what it was. Unfortunately, there is a new problem...now, when a user clicks on the "Click here to change your avatar," they get this

:

Server.MapPath() error 'ASP 0173 : 80004005'

Invalid Path Character

/forum/incAvatarFunctions.asp, line 108

An invalid character was specified in the Path parameter for the MapPath method.
Here's what I have around line 108 in incAvatarFunctions.asp:

Code:

' =======================================================================
	' ===           Returns the Number of Avatars from a User             ===
	' =======================================================================
	Function getPersonalAvatarLimit(userID)
		Dim ObjFSO : Set ObjFSO = CreateObject("Scripting.FileSystemObject")

		'=== Precheck For Folder ===
		Select Case (ObjFSO.FolderExists(Server.MapPath(avatarFolderPath & privateFolderName)))
			Case True
				'=== Set File System Object ===
				Set rootFolder    =  ObjFSO.GetFolder(Server.MapPath(avatarFolderPath & privateFolderName))
				Set files		  =	 rootFolder.Files

				For each File in Files
					Select Case (isAvatarMatch(File.Name, UserID))
						Case True: getPersonalAvatarLimit = getPersonalAvatarLimit + 1
						Case Else: '=== Do Nothing ===
					End Select
				Next

<

Reply Author: ruirib
Replied on: 01 November 2007, 16:35
Message:

Not sure about that one, I don't really know the mod that well. Doesn't the mod allow you to the define the avatar folder?<

Reply Author: connietalk
Replied on: 01 November 2007, 17:02
Message:

Uh oh. Yup, I defined it here, at the beginning of incAvatarFunctions.asp:

Code:

<%
	'=== Two Global Variables used within both Forms ===
	Dim avatarFolderPath, privateFolderName

	'=== Avatar Path Location - Change If You Wish ===
	'=== Example:  http://yourforumurl.com/forum/avatars/
	'=== Folder MUST be within the Forum Directory ===
	avatarFolderPath = "http://www.connietalk.com/forum/avatars/"

	'=== Private Avatar Folder Name - Change If You Wish ===
	'=== Example:  "Personal", "Secret", "Private" ===
	'=== This is only a NAME not a Directory - Do NOT Include the Slash "/" ===
	privateFolderName = "Personal"

	' ======================================================================
	' ===           Common Functions within frmAvatarMain.asp            ===
	' ===  LAST UPDATE:        July, 2006                                ===
	' ===  LAST FUNC MODIFIED: checkForCategoryRecords()  - CREATED      ===
	' ======================================================================
%>

<

Reply Author: ruirib
Replied on: 01 November 2007, 17:21
Message:

That's the mistake then. You cannot use an URL. Try this:

Code:


avatarFolderPath = "avatars/"

<

Reply Author: connietalk
Replied on: 01 November 2007, 17:56
Message:

Thank you!!! IT IS WORKING!!

The only problem now is that when the user clicks "Personal" avatars category, none of their personal uploaded avs display...they upload to the server okay but they don't show on their Edit Avatar page when they click to display their personal avs:

frmAvatarMain.asp?Select=Personal&method=Main

Reloads page but doesn't display anything...<

Reply Author: ruirib
Replied on: 01 November 2007, 18:17
Message:

Sorry, don't think I can help with that, as I said, I'm not an expert on that mod.<

Reply Author: connietalk
Replied on: 01 November 2007, 18:43
Message:

Alright, I'll work on it, but thank you soooooo incredibly much!

<

Help with Zuel's Avatar addon, please!!

Topic

Replies ...