->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] => c), 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] => c))) 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] => c)),[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] => c)),[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] => Westbound,[lineKey] => 27,[linename] => Paddington to Heathrow Airport and Reading,[lineshortname] => Pad-Hea,[type] => c)),[10] => Array ([station] => Array ([autokey] => 4685,[code] => WEA,[dlrcode] => ,[TLC] => WEA,[stopPointId] => LEWEA,[id] => ,[name] => West Ealing,[shortname] => West Ealing,[namenopunc] => West Ealing,[isTube] => 0,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 1,[isNR] => 1,[zone] => 3,[tempzone] => ,[lat] => 51.513698578,[lon] => -0.320300013,[easting] => 516542.687500000,[northing] => 180810.203125000,[osref] => TQ165808,[addr1] => ,[addr2] => ,[addr3] => ,[addr4] => ,[addr5] => ,[postcode] => W13 0LJ,[phone] => ,[wikihref] => https://en.wikipedia.org/wiki/West Ealing_railway_station,[isair] => ,[isriver] => ,[istram] => ,[iscable] => ),[seconds] => 2949,[service] => Array ([servicename] => Westbound,[lineKey] => 27,[linename] => Paddington to Heathrow Airport and Reading,[lineshortname] => Pad-Hea,[type] => c)),[11] => Array ([station] => Array ([autokey] => 4686,[code] => HAN,[dlrcode] => ,[TLC] => HAN,[stopPointId] => LEHAN,[id] => ,[name] => Hanwell,[shortname] => Hanwell,[namenopunc] => Hanwell,[isTube] => 0,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 1,[isNR] => 1,[zone] => 4,[tempzone] => ,[lat] => 51.511600494,[lon] => -0.338900000,[easting] => 515257.531250000,[northing] => 180547.453125000,[osref] => TQ153805,[addr1] => ,[addr2] => ,[addr3] => ,[addr4] => ,[addr5] => ,[postcode] => W7 3EB,[phone] => ,[wikihref] => https://en.wikipedia.org/wiki/Hanwell_railway_station,[isair] => ,[isriver] => ,[istram] => ,[iscable] => ),[seconds] => 3069,[service] => Array ([servicename] => Westbound,[lineKey] => 27,[linename] => Paddington to Heathrow Airport and Reading,[lineshortname] => Pad-Hea,[type] => c)),[12] => Array ([station] => Array ([autokey] => 4687,[code] => ST2,[dlrcode] => ,[TLC] => STL,[stopPointId] => LEST2,[id] => ,[name] => Southall,[shortname] => Southall,[namenopunc] => Southall,[isTube] => 0,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 1,[isNR] => 1,[zone] => 4,[tempzone] => ,[lat] => 51.506000519,[lon] => -0.378300011,[easting] => 512537.687500000,[northing] => 179863.453125000,[osref] => TQ125799,[addr1] => ,[addr2] => ,[addr3] => ,[addr4] => ,[addr5] => ,[postcode] => UB1 3AD,[phone] => ,[wikihref] => https://en.wikipedia.org/wiki/Southall_railway_station,[isair] => ,[isriver] => ,[istram] => ,[iscable] => ),[seconds] => 3249,[service] => Array ([servicename] => Westbound,[lineKey] => 27,[linename] => Paddington to Heathrow Airport and Reading,[lineshortname] => Pad-Hea,[type] => c)),[13] => Array ([station] => Array ([autokey] => 4688,[code] => HAY,[dlrcode] => ,[TLC] => HAY,[stopPointId] => LEHAY,[id] => ,[name] => Hayes & Harlington,[shortname] => Hayes & Harlington,[namenopunc] => Hayes and Harlington,[isTube] => 0,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 1,[isNR] => 1,[zone] => 5,[tempzone] => ,[lat] => 51.501998901,[lon] => -0.420100003,[easting] => 509646.750000000,[northing] => 179355.046875000,[osref] => TQ096794,[addr1] => ,[addr2] => ,[addr3] => ,[addr4] => ,[addr5] => ,[postcode] => UB3 4BX,[phone] => ,[wikihref] => https://en.wikipedia.org/wiki/Hayes & Harlington_railway_station,[isair] => ,[isriver] => ,[istram] => ,[iscable] => ),[seconds] => 3489,[service] => Array ([servicename] => Westbound,[lineKey] => 27,[linename] => Paddington to Heathrow Airport and Reading,[lineshortname] => Pad-Hea,[type] => c)),[14] => Array ([station] => Array ([autokey] => 4207,[code] => HRC,[dlrcode] => ,[TLC] => HXX,[stopPointId] => 9400ZZLUHRC,[id] => 1000105,[name] => Heathrow Terminals 123,[shortname] => Heathrow T123,[namenopunc] => Heathrow Terminals 123,[isTube] => 1,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 1,[isNR] => 1,[zone] => 6,[tempzone] => 6,[lat] => 51.471218109,[lon] => -0.452439129,[easting] => 507474.843750000,[northing] => 175884.453125000,[osref] => TQ075759,[addr1] => ,[addr2] => ,[addr3] => ,[addr4] => ,[addr5] => ,[postcode] => ,[phone] => ,[wikihref] => http://en.wikipedia.org/wiki/Heathrow_Terminals_1,_2,_3_tube_station,[isair] => 1,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 4209,[service] => Array ([servicename] => Westbound,[lineKey] => 27,[linename] => Paddington to Heathrow Airport and Reading,[lineshortname] => Pad-Hea,[type] => c)),[15] => Array ([station] => Array ([autokey] => 4048,[code] => HRF,[dlrcode] => ,[TLC] => HAF,[stopPointId] => 9400ZZLUHR4,[id] => 1000104,[name] => Heathrow Terminal 4,[shortname] => Heathrow T4,[namenopunc] => Heathrow Terminal 4,[isTube] => 1,[isDLR] => 0,[isOvgd] => 0,[isCrossrail] => 1,[isNR] => 1,[zone] => 6,[tempzone] => 6,[lat] => 51.458553314,[lon] => -0.446058780,[easting] => 507947.812500000,[northing] => 174485.593750000,[osref] => TQ079745,[addr1] => Heathrow T4 Station,[addr2] => London Underground Ltd.,[addr3] => Hthrw Airport complex,[addr4] => Trmnl 4,[addr5] => Hounslow,[postcode] => ,[phone] => ,[wikihref] => http://en.wikipedia.org/wiki/Heathrow_Terminal_4_tube_station,[isair] => 1,[isriver] => 0,[istram] => 0,[iscable] => ),[seconds] => 4449,[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]