Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

R63B - SQL Issue. Help Needed ?

Status
Not open for further replies.
Initiate Mage
Joined
Jul 30, 2012
Messages
75
Reaction score
3
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:

Code:
 [B][SQL][/B] - 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
 
Junior Spellweaver
Joined
Feb 9, 2013
Messages
177
Reaction score
9
navicat, select your table, then goto tools/console and paste your code there. Don't use query for that context.
 
Upvote 0
Status
Not open for further replies.
Back
Top