Database Error

[bravely]

Hello,

 

I am having a problem with installation. I want to store sessions in the database. I had this working before, but I asked my host to move my account to a secure server. Now when I install, I get 1 page view on admin before the whole thing crashes and 1 page view on catalog before that crashes.

 

The admin screen just gives me:

 

1064 - You have an error in your SQL syntax near 'h'? ' at line 1

h'? ??#<#??#codelanguages where code = ''

[TEP STOP]

 

after viewing just one page. The catalog page just gives me an Internal Server Error after the first page view. I know this is a problem with sessions because I can delete the session from the database and the store again gives me one page and then crashes. I know the sessions can be saved in a file, but I am running into a problem there too so I prefer to go with sessions in the database.

 

Here's my database session entry:

 

sesskey:

06305a6dfa8d24686fbd90f3310bdac4

 

expiry:

1037647947

 

value:

language|s:7:"english";languages_id|s:1:"1";selected_box|s:5:"tools";

 

And that's it. Should there be more fields in the session table? Are there any illegal characters in the entry? Any Ideas?

[bravely]

I deleted the session and tried admin again to see what changes on the error screen. After 1 page view, I get this (which is the same in some respects, and different in others):

 

1064 - You have an error in your SQL syntax near 'h'? ' at line 1

h'? ?"lN"<?"codelanguages where code = ''

[TEP STOP]

[Guest]

I'm having the same problem running on my dev server (Win XP/Apache 2/MySQL 3.23/PHP 4.2.3)

 

1064 - You have an error in your SQL syntax near 'h'? ' at line 1



h'? ?j??_?`k?codelanguages where code = ''



[TEP STOP]