Print Page | Close Window

Installation woes

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27089
Printed Date: 02 April 2026 at 12:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Installation woes
Posted By: yandr
Subject: Installation woes
Date Posted: 10 March 2009 at 11:45am
I tried to install the latest edition (SQL Server 2005) by doing the following

  1. downloaded the package and unzipped it
  2. created an SQL Server 2005 database on the server and created a user to manage it
  3. modified the connection string in the webqiz package and uploaded the software
  4. I tried to run the Web Wiz Forums Database Microsoft SQL Server Setup but I get the following error message

file:///c:%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="nofollow - Error entering default values in the Table tblConfiguration
Invalid column name 'A_Code'.

Invalid column name 'A_Code'.
SQL Server database is set up, but with Error!

file:///c:%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="nofollow -

file:///c:%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="nofollow - The table are created but the thing does not work.

file:///c:%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="nofollow -

file:///c:%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="nofollow - Any ideas?




Replies:
Posted By: WebWiz-Bruce
Date Posted: 10 March 2009 at 2:18pm
Most errors are coursed by corrupted files during the upload process.

I would suggest deleting all the tables from the database, reuploaidng the forum files again, and then re-run the database setup on the empty SQL Server database.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: wb-in-wpb
Date Posted: 10 March 2009 at 3:56pm
It could also be the collating sequence for the database. If the database was created case sensitive, and the field somehow was created as a_code instead of A_Code then you could have that problem.


Posted By: yandr
Date Posted: 13 March 2009 at 8:08am
I found the error in you installation script.

The column is created as A_Code in the create table statement, but when the default value is inserted it is referred to as A_code.

When I fixed this I got the database running.

I dunno why other users haven't reported this error.


Posted By: WebWiz-Bruce
Date Posted: 13 March 2009 at 8:14am
Sounds like your SQL Server database has been setup to be case sensitive which is why you got this error.

It is extremely rare for an SQL Server database to use a case sensitive collation, which is why this has not been reported before.

I would suggest that you use a database that is not setup to be case sensitive as this would prevent other errors like this and also improve searches.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: yandr
Date Posted: 13 March 2009 at 8:19am
Yes, you are right this is the problem and it does come up in lots of other cases.

However, being a software engineer myself, I also consider bad practice to to refer to the same column, table or whatever with randomly assigned uppercase characters.

I would really suggest a fix in future versions.
It is extremely easy to fix this.

Thanks, case closed....


Posted By: WebWiz-Bruce
Date Posted: 13 March 2009 at 9:38am
Have tried to keep all table and field names the same case so that this issue does not happen and the one that you have bought up is fixed for the next release. You should not find any others but if you do then let us know.

Although having a non case sensitive collation would be advisable otherwise if users do searches within the forum system their searches will be case sensitive which may make it harder for them to find what they are looking for.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: yandr
Date Posted: 13 March 2009 at 12:35pm
A workaround if someone needs it, is:

ALTER database [YOURDBNAME] COLLATE Latin1_General_CI_AI



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net