H E L P P L E A S E
I upgraded the server from windows server 2003 to windows server 2008.
I backed up the site directory and the data base and restored on the new server.
Since I cannot PUBLISH any entry at all.
Everything in control panel works. I can review and edit existing entries and it work fine.
However, when I add a new entry and press submit, it goes to next screen and does not show a preview of the new entry like it always did and the new entry is not listed when I press edit on the top.
When I looked at the error reporting I get the following error:
MySQL ERROR:
Error Number: 1366
Description: Incorrect integer value: ‘’ for column ‘entry_id’ at row 1
Query: INSERT INTO `exp_weblog_titles` (`entry_id`, `weblog_id`, `author_id`, `site_id`, `ip_address`, `title`, `url_title`, `entry_date`, `edit_date`, `versioning_enabled`, `year`, `month`, `day`, `expiration_date`, `comment_expiration_date`, `sticky`, `status`, `allow_comments`, `allow_trackbacks`, `forum_topic_id`, `dst_enabled`) VALUES (’‘, ‘1’, ‘1’, ‘1’, ‘184.19.90.71’, ‘Test123’, ‘test123’, ‘1355687528’, ‘20121216095309’, ‘y’, ‘2012’, ‘12’, ‘16’, ‘0’, ‘1358279528’, ‘n’, ‘open’, ‘y’, ‘y’, ‘0’, ‘n’)
By looking at the values in the tables this is what I am getting:
In table exp_category_posts it is not assigning and column entry_id : it is giving them a zero (0) id.
However, the entries are written into exp_weblog_data , but the entry_id are (0).
When I look into exp_weblog_titles there are no entries added.
I need help to resolve this please.
Thank you
(v1.6.6)