error in adding public room sql

Results 1 to 2 of 2
  1. #1
    Member Angel1303 is offline
    MemberRank
    Feb 2011 Join Date
    UKLocation
    59Posts

    error in adding public room sql

    [SQL] INSERT INTO `navigator_publics` (`id`, `ordernum`, `bannertype`, `caption`, `description`, `image`, `image_type`, `room_id`, `category_id`, `category_parent_id`, `enabled`, `recommended`, `typeofdata`, `tag`) VALUES ('1', '1', '0', 'THE CAPTION', 'THE DESCRIPTION', '/officialrooms_au/fireservices_02.png', 'internal', 'YOUR ROOM ID FROM ROOMS', '0', '0', '1', '1', '2', '');
    [Err] 1366 - Incorrect integer value: 'YOUR ROOM ID FROM ROOMS' for column 'room_id' at row 1

    is the error i get atm from useing the Mercury EMu v2.3
    any help please


  2. #2
    HabboFont.net Cankiee is offline
    MemberRank
    May 2013 Join Date
    North KoreaLocation
    978Posts

    Re: error in adding public room sql

    Change "YOUR ROOM ID FROM ROOMS" to a ID..
    Try that. lol



Advertisement