installation prob

[Anonymous]

i'm a rookie in the apache , mssql , php world..i have successfully installed and config'd all of the above (apache 2,mssql 5.0.1, php 5.0.1)on a win2k machine, but i keep getting an error when running the setupdb.sh script. i've tried running them individually --SOL
ERROR msg - "ERROR 1064 (42000): 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 ')' at
line 1"
Football season is days away and would really like to see this working.
any help would be great!
THX

[Stephen Rochelle]

Which particular file is causing problems?

(and no, the .sh file won't work under windows)

[Anonymous]

rookie error..lol..but still won't execute sql scripts
tried to run auctionvalues.sql and responded with the same error -- any script in the tables dir gives the same message.
I've narrowed down the problem to me..lol..
thnx

[dsfunk]

that would be auctionvalues.sql

you have an extra semicolon

[Anonymous]

not familiar with mysql..2 semicolons in the script..are u saying one of these doesn't belong..i've played that game before..lol..
Also wil this apply to the rest of the scripts

[dsfunk]

mine came like this:

    primary key (`league_id`, `player_id`);
);

it needs to be this:

    primary key (`league_id`, `player_id`)
);

the rest of the scripts were fine

[Anonymous]

ok missed that one..now it looks like this:

drop table if exists `auctionvalues`;
create table `auctionvalues` (
    `league_id`            smallint unsigned,
    `player_id`            smallint unsigned,
    `auction_value`        smallint unsigned,
    primary key (`league_id`, `player_id`)
);

Still recieve the same error "#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 '' at line 5"

By the way i really appreciate the help

[Anonymous]

i've come across some articles referencing various issues with MYSQL 5.0.1..????
Anything else that could be the culprit..config maybe?? just considering all possibilities

[Anonymous]

Rest of the scripts work fine..thought i tried a couple of them...just that one refuses to join the crowd

[Stephen Rochelle]

OK, that's my fault -- the initial upload had another syntax error in that file.  The current download should be fine (except that second semicolon)

[Anonymous]

Nobodies fault; Appreciate all the help;
I eneded up just creating the table myself..it was only 1, but I will grab the updated one..

Again thanks..and maybe someone could take a look at my latest posting in help..

Cheers!