Thread

Hi Paul,

Many thanks for the information there. I’m going to let the DEVs know internally about this one.

Ditchmonkey I’m just wondering if the information above from Paul helps in your situation at all?

Thanks all.

Mark

No I’m not an expert at the inner workings of EE. I’m going to need some help with this. I’m leaving town for a week but when I get back maybe I can hire Paul to help me out.

If you have about an hour today, you can send me CP and FTP login information.  I can probably pop in there real quick and see if it is the same problem.

Ditchmonkey, did you by any chance use DataGrab to add any entries?

Ditchmonkey- to see if it’s the same issue, you can check it pretty quickly.

Go to ‘Tools- Data- SQL Data’ in the control panel.  Select ‘Database Query Form’.

Put the following query in there:

SELECT * FROM exp_category_posts WHERE entry_id = 0

Do you get any results?  If you do- it’s the same problem.

To fix it:
1.  Back up your exp_category_posts table using phpmyadmin or something similar.  This is something you always want to do when manipulating the database directly, even for something as low risk as this query.
2.  Run the following query in the query form:

DELETE FROM exp_category_posts WHERE entry_id = 0

It should tell you how many rows were affected.  And if it’s the same issue, that should solve it.

It does of course leave the question of how those entries got in there.  I’d be tempted to run this query just to make sure the entry tables are looking clean:

SELECT * FROM exp_channel_titles WHERE entry_id = 0
and
SELECT * FROM exp_channel_data WHERE entry_id = 0

If you do have entry_id’s 0 in the category post table, probably a good idea to do the above double check.  But if you find any with a bad entry id in channel titles or channel data?  Don’t delete it!

ETA- and Sue is right on the money.  Have you imported any data?  That’s typically how I’ve seen that cat table get ‘off’.

That fixed it thanks. I don’t know what data grab is but we have been inserting a lot of records directly into the database (bypassing EE) with a custom script of our own.

Glad that did the trick- and I’d take a close look at the custom script- make sure it’s not populating the cat table w/entry_id 0’s.  For one- it will cause the above problem.  And for 2 - you might be losing your cat data in the import!

Glad that got you fixed up as well.  And if anyone runs into more issues?  Start up a new thread and we’ll be happy to pile in.