Language error possibly ?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Pezzer Members Profile Find Members Posts Newbie Joined: 10 November 2007 Status: Offline Points: 7	Post Options Post Reply Quote Pezzer Report Post Thanks(0) Quote Reply Topic: Language error possibly ? Posted: 15 November 2007 at 5:07pm
	Have the most strange error occuring that I know must be easy to solve if it isnt then it will create some amusement When creating a post on my forum ( I'm new too by the way ) you can type every letter on your keyboard other than the £ sign. As soon as you press the pound sign and press to post the message you get the following error message Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Incorrect string value: '\xC2\xA3<br>...' for column 'Message' at row 1 /forum/edit_post.asp, line 505 Ok for those that are now thinking it's blah blah blah heres what I am running and using :- Dedicated Windows Server 2003 rackmount Fully updated and legal ! MySQL WebWiz 9 just purchased and licensed MySQL language set to Latin1 Rest of forum works fine other than one gripe about if you change something in somebodies profile it resets their password. We are a UK site and people want to use the £ sign on a items for sale part of the board. So getting error messages kinda kills the forum useage. Any ideas anyone? Edited by Pezzer - 15 November 2007 at 5:08pm

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 15 November 2007 at 7:15pm
	To be honest with you if you are running your own dedicated server, I would use SQL Server Express instead of mySQL. SQL Server Express is a free download from MS and can be used legally in a web hosting environment without paying additional licensing fees to Microsoft on top of your monthly SPLA licensing fees for Windows 2003 server.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Pezzer Members Profile Find Members Posts Newbie Joined: 10 November 2007 Status: Offline Points: 7	Post Options Post Reply Quote Pezzer Report Post Thanks(0) Quote Reply Posted: 15 November 2007 at 7:33pm
	So you think that MySQL is the issue then ? Just odd that it only the pound sign £ that throws up the error. Also the password problem of when you change the status of a user in their profile to move them from one group to another it wipes their password out, is that MySQL issue too ? To be honest after spending $129.99 on a product that proports to support MySQL to now be advised to get rid I don't really want to do. Is there no other solution ?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 16 November 2007 at 8:13am
	The reason I suggested using SQL Server is given the choice I would opt for SQL Server over mySQL on a Windows system using ASP and ASP.NET any day, as they work much better, and as you are on a dedicated server there is nothing stopping you installing SQL Server Express. mySQL is a good database, but the myODBC driver that you use for ASP to talk to the mySQL databases has allot to be desired with many strange and unusual bugs. Infact, try reinstalling the myODBC 3.51 driver to see if that fixes the issue. The mySQL version of Web Wiz Forums works fine with many 1,000's of users running it. We have over 100 users on our own systems using the mySQL version, some with over 500,000 posts with no issues at all. The bugs you mention seem very odd, no-one else has reported them and we are unable to replicate them in the lab. There is certainly a setting wrong on the server somewhere for the £ sign not to work in mySQL. If you want to stay with the mySQL version, then try reinstalling mySQL and the myODBC driver to see if that resolves the issue. Also check that the server is setup with UK locale settings.
	Web Wiz Forums Hosting ASP.NET Web Hosting

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 16 November 2007 at 8:22am
	Looking again at your error a \ is an escape character in mySQL, and the error message has \xC2\xA3<br> in it. This looks to be myODBC driver is trying to insert \xC2\xA3 into the database rather than £ or £ To me this looks like either a server encoding issue or an issue with the myODBC driver. We still use the myODBC 3.51.12 as we have found a number of issues with the newer drivers when used on Windows server 2003 SP2, with the IIS app pool crashing under load with the newer versions of this driver. You should also check the page encoding you have set for your forum, and in the server control panel, check the Regional Language Options are all set to English (united Kingdom) and you have ALL 'Code page conversion tables' installed on the server. Under the web edition these are all installed by default, but not with other version of Windows 2003 server.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Pezzer Members Profile Find Members Posts Newbie Joined: 10 November 2007 Status: Offline Points: 7	Post Options Post Reply Quote Pezzer Report Post Thanks(0) Quote Reply Posted: 16 November 2007 at 8:56am
	I will check all the above, thank you for looking into this for me.I will post back any results. The main reason for not wanting to swap from MySQL is that even tho I run the server SQL is way past me and I got someone to set mysql and the forum up for me. So to now swap means doing the same again and it took me weeks to get it done the first time. Also the forum is now live with posts and wouldn't want to loose all the data.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum