dbDelta not creating table (yes, once more)
I KNOW there are other posts relating to my issue, i read all of them and tried to see if the answer would change and tried a few ones, but I can't seem to create my table using it.
Here's my code (function is in object) and my sql querry:
public static function mq_install(){
global $wpdb;
require_once(constant('ABSPATH') . 'wp-admin/includes/upgrade.php');
$table_name = $wpdb-prefix . 'zebra_musiquote';
$charset_collate = $wpdb-get_charset_collate();
$sql = "CREATE TABLE " . $table_name . "(
id mediumint(9) NOT NULL AUTO_INCREMENT,
from tinytext NOT NULL,
artist tinytext NOT NULL,
song tinytext NOT NULL,
quote text NOT NULL,
url tinytext NOT NULL,
PRIMARY KEY (id)
) ".$charset_collate.";";
dbDelta( $sql );
}
Any suggestions? I'm desperate.