The Joyent Community

A place where the Joyent community can gather, help each other out, and stay informed.

You are not logged in.

  • Index
  •  » WordPress
  •  » Wordpress not assigning post_id numbers to posts

#1 2007-12-24 06:05:09

cbassman
New member
From: Chicago, IL
Registered: 2007-12-16
Posts: 2
Expertise

Wordpress not assigning post_id numbers to posts

Hi everybody,

My wordpress installation (I used the default install of 2.3 available as an install script on the marie server) is not assigning post_id numbers to new posts. It assigns a value of "0", and I am then unable to view or edit the post unless I go into phpMyAdmin and manually edit the record to have a valid post_id number.

I did an import of my existing MySQL database from my old hosting provider once I had the install set up on this server, and that is the only thing I imported. Everything else seems to be running smoothly, I just can't figure out why wordpress is not assigning actual post_id numbers to new entries.

Any help that anybody can provide would be greatly appreciated. I found no related issues on the wiki or forums, or even on wordpress' site.

Thanks for reading this.
Cbassman

Offline

 

#2 2007-12-24 13:07:15

Andy
Dabbler
From: London
Registered: 2005-01-15
Posts: 1177
Website  Expertise

Re: Wordpress not assigning post_id numbers to posts

It sounds like you're having a problem with auto_increment not being dumped/loaded. Take a look at the dump file; is that the case?


— Andy (andrewlkho)

Offline

 

#3 2007-12-25 17:06:20

cbassman
New member
From: Chicago, IL
Registered: 2007-12-16
Posts: 2
Expertise

Re: Wordpress not assigning post_id numbers to posts

Andy, that was EXACTLY it. A closer look at the SQL table showed that the ID field was not set to auto increment. I changed this, and now it works perfectly.

Thanks for the suggestion!

Offline

 

#4 2007-12-26 17:36:20

Andy
Dabbler
From: London
Registered: 2005-01-15
Posts: 1177
Website  Expertise

Re: Wordpress not assigning post_id numbers to posts

No problem, glad to hear it worked out. IIRC, it's quite easy to set options in mysqldump such that it doesn't dump stuff like that.


— Andy (andrewlkho)

Offline

 
  • Index
  •  » WordPress
  •  » Wordpress not assigning post_id numbers to posts

Board footer

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson