Completely locked out of Admin

[picandnix]

Hey ,have managed to fix both my issues within the last 10 minutes .. I reset my website in mydatabasesql to none www. and admin came back .
I search for the debug error and found the solution ,something to do with whos_online so copied from my spare test site over and bobs your uncle
site up and running .. I do have a small error left but will look into that later as work is calling so have to go

Nice one.

[Andy-C27]

Although my site is up and running again ,this is the only debug error left atm and can't seem to find a solution

[14-May-2014 08:43:53 Europe/London] PHP Fatal error: 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 'TYPE=MyISAM' at line 1 :: CREATE TABLE whos_online ( customer_id int(11) default NULL, full_name varchar(64) NOT NULL default '', session_id varchar(128) NOT NULL default '', ip_address varchar(15) NOT NULL default '', time_entry varchar(14) NOT NULL default '', time_last_click varchar(14) NOT NULL default '', last_page_url varchar(255) NOT NULL default '', host_address text NOT NULL, user_agent varchar(255) NOT NULL default '', KEY idx_ip_address_zen (ip_address), KEY idx_session_id_zen (session_id), KEY idx_customer_id_zen (customer_id), KEY idx_time_entry_zen (time_entry), KEY idx_time_last_click_zen (time_last_click), KEY idx_last_page_url_zen (last_page_url) ) TYPE=MyISAM; in /var/www/vhosts/pewterworld.co.uk/httpdocs/includes/classes/db/mysql/query_factory.php on line 120

Any idea on this error

cheers

[swguy]

Andy, in the SQL script you're trying to run, change

TYPE=MyISAM

to

ENGINE=MyISAM