| Author |
 Topic  |
|
|
505_medic
New Member
USA
54 Posts |
 Posted - 20 December 2005 : 12:06:25
|
It seems that every mod I run has difficulties...except for the one that I modified and tweaked around with.
The active users mod is working, but now I'm getting the following during the PM setup.
quote:
CREATE TABLE FORUM_PM( M_ID INT (11) DEFAULT '' NOT NULL auto_increment , M_SUBJECT varchar (100) NULL , M_FROM int NULL , M_TO int NULL , M_SENT varchar (50) NULL , M_MESSAGE text NULL , M_PMCOUNT varchar (50) NULL , M_READ int NULL DEFAULT 0, M_MAIL varchar (50) NULL , M_OUTBOX smallint NULL DEFAULT 1,KEY FORUM_PM_M_ID(M_ID))
CREATE TABLE FORUM_PM( M_ID INT (11) DEFAULT '' NOT NULL auto_increment , M_SUBJECT varchar (100) NULL , M_FROM int NULL , M_TO int NULL , M_SENT varchar (50) NULL , M_MESSAGE text NULL , M_PMCOUNT varchar (50) NULL , M_READ int NULL DEFAULT 0, M_MAIL varchar (50) NULL , M_OUTBOX smallint NULL DEFAULT 1,KEY FORUM_PM_M_ID(M_ID))
-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.15-nt]Invalid default value for 'M_ID'
With the active users, thinking it was just a screwy thing...I updated the rest of the files. The forum still loads, but on the main page I get the following:
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.15-nt]Table 'seehawk98.forum_pm' doesn't exist
/forums/privatemess.asp, line 65
So something did go wrong. I searched the forum here to find answers, but have found nobody else with the same problems. Perhaps I'm not meant to mod the forums?? LOL.
Jon
-Edit: I forgot to put the information in that is required. Its Snitz 3.4, the PM variant is the downloadable from SnitzBitz...don't remember the exact file name, but it was 3.305-3.5 or something in that namesake.
Forum address is http://www.silent-knights.com/forums |
http://www.silent-knights.com/forums
Mods Utilized: Active Users 4.0, Customized Icons, Customized Ranks, Private Messaging, Split Topics, IP Search, Custom Policy, Custom FAQ |
Edited by - 505_medic on 20 December 2005 12:11:16 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
505_medic
New Member
USA
54 Posts |
Posted - 20 December 2005 : 15:14:53
|
Thanks so much for it. I think the remaining installs are fairly simple, so I can hopefully proceed independantly. I feel really bad posting these kinds of basic questions. I've learned enough to know that they're basic...not enough to know how to fix them.
Jon |
http://www.silent-knights.com/forums
Mods Utilized: Active Users 4.0, Customized Icons, Customized Ranks, Private Messaging, Split Topics, IP Search, Custom Policy, Custom FAQ |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Hopeful
Junior Member
130 Posts |
Posted - 30 December 2005 : 05:53:17
|
My server upgraded to mysql 5.0 and I am getting the same error:
Table 'username.forum_pm' doesn't exist
/forum/inc_header.asp, line 300
Can you please tell me how to get the correct tables installed in the database?
Do I need to change a line of code or something?
All help appreciated!
Thanks!
|
Please explain everything in layman terms!!! |
|
|
|
Martin Hazel
Starting Member
9 Posts |
Posted - 04 January 2006 : 06:28:30
|
| I had the same problem in the end I just ended up creating the tables manualy that resolved that problem at least. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 04 January 2006 : 06:50:05
|
if you are all getting the same problem when installing then something needs to be fixed in the dbs file which creates the tables, according to 505_medic mysql does not seem to like this
M_ID INT (11) DEFAULT '' NOT NULL auto_increment
my gues would be to remove the DEFAULT '' |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 January 2006 : 08:47:53
|
quote:
Originally posted by HuwR
if you are all getting the same problem when installing then something needs to be fixed in the dbs file which creates the tables, according to 505_medic mysql does not seem to like this
M_ID INT (11) DEFAULT '' NOT NULL auto_increment
my gues would be to remove the DEFAULT ''
Yes, that is the fix. MySQL versions >= 4.0 (not sure) or >=4.1 (definitely) don't like this syntax. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Martin Hazel
Starting Member
9 Posts |
Posted - 06 January 2006 : 02:35:32
|
| removing the default was pretty much what I did when manually creating the tables |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 13 January 2006 : 14:16:27
|
| MySQL has removed the DEFAULT syntax from the CREATE table for the field that is listed as auto_increment because I guess it is pointless. Auto Increment fields are automatically integer fields and start at 0. So no need to be setting a default value for it. Hence why they took it out. |
Support Snitz Forums
|
|
|
| |
Topic |
|
Topic Locked
