Hi all,
I’m having the same problem as nexia, my sticky posts are lost to view. Had a look in PHPmyAdmin (2.5.5-pl1) and the “sticky” status doesn’t show in the wp-posts table. If I try to modify it in by hand or import a text file as described above but replacing “b2posts” by “wp-posts”, I get this error message :
ALTER TABLE wp_posts
CHANGE post_status
post_status
ENUM( ‘publish’, ‘draft’, ‘private’, ‘sticky’, ) DEFAULT ‘publish’ NOT NULL
MySQL a répondu:
#1064 – You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) DEFAULT ‘publish’ NOT NULL’ at line 1
I’ve had a look at the doc but I’m afraid I’m too much of a newbie to figure this one out. If anyone can help?
This is the version n° : MySQL 4.0.16-standard
Thanks.