Snitz Forums 2000 - SmileManager Plus Version: 1.3 Problem

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

SmileManager Plus Version: 1.3 Problem

New Topic

Topic Locked

Printer Friendly

Author

Topic

hans_
Junior Member

Czech Republic
161 Posts

Posted - 30 May 2005 : 09:54:51

I installed this MOD and have following problem:

this is in admin option

this is if i try reply on topic

**********

It looks that table FORUM_SMILES was not created.

I looked at the my Access dtb and did not find any table FORUM_SMILES.

Can you help em please?

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 30 May 2005 : 10:07:26

Did you run the dbs file that came in the zip as per the instructions in the readme? Did you receive any errors when doing so?

Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”

hans_
Junior Member

Czech Republic
161 Posts

Posted - 30 May 2005 : 14:13:47

First I started in MOD Setup: Add Default Smiles
in Adding new records.. was problem at the end:
Snitz Forum Modifications

Add Default Smiles

Adding new records..
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_angry.gif', '

', 'yes', 1, 'Angry', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_blackeye.gif', '

', 'yes', 1, 'Black Eye', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_dead.gif', '

', 'yes', 1, 'Dead', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_dead.gif', '

', 'yes', 0, 'Dead', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_shock.gif', '

', 'yes', 1, 'Shock', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_shock.gif', '

', 'yes', 0, 'Shock', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_shock.gif', '

', 'yes', 0, 'Shock', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_blush.gif', '

', 'yes', 1, 'Blush', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_sad.gif', '

', 'yes', 1, 'Sad', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_shy.gif', '

', 'yes', 1, 'Shy', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile.gif', '

', 'yes', 1, 'Smile', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_evil.gif', '

', 'yes', 1, 'Evil', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_big.gif', '

', 'yes', 1, 'Big Smile', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_cool.gif', '

', 'yes', 1, 'Cool', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_sleepy.gif', '

', 'yes', 1, 'Sleepy', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_clown.gif', '

', 'yes', 1, 'Clown', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_clown.gif', '

', 'yes', 0, 'Clown', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_clown.gif', '

', 'yes', 0, 'Clown', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_tongue.gif', '

', 'yes', 1, 'Tongue', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_tongue.gif', '

', 'yes', 0, 'Tongue', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_wink.gif', '

', 'yes', 1, 'Wink', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_8ball.gif', '

', 'yes', 1, 'Eight Ball', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_question.gif', '

', 'yes', 1, 'Question', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_approve.gif', '

', 'yes', 1, 'Approve', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_disapprove.gif', '

', 'yes', 1, 'Disapprove', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_disapprove.gif', '

', 'yes', 0, 'Disapprove', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_kisses.gif', '

', 'yes', 1, 'Kisses', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_kisses.gif', '

', 'yes', 0, 'Kisses', 1, 1, 0)
INSERT INTO FORUM_SMILES (S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE) VALUES ('icon_smile_kisses.gif', '

', 'yes', 0, 'Kisses', 1, 1, 0)
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_SMILES'.

Than i started SmileManager Plus Upgrade
There was problem:
SmileManager Plus Upgrade

Adding Column S_VISIBLE...
ALTER TABLE FORUM_SMILES ADD COLUMN S_VISIBLE int NULL
ALTER TABLE FORUM_SMILES ADD COLUMN S_VISIBLE int NULL
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Cannot find table or constraint.
Adding Column S_DEFAULT...
ALTER TABLE FORUM_SMILES ADD COLUMN S_DEFAULT int NULL
ALTER TABLE FORUM_SMILES ADD COLUMN S_DEFAULT int NULL
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Cannot find table or constraint.
Adding Column S_EXCLUDE...
ALTER TABLE FORUM_SMILES ADD COLUMN S_EXCLUDE int NULL
ALTER TABLE FORUM_SMILES ADD COLUMN S_EXCLUDE int NULL
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Cannot find table or constraint.
Adding Column S_COLSPAN...
ALTER TABLE FORUM_SMILES ADD COLUMN S_COLSPAN int NULL
ALTER TABLE FORUM_SMILES ADD COLUMN S_COLSPAN int NULL
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Cannot find table or constraint.

Creating table(s)...
CREATE TABLE FORUM_SMILES2( S2_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , S2_ALLOWEDIT int NULL )
Table already exists

Adding new records..
INSERT INTO FORUM_SMILES2 (S2_ALLOWEDIT) VALUES (1)

Value(s) updated successfully

Creating table(s)...
CREATE TABLE FORUM_SMILES_CUSTOM( MS_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , MEMBER_ID int NULL , S_ID int NULL )
Table already exists

I am still learning.
Sorry for my stupid questions (sometimes) and bad English.

modifichicci
Average Member

Italy
787 Posts

Posted - 30 May 2005 : 15:20:13

You have to run the dbs_smiles.asp first and then the dbs_addoldsmiles.asp..
Delete tables from db and run again the dbs, in the right order.
You have also to upload new files and modifyed files after the dbs run...
If it's a new installation you haven't to use dbs_smiles_upgrade.asp.

Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum

Edited by - modifichicci on 30 May 2005 15:21:07

hans_
Junior Member

Czech Republic
161 Posts

Posted - 31 May 2005 : 09:43:22

I found now i have not file dbs_smiles.asp in root of the forum

thank you i will try it

quote:
Originally posted by modifichicci

You have to run the dbs_smiles.asp first and then the dbs_addoldsmiles.asp..
Delete tables from db and run again the dbs, in the right order.
You have also to upload new files and modifyed files after the dbs run...
If it's a new installation you haven't to use dbs_smiles_upgrade.asp.

Edited by - hans_ on 31 May 2005 09:45:38

alanh
New Member

United Kingdom
92 Posts

Posted - 31 May 2005 : 16:17:51

hans,

I am no expert here, but should the dbs_smilies.asp and all the other files not be in the original .zip file that came with the MOD, just put the dbs file/s back in your main forum then run the upgrade again.

I always copy the unzipped and original zipped MOD's to a directory after MOD's, so I know what is installed.

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.31 seconds.