Snitz Forums 2000 - setup error 2147217871

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)

setup error 2147217871

New Topic

Topic Locked

Printer Friendly

Author

Topic

Page: of 2

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 May 2006 : 16:47:17

Can you post a link to a text version of your inc_create_forum_mysql.asp file?

Snitz 3.4 Readme | Like the support? Support Snitz too

jwhite
New Member

51 Posts

Posted - 01 May 2006 : 16:52:54

http://dandjelectrical.com/forum/inc_create_forum_mysql.txt

but I have already put the red part back to try it again.

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 May 2006 : 17:07:43

Use this file, after changing its extension to .asp.
Delete all tables before trying setup.asp again.

Snitz 3.4 Readme | Like the support? Support Snitz too

jwhite
New Member

51 Posts

Posted - 02 May 2006 : 14:02:43

Sorry so long getting back ruirib.

I had to sleep, work a full day, then get back to this.

What ever you did worked. thanks for the help.

Is there a laymens way to explain what was wrong?

Edit to add: can I remove the text version of my file from my site now?

Edited by - jwhite on 02 May 2006 14:03:37

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 02 May 2006 : 22:56:43

What I did was add the change I suggested in my first post. You probably made some mistake while doing it.
Yes, you can remove the file now.

The error occurs because MySQL versions 4.1 or greater are much more restrictive with column default values than the previous versions. What I did was correct a default value of '' that should not be assigned to a numeric column.

Snitz 3.4 Readme | Like the support? Support Snitz too

Page: of 2

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.25 seconds.