Hi,
wie gehe ich nun am besten vor, um doch myqsl bzw. 1.5.0 nutzen zu können? Einfach files backupen, xampp 1.5.0 installieren und danach configs wieder hoch und db bzw. webspace files? oder ganz anders durchführen?
Database error in WoltLab Burning Board (2.3.3): Invalid SQL: SELECT t.threadid, t.boardid, x.title, x.boardid, t.prefix, t.topic, t.starttime, t.starterid, t.starter, t.lastposttime, t.lastposterid, t.lastposter, t.replycount, t.views, t.attachments, t.closed, t.important, t.pollid FROM bb1_threads t, bb1_boards x LEFT JOIN bb1_boards b ON (t.boardid=b.boardid) WHERE t.visible='1' AND t.closed <> 3 AND t.threadid <> 1782 AND b.password='' AND t.boardid=x.boardid AND t.boardid IN (0,1,2,4,6,7,8,9,10,11,5,12,66,13,14,15,16,17,23,24,25,26,28,29,30,31,70,18,19,20,65,21,22,32,33,34,35,36,37,38,39,62,53,54,55,60,63,57,58,59,61,42,43,56,64,68,44,52,69,45,46,47,48,49,50,51,40,41) AND (t.topic LIKE '%Server%' OR t.topic LIKE '%Update%') ORDER BY t.lastposttime DESC LIMIT 0, 5;
mysql error: Unknown column 't.boardid' in 'on clause'
mysql error number: 1054
mysql version: 5.0.15
php version: 5.0.5
Date: 05.11.2005 @ 10:06
Script: /thread.php?postid=20039#post20039
nubis wrote:Nur leider gehen die MYSQL DB nicht mehr...
DB Error: Bad SQL Query: ...... Unknown column 'i.user_id' in 'on clause'
.....
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
LazyOne wrote:schreib mal die komplette abfrage die den fehler erzeugt bitte, dann wird das schon
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 6, 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 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) 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 /home/wenger/public_html/4images/includes/db_mysql.php on line 116
Kai 'Oswald' Seidler wrote:Also, eigentlich kannst Du jetzt nur eines machen:
Solange auf ein Upgrade von XAMPP verzichten, solange es kein Upgrade von 4images (für MySQL 5) gibt.
Users browsing this forum: No registered users and 86 guests