|
lakobe
Starting Member
10 Posts |
 Posted - 23 May 2002 : 04:28:48
|
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.
|
|
Topic Locked
