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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Avatar FAQ
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

lakobe
Starting Member

10 Posts

Posted - 23 May 2002 :  04:28:48  Show Profile
I had some problems when I tried to create the Avatar table in database and setup the Avatar. Those problems took me long long time to fix it. Later no, I found that those problems were very common with lots of people and I am very happy that I am not alone. Here are the solutions.

1: Q: Where to download the Avatar Mod 2.0?
S: http://www.ls3k.com/snitz/mods.asp?action=details&ID=97

2. Q: Tables creating problem.
When I run the Avatar Mod v2.0 script from the admin_mod_dbsetup.asp page the script runs and tells me that the table FORUM_AVATAR already exists but succesfully adds the table FORUM_AVATAR2 and the field for Avatar URLs to the FORUM_MEMBERS table. But when I try to add an avatar to the database I get the following error message:

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

[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.

/forum/admin_add_avatar.asp, line 90

S: This problem might only occur in Brinkster. To fix this problem, we need to have a updated admin_mod_dbsetup.asp file. We can get it at
http://kinser.121hosts.net/link-it/default.asp?catid=3&cattitle=FILES

3. Q: Adding new record problem.
Avatar Mod v2.0

Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL )
Table created succesfully

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_AVATAR2( A_HSIZE int NULL , A_WSIZE int NULL , A_BORDER int NULL )
Table created succesfully

--------------------------------------------------------------------------------

Adding new records..
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: "AVATAR2"]'

S: This problem only occurs when user use Access 97. So all we need is changing Access 97 to Access 2000 by modifing config.asp file.

Uncomment Line 5
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/saleen/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster

4. Q: Avatar table already exist problem.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[TCX][MyODBC]Table 'vbulletin.forum_avatar2' doesn't exist

/mysticrhino/lost_lands/forum/admin_avatar_settings.asp, line 100


S: Download the database to the local machine, delete "Avatar Table" and reload it.


  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07