A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/Villanegyed.php

Line Number: 1138

Backtrace:

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 1138
Function: _exception_handler

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 230
Function: ingatlan

File: /var/www/virtual/villanegyed.hu/htdocs/index.php
Line: 274
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/Villanegyed.php

Line Number: 1139

Backtrace:

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 1139
Function: _exception_handler

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 230
Function: ingatlan

File: /var/www/virtual/villanegyed.hu/htdocs/index.php
Line: 274
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/Villanegyed.php

Line Number: 1140

Backtrace:

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 1140
Function: _exception_handler

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 230
Function: ingatlan

File: /var/www/virtual/villanegyed.hu/htdocs/index.php
Line: 274
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/Villanegyed.php

Line Number: 1165

Backtrace:

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 1165
Function: _exception_handler

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 230
Function: ingatlan

File: /var/www/virtual/villanegyed.hu/htdocs/index.php
Line: 274
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/Villanegyed.php

Line Number: 1166

Backtrace:

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 1166
Function: _exception_handler

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 230
Function: ingatlan

File: /var/www/virtual/villanegyed.hu/htdocs/index.php
Line: 274
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /var/www/virtual/villanegyed.hu/htdocs/system/core/Exceptions.php:211)

Filename: core/Common.php

Line Number: 549

Backtrace:

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 1169
Function: query

File: /var/www/virtual/villanegyed.hu/htdocs/application/controllers/Villanegyed.php
Line: 230
Function: ingatlan

File: /var/www/virtual/villanegyed.hu/htdocs/index.php
Line: 274
Function: require_once

Database Error

Error Number: 1064

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 ') order by iranyar_huf limit 0, 16' at line 11

select distinct(a.id), a.BURL, a.TIP_ID, a.EURO, a.hely, a.IRANYAR_HUF, a.IRANYAR_EUR, concat('/images/',a.id,'/',replace(b.newfilename,'.jpg', '-galeria_nagy.jpg')) as filename, c.megnevezes as tipus, coalesce(e.megnevezes,f.megnevezes,g.megnevezes) as jelleg, a.VAROSRESZ, a.HELY, a.FURDO, a.HALL, TER_BR, FELSZOBA, SZOBA, NAPPALI, HALO, MERET_NM, MERET_NOL from KIADO a left join KEPEK b on (b.kinal_id=a.id) left join SZOTAR_TIP_ID c on (c.tip_id=a.tip_id and c.lang='EN') left join SZOTAR_JELLEG_ID e on (e.jelleg_id=a.jelleg_id and e.lang='EN') left join SZOTAR_TIPUS_ID f on (f.tipus_id=a.tipus_id and f.lang='EN') left join SZOTAR_TEL_TIP_ID g on (g.tel_tip_id=a.tel_tip_id and g.lang='EN') where a.id<>'4111' and a.eladva='0' and b.alapertelmezett='1' and a.tip_id='' and iranyar_huf>'' and a.id not in () order by iranyar_huf limit 0, 16

Filename: controllers/Villanegyed.php

Line Number: 1169