Case senstive column names
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=15852
Printed Date: 13 April 2026 at 12:02pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Case senstive column names
Posted By: BobGandalf
Subject: Case senstive column names
Date Posted: 15 July 2005 at 2:47pm
|
Hi,
Ive been trying out this software, and have installed the SQL server version, ive done the set-up, and most things appear to work, but whenever i try and change Forum Permissions, or do things like Edit the administrator password, the .asp pages return an error. New posts and registrations happen fine, so the connection to the Database must be ok..
The Error i get is i.e on forum_group_permissions.asp, line 117, Invalid Column name Cat_ORDER ... Looking in the database, the field is Cat_Order , with lowercases. If i edit the PHP file, it works fine, so i assume this is the nature of the error.
I would go through and manually change all the instances to be in the right case, but theres a lot of errors, not only regarding this column, but ones in other tables as well,,,
Could there be something wrong with the setup of my DB or Table on the SQL server?
Thanks,
David
|
Replies:
Posted By: michael
Date Posted: 15 July 2005 at 10:56pm
First of all if you edit a php file you are posting at the wrong forum  . If your columns are case sensitive, you sql server database most likely has been installed with the wrong collation. Have your host setup a database with the collation of Lating case-insensitive.------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |