Thread

Hello. I recently moved a site to a new server. I imported the database and everything appeared to be fine. I needed to change some weblog entries to a new weblog/category scheme, so I used phpMyAdmin to change the weblog_id and category_id of several entries (or so I thought).

One entry in particular is giving me problems in the wake of this operation (I suspect that a lot of the entries will ultimately give me problems, but this is the first one I’ve run up against).

The entry was originally in a weblog called “news_general”. I moved it to a new weblog called “news” through a mySQL query (in phpMyAdmin). With a subsequent mySQL query (again, in phpMyAdmin), I tried to change the category id.

In the EE control panel, when I search for entries in the news_general weblog, this particular entry is returned. When I click through to the entry and check the weblog on the Options tab, the weblog is listed as “news” and it has no categories assigned. When I try to assign a category and update the entry, I get a blank screen (except for the control panel header and footer). And nothing I do seems to enable me to change the weblog (I tried moving it to another weblog temporarily so I could move it back into “news” but whenever I update, I just get that blank screen).

When I look in phpMyAdmin, it lists the entry as being in the “news” weblog.

Any thoughts on why this might be happening?

Thanks,
Frank

Frank, I’m going to assume you have good backups? The exp_category_posts table is pretty simple, it has only two columns, entry_id and cat_id. You may need to do a delete query in the database to remove the old category.

Which is why I asked about your backup status.

Try delete from exp_category_posts where entry_id = ‘1234’

where 1234 is your entry_id. Does that help?