Error when Trying to make new post or Forum

Involved Joined: Jul 12, 2005 Posts: 283

I get an error when i try to make a new forum or post, i didnt change anything, site was working fine.

My site is gamerbomb.com

here is the error when i try to post:

Error in posting

DEBUG MODE

SQL Error : 1062 Duplicate entry '0' for key 1

INSERT INTO nuke_bbtopics (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote) VALUES ('Welcome to all the new members coming.', 2, 1192542593, 1, 0, 0, 0)

Line : 227
File : functions_post.php

Posted: Mon Oct 15, 2007 8:22 am

I cant do anything, i cant have people register now etc.

Just says error...

Anyone?

Posted: Mon Oct 15, 2007 8:23 am

Even on a post i made, when i click on it, it says "cant find post"...

Weird, i didnt change anything, it was working, then this happened....

registered · Posted: Tue Oct 16, 2007 5:15 am

Something HAD to change. Maybe check that table within phpMyAdmin and try to do a repair on it. The autoindex may also not be correct. Check to see what you largest topic_id is and then make sure the autoindex value is one greater than that.

Posted: Tue Oct 16, 2007 6:27 am

I know this is off the top but...

I have a module thats "in home" how do i get it not to be "in home" when i hit edit, its still there....and dosent give me the option to not put it "in home"

Posted: Tue Oct 16, 2007 10:20 am

You need to tell Nuke to put one of your other modules in home, by clicking 'Put In Home' link next to module you want displayed in Home.

Posted: Tue Oct 16, 2007 11:38 am

Perfect that worked.

Now i cant seem to make any more forum catagories, or make new "news" items Sad

Posted: Tue Oct 16, 2007 12:00 pm

Yeah, cant add new advertisers, or make new banners, i can make new blocks etc.

it looks like it made it but just blinks, and goes back to page...

registered · Posted: Tue Oct 16, 2007 1:49 pm

Enable error reporting in config.php and check your server error logs.

registered · Posted: Tue Oct 16, 2007 3:17 pm

I am helping debug jjmusicpro's site. Looks like none of the tables have their AUTO_INCREMENT status anymore. I am fixing these as I find them, it should explain all the errors he has.

Posted: Wed Oct 17, 2007 5:41 am

evaders99, you are a saint.

That is really strange. I have never heard of mySQL just dropping / corrupting these (at least in these forums), so this is definitely a new one.

I can see it happening if this was a moved site where there was an export/import done, or maybe on a restore, but it sounded like this was running just fine one day and puking on itself the next.

Am definitely interested in hearing more about what might have caused this.

Subject Matter Expert Joined: Feb 23, 2004 Posts: 358

The auto-increment is definitely an OPTION when doing an export. I'll wager he opted not to export it with the data... = D

PHrEEk

Posted: Wed Oct 17, 2007 4:47 pm

I'm really not sure, but I will ask if this is a recent import. As far as I can, all the other data works fine. It already has all the index data.