See output of a sql query while plugin installation in wordpress

You could insert a

$wpdb->show_errors(); 

to output the errors in your query.

Also you need to input that sql into

dbDelta($sql)

did you miss that?