unserialize(): Passing null to parameter #1 ($data) of type string is deprecated
app/addons/hybrid_auth/func.php, line: 200
| File: | app/addons/hybrid_auth/func.php |
| Line: | 200 |
| Function: | {closure} |
| File: | app/Tygh/Registry.php |
| Line: | 800 |
| Function: | {closure} |
| File: | app/addons/hybrid_auth/func.php |
| Line: | 222 |
| Function: | getOrSetCache |
| File: | app/addons/hybrid_auth/controllers/frontend/init.post.php |
| Line: | 17 |
| Function: | fn_hybrid_auth_get_providers_list |
| File: | app/functions/fn.control.php |
| Line: | 727 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 458 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 19 |
| Function: | fn_dispatch |
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "203.71"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "140.00"
},
"nested_loop": [
{
"table": {
"table_name": "a",
"access_type": "ref",
"possible_keys": [
"cs",
"country_code"
],
"key": "cs",
"used_key_parts": [
"country_code"
],
"key_length": "8",
"ref": [
"const"
],
"rows_examined_per_scan": 140,
"rows_produced_per_join": 140,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.71",
"eval_cost": "14.00",
"prefix_cost": "14.71",
"data_read_per_join": "15K"
},
"used_columns": [
"state_id",
"country_code",
"code"
]
}
},
{
"table": {
"table_name": "b",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"state_id",
"lang_code"
],
"key_length": "9",
"ref": [
"nuie_scalesta_net.a.state_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 140,
"filtered": "100.00",
"cost_info": {
"read_cost": "35.00",
"eval_cost": "14.00",
"prefix_cost": "63.71",
"data_read_per_join": "107K"
},
"used_columns": [
"state_id",
"lang_code",
"state"
]
}
}
]
}
}
}
| code | state |
|---|---|
| ABN | Aberdeen |
| ABNS | Aberdeenshire |
| ANG | Anglesey |
| AGS | Angus |
| ANN | Antrim and Newtownabbey |
| AND | Ards and North Down |
| ARY | Argyll and Bute |
| ABC | Armagh City, Banbridge and Craigavon |
| AVN | Avon |
| BAN | Banffshire |
| BEDS | Bedfordshire |
| BFS | Belfast City |
| BERKS | Berkshire |
| BEW | Berwickshire |
| BLA | Blaenau Gwent |
| BRI | Bridgend |
| BSTL | Bristol |
| BUCKS | Buckinghamshire |
| CAE | Caerphilly |
| CAI | Caithness |
| CAMBS | Cambridgeshire |
| CDF | Cardiff |
| CARM | Carmarthenshire |
| CCG | Causeway Coast and Glens |
| CDGN | Ceredigion |
| CHES | Cheshire |
| CLACK | Clackmannanshire |
| CLV | Cleveland |
| CWD | Clwyd |
| CON | Conwy |
| CORN | Cornwall |
| ANT | County Antrim |
| ARM | County Armagh |
| DOW | County Down |
| FER | County Fermanagh |
| LDY | County Londonderry |
| TYR | County Tyrone |
| CMA | Cumbria |
| DNBG | Denbighshire |
| DERBY | Derbyshire |
| DRS | Derry and Strabane |
| DVN | Devon |
| DOR | Dorset |
| DGL | Dumfries and Galloway |
| DFS | Dumfries-shire |
| DUND | Dundee |
| DHM | Durham |
| DFD | Dyfed |
| ARYE | East Ayrshire |
| DUNBE | East Dunbartonshire |
| LOTE | East Lothian |
| RENE | East Renfrewshire |
| ERYS | East Riding of Yorkshire |
| SXE | East Sussex |
| EDIN | Edinburgh |
| ESX | Essex |
| FALK | Falkirk |
| FMO | Fermanagh and Omagh |
| FFE | Fife |
| FLINT | Flintshire |
| GLAS | Glasgow |
| GLOS | Gloucestershire |
| LDN | Greater London |
| MCH | Greater Manchester |
| GDD | Gwynedd |
| HANTS | Hampshire |
| HWR | Herefordshire |
| HERTS | Hertfordshire |
| HLD | Highlands |
| HUM | Humberside |
| IVER | Inverclyde |
| INV | Inverness-shire |
| IOW | Isle of Wight |
| IOS | Isles of Scilly |
| KNT | Kent |
| KCD | Kincardineshire |
| LANCS | Lancashire |
| LEICS | Leicestershire |
| LINCS | Lincolnshire |
| LBC | Lisburn and Castlereagh |
| MER | Merionethshire |
| MSY | Merseyside |
| MERT | Merthyr Tydfil |
| MEA | Mid and East Antrim |
| MUL | Mid-Ulster |
| MDX | Middlesex |
| MLOT | Midlothian |
| MMOUTH | Monmouthshire |
| MORAY | Moray |
| NAI | Nairnshire |
| NPRTAL | Neath Port Talbot |
| NEWPT | Newport |
| NMD | Newry, Mourne and Down |
| NOR | Norfolk |
| ARYN | North Ayrshire |
| LANN | North Lanarkshire |
| YSN | North Yorkshire |
| NHM | Northamptonshire |
| NLD | Northumberland |
| NOT | Nottinghamshire |
| ORK | Orkney Islands |
| OFE | Oxfordshire |
| PEE | Peebles-shire |
| PEM | Pembrokeshire |
| PERTH | Perth and Kinross |
| PWS | Powys |
| REN | Renfrewshire |
| RHON | Rhondda Cynon Taff |
| ROX | Roxburghshire |
| RUT | Rutland |
| BOR | Scottish Borders |
| SEL | Selkirkshire |
| SHET | Shetland Islands |
| SPE | Shropshire |
| SOM | Somerset |
| ARYS | South Ayrshire |
| LANS | South Lanarkshire |
| SYK | South Yorkshire |
| SFD | Staffordshire |
| STIR | Stirling |
| STI | Stirlingshire |
| SFK | Suffolk |
| SRY | Surrey |
| SUT | Sutherland |
| SWAN | Swansea |
| TORF | Torfaen |
| TWR | Tyne and Wear |
| VGLAM | Vale of Glamorgan |
| WARKS | Warwickshire |
| WDUN | West Dunbartonshire |
| WLOT | West Lothian |
| WMD | West Midlands |
| SXW | West Sussex |
| YSW | West Yorkshire |
| WIL | Western Isles |
| WIG | Wigtownshire |
| WLT | Wiltshire |
| WORCS | Worcestershire |
| WRX | Wrexham |
| YKS | Yorkshire |