| Author |
 Topic  |
|
|
hizgan
Starting Member
26 Posts |
 Posted - 30 March 2005 : 10:23:49
|
Hi,
I am trying to install active users 4.0 on snitz 3.4.05 using My Sql
Its a fresh install with only custom policy mod and Nis fix mod.
Here is what happens when I do the database
Active Users 4.0 for Snitz 3.4 compatable
Dropping Table..
DROP TABLE FORUM_ONLINE
-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-4.0.20]Unknown table 'FORUM_ONLINE'
Dropping Table..
DROP TABLE FORUM_ACTIVE_USERS
-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-4.0.20]Unknown table 'FORUM_ACTIVE_USERS'
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
-2147217911 | [MySQL][ODBC 3.51 Driver][mysqld-4.0.20]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(
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
Are these problem going to affect me, I have made the changes to the file but have an error in the admin section. Here is error below.
Administrative Functions
Forum Feature Configuration:
Main Forum Configuration
Feature Configuration
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'fLang'
/admin_home.asp, line 127
 I would be grateful for any help
Cheers
|
Edited by - hizgan on 30 March 2005 10:26:53 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 30 March 2005 : 10:43:36
|
The first two errors related to the dropping of tables are perfectly normal, the dbs is trying to delete any existing AU tables you may have. The next error about SQL Syntax shouldn't be a problem, either, as further down the results it tells you that M_AUHIDE was added sucessfully. Have a look at your MEMBERS table, though, just to be sure.
To fix the error in admin options, go through the readme again paying close attention to the changes related to language files.
|
 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.” |
 |
|
|
hizgan
Starting Member
26 Posts |
Posted - 30 March 2005 : 11:27:34
|
Thanks for the reply,
I have checked config.asp and relised I put just <!--#include file="langMODS_Ls3kAU4.asp"-->
rather than the other one, but now my site just shows the following error:
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
/default.asp, line 1073
--- I have looked at default.asp and it look fine, here is the code:
end if ' ChkDisplayForum()
end if
next '## Next Forum
end if
next '## Next Category
end if
%><!--#include file="inc_activeusers.asp"--><%
if strShowStatistics = "1" then
WriteStatistics
end if
Response.Write " </table>" & vbNewline & _
" </td>" & vbNewline & _
" </tr>" & vbNewline & _
" <tr>" & vbNewline & _
-- Cheers
|
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
hizgan
Starting Member
26 Posts |
Posted - 30 March 2005 : 17:50:51
|
nothing happens it makes no difference at all.
as far as I can see |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 30 March 2005 : 22:32:16
|
Have you opened your default.asp page in a text editor and gone to line 1073 or looked at the code around there and compared it to an unedited version of default.asp as it looks like something was taken out of it.
|
Cheers,
David Greening |
|
|
|
hizgan
Starting Member
26 Posts |
Posted - 31 March 2005 : 09:27:50
|
Guys,
I got really lost, so I have started from strach and is now getting this error.
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
/default.asp, line 1073
I havec checked default .asp and the seems to be no problem.
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 31 March 2005 : 11:55:00
|
Could also be a problem in one of the includes as a result to the changes you made for the AU mod. Are you getting errors on any other pages?
|
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.” |
|
|
|
hizgan
Starting Member
26 Posts |
Posted - 31 March 2005 : 15:23:44
|
Hi
Its weird I could go on to the forum but that error would show when I go to admin, but now the page is 'The page could not be displayed' for the whole site. Maybe it was cached.
|
Edited by - hizgan on 01 April 2005 11:26:52 |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 01 April 2005 : 15:13:03
|
| Could you post a link to a text-version of your inc_func_common.asp, hizgan? I suspect that the error lies in there. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
hizgan
Starting Member
26 Posts |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 04 April 2005 : 12:41:03
|
inc_func_common.asp looks ok, so the error isn't in there. I would then suggest that you upload anew the following pages: config.asp, inc_func_secure.asp, inc_sha256.asp, inc_header.asp, inc_func_member.asp, inc_moderation.asp, inc_subscription.asp, and default.asp.
If the error persists after that, I would suspect default.asp. If you post a link to a text-version of default.asp, I'll take a look at it. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
hizgan
Starting Member
26 Posts |
Posted - 05 April 2005 : 12:08:38
|
I re-uploaded the files you mentioned that are not editied for active users (this made no difference.
I then uploaded orginal files of inc_header.asp, and made no differnce.
default.asp made no differnece
when i uploaded the orginial config.asp the forum now works.
So I think the is a problem with either default.asp or config.asp.
I have posted www.verdicthosting.co.uk/default.txt.
If you can take a look and let me know.
Thanks
Hiren
|
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 05 April 2005 : 13:00:17
|
| I checked your default.asp, and it looks ok to me. If the error persisted until you re-uploaded the original config.asp, the error lies in there. Apply the mod changes again (remember to keep a back-up of the original files), and it should work. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
hizgan
Starting Member
26 Posts |
Posted - 06 April 2005 : 10:08:37
|
| Thanks it was the the config.asp, I was not installing the language bit correctly. |
|
|
| |
Topic |
|
Topic Locked
