| Author |
 Topic  |
|
|
Yoshio
Starting Member
Spain
7 Posts |
 Posted - 05 March 2008 : 14:17:10
|
I don't know what else to do here. I'm desperate!
I started a new forum with your incredible system (thank you!!) and everything went perfect from the beginning.
Right now, before letting users to start registering (yes, I had an obsolete UBB classic forum which I cannot export to Snitz because of the difficulty and SHA256  ) I made myself an Avatar MOD implementation and hoping it will be slow and tedious but easy.
It seemed to be ok until I got with multiple 500 error from several asp files. Later on I discovered it was because table FORUM_AVATAR was not created at the beginning. On install, it reported some "Table already exists" and I didn't give it much importance because I was new at this.
I downloaded the database to check it and "FORUM_AVATAR" table was not there.
I created the table manually but didn't work out well.
Sooooo I started again from scratch. I thought maybe I did something wrong. OK, old database and new Snitz install ready.
And here I am again trying to create the table manually from the "MOD implementation" admin advance option and again "Table already exists". But downloaded the db and nowhere to be found.
Then I tried to delete it with [DROP] command and heheh surprise! It replied:
"Dropping Table..
DROP TABLE FORUM_AVATAR
Table does not exist"
I am desperate now. Everything else seems to be working great, but this minor thing is getting on my nerves. Please, help. |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Yoshio
Starting Member
Spain
7 Posts |
Posted - 05 March 2008 : 14:25:16
|
The one that originally came with the MOD:
"Avatar Mod for 3.4
[CREATE]
AVATAR
A_ID
A_URL#varchar (255)#NULL#
A_NAME#varchar (50)#NULL#
A_MEMBER_ID#int#NULL#0
[END]
[ALTER]
MEMBERS
ADD#M_AVATAR_URL#varchar (255)#NULL#
[END]
[ALTER]
MEMBERS_PENDING
ADD#M_AVATAR_URL#varchar (255)#NULL#
[END]
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('intShowAvatar','1')
(C_VARIABLE,C_VALUE)#('strAvatarFolder','avatars/')
(C_VARIABLE,C_VALUE)#('intAvatarWidth','64')
(C_VARIABLE,C_VALUE)#('intAvatarHeight','64')
(C_VARIABLE,C_VALUE)#('intAvatarBorder','1')
[END]" |
 |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Yoshio
Starting Member
Spain
7 Posts |
Posted - 05 March 2008 : 14:33:24
|
Access 2000 database.
That's the only command that fails. The rest work fine. |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Yoshio
Starting Member
Spain
7 Posts |
Posted - 05 March 2008 : 14:52:52
|
Well, I tried step-by-step creation of the table and after each implementation the response was "created successfully".
No problem here.
But then I download the .mdb file and there is no FORUM_AVATAR or any ANYTHING_AVATAR table created.
Is this normal? |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 March 2008 : 15:01:02
|
Can you tell us what connection string you are using? You can omit the details I just want to know the start of it.
For the mod setup to work, you need to be using a Jet OLEDB string. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Yoshio
Starting Member
Spain
7 Posts |
Posted - 05 March 2008 : 15:05:38
|
I will try it again, but remember last time I did something wrong with column design in MS Office 2003 and probably that was creating even more problems.
Should I have in mind some short instructions on how properties for the columns should look like? I'm afraid properties are important in this case.
Sorry for bothering that much, but I am not much into programming, just in an everyday learning status. Thanks, modifichicci! |
|
|
|
Yoshio
Starting Member
Spain
7 Posts |
Posted - 05 March 2008 : 15:10:11
|
quote:
Originally posted by ruirib
Can you tell us what connection string you are using? You can omit the details I just want to know the start of it.
For the mod setup to work, you need to be using a Jet OLEDB string.
DSN conn string.
Then that's why. Is it written somewhere? Didn't see it!!
So to solve it I have to follow modifichicci's approach, right?
Thank you too, ruirib!! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Yoshio
Starting Member
Spain
7 Posts |
Posted - 05 March 2008 : 17:20:57
|
| Great!! It is working now. Thank you both of you for helping me out that quickly and special thanks goes to ruirib for suggesting changing to Jet OLEBD. You're terrific! Once my website forum is finished and up, I'll let you know! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
