I have tried to install a few times from scratch mms-->sm--->hooks---->mod (plugins etc, extensions, sounds). I have the database set up correctly.

L 05/29/2011 - 23:38:03: Info (map "arena_lumberyard") (file "errors_20110529.log")
L 05/29/2011 - 23:38:03: [SM] Fatal error encountered parsing translation file "common.superh.txt"
L 05/29/2011 - 23:38:03: [SM] Error (line 0, column 0): Stream failed to open

Fatal error....that file is not to be found under translation. Is that the problem?

Yeah...you right checked things again including hooks and it did boot. Got it running saving data using sqlite on local but having some trouble with remote mysql..I have whitelisted my server IP with webhost and triple checked my username, password etc

"Databases"
{
   "driver_default"      "mysql"
   
   "default"
   {
      "driver"         "default"
      "host"            "mywebhost.com"
      "database"         "mydatabase"
      "user"            "username"
      "pass"            "*******"
      //"timeout"         "0"
      //"port"            "3306"
   }
   
Mon May 30 23:18:24 2011 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
Mon May 30 23:18:24 2011 ERRMSG:([2003]: Can't connect to MySQL server on 'mywebhost.com' (110))

The config looks right as per your FAQ I believe....any suggestions. I did try resolving my webhost.com to IP but didn't work either.

All exts and plugins seem loaded without errors...clean install as mentioned above.