Snitz Forums 2000 - Error deleting topics

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)

Error deleting topics

New Topic

Topic Locked

Printer Friendly

Author

Topic

samyot
Junior Member

Canada
242 Posts

Posted - 16 December 2004 : 14:04:32

Hi,

Since upgrading to version 3.4.05 I now get the following error deleting topics:

------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt]Unknown column 'T.T_POSTS' in 'field list'

/support_old/topic.asp, line 122
------------------------------------------------

Any thoughts?

Sylvain Amyot
Forum | Home

MY OTHER SITES:
http://www.mypcsecurity.ca
http://www.mynature.ca
http://www.myworkshop.ca
http://www.toptechsites.com
http://www.topsportsites.com
http://www.mysportsforums.net

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 16 December 2004 : 14:25:55

Could you either a) post the code surrounding the line in question
or b) post a link to your topic.asp in text format?

-Stim

samyot
Junior Member

Canada
242 Posts

Posted - 16 December 2004 : 14:42:27

Hi,

Thank you for your help!

Here is a link to topic.asp
http://www.mytechsupport.ca/support/topic.txt

T_Posts was added by the Post Stamp MOD

Edited by - samyot on 16 December 2004 14:44:48

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 16 December 2004 : 14:50:51

quote:
T_Posts was added by the Post Stamp MOD

That sounds like the issue right there, when you upgraded that column was probably dropped.

Without looking at the database I cant really be sure, but I'd recommend re-running any setup that went along with the post stamp mod, to update the database to include that column

-Stim

samyot
Junior Member

Canada
242 Posts

Posted - 16 December 2004 : 15:12:53

You were right, I had one missing column!

Thank you for your help!