Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Posting dates appearing with ? characters
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Posting dates appearing with ? characters

 Post Reply Post Reply
Author
kcsheets View Drop Down
Newbie
Newbie
Avatar

Joined: 20 February 2008
Location: Illinois
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote kcsheets Quote  Post ReplyReply Direct Link To This Post Topic: Posting dates appearing with ? characters
    Posted: 20 March 2008 at 3:50am
The following is an example of how all my posting dates are showing in my forum

March�17�2008 at 7:41pm

Any idea on how to fix this.  I was originally running a version 7.xx Access forum and then upgraded the Access database to V. 8 then V.9.  I then used Navicat v.8 to migrate the Access v.9 data over to MySQL.  I am running WebWizForums 9.08 and my dates all show this way for posts before and after the conversion to MySQL.

http://ipvmc.net/forums/
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 20 March 2008 at 11:13am
This is a character encoding issue. You can either edit the includes/setup_options_inc.asp file and change the page encoding, or log into the admin area and resubmit the time and date settings so they are saved with the correct page encoding.

You should also be aware that mySQL uses a very different database scehma to Access or SQL Server so an Access to mySQL conversion is not supported and you will more likly end up with an unstable database.

You should look instead at using Micrososfts Access upsize wizard to Upsize the database to from Access to SQL Server as the database schemas between the two are very similar.
Back to Top
kcsheets View Drop Down
Newbie
Newbie
Avatar

Joined: 20 February 2008
Location: Illinois
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote kcsheets Quote  Post ReplyReply Direct Link To This Post Posted: 27 March 2008 at 3:48pm

After I got my "Access Denied" problem mostly solved (it's still happens occasionally), I tried updating the date setting on the date and time panel.  I had set the separator to <space> and all it did was squeeze the month, day and year together: January122008.  After that I just decided to work around that problem by changing it to a mm/dd/yyyy format which worked.

Unfortunately, it only looks right when I'm signed in as the administrator.  When I sign in as a regular member the format is dd/mm/yyyy.  Any idea why it is correct for the admin id and wrong for regular forum members?
Back to Top
kcsheets View Drop Down
Newbie
Newbie
Avatar

Joined: 20 February 2008
Location: Illinois
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote kcsheets Quote  Post ReplyReply Direct Link To This Post Posted: 27 March 2008 at 3:53pm
Never mind.  I forgot about the the person profile settings in the member control panel.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.