4

I've been working on a site for about a year now without issue. There's a good number of channels and entries (about 11/2000+). Within that last couple weeks, I seen something strange happen. The channel ID's in the database seem to be in correct.

An example:

  • Vendors channel_id = 4 in the exp_channels table
  • in exp_channel_titles, channel_id 4 correlates to the title for the blog channel (channel 5).

Has anyone ever experienced this before? I'm trying to go through and fix this, but it's now causing more issues (IE: when you go to a page with a safecracker form it's not pulling in the channel fields for that channel).

Have I completely screwed myself? How can I fix this?

Thanks!

  • Did you mean the channel_id's are incorrect? Not sure how that is even possible unless someone altered the datatables or some custom add-on. What happens if you use a SQL client and update the channel_id's in the exp_channels table to what they should be? Are all the entries in the exp_channel_titles table match up 1-to-1 with the correct channel? I guess I would try to see if it's just a few entries or ALL of them is effected. – Justin Kimbrell Nov 15 '12 at 20:28
  • Hey Justin, Yeah I tried this but now I'm getting more funky stuff going on. Like I said, when I go to a safecracker form on the frontend, it show's the channel field short name, instead of the actual value. – Lucas Hibbard Nov 15 '12 at 20:34
  • I have never seem anything like that. Unless, as Justin Kimbrel says, something deliberately programmed did this, there must have been a serious glitch in the server. I suppose there are no older backups to look at? I can't see how EE can do this by itself without action at the DB level. – John de Beer Nov 15 '12 at 20:59
  • I was able to fix this by going through each channel in the CP and re-updating them to be pointing to the correct channel fields. Not sure how this happened, but it's fixed now. Thanks both Justin and John for the advice. – Lucas Hibbard Nov 15 '12 at 21:16
5

Lucas fixed his issue and I quote:

I was able to fix this by going through each channel in the CP and re-updating them to be pointing to the correct channel fields.

  • Nice answer, you deserve +10 rep for that :) – Adrian Macneil Nov 16 '12 at 6:31
  • Thanks! Wonder what's the best way to encourage Questioners to provide the answer after they have figured it out on their own and set it as the correct answer? – Natetronn Nov 17 '12 at 7:15
  • You could tell them in the comments they should post their solution. Or just jump in and take credit for it yourself :) – Adrian Macneil Nov 17 '12 at 7:32
  • I would have, but I couldn't due to a 24 hour limit placed on the poster of the question answering. – Lucas Hibbard Nov 19 '12 at 20:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.