Thanks, now getting this issue:
Static analysis:
4 errors were found during analysis.
- An alias was previously found. (near “:01’” at position 446)
- A comma or a closing bracket was expected. (near “:01’” at position 446)
- Unexpected beginning of statement. (near “id” at position 518)
- Unrecognized statement type. (near “INDEX” at position 523)
SQL query:
CREATE TABLE modx_seosuite_redirect (id INTEGER unsigned NOT NULL AUTO_INCREMENT, context_key VARCHAR(100) NOT NULL DEFAULT ‘’, resource_id INTEGER(10) NOT NULL DEFAULT ‘0’, old_url VARCHAR(255) NOT NULL DEFAULT ‘’, new_url VARCHAR(255) NOT NULL DEFAULT ‘’, redirect_type VARCHAR(75) NOT NULL DEFAULT ‘’, active TINYINT(1) unsigned NOT NULL DEFAULT ‘1’, visits INTEGER(11) NOT NULL DEFAULT ‘0’, last_visit TIMESTAMP NULL DEFAULT ‘1970-01-01 01:01:01’, editedon TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), INDEX context_key (context_key), INDEX resource_id (resource_id), INDEX old_url (old_url), INDEX active (active)) ENGINE=InnoDB
#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 '‘’, resource_id INTEGER(10) NOT NULL DEFAULT ‘0’, old_url VARCHAR(255) N' at line 1