Welcome to Geeklog, Anonymous Thursday, November 28 2024 @ 12:54 am EST

Geeklog Forums

Problem adding story.


PSLking

Anonymous
hopeful
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.
 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