stored procedure not working on win 2k3

L P <[email protected]>
Newsgroups gmane.comp.db.mysql.windows
Message-ID <[email protected]>
Folks,
 when I try and implement this stored procedure on mysql 5.0.18 running on
win 2k3, i get a 1064 error for syntax on the the following line:
select SQL_CALC_FOUND_ROWS * from currentbidding where expired='N' AND
match(itemname) against (? IN BOOLEAN MODE) limit ?,?

DELIMITER $$

DROP PROCEDURE IF EXISTS `emp`.`test4` $$
CREATE PROCEDURE `test4`(startRow int, pageSize int, keywords char(120))
BEGIN
  set @sRow = startRow;
  set @pSize = pageSize;
  set @kWords = keywords;
  prepare stmt from "select SQL_CALC_FOUND_ROWS * from currentbidding where
expired='N' AND match(itemname) against (? IN BOOLEAN MODE) limit ?,?";
  execute stmt using @kWords, @sRow, @pSize;
  select found_rows();
END $$

DELIMITER ;

Table definition:


CREATE TABLE  "emp"."currentbidding" (
  "itemid" int(10) unsigned NOT NULL auto_increment,
  "itemName" varchar(120) NOT NULL default '',
  "expired" char(1) NOT NULL default 'N',
  PRIMARY KEY  ("itemid"),
  KEY "ActiveListing" ("expired"),
  FULLTEXT KEY "fulltext" ("itemName")
);

The stored procedure works without any problems on windows xp with the same
version of mysql.

I just did a backup of the database and restored it on the win2k3 box and
get the

Any help is appreciated.

Thanks,
LP
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.