Knowledgebase
Home » Item #951
Pages are blank after logging into back end of my site (MS SQL)
Question
I have set up my site to connect to an MS SQL database. It seems to work fine until I login to the back end. At that point I just get blank pages. Even if I look at the front of the site, pages are blank.
The pages do not hang or timeout, page execution has finished but they are blank and contain no text when I view the source of the page.
Why is this and how can I fix it?
Answer
This seems to be related to date/time issues in MS SQL. It seems that logging in causes certain session code to run which causes a date/time error (although no error message is displayed). Because the session code runs prior to anything being written to the page, the termination of the script execution results in a blank page.
In all the cases where we have found this problem, the database is set to non-US regional settings, for example 'British' instead of 'English'. For uniformity, CactuShop is designed to use US defaults, and it may suffer date problems on databases set with different language settings.
The fix is to set your SQL database to use US settings. More information and instructions doing this can be found here:
[#592] Error: 'The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value'