R63B - SQL Issue. Help Needed ?

[NetVibeNet]

Dear Ragezone,


Hello, im setting up an R63B Retro with Bcstorm and revCMS. Now when i do the SQL Database for R63B Bcstorm, i get this ERROR when instering the DB into my navicat. Can anyone give me a fix or whatnot ?


Error Message:

 [SQL] - BEGIN
SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data, items.placedBy
FROM items_rooms
JOIN items ON (items.item_id = items_rooms.item_id)
LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
WHERE items_rooms.room_id = roomid;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.b' at line 2

[MentaL]

[prodigy007]

navicat, select your table, then goto tools/console and paste your code there. Don't use query for that context.