Thread

A project I’m working on involved a directory with more than 27,000 entries. Rather than manually entering each one by hand, I imported a CSV into the database by use of a third-party MySQL client. I made sure the entry numbers synced and were unique, and running “SELECT COUNT(DISTINCT(entry_id)) FROM “exp_weblog_titles’” produces the correct number of entries that should be there, but when I go to the Edit screen, it says the weblog is empty. Meanwhile, on the front-end, I can view the missing entries just fine.

Vince, when you create a new entry, you need to write rows to both the exp_weblog_data and exp_weblog_titles tables.

Do you have the same number of entries in each table?

Ah! I see that my exp_weblog_titles table has 27876 entries while my exp_weblog_data table has 27893 entries. If I track down the rogue exp_weblog_data entries (or, perhaps, the missing exp_weblog_titles entries), it should solve the problem?

You will also have to make sure that your custom fields match up.

How many fields are in the rows you are importing? Have you created the custom fields in EE yet?

This can often times be very tricky… Have you seen this Wiki Article? It may be a lot easier than trying to import directly into mysql.