Boost installation help needed

[speedr6]

A novice here trying to install boost on a windows 2008 R2 server and following the installation steps for boost, i attempted to modify the poller_output and poller_output_boost table but getting the error below. Please pardon my ignorance as i am new to all this and have not been able to figure out what i am doing wrong. I used the windows installer package and I have mySQL 5.5 installed. Please help.

Thank you

Code: Select all

mysql> connect cacti
Connection id:    438
Current database: cacti

mysql> alter table poller_output, modify column output varchar(50) not null defa
ult "", engine=memory;
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 ' modi
fy column output varchar(50) not null default "", engine=memory' at line 1
mysql> alter table poller_output_boost, modify column output varchar(50) not nul
l default "";
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 ' modi
fy column output varchar(50) not null default ""' at line 1
mysql>

[rsanto]

try:

alter table poller_output, modify column output varchar(50) not null default "";

and after:

alter TABLE poller_output ENGINE = memory;