Show Posts
1
Installation, Update & Configuration / Since I have changed of server, I get strange database errors in my browser
« on: December 16, 2005, 12:35:41 PM »
English:
Since I have changed of server, I get strange errors in my browser.
I have changed server of IIS to APACHE.
On IIS worked everything perfectly, and had no errors in script.
I now get errors which I will show below.
I think that it is due to my configuration of my server.
Is it possible do has with the version of PHP or MYSQL?
Does that make much difference?
Below the errors I cannot which translate because he asks names from the database which does not exist.
What can be wrong?
Deutscher:
Da ich vom Bediener geändert habe, erhalte ich merkwürdige Störungen in meiner Datenbanksuchroutine.
Ich habe Bediener von IIS zu APACHE geändert.
Auf tadellos bearbeitetem IIS alles und hatte keine Störungen im Index.
Ich erhalte jetzt Störungen, die ich unten zeige.
Ich denke, daß er an meiner Konfiguration meines Bedieners liegt.
Ist es hat mit der Version von PHP oder von MYSQL möglich?
Unterscheidet das viel?
Unterhalb der Störungen kann ich nicht, die übersetzen, weil er um um Namen von der Datenbank bittet, welches nicht besteht. Was kann falsch sein?
Error:
DB Error: Bad SQL Query: SELECT DISTINCT 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, 14, 1, 15, 10, 30, 6, 11, 12, 19, 20, 17, 13, 18, 23, 21, 22) AND c.cat_id = i.cat_id ORDER BY RAND()
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 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 NOT IN (0, 14, 1, 15, 10, 30, 6, 11, 12, 19, 20, 17, 13, 18, 23, 21, 22) ORDER BY i.image_date DESC LIMIT 3
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\Server\www\meetyou\includes\db_mysql.php on line 116
Line 116 at db_mysql:
return mysql_num_rows($this->query_id);
I work with mysql 5.0.16 and php 5.1.1
Since I have changed of server, I get strange errors in my browser.
I have changed server of IIS to APACHE.
On IIS worked everything perfectly, and had no errors in script.
I now get errors which I will show below.
I think that it is due to my configuration of my server.
Is it possible do has with the version of PHP or MYSQL?
Does that make much difference?
Below the errors I cannot which translate because he asks names from the database which does not exist.
What can be wrong?
Deutscher:
Da ich vom Bediener geändert habe, erhalte ich merkwürdige Störungen in meiner Datenbanksuchroutine.
Ich habe Bediener von IIS zu APACHE geändert.
Auf tadellos bearbeitetem IIS alles und hatte keine Störungen im Index.
Ich erhalte jetzt Störungen, die ich unten zeige.
Ich denke, daß er an meiner Konfiguration meines Bedieners liegt.
Ist es hat mit der Version von PHP oder von MYSQL möglich?
Unterscheidet das viel?
Unterhalb der Störungen kann ich nicht, die übersetzen, weil er um um Namen von der Datenbank bittet, welches nicht besteht. Was kann falsch sein?
Error:
DB Error: Bad SQL Query: SELECT DISTINCT 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, 14, 1, 15, 10, 30, 6, 11, 12, 19, 20, 17, 13, 18, 23, 21, 22) AND c.cat_id = i.cat_id ORDER BY RAND()
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 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 NOT IN (0, 14, 1, 15, 10, 30, 6, 11, 12, 19, 20, 17, 13, 18, 23, 21, 22) ORDER BY i.image_date DESC LIMIT 3
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\Server\www\meetyou\includes\db_mysql.php on line 116
Line 116 at db_mysql:
return mysql_num_rows($this->query_id);
I work with mysql 5.0.16 and php 5.1.1
