Help with Zuel's Avatar addon, please!! - Posted (1451 Views)
connietalk
Starting Member
connietalk
Posts: 14
14
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! bigsmile
Connie<
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
Did you execute the dbs file?<
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
connietalk
Starting Member
connietalk
Posts: 14
14
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?<
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
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.<
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
connietalk
Starting Member
connietalk
Posts: 14
14
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!
bigsmile<
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
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;
<
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
connietalk
Starting Member
connietalk
Posts: 14
14
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? sad
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 blush
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!!

<
Last edited by connietalk on 01 November 2007, 01:41
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
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.<
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
connietalk
Starting Member
connietalk
Posts: 14
14
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 sad :

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
<
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
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?<
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
connietalk
Starting Member
connietalk
Posts: 14
14
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      ===
	' ======================================================================
%>
<
You Must enter a message