First let me apologize for posting again here but I've been working on this for over 8 hours and I just wanted to be finished, I deleted the whole database and reinstalled it from the sql dump provided with the source code.
I noticed an error this time in the console saying syntax error around line 1116, now I'm either blind or I'm just missing it but I can't see any problem, can anyone see whats going on here ?
CREATE TABLE IF NOT EXISTS `bw_users` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`banned` enum('0','1') DEFAULT '0',
`block_non_pgp` enum('0','1') DEFAULT '0',
`entry_paid` enum('0','1') DEFAULT '0',
`force_pgp_messages` enum('0','1') DEFAULT '0',
`location` int(3) NOT NULL,
`login_time` int(20) NOT NULL,
`display_login_time` enum('0','1') DEFAULT '0',
`password` varchar(128) NOT NULL,
`public_key` blob NOT NULL,
`private_key` blob NOT NULL,
`private_key_salt` varchar(64) NOT NULL,
`register_time` int(20) NOT NULL,
`salt` varchar(128) NOT NULL,
`wallet_salt` varchar(128) NOT NULL,
`user_hash` varchar(25) NOT NULL,
`user_name` varchar(40) NOT NULL,
`user_role` enum('Buyer','Vendor','Admin') NOT NULL,
`local_currency` int(11) NOT NULL,
`completed_order_count` int(9) DEFAULT '0',
`totp_secret` varchar(25),
`totp_two_factor` enum('0','1') DEFAULT '0',
`pgp_two_factor` enum('0','1') DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `user_hash` (`user_hash`,`user_name`),
KEY `user_name` (`user_name`,`user_hash`,`banned`,`entry_paid`,`register_time`,`user_role`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `bw_users` (`banned`, `block_non_pgp`, `entry_paid`, `force_pgp_messages`, `location`, `login_time`, `display_login_time`, `password`, `public_key`, `private_key`, `private_key_salt`, `register_time`, `salt`, `pgp_two_factor`, `user_hash`, `user_name`, `user_role`, `local_currency`, `completed_order_count`, `totp_two_factor`, `totp_secret`) VALUES
('0', '0', '1', '0', 1, 0, '0', '%PASSWORD%', '%PUBLIC_KEY%', '%PRIVATE_KEY%', '%PRIVATE_KEY_SALT%', %REGISTER_TIME%, '%SALT%', '0', '%USER_HASH%', 'admin', 'Admin', 0, 0, '0', '');