Snitz Forums 2000 - Is this bug - Wrong prefix for SPAM

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Classic ASP versions(v3.4.XX)

Is this bug - Wrong prefix for SPAM_MAIL

New Topic

Topic Locked

Printer Friendly

Author

Topic

Jonathan8146
Starting Member

21 Posts

Posted - 07 May 2010 : 07:18:26

I've just installed the latest version from the zip file and it appears to have set up OK.

I have several different forums, most tables are unique to each but the BADWORD, NAMEFILTER and I thought SPAM_FILTER are shared across them.

I have just tried to change a user to an administrator and received the following error:

"Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tbl_KeyCommunicatorsSPAM_MAIL'.

/forums/keycommunicators/pop_profile.asp, line 1532"

Looking at the line it is:
strsql = "SELECT SPAM_SERVER FROM " & strTablePrefix & "SPAM_MAIL

But I suspect it should be using strFilterTablePrefix.

Also appears in register.asp, line 399

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 07 May 2010 : 08:03:11

See here.

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.”

Jonathan8146
Starting Member

21 Posts

Posted - 07 May 2010 : 08:07:57

Thanks. I'm not sure why this didn't show up when I searched, the missing zap icon did!

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 10 May 2010 : 05:13:33

You're welcome, Jonathan.

Sometimes, you just gotta know the right things to search for

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.”

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.32 seconds.