| Author |
 Topic  |
|
Hopeful
Junior Member
130 Posts |
 Posted - 25 January 2006 : 06:25:56
|
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE varchar(1) NULL
Column added successfully
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(1) NULL' at line 1
Can anyone tell me how to correct this or install it manually in the alternative mod set up section?
Thank you in Advance!
|
Please explain everything in layman terms!!! |
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 06:29:55
|
oh yeah... running snitz 3.4.05 and have a few other mods already installed; pm's, mike's file attachment, birthdays, pm notify, pop up toast notify and I think thats it.
db is mysql 4.1.8
Thanks! |
Please explain everything in layman terms!!! |
 |
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 06:46:45
|
I just saw another post from you Rui and you gave code to install the whole db for active users.
Can I just use the code for the part that has the error in the alternate mod set up section?
[ALTER]
MEMBERS
ADD#M_AUHIDE#varchar(1)#NULL#
ALTER#M_AUHIDE#varchar(1)#NULL#
[END]
Would this work for this problem?
Thanks! |
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 07:11:29
|
I looked in the db and there is a column M_AUHIDE in the forum_members table
Does that mean I can continue with the coding steps or is there still something I need to do or add or alter?
Thank You! |
Please explain everything in layman terms!!! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 January 2006 : 07:16:27
|
| Yeah, you can continue. Just check whether there are more statements in the DBS file and whether they have been executed as well (I don't have the file here to have a look). |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 07:22:35
|
This was the only error I received when I ran the setup...
I did the next step,
From your browser run the audbsetup.asp file. http://your-forum/audbsetup.asp When is says "Update Complete" then proceed onto modifying files.
All this does is leads me back to:
http://myforum.com/down.asp
It does not say "Update Complete"
How can I be sure it is complete before I move on?
Thank you, Thank you!
|
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 07:24:46
|
This is the DBS file:
Active Users 4.0 for Snitz 3.4 compatable
[DROP]
ONLINE
[END]
[DROP]
ACTIVE_USERS
[END]
[CREATE]
ACTIVE_USERS
MEMBER_ID#int#NULL#
AU_IP#varchar(40)#NULL#
AU_LOGINTIME#varchar(100)#NULL#
AU_LASTACTIVETIME#varchar(100)#NULL#
AU_LASTPAGE#varchar(250)#NULL#
AU_QUERYSTRING#text#NULL#
AU_USER_AGENT#text#NULL#
[END]
[ALTER]
MEMBERS
ADD#M_AUHIDE#varchar(1)#NULL#
ALTER#M_AUHIDE#varchar(1)#NULL#
[END]
[ALTER]
MEMBERS_PENDING
ADD#M_AUHIDE#varchar(1)#NULL#
[END]
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRAUANON','1')
(C_VARIABLE,C_VALUE)#('STRAUANONOVERRIDE','2')
(C_VARIABLE,C_VALUE)#('STRAUPALLOW','4')
(C_VARIABLE,C_VALUE)#('STRAUPCOLLAPSE','1')
(C_VARIABLE,C_VALUE)#('STRAUALLOW','3')
(C_VARIABLE,C_VALUE)#('STRAUREFRESH','0')
(C_VARIABLE,C_VALUE)#('STRAUIP','1')
(C_VARIABLE,C_VALUE)#('STRAUUA','2')
(C_VARIABLE,C_VALUE)#('STRAULOCAL','3')
(C_VARIABLE,C_VALUE)#('STRAUTIMEOUT','7')
(C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered')
(C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen')
(C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered')
(C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen')
(C_VARIABLE,C_VALUE)#('intAURecord','0')
(C_VARIABLE,C_VALUE)#('strAURecordDate','11111111111111')
[END] |
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 07:29:44
|
This is the screen I got when I ran the mod setup:
Active Users 4.0 for Snitz 3.4 compatable
Dropping Table..
Table does not exist
Dropping Table..
Table does not exist
Creating table(s)...
CREATE TABLE FORUM_ACTIVE_USERS( MEMBER_ID int NULL , AU_IP varchar(40) NULL , AU_LOGINTIME varchar(100) NULL , AU_LASTACTIVETIME varchar(100) NULL , AU_LASTPAGE varchar(250) NULL , AU_QUERYSTRING text NULL , AU_USER_AGENT text NULL )
Table created successfully
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE varchar(1) NULL
Column added successfully
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(1) NULL' at line 1
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS_PENDING ADD M_AUHIDE varchar(1) NULL
Column added successfully
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUANON','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUANONOVERRIDE','2')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUPALLOW','4')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUPCOLLAPSE','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUALLOW','3')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUREFRESH','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUIP','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUUA','2')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAULOCAL','3')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUTIMEOUT','7')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUADMINCOLOR','orangered')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUMODCOLOR','forestgreen')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUADMINCOLOR','orangered')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRAUMODCOLOR','forestgreen')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAURecord','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strAURecordDate','11111111111111')
Value(s) updated successfully
The dbs file was successfully deleted.
If there were errors please post a question in the MOD Implementation Forum at
Snitz Forums
Do you think this is the only step I need to be sure of?
|
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 07:41:07
|
I don't see anything..... but I don't know anything either  lol
Thank you AGAIN Rui, you are ALWAYS a BIG help!!! |
Please explain everything in layman terms!!! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 08:39:59
|
Thank you so much!!!
I know that was a lot to post but I wanted a second pair of eyes to see what I was seeing!
THANK YOU, THANK YOU!!!
I'm getting busy with the code changes now!
Wish me luck! (I AM using Araneae to be safe!)
|
Please explain everything in layman terms!!! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 10:12:37
|
I DID IT!!! DONE AND WORKING!!!
I can hardly believe my only glitch was the first error when I ran the mod db setup! WHEW!!!
Thank you soooooooooooooooooooooooooooooooooooooooooooo much for all your help the last 2 days!
P.S. Since I kept a copy of the changed coded pages, can I upload the AU.asp files, run the DB setup and upload the same coded pages to another forum? Will this work?
Just an after thought!
Thanks a million again Rui! What would we all do without you!!! |
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 10:58:34
|
quote:
Originally posted by Hopeful
P.S. Since I kept a copy of the changed coded pages, can I upload the AU.asp files, run the DB setup and upload the same coded pages to another forum? Will this work?
OOPS! Guess not... it took out all my info  !
I hope the server has a backup of the DB & files... or can roll back an hour!
Will find out soon... |
Please explain everything in layman terms!!! |
|
|
|
Hopeful
Junior Member
130 Posts |
Posted - 25 January 2006 : 11:41:25
|
Well, yes you can!
I forgot to change the config.asp connection string. Once I did that it worked like a charm!!!
Thanks again everyone for your help!
I'll be back in a couple months after I recoup from that to tackle something else... lol
|
Please explain everything in layman terms!!! |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 26 January 2006 : 07:44:44
|
[ALTER]
MEMBERS
ADD#M_AUHIDE#varchar(1)#NULL#
ALTER#M_AUHIDE#varchar(1)#NULL#
[END]
I know you got it working but I think that line gave you the error. It shouldn't be there. |
_-/Cripto9t\-_ |
|
|
|
Topic |
|
Topic Locked
.