Trouble Updating Server (7.0-Current)

[greneday]

I looked around, and tried to on my own, but I just do not know how to impliment the change logs into my database.

ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;
when plugged into mysql, or saved as a sql file and tried to query, it just gives me syntax errors.

[Aramid]

Originally Posted by greneday

I looked around, and tried to on my own, but I just do not know how to impliment the change logs into my database.

ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;
when plugged into mysql, or saved as a sql file and tried to query, it just gives me syntax errors.

Assuming that everything is installed as defaults, see if this helps:

goto c:\mysql\bin>

Type in mysql -ueq -p peq (peq if your using peq database or eq if your using cavedude's database)

Enter your password. You should now be at a mysql> prompt

TYpe in the Changes

ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;

If you get an error, leave off the ` around traps, message and effectvalue2

when your done, type in quit to exit mysql.

[johane]

Originally Posted by greneday

I looked around, and tried to on my own, but I just do not know how to impliment the change logs into my database.

ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;
when plugged into mysql, or saved as a sql file and tried to query, it just gives me syntax errors.

Don't use the character ` for quotes, use the character ' .

That's the single quote near your enter key, NOT the one near your escape key (assuming you have a standard US keyboard layout).