Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 setup error 2147217871		  New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

jwhite
New Member

51 Posts
Posted - 01 May 2006 :  14:16:20  Show Profile
[MySQL][ODBC 3.51 Driver][mysqld-5.0.18-nt]Invalid default value for 'M_APPROVE'

I get this error when trying to install the program. I started with a blank database and a fresh unzip of the program.

I can to to the site but when I click admin options I get.

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

[MySQL][ODBC 3.51 Driver][mysqld-5.0.18-nt]Table 'dandjelectrical.forum_members_pending' doesn't exist

/forum/admin_home.asp, line 49

can anyone help?

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 May 2006 :  14:50:07  Show Profile  Send ruirib a Yahoo! Message
Ate line #233, inc_create_forum_mysql.asp, where you now have

	strSql = strSql & "M_APPROVE smallint (6) DEFAULT '' , "

delete the red part.

Then try running setup.asp again, but do it like this:

http://WhateverYourForumURLIs/setup.asp?RC=5

This will make the forum create the DB tables again.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

jwhite
New Member

51 Posts
Posted - 01 May 2006 :  15:22:45  Show Profile
That made the program say that the database was created successfully, but I still cannot log into admin options. I still get the same error.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 May 2006 :  15:30:06  Show Profile  Send ruirib a Yahoo! Message
Did you use the RC=5 querystring option?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

jwhite
New Member

51 Posts
Posted - 01 May 2006 :  15:33:16  Show Profile
yes.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 May 2006 :  15:39:33  Show Profile  Send ruirib a Yahoo! Message
Make sure you are not using a cached version of that page by refreshing the page with CTRL+F5. With RC=5 all your tables were recreated, which means that the table error should have gone away. Likely you're just seeing a cached version of the page, so try force a page refresh.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

jwhite
New Member

51 Posts
Posted - 01 May 2006 :  15:48:57  Show Profile
Still not go.

I have 16 tables in my data base. Should there be more?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 May 2006 :  15:58:13  Show Profile  Send ruirib a Yahoo! Message
Yeah, 16 tables are what a newly created forum should have. What error message are you getting now?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

jwhite
New Member

51 Posts
Posted - 01 May 2006 :  16:05:14  Show Profile
when I log into admin options I get.

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

[MySQL][ODBC 3.51 Driver][mysqld-5.0.18-nt]Table 'dandjelectrical2.forum_members_pending' doesn't exist

/forum/admin_home.asp, line 49

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 May 2006 :  16:09:26  Show Profile  Send ruirib a Yahoo! Message
Where did you check the number of tables? Can you use the same strategy to verify whether that table does indeed exist? What tool are you using for this?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

jwhite
New Member

51 Posts
Posted - 01 May 2006 :  16:22:33  Show Profile
I am using the interface provided by my service provider.

I do not see forum_members_pending

This is what I have:

forum_allowed_members
forum_a_reply
forum_a_topics
forum_badwords
forum_category
forum_config_new
forum_forum
forum_groups
forum_group_names
forum_members
forum_moderator
forum_namefilter
forum_reply
forum_subscriptions
forum_topics
forum_totals
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 May 2006 :  16:30:43  Show Profile  Send ruirib a Yahoo! Message
Can you use that interface to remove all the tables and then run setup.asp again?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

jwhite
New Member

51 Posts
Posted - 01 May 2006 :  16:33:19  Show Profile
I have done that a couple times.
Go to Top of Page

jwhite
New Member

51 Posts
Posted - 01 May 2006 :  16:34:45  Show Profile
then I had the server create a new db and tried that.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 May 2006 :  16:38:21  Show Profile  Send ruirib a Yahoo! Message
So the table is not yet being created, but you get no errors when you run setup.asp?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

jwhite
New Member

51 Posts
Posted - 01 May 2006 :  16:43:13  Show Profile
If I run the program from scratch I get the error that I stated in the very first message of this thread followed by a very long line of code.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07