Error Posting

chickens · Post by **chickens** » Fri Nov 02, 2007 3:30 am

I am trying to post something to my site and am getting - Error: Entries were not successfully inserted!

I am unable to post anything nor save. The only thing that I've changed as of the last post was installing the polling plugin. I've uninstalled that plugin and its still not working.

Steps to reproduce:
create new entry
save as draft; does not work but it does not error out
try to post; Error: Entries were not successfully inserted!
auto-save error: /!\ auto-save failed ;-(

Server: lighttpd with postgresql and the latest php version

If anyone wants more info let me know.

Thanks

chickens · Post by **chickens** » Fri Nov 02, 2007 3:53 am

I manually added a test post via phppgadmin and then everything started to work again. I also did a vacuum on the entries table which didn't seem to help.

I will post again if I figure anything out; its working now for me.

Post by **garvinhicking** » Fri Nov 02, 2007 11:59 am

Hi!

Maybe something with auto-increment keys?

Regards,
Garvin

chickens · Post by **chickens** » Wed Nov 07, 2007 2:44 am

bingo, it was the auto-increment. For some reason it was reset to around 20 instead of 200. I just hit my first post ID and had the script error out. I changed the auto-increment back to the right value and everything is back up and running great.

Thanks.