-
Member
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
-
-
Re: error in adding public room sql
Change "YOUR ROOM ID FROM ROOMS" to a ID..
Try that. lol