i did use that but may be it's looking table some were else becosue i don't know what file it's use and may be i need give it permision to write
does it write on my normal database were all info about forum (users,message,...) or it's have it's own database file some were may be it's just in wrong place?
I always get this problem when i'm on the review\edit avatars screen:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_AVATAR'. Make sure it exists and that its name is spelled correctly.
/forums/pokemon/admin_review_avatar.asp, line 89
-----------------------------
Also i cant edit now my profile, or see anyone else's profile, before its creating more and more blank options in the avatars select box.
Can someone help me? im tired of trying fixing it.. -Tomer
I installed your 105 avatar mod and everythfing appears to be working except that user don't have access to the now uploaded avatars. Is there something I missed?
I thought the 105 Avatar Pack MOD was supposed to make the Avatars available to the users? If not, how do users view the additional Avatars so they can select from them? Does ANYBODY know anything about this MOD?
The problem is most likely with how the Avatar MOD was installed. When you use the strConnString labeled for use with Access97, DEFAULT values are not set when creating new fields in a table because the Driver that is used does not support it. The Driver used when you use one of the strConnString lines labeled for use with Access2000 does support it.
This Avatar Pack only adds info to the A_URL and A_NAME fields, so the A_MEMBER_ID field is NULL for each of the entries.
If you edit each avatar in the Review Avatar page and then choose submit, then it will update that field and the Avatars will be available to be chosen.
The script that will autoupate the database using the SQL strings I posted can be named anything you want. You need to include config.asp, inc_functions.asp, inc_top.asp and inc_footer.asp in the file and then within script tags define the SQL string and then run the command using my_Conn.execute(strSql).
You then simply upload the file, navigate to it using your browser by entering the relevant URL and then the page will load and the database will update. Then when your users select their avatar the new avatars shiuld appear.
Topic Locked
Posted - 13 March 2002 : 04:14:57
