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: MOD Implementation
 Poll MOD 2.0.7 - Table setup problems?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

bearclaw_leader
Starting Member

2 Posts
Posted - 16 February 2006 :  12:13:51  Show Profile
In trying to install the Poll MOD to a forum I set up on our Intranet, I keep getting the following in the Creating Tables area when I run the MOD setup:

-2147217871 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.14-nt]Invalid default value for 'POLL_ID'

After going ahead and adding the Poll code changes, my forum will work fine, but will get the following whenever I try anything with the polls:

[MySQL][ODBC 3.51 Driver][mysqld-4.1.14-nt]Table 'forum.forum_polls' doesn't exist

I've searched the forums but couldn't seem to find anything like these errors. Anyone else run into this before?

I'm running Snitz 3.4.05 on Server 2003 SP1 with MySQL 4.1.14 if that helps you out any.

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 16 February 2006 :  12:29:43  Show Profile
In your files admin_mod_dbsetup.asp and admin_mod_dbsetup2.asp, find the following code on lines 275 and 307 respectively and remove the code in red:
strSql = strSql & idFieldName &" INT (11) DEFAULT '' NOT NULL auto_increment "
Then run your poll mod setup file again.
Support Snitz Forums
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 16 February 2006 :  12:38:31  Show Profile  Visit AnonJr's Homepage
Never mind... Davio beat me to it....


Did you come across either of these topics in your search?

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=61017

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=60936 (the post by modifichicci down near the bottom)

I seem to remember there being some other topics on this same error, but I can't seem to find them at the moment....
Edited by - AnonJr on 16 February 2006 12:39:28
Go to Top of Page

bearclaw_leader
Starting Member

2 Posts
Posted - 16 February 2006 :  12:40:32  Show Profile
That worked beautifully, Davio!

Thanks so much for the quick reply! :)
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07