Episode Guide database bugs
Malcolm in the Middle Voting Community Forum Episode Guide Gallery Watch & Download Episodes Home FAQ About Contact Home Store




Results 1 to 4 of 4

Thread: Episode Guide database bugs

  1. #1
    Join Date
    Apr 2008
    Location
    The Netherlands (i.e. 'Holland') ;)
    Age
    45
    Posts
    6,439

    Default Episode Guide database bugs




    Hi,

    I've been noticing this for over a week now. Whenever I go to the Episode Guide, I get MySQL database selection errors, and I can't access any individual seasons or episodes, like this:

    DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 2, 5, 6, 7, 8, 10, 12) ORDER BY i.image_rating DESC, i.image_votes DESC
    Unknown column 'i.user_id' in 'on clause'


    Any clue? I hope so!

    Richard



  2. #2
    Join Date
    Apr 2008
    Location
    The Netherlands (i.e. 'Holland') ;)
    Age
    45
    Posts
    6,439

    Default

    I guess the reply would be to go to the new layout at:

    http://www.malcolminthemiddle.co.uk/episode

    So the URL without the 's' at the end of 'episodes'?

    I wasn't aware it was hidden in one of the 'sticky' threads.

    Could you announce it on the home page or change the link, please?

    Thank you!

    Richard

  3. #3
    Join Date
    Jan 2005
    Location
    UK
    Age
    32
    Posts
    6,434

    Default

    Sadly the episode guide is broken. And there will be no fix. The fix will come in the way of the NEW episode guide, which is being worked on.

    Sorry about this, but its not worth the time fixing the old one, time needs to be spent on the new one.

    It's not linked to yet because its not really done.

    But I guess its better then the state of the old episode guide. I'll probs change the link over soon.
    Last edited by tjpeople; Aug 15, 2008 at 06:41 PM.
    Need help? Email Me Here

  4. #4
    Join Date
    Apr 2008
    Location
    The Netherlands (i.e. 'Holland') ;)
    Age
    45
    Posts
    6,439

    Default

    Quote Originally Posted by tjpeople View Post
    Sorry about this, but its not worth the time fixing the old one, time needs to be spent on the new one.
    Thanks, TJ!

    I guess as long as all the 'old' content can be retrieved and loaded into the new database, it's okay.

    I'll be patiently looking forward to 'Mark II'.

    Rich

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •