Member Avatar for whitestream6

I have two databases, tvguide and episodes1.

Both are InnoDB, and I use Phpmyadmin to edit them.

I tried creating a foreign key between the "episode" field of episodes1 and tvguide, and this error message came up:

Error creating foreign key (check data types) : episode

How can I fix this and ensure both tables join? I have InnoDB set for both databases, so this shouldn't happen, but why?

Here are the table definitions:
episodes1 table: www.pastebin.com/54Cc5TNg
episodedata1 table: www.pastebin.com/AxWeHnkn

Otherwise, I have few issues with my PHP script, the pagination works fine, although some issues with that one [but not for this thread] and it's working well for now, so where have I gone wrong with the InnoDB for this?

  • 1 Contributor
  • 1 Reply
  • 94 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by whitestream6
Member Avatar for whitestream6

What would I do to fix this?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.