Author Topic: Problema con MySQL Version 5.0.15  (Read 5030 times)

0 Members and 1 Guest are viewing this topic.

Offline drizzt24

  • Pre-Newbie
  • Posts: 1
    • View Profile
Problema con MySQL Version 5.0.15
« on: November 21, 2005, 05:28:22 AM »
Buenas a todos y antes de nada enviar mi agradecimiento a quien me sirva de ayuda...
El problema que tengo es que si instalaba 4images empleando mysql version 4 y pico, no tenia problema, me funcionaba a la perfeccion, pero sin embargo ahora con la version 5.0.15 me aparece el siguiente error en la parte superior de la pantalla:

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 i.cat_id NOT IN (0) AND c.cat_id = i.cat_id LIMIT 0, 1
Unknown column 'i.user_id' in 'on clause'


y no encuentro la solución... ¿Alguien tuvo el mismo problema o puede ayudarme...?

Muchas gracias...

Offline f1do

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: Problema con MySQL Version 5.0.15
« Reply #1 on: November 24, 2005, 12:54:28 AM »
Me parece que hay que cambiar en /includes/functions.php
Esto
Code: [Select]
FROM ".CATEGORIES_TABLE." i, ".IMAGES_TABLE." cpor:
Code: [Select]
FROM ".CATEGORIES_TABLE." c, ".IMAGES_TABLE." i
Si no es eso, leete este thread http://www.4homepages.de/forum/index.php?topic=10184

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: Problema con MySQL Version 5.0.15
« Reply #2 on: November 24, 2005, 09:32:55 AM »
Me parece que hay que cambiar en /includes/functions.php
Esto
Code: [Select]
FROM ".CATEGORIES_TABLE." i, ".IMAGES_TABLE." cpor:
Code: [Select]
FROM ".CATEGORIES_TABLE." c, ".IMAGES_TABLE." i
Si no es eso, leete este thread http://www.4homepages.de/forum/index.php?topic=10184
a-a

Code: [Select]
FROM (".CATEGORIES_TABLE." c, ".IMAGES_TABLE." i)
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline excitex2

  • Addicted member
  • ******
  • Posts: 1.590
  • He desactivado la galería y el buscador
    • View Profile
Re: Problema con MySQL Version 5.0.15
« Reply #3 on: November 24, 2005, 05:48:52 PM »
Lo importante no es saber,,, lo importante es tener el E-Mail de quien sabe