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

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 BUG+FIX (All Versions) M_COUNTRY field too small
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 07 August 2001 :  22:05:25  Show Profile  Visit HuwR's Homepage
The M_COUNTRY field is set to a size of 20 chars, but some of the counties in the dropdown are longer than this, would suggest setting it to something larger.

Deleted
deleted

4116 Posts

Posted - 16 August 2001 :  18:57:55  Show Profile
Waiting for related code changes for v40b02.

Think Pink
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 17 August 2001 :  00:37:30  Show Profile  Visit gor's Homepage
<!-- bump -->

Pierre
Join a Snitz Mailinglist
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 07 November 2001 :  22:44:56  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
*bump* - was this attended to?

---------------
-Da_Stimulator
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 07 November 2001 :  23:30:18  Show Profile
in inc_create_forum_mysql.asp on line #130

Change this:

strSql = strSql & "M_COUNTRY VARCHAR (20) DEFAULT '' , "


to this:

strSql = strSql & "M_COUNTRY VARCHAR (50) DEFAULT '' , "



in inc_create_forum_sqlx.asp on line #102

Change this:

	strSql = strSql & "M_COUNTRY varchar (20) NULL , "


to this:

	strSql = strSql & "M_COUNTRY varchar (50) NULL , "



Also, we'll need to change it in the Access DB that is included with the download. We'll need to update the dates for the default stuff in there as well, so this can wait until right before we release the new version.
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 07 November 2001 :  23:34:06  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Ok, but should I include the sql server fixes for the bug fix release?

---------------
-Da_Stimulator
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 07 November 2001 :  23:39:40  Show Profile
yes.
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 08 November 2001 :  00:20:21  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Fixed for 3.4

---------------
-Da_Stimulator
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 11 November 2001 :  09:49:48  Show Profile
Will this also upgrade existing forums?

Think Pink
Test Site not ready yet | Post v40b03 Patches
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 13 November 2001 :  14:47:22  Show Profile
we will have code in setup.asp for upgrading existing forums.
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 01 December 2001 :  10:26:03  Show Profile
To support multilingual forums, its not a good practice to keep string data in the database. I suggest that the database contains three letter country codes only and the related code interpretes these codes to output actual country names.

Think Pink
Test Site not ready yet | Post v40b03 Patches
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 01 December 2001 :  10:32:14  Show Profile
inc_create_xxx.asp related ones fixed in [v40b03patch001]...

Think Pink
Test Site not ready yet | Post v40b03 Patches
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07