->MYSQLI ERROR: query() select l.* from line as l left join line_station as l_s on l_s.lineKey=l.autokey left join station as s on s.autokey=l_s.stationKey where s.autokey= and type='u' order by l.name You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and type='u' order by l.name' at line 5#0 MysqliManager->query(select l.* from line as l left join line_station as l_s on l_s.lineKey=l.autokey left join station as s on s.autokey=l_s.stationKey where s.autokey= and type='u' order by l.name) called at [/usr/local/a1p/www/web/_sites/tubestationuk/WebBuilderSite.php:380] #1 WebBuilderSite->buildLinebars(HtmlDiv Object (), , Array ([servicename] => Westbound,[lineKey] => 27,[linename] => Paddington to Heathrow Airport and Reading,[lineshortname] => Pad-Hea,[type] => x), 27) called at [/usr/local/a1p/www/web/_sites/tubestationuk/RopRouteplan.php:112] #2 RopRouteplan->buildStationchange(HtmlDiv Object (), Array ([station] => ,[seconds] => 1869,[service] => Array ([servicename] => Westbound,[lineKey] => 27,[linename] => Paddington to Heathrow Airport and Reading,[lineshortname] => Pad-Hea,[type] => x))) called at [/usr/local/a1p/www/web/_sites/tubestationuk/RopRouteplan.php:50] #3 RopRouteplan->buildPathPoints(HtmlDiv Object (), Array ([0] => Array ([station] => Array ([autokey] => 4269,[code] => ABR,[dlrcode] => abr,[TLC] => ,[stopPointId] => 9400ZZDLABR,[id] => ,[name] => Abbey Road,[shortname] => Abbey Road,[namenopunc] => Abbey Road,[isTube] => 0,[isDLR] => 1,[isOvgd] => 0,[isCrossrail] => 0,[isNR] => 0,[zone] => 3,[tempzone] => ,[lat] => 51.532001495,[lon] => 0.004000000,[easting] => 538985.937500000,[northing] => 183411.609375000,[osref] => TQ390834,[addr1] => ,[addr2] => ,[addr3] => ,[addr4] => ,[addr5] => ,[postcode] => ,[phone] => ,[wikihref] => http://en.wikipedia.org/wiki/Abbey_Road_DLR_station,[isair] => 0,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 0,[service] => Array ([servicename] => Stratford International,[lineKey] => 16,[linename] => Beckton / Woolwich Arsenal to Stratford International,[lineshortname] => Bec-StI,[type] => d)),[1] => Array ([station] => Array ([autokey] => 4276,[code] => SHS,[dlrcode] => shs,[TLC] => ,[stopPointId] => 9400ZZDLSHS,[id] => ,[name] => Stratford High Street,[shortname] => Stratford High Street,[namenopunc] => Stratford High Street,[isTube] => 0,[isDLR] => 1,[isOvgd] => 0,[isCrossrail] => 0,[isNR] => 0,[zone] => 3,[tempzone] => ,[lat] => 51.537899017,[lon] => -0.000600000,[easting] => 538649.062500000,[northing] => 184058.625000000,[osref] => TQ386841,[addr1] => ,[addr2] => ,[addr3] => ,[addr4] => ,[addr5] => ,[postcode] => ,[phone] => ,[wikihref] => http://en.wikipedia.org/wiki/Stratford_High_Street_DLR_station,[isair] => 0,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 69,[service] => Array ([servicename] => Stratford International,[lineKey] => 16,[linename] => Beckton / Woolwich Arsenal to Stratford International,[lineshortname] => Bec-StI,[type] => d)),[2] => Array ([station] => Array ([autokey] => 4150,[code] => SFD,[dlrcode] => str,[TLC] => SRA,[stopPointId] => 9400ZZDLSTD,[id] => 1000226,[name] => Stratford,[shortname] => Stratford,[namenopunc] => Stratford,[isTube] => 1,[isDLR] => 1,[isOvgd] => 1,[isCrossrail] => 1,[isNR] => 1,[zone] => 3,[tempzone] => 3,[lat] => 51.541309357,[lon] => -0.003195330,[easting] => 538458.750000000,[northing] => 184432.906250000,[osref] => TQ385844,[addr1] => Stratford Station BR Station St,[addr2] => London,[addr3] => ,[addr4] => ,[addr5] => ,[postcode] => E15 1DE,[phone] => 0845 330 9871,[wikihref] => http://en.wikipedia.org/wiki/Stratford_station,[isair] => 0,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 129,[service] => Array ([servicename] => Westbound,[lineKey] => 26,[linename] => Liverpool Street to Shenfield,[lineshortname] => Liv-She,[type] => c)),[3] => Array ([station] => Array ([autokey] => 4077,[code] => LST,[dlrcode] => ,[TLC] => LST,[stopPointId] => 9400ZZLULVT,[id] => 1000138,[name] => Liverpool Street,[shortname] => Liverpool Street,[namenopunc] => Liverpool Street,[isTube] => 1,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 1,[isNR] => 1,[zone] => 1,[tempzone] => 1,[lat] => 51.517353058,[lon] => -0.082965709,[easting] => 532997.687500000,[northing] => 181621.218750000,[osref] => TQ330816,[addr1] => Liverpool Street Underground Station Central,[addr2] => London Underground Ltd.,[addr3] => Liverpool Street,[addr4] => London,[addr5] => ,[postcode] => EC2M 7PP,[phone] => 0845 330 9878,[wikihref] => http://en.wikipedia.org/wiki/Liverpool_Street_station,[isair] => 0,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 909,[service] => Array ([servicename] => Westbound,[lineKey] => 28,[linename] => Paddington to Abbey Wood,[lineshortname] => Pad-Abb,[type] => c)),[4] => Array ([station] => Array ([autokey] => 4030,[code] => FAR,[dlrcode] => ,[TLC] => ZFD,[stopPointId] => 9400ZZLUFCN,[id] => 1000080,[name] => Farringdon,[shortname] => Farringdon,[namenopunc] => Farringdon,[isTube] => 1,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 0,[isNR] => 1,[zone] => 1,[tempzone] => 1,[lat] => 51.520442963,[lon] => -0.105065256,[easting] => 531455.750000000,[northing] => 181924.843750000,[osref] => TQ315819,[addr1] => Farringdon Station,[addr2] => London Underground Ltd.,[addr3] => Cowcross St,[addr4] => London,[addr5] => ,[postcode] => EC1M 6BY,[phone] => 0845 330 9878,[wikihref] => http://en.wikipedia.org/wiki/Farringdon_station,[isair] => 0,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 1389,[service] => Array ([servicename] => Westbound,[lineKey] => 28,[linename] => Paddington to Abbey Wood,[lineshortname] => Pad-Abb,[type] => c)),[5] => Array ([station] => Array ([autokey] => 4159,[code] => TCR,[dlrcode] => ,[TLC] => ,[stopPointId] => 9400ZZLUTCR,[id] => 1000235,[name] => Tottenham Court Road,[shortname] => Tottenham Court Road,[namenopunc] => Tottenham Court Road,[isTube] => 1,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 0,[isNR] => 0,[zone] => 1,[tempzone] => 1,[lat] => 51.516208649,[lon] => -0.130870521,[easting] => 529677.750000000,[northing] => 181407.984375000,[osref] => TQ297814,[addr1] => Tottenham Court Road Station,[addr2] => London Underground Ltd.,[addr3] => Oxford St,[addr4] => London,[addr5] => ,[postcode] => W1,[phone] => 0845 330 9879,[wikihref] => http://en.wikipedia.org/wiki/Tottenham_Court_Road_tube_station,[isair] => 0,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 1569,[service] => Array ([servicename] => Westbound,[lineKey] => 28,[linename] => Paddington to Abbey Wood,[lineshortname] => Pad-Abb,[type] => c)),[6] => Array ([station] => Array ([autokey] => 3978,[code] => BDS,[dlrcode] => ,[TLC] => ,[stopPointId] => 9400ZZLUBND,[id] => 1000025,[name] => Bond Street,[shortname] => Bond Street,[namenopunc] => Bond Street,[isTube] => 1,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 0,[isNR] => 0,[zone] => 1,[tempzone] => 1,[lat] => 51.513805389,[lon] => -0.149332359,[easting] => 528403.750000000,[northing] => 181108.203125000,[osref] => TQ284811,[addr1] => Bond Street Station,[addr2] => London Underground Ltd.,[addr3] => Oxford St,[addr4] => London,[addr5] => ,[postcode] => W1R 1FE,[phone] => 0845 330 9873,[wikihref] => http://en.wikipedia.org/wiki/Bond_Street_tube_station,[isair] => 0,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 1689,[service] => Array ([servicename] => Westbound,[lineKey] => 28,[linename] => Paddington to Abbey Wood,[lineshortname] => Pad-Abb,[type] => c)),[7] => Array ([station] => ,[seconds] => 1869,[service] => Array ([servicename] => Westbound,[lineKey] => 27,[linename] => Paddington to Heathrow Airport and Reading,[lineshortname] => Pad-Hea,[type] => x)),[8] => Array ([station] => Array ([autokey] => 4683,[code] => AML,[dlrcode] => ,[TLC] => AML,[stopPointId] => LEAML,[id] => ,[name] => Acton Main Line,[shortname] => Acton Main Line,[namenopunc] => Acton Main Line,[isTube] => 0,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 1,[isNR] => 1,[zone] => 3,[tempzone] => ,[lat] => 51.516899109,[lon] => -0.266900003,[easting] => 520239.062500000,[northing] => 181252.468750000,[osref] => TQ202813,[addr1] => ,[addr2] => ,[addr3] => ,[addr4] => ,[addr5] => ,[postcode] => W3 9EH,[phone] => ,[wikihref] => https://en.wikipedia.org/wiki/Acton Main Line_railway_station,[isair] => ,[isriver] => ,[istram] => ,[iscable] => ),[seconds] => 2529,[service] => Array ([servicename] => Westbound,[lineKey] => 27,[linename] => Paddington to Heathrow Airport and Reading,[lineshortname] => Pad-Hea,[type] => x)),[9] => Array ([station] => Array ([autokey] => 4014,[code] => EBY,[dlrcode] => ,[TLC] => EAL,[stopPointId] => 9400ZZLUEBY,[id] => 1000062,[name] => Ealing Broadway,[shortname] => Ealing Broadway,[namenopunc] => Ealing Broadway,[isTube] => 1,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 1,[isNR] => 1,[zone] => 3,[tempzone] => 3,[lat] => 51.514911652,[lon] => -0.301500082,[easting] => 517843.875000000,[northing] => 180975.187500000,[osref] => TQ178810,[addr1] => Ealing Broadway Station,[addr2] => The Broadway,[addr3] => London,[addr4] => ,[addr5] => ,[postcode] => W5 2NU,[phone] => 0845 330 9873,[wikihref] => http://en.wikipedia.org/wiki/Ealing_Broadway_station,[isair] => 0,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 2769,[service] => Array ([servicename] => Eastbound,[platformname] => Eastbound,[lineKey] => 3,[linename] => District,[lineshortname] => District,[type] => u,[stopPointId] => 9400ZZLUECM,[stationname] => Ealing Common,[direction] => o)),[10] => Array ([station] => Array ([autokey] => 4015,[code] => ECM,[dlrcode] => ,[TLC] => ,[stopPointId] => 9400ZZLUECM,[id] => 1000063,[name] => Ealing Common,[shortname] => Ealing Common,[namenopunc] => Ealing Common,[isTube] => 1,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 0,[isNR] => 0,[zone] => 3,[tempzone] => 3,[lat] => 51.510124207,[lon] => -0.288260370,[easting] => 518774.843750000,[northing] => 180464.265625000,[osref] => TQ188805,[addr1] => Ealing Common Station,[addr2] => London Underground Ltd.,[addr3] => Uxbridge Rd,[addr4] => London,[addr5] => ,[postcode] => W5 3LD,[phone] => 0845 330 9874,[wikihref] => http://en.wikipedia.org/wiki/Ealing_Common_tube_station,[isair] => 0,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 3249,[service] => ))) called at [/usr/local/a1p/www/web/_sites/tubestationuk/RopRouteplan.php:87] #4 RopRouteplan->buildroute(HtmlDiv Object ()) called at [/usr/local/a1p/www/web/_sites/tubestationuk/WebBuilderSiteDesktopAndTablet.php:264] #5 WebBuilderSiteDesktopAndTablet->buildCentre(HtmlDiv Object ()) called at [/usr/local/a1p/www/web/_sites/tubestationuk/WebBuilderSiteDesktopAndTablet.php:367] #6 WebBuilderSiteDesktopAndTablet->buildmain(HtmlDiv Object ()) called at [/usr/local/a1p/www/web/_sites/tubestationuk/WebBuilderSiteDesktopAndTablet.php:61] #7 WebBuilderSiteDesktopAndTablet->_build() called at [/usr/local/a1p/www/web/tubestationuk/index.php:14]