Welcome to Geeklog, Anonymous Thursday, November 28 2024 @ 12:54 am EST
Geeklog Forums
Problem adding story.
PSLking
Anonymous
I was running my Geeklog site on FC4. I managed to crash that box and have now migrated everything to my Server 2003 box running IIS with PHP 5. I created a new DB using the MySQL Server Administrator using the same name as the previous one on the FC4 box. I then restored the data from a backup I had created. Everything seems to be working now, except stories. When I log in and try to post a new story, I get:
An SQL error has occured. Please see error.log for details.
When I check the log file, I see:
1366: Incorrect integer value: '' for column 'statuscode' at row 1
It then shows the data and it looks like the "integer" is NULL. There is nothing in the (). I just did an upgrade to SR2 in hopes that might fix this, but no... If anyone can help, I would really appreciate it.
An SQL error has occured. Please see error.log for details.
When I check the log file, I see:
1366: Incorrect integer value: '' for column 'statuscode' at row 1
It then shows the data and it looks like the "integer" is NULL. There is nothing in the (). I just did an upgrade to SR2 in hopes that might fix this, but no... If anyone can help, I would really appreciate it.
22
6
Quote
All times are EST. The time is now 12:54 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content