Help with Zuel's Avatar addon, please!! - Postet den (1454 Views)
connietalk
Starting Member
connietalk
Innlegg: 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<
   
 Sidestørrelse 
Postet den
ruirib
Snitz Forums Admin
ruirib
Innlegg: 26364
26364
Did you execute the dbs file?<
Snitz 3.4 Readme | Like the support? Support Snitz too
Postet den
connietalk
Starting Member
connietalk
Innlegg: 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?<
Postet den
ruirib
Snitz Forums Admin
ruirib
Innlegg: 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
Postet den
connietalk
Starting Member
connietalk
Innlegg: 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<
Postet den
ruirib
Snitz Forums Admin
ruirib
Innlegg: 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
Postet den
connietalk
Starting Member
connietalk
Innlegg: 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!!

<
Sist redigert av
Postet den
ruirib
Snitz Forums Admin
ruirib
Innlegg: 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
Postet den
connietalk
Starting Member
connietalk
Innlegg: 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
<
Postet den
ruirib
Snitz Forums Admin
ruirib
Innlegg: 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
Postet den
connietalk
Starting Member
connietalk
Innlegg: 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      ===
	' ======================================================================
%>
<
Du må legge inn en melding