Author Topic: MySQL-Problem  (Read 6228 times)

0 Members and 1 Guest are viewing this topic.

Offline alterego

  • Pre-Newbie
  • Posts: 3
    • View Profile
MySQL-Problem
« on: September 07, 2006, 02:47:35 PM »
Das Projekt lief einwandfrei. Nun gint's folgende Fehlermeldung:

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 systemiker_images i, systemiker_categories c LEFT JOIN systemiker_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 129, 1
Unknown column 'i.user_id' in 'on clause'

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 systemiker_images i, systemiker_categories c LEFT JOIN systemiker_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 NOT IN (0) ORDER BY i.image_date DESC LIMIT 5
Unknown column 'i.user_id' in 'on clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /pages/d6/66/d0002642/home/htdocs/diesal/bil_sys/includes/db_mysql.php on line 116

www.perspektiven.info/bil_sys


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: MySQL-Problem
« Reply #1 on: September 07, 2006, 02:56:43 PM »
FAQ
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 alterego

  • Pre-Newbie
  • Posts: 3
    • View Profile
Re: MySQL-Problem
« Reply #2 on: September 07, 2006, 04:02:51 PM »
Mir wäre mehr geholfen, du hättest meine Frage beantwortet.

Ich habe in der Suche und nach reichlicher Recherche keinen Hinweis auf meinen Fehler gefunden.

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: MySQL-Problem
« Reply #3 on: September 07, 2006, 08:47:29 PM »
hi,

keine files geändert?
tables alle da?
mysql update?

btw. du hast eine alte 4images. nicht ganz sicher ;)
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline alterego

  • Pre-Newbie
  • Posts: 3
    • View Profile
Re: MySQL-Problem
« Reply #4 on: September 07, 2006, 09:22:56 PM »
mysql update?

Doch, mysql update auf 5. Aber warum läuft das da nicht?

Offline e-trader_2002

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: MySQL-Problem
« Reply #5 on: September 07, 2006, 09:25:21 PM »
Hi,

try this:           http://www.4homepages.de/forum/index.php?topic=3102.msg71831#msg71831

Just add the parentheses ( around all table-names refered by from ) to all your mySQL-queries producing this error. This applies to most mySQL-queries with a  JOIN when using MySQL 5.0.12 or higher.

Greetings
e-trader_2002
A hobby is a great way to spent time you actually don't have! :wink: