| Author |
 Topic  |
|
|
Mick
Starting Member
5 Posts |
 Posted - 30 April 2002 : 08:31:18
|
Avatar Mod v2.0
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID int COUNTER NOT NULL , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Why?!?!
It doesn't work.
If I go to the amministration options, it says:
Active Server Pages error 'ASP 0126'
Include file not found
/forum/admin_home.asp, line 127
The include file 'mods/modCMD.asp' was not found.
HELP ME!!!! PLZ!
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 30 April 2002 : 08:37:58
|
did you upload any files before running the DBS file? i bet you did... not good.
the DBS file you tried to install isn't correct. i take it you have no or little experience with DBS files?
Crash's Site | Crash is from 
|
 |
|
|
Mick
Starting Member
5 Posts |
Posted - 30 April 2002 : 09:03:25
|
I uploaded all the mod first. then i changed the lines that were incorrect (as the readme said). Then I ran the setup file of the mod, and then I went to the forum administration, where there was the mod waiting for install...
But after that, the register button didn't work, and also the profile button...
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 30 April 2002 : 09:12:15
|
you shouldn't upload all the files at first. just the dbs file... replace the ones you uploaded with your backuped files
Crash's Site | Crash is from
|
|
|
|
Mick
Starting Member
5 Posts |
Posted - 30 April 2002 : 09:28:01
|
Sorry but I don't understand..
Have I to leave some file offline?!
what files?
In the readme file it doesn't say anything 'bout that
(thanks for helping me and sorry for my english)
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 30 April 2002 : 09:33:39
|
1. upload all the files you backed up before adding/installing this avatar mod.
you edited some files, right? you made a backup before editing them, right? replace the ones from the backup with the ones you've edited.
2. remove all entries made by the DBS file from the DB.
3. re-upload the DBS file and only that file. run it.
4. edit the file again and upload them
Crash's Site | Crash is from
|
|
|
|
Mick
Starting Member
5 Posts |
Posted - 30 April 2002 : 09:36:55
|
and then have I to go to admin options and go to mod install to install avatar or not?
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 30 April 2002 : 09:52:38
|
point 3. does that
Crash's Site | Crash is from
|
|
|
|
Mick
Starting Member
5 Posts |
Posted - 30 April 2002 : 10:01:43
|
I did it. Now this is the problem:
Review/Edit Avatars
Preview Avatar URL Avatar Name Owner
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.
/forum/admin_review_avatar.asp, line 89
Can you write me all the points from when I install the database? I'll start all over again... even the database
(isn't there a Snitz forum with avatar included in its installation?
Thanks a lot for your help
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 30 April 2002 : 10:23:46
|
allright then. here we go from scratch...
this will only work if you have clean files, meaning nothing edited in, on, at, over them. clean files.
use reply with quote on my post to see the code and then select all the code between these lines (so, NOT including the lines):
---------------------------------
Drop & Recreate Avatar
[drop]
AVATAR
[end]
[drop]
AVATAR2
[end]
[ALTER]
MEMBERS
ADD#M_AVATAR_URL#varchar(255)#NULL#
[END]
[CREATE]
AVATAR
A_ID
A_URL#varchar (255)#NULL#
A_NAME#varchar (50)#NULL#
A_MEMBER_ID#int#NULL#0
[END]
[CREATE]
AVATAR2
A_HSIZE#int#NULL#
A_WSIZE#int#NULL#
A_BORDER#int#NULL#
[END]
[INSERT]
AVATAR2
(A_HSIZE, A_WSIZE, A_BORDER)#(64, 64, 0)
[END]
---------------------------------
save that as a file named dbs_avatar_update.asp
upload that file to your forum. go to the admin pages and select mod setup. select Drop & Recreate Avatar and hit the Update! button. now the tables are being recreated.
next, edit all the file as mentioned in the readme that came with the zipfile.
upload them after editing. Remember: DO NOT edit them with FrontPage
Crash's Site | Crash is from
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 30 April 2002 : 11:10:30
|
you can download an updated version of MOD Setup that handles Access97 connection strings a little better:
http://kinser.121hosts.net/link-it/default.asp?catid=3
You should really use one of the Connection Strings labeled for use with Access2000 instead of one of the ones labeled for use with Access97. |
|
|
| |
Topic |
|
Topic Locked
