ResidentialComplexController :: listResidentialComplexes
Request
GET Parameters
None
POST Parameters
None
Uploaded Files
None
Request Attributes
| Key | Value |
|---|---|
| _cache | [ Symfony\Component\HttpKernel\Attribute\Cache {#769 +expires: null +maxage: null +smaxage: 10 +public: null +mustRevalidate: false +vary: [] +lastModified: null +etag: null +maxStale: null +staleWhileRevalidate: null +staleIfError: null +noStore: null } ] |
| _controller | "App\Controller\ResidentialComplexController::listResidentialComplexes" |
| _firewall_context | "security.firewall.map.context.user_secured_area" |
| _locale | "en" |
| _remove_csp_headers | true |
| _route | "list_residential_complexes" |
| _route_params | [ "_locale" => "en" ] |
| _security_authenticators | [] |
| _security_firewall_run | "_security_user" |
| _security_skipped_authenticators | [ Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator {#615 -supports: false -passport: null -duration: null -stub: "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator" -authenticated: null -exception: null -authenticator: Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator {#552 …} } Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator {#617 -supports: false -passport: null -duration: null -stub: "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator" -authenticated: null -exception: null -authenticator: Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator {#618 …} } ] |
| _stopwatch_token | "bdcdbb" |
Request Headers
| Header | Value |
|---|---|
| accept | "*/*" |
| accept-encoding | "gzip, br, zstd, deflate" |
| authorization | "" |
| cookie | "device_view=full; company_secured_area_deauth_profile_token=684649; PHPSESSID=b1f8bd10f4b8170e94694468c12af17a; user_secured_area_deauth_profile_token=710d69" |
| host | "imobiliare.n46.net" |
| user-agent | "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" |
| x-php-ob-level | "0" |
Request Content
Request content not available (it was retrieved as a resource).
Response
Response Headers
| Header | Value |
|---|---|
| cache-control | "no-cache, private" |
| content-type | "text/html; charset=UTF-8" |
| date | "Tue, 20 Jan 2026 18:25:23 GMT" |
| referrer-policy | "no-referrer, strict-origin-when-cross-origin" |
| x-content-type-options | "nosniff" |
| x-debug-exception | "An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B42S22%5D%3A%20Column%20not%20found%3A%201054%20Unknown%20column%20%27a0_.instagram_reel_id%27%20in%20%27SELECT%27" |
| x-debug-exception-file | "%2Fvar%2Fwww%2Fvhosts%2F1007%2Fdomains%2Fn46.net%2Fimobiliare%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:63" |
| x-debug-token | "7f13ff" |
| x-debug-token-link | "https://imobiliare.n46.net/_profiler/843913" |
| x-frame-options | "DENY" |
| x-previous-debug-token | "843913" |
| x-robots-tag | "noindex" |
Cookies
Request Cookies
| Key | Value |
|---|---|
| PHPSESSID | "b1f8bd10f4b8170e94694468c12af17a" |
| company_secured_area_deauth_profile_token | "684649" |
| device_view | "full" |
| user_secured_area_deauth_profile_token | "710d69" |
Response Cookies
No response cookies
Session
Session Metadata
| Key | Value |
|---|---|
| Created | "Tue, 20 Jan 26 18:25:21 +0000" |
| Last used | "Tue, 20 Jan 26 18:25:23 +0000" |
| Lifetime | 0 |
Session Attributes
| Attribute | Value |
|---|---|
| _security.company_secured_area.target_path | "/en/professional/" |
Session Usage
0
Usages
Stateless check enabled
Session not used.
Flashes
Flashes
No flash messages were created.
Server Parameters
Server Parameters
Defined in .env
| Key | Value |
|---|---|
| ADSENSE | "ca-pub-?" |
| APP_ENV | "dev" |
| APP_SECRET | "c279bacd228b954540f19b984b992885" |
| APP_SHARE_DIR | "var/share" |
| DATABASE_URL | "mysql://1007-imobiliare:Ppppppp123!@127.0.0.1:3306/1007-imobiliare" |
| DEFAULT_URI | "http://localhost" |
| DOMAIN_NAME | "land.n46.net" |
| EMAIL_FROM_NAME | "imobiliare.pro" |
| EMAIL_INFO | "info@imobiliare.pro" |
| EMAIL_NOREPLY | "no-reply@imobiliare.pro" |
| EMAIL_SUPPORT | "support@imobiliare.pro" |
| FACEBOOK_APP_ID | "850026243501684" |
| GOOGLE_API_KEY | "" |
| GOOGLE_API_KEY_HTTP_REFERRERS | "AIzaSyBzayA0PZnknYYNU7N4sGV1dSCpa4Ro8Ec" |
| GOOGLE_API_KEY_IP_ADDRESSES | "AIzaSyADGYOFYEyVPUqYO7wNS9w5VF6BflAD0ME" |
| GOOGLE_AUTH_CONFIG | "%kernel.project_dir%/config/gcloud/service-account.json" |
| GOOGLE_CLIENT_ID | "657636602163-k0cus770ojntgvseqt92ibldarv3b87m.apps.googleusercontent.com" |
| GOOGLE_CLIENT_SECRET | "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" |
| GOOGLE_MAP_ID | "6a11089a3322a7c0" |
| GOOGLE_PROJECT_ID | "imobiliare-online" |
| GOOGLE_RECAPTCHA_SECRET_KEY | "6LcEsJ4rAAAAAOhBolWffwccYVMtSMjBAxFCjdsK" |
| GOOGLE_RECAPTCHA_SITE_KEY | "6LcEsJ4rAAAAAGAlBhjH2BBLt7TCnB97T7NLpsAy" |
| GTM | "GTM-?" |
| JWT_PASSPHRASE | "AgroFermaOnlineMoldova" |
| JWT_PUBLIC_KEY | "%kernel.project_dir%/config/jwt/public.pem" |
| JWT_SECRET_KEY | "%kernel.project_dir%/config/jwt/private.pem" |
| LOCK_DSN | "flock" |
| MAILER_DSN | "smtp://no-reply%40imobiliare.pro:Imobiliare.Pro_2024-11-25MX@lxhost.com:465/?encryption=ssl&auth_mode=plain&local_domain=imobiliare.pro" |
| MAPBOX_ACCESS_TOKEN | "pk.eyJ1IjoibHJ1ZGVuY28iLCJhIjoiY2treTVidnFpMm5hajJvcW5qbXk1eWptcyJ9.F8v49glk418QVqDcMiQweg" |
| REDIS_HOST | "127.0.0.1" |
| REDIS_PASSWORD | "" |
| REDIS_PORT | "6379" |
| TELEGRAM_DSN | "telegram://5787131626:AAF4MtzHRW8aDoRy4FRLHGWVHb7YgF1MeV4@default?channel=-1002713124951" |
| TELEPHONE_NUMBER | "+37361007007" |
| VICTORIA_BANK_CARD_ACCEPTOR_ID | "498000049892038" |
| VICTORIA_BANK_MERCHANT_ADDRESS | "str. A. Puskin 22, of. 229, MD-2013, Chisinau, Moldova" |
| VICTORIA_BANK_MERCHANT_BANK_PUBLIC_KEY | "victoria_pub.pem" |
| VICTORIA_BANK_MERCHANT_COUNTRY_CODE | "MD" |
| VICTORIA_BANK_MERCHANT_DEFAULT_LANGUAGE | "ro" |
| VICTORIA_BANK_MERCHANT_NAME | "Media Web S.R.L." |
| VICTORIA_BANK_MERCHANT_PRIVATE_KEY | "private.pem" |
| VICTORIA_BANK_MERCHANT_PUBLIC_KEY | "public.pem" |
| VICTORIA_BANK_MERCHANT_TERMINAL_ID | "49892038" |
| VICTORIA_BANK_MERCHANT_TIMEZONE_NAME | "Europe/Chisinau" |
| VICTORIA_BANK_MERCHANT_URL | "https://www.lxhost.com/" |
| VICTORIA_BANK_SECURITY_SIGNATURE_FIRST | "0001" |
| VICTORIA_BANK_SECURITY_SIGNATURE_PADDING | "00" |
| VICTORIA_BANK_SECURITY_SIGNATURE_PREFIX | "3020300C06082A864886F70D020505000410" |
Defined as regular env variables
| Key | Value |
|---|---|
| APP_DEBUG | "1" |
| APP_PROJECT_DIR | "/var/www/vhosts/1007/domains/n46.net/imobiliare" |
| APP_RUNTIME | "Symfony\Component\Runtime\SymfonyRuntime" |
| APP_RUNTIME_OPTIONS | [ "project_dir" => "/var/www/vhosts/1007/domains/n46.net/imobiliare" ] |
| CONTEXT_DOCUMENT_ROOT | "/var/www/vhosts/1007/domains/n46.net/imobiliare/public_html" |
| CONTEXT_PREFIX | "" |
| DOCUMENT_ROOT | "/var/www/vhosts/1007/domains/n46.net/imobiliare/public_html" |
| FCGI_ROLE | "RESPONDER" |
| GATEWAY_INTERFACE | "CGI/1.1" |
| H2PUSH | "off" |
| H2_PUSH | "off" |
| H2_PUSHED | "" |
| H2_PUSHED_ON | "" |
| H2_STREAM_ID | "9" |
| H2_STREAM_TAG | "3839595-409-9" |
| HOME | "/var/www/vhosts/1007/domains" |
| HTTP2 | "on" |
| HTTPS | "on" |
| HTTP_ACCEPT | "*/*" |
| HTTP_ACCEPT_ENCODING | "gzip, br, zstd, deflate" |
| HTTP_AUTHORIZATION | "" |
| HTTP_COOKIE | "device_view=full; company_secured_area_deauth_profile_token=684649; PHPSESSID=b1f8bd10f4b8170e94694468c12af17a; user_secured_area_deauth_profile_token=710d69" |
| HTTP_HOST | "imobiliare.n46.net" |
| HTTP_USER_AGENT | "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" |
| PATH | "/usr/local/bin:/usr/bin" |
| PERL5LIB | "/usr/share/awstats/lib:/usr/share/awstats/plugins" |
| PHP_SELF | "/index.php" |
| QUERY_STRING | "" |
| REDIRECT_H2PUSH | "off" |
| REDIRECT_H2_PUSH | "off" |
| REDIRECT_H2_PUSHED | "" |
| REDIRECT_H2_PUSHED_ON | "" |
| REDIRECT_H2_STREAM_ID | "9" |
| REDIRECT_H2_STREAM_TAG | "3839595-409-9" |
| REDIRECT_HTTP2 | "on" |
| REDIRECT_HTTPS | "on" |
| REDIRECT_PERL5LIB | "/usr/share/awstats/lib:/usr/share/awstats/plugins" |
| REDIRECT_SCRIPT_URI | "https://imobiliare.n46.net/en/residential-complexes" |
| REDIRECT_SCRIPT_URL | "/en/residential-complexes" |
| REDIRECT_SSL_TLS_SNI | "imobiliare.n46.net" |
| REDIRECT_STATUS | "200" |
| REDIRECT_UNIQUE_ID | "aW_Ik46zt_ZwoWWims8oYQABERE" |
| REDIRECT_URL | "/en/residential-complexes" |
| REMOTE_ADDR | "216.73.216.102" |
| REMOTE_PORT | "38657" |
| REQUEST_METHOD | "GET" |
| REQUEST_SCHEME | "https" |
| REQUEST_TIME | 1768933523 |
| REQUEST_TIME_FLOAT | 1768933523.3508 |
| REQUEST_URI | "/en/residential-complexes" |
| SCRIPT_FILENAME | "/var/www/vhosts/1007/domains/n46.net/imobiliare/public_html/index.php" |
| SCRIPT_NAME | "/index.php" |
| SCRIPT_URI | "https://imobiliare.n46.net/en/residential-complexes" |
| SCRIPT_URL | "/en/residential-complexes" |
| SERVER_ADDR | "37.27.239.38" |
| SERVER_ADMIN | "root@localhost" |
| SERVER_NAME | "imobiliare.n46.net" |
| SERVER_PORT | "443" |
| SERVER_PROTOCOL | "HTTP/2.0" |
| SERVER_SIGNATURE | "" |
| SERVER_SOFTWARE | "Apache/2.4.65 (Fedora Linux) OpenSSL/3.2.6 mod_perl/2.0.13 Perl/v5.40.3" |
| SSL_TLS_SNI | "imobiliare.n46.net" |
| SYMFONY_DOTENV_PATH | "/var/www/vhosts/1007/domains/n46.net/imobiliare/.env" |
| SYMFONY_DOTENV_VARS | "APP_ENV,APP_SECRET,APP_SHARE_DIR,DATABASE_URL,MAILER_DSN,DEFAULT_URI,DOMAIN_NAME,EMAIL_NOREPLY,EMAIL_INFO,EMAIL_SUPPORT,EMAIL_FROM_NAME,TELEPHONE_NUMBER,MAPBOX_ACCESS_TOKEN,GOOGLE_RECAPTCHA_SITE_KEY,GOOGLE_RECAPTCHA_SECRET_KEY,GOOGLE_API_KEY_HTTP_REFERRERS,GOOGLE_API_KEY_IP_ADDRESSES,GOOGLE_MAP_ID,GTM,ADSENSE,VICTORIA_BANK_CARD_ACCEPTOR_ID,VICTORIA_BANK_MERCHANT_TERMINAL_ID,VICTORIA_BANK_SECURITY_SIGNATURE_FIRST,VICTORIA_BANK_SECURITY_SIGNATURE_PREFIX,VICTORIA_BANK_SECURITY_SIGNATURE_PADDING,VICTORIA_BANK_MERCHANT_NAME,VICTORIA_BANK_MERCHANT_ADDRESS,VICTORIA_BANK_MERCHANT_URL,VICTORIA_BANK_MERCHANT_PUBLIC_KEY,VICTORIA_BANK_MERCHANT_PRIVATE_KEY,VICTORIA_BANK_MERCHANT_BANK_PUBLIC_KEY,VICTORIA_BANK_MERCHANT_TIMEZONE_NAME,VICTORIA_BANK_MERCHANT_COUNTRY_CODE,VICTORIA_BANK_MERCHANT_DEFAULT_LANGUAGE,JWT_SECRET_KEY,JWT_PUBLIC_KEY,JWT_PASSPHRASE,REDIS_HOST,REDIS_PORT,REDIS_PASSWORD,TELEGRAM_DSN,FACEBOOK_APP_ID,GOOGLE_API_KEY,GOOGLE_CLIENT_ID,GOOGLE_CLIENT_SECRET,GOOGLE_AUTH_CONFIG,GOOGLE_PROJECT_ID,LOCK_DSN" |
| UNIQUE_ID | "aW_Ik46zt_ZwoWWims8oYQABERE" |
| USER | "a1007" |
| proxy-nokeepalive | "1" |
Sub Requests 1
ErrorController (token = 843913)
| Key | Value |
|---|---|
| _controller | "error_controller" |
| _stopwatch_token | "e5190a" |
| exception | Doctrine\DBAL\Exception\InvalidFieldNameException {#992 #message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.instagram_reel_id' in 'SELECT'" #code: 1054 #file: "/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php" #line: 63 -previous: Doctrine\DBAL\Driver\PDO\Exception {#1140 …} -query: Doctrine\DBAL\Query {#1277 …} : { { Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException … › |
| logger | Symfony\Bridge\Monolog\Processor\DebugProcessor {#274 -records: [ 12 => [ [ "timestamp" => 1768933523 "timestamp_rfc3339" => "2026-01-20T18:25:23.462+00:00" "message" => "Matched route "{route}"." "priority" => 200 "priorityName" => "INFO" "context" => [ "route" => "list_residential_complexes" "route_parameters" => [ "_route" => "list_residential_complexes" "_controller" => "App\Controller\ResidentialComplexController::listResidentialComplexes" "_locale" => "en" ] "request_uri" => "https://imobiliare.n46.net/en/residential-complexes" "method" => "GET" ] "channel" => "request" ] [ "timestamp" => 1768933523 "timestamp_rfc3339" => "2026-01-20T18:25:23.471+00:00" "message" => "Checking for authenticator support." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "firewall_name" => "user_secured_area" "authenticators" => 2 ] "channel" => "security" ] [ "timestamp" => 1768933523 "timestamp_rfc3339" => "2026-01-20T18:25:23.471+00:00" "message" => "Checking support on authenticator." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "firewall_name" => "user_secured_area" "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator" ] "channel" => "security" ] [ "timestamp" => 1768933523 "timestamp_rfc3339" => "2026-01-20T18:25:23.471+00:00" "message" => "Authenticator does not support the request." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "firewall_name" => "user_secured_area" "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator" ] "channel" => "security" ] [ "timestamp" => 1768933523 "timestamp_rfc3339" => "2026-01-20T18:25:23.471+00:00" "message" => "Checking support on authenticator." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "firewall_name" => "user_secured_area" "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator" ] "channel" => "security" ] [ "timestamp" => 1768933523 "timestamp_rfc3339" => "2026-01-20T18:25:23.471+00:00" "message" => "Authenticator does not support the request." "priority" => 100 "priorityName" => "DEBUG" "context" => [ "firewall_name" => "user_secured_area" "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator" ] "channel" => "security" ] [ "timestamp" => 1768933523 "timestamp_rfc3339" => "2026-01-20T18:25:23.534+00:00" "message" => "Connecting with parameters {params}" "priority" => 200 "priorityName" => "INFO" "context" => [ "params" => [ "driver" => "pdo_mysql" "charset" => "utf8mb4" "idle_connection_ttl" => 600 "host" => "127.0.0.1" "port" => 3306 "user" => "1007-imobiliare" "password" => "<redacted>" "driverOptions" => [] "serverVersion" => "mariadb-10.11.15" "defaultTableOptions" => [ "charset" => "utf8mb4" "collation" => "utf8mb4_unicode_ci" "engine" => "InnoDB" ] "dbname" => "1007-imobiliare" ] ] "channel" => "doctrine" ] [ "timestamp" => 1768933523 "timestamp_rfc3339" => "2026-01-20T18:25:23.535+00:00" "message" => "Executing statement: {sql} (parameters: {params}, types: {types})" "priority" => 100 "priorityName" => "DEBUG" "context" => [ "sql" => "SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2, ST_AsText(a0_.multipolygon) AS multipolygon_3, ST_AsText(a0_.centroid) AS centroid_4, a0_.land_area AS land_area_5, a0_.name AS name_6, a0_.rcslug AS rcslug_7, a0_.address AS address_8, a0_.instagram_reel_id AS instagram_reel_id_9, a0_.price_per_square_meter AS price_per_square_meter_10, a0_.completion_date AS completion_date_11, a0_.is_sold_out AS is_sold_out_12, a0_.client_status AS client_status_13, a0_.server_status AS server_status_14, a0_.views AS views_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.company_id AS company_id_18, a0_.locality_id AS locality_id_19 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC LIMIT 10" "params" => [ 1 => "active" 2 => "ok" ] "types" => [ 1 => Doctrine\DBAL\ParameterType {#1141 +name: "STRING" } 2 => Doctrine\DBAL\ParameterType {#1141} ] ] "channel" => "doctrine" ] [ "timestamp" => 1768933523 "timestamp_rfc3339" => "2026-01-20T18:25:23.542+00:00" "message" => "Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.instagram_reel_id' in 'SELECT'" at ExceptionConverter.php line 63" "priority" => 500 "priorityName" => "CRITICAL" "context" => [ "exception" => Doctrine\DBAL\Exception\InvalidFieldNameException {#992 #message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.instagram_reel_id' in 'SELECT'" #code: 1054 #file: "/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php" #line: 63 -previous: Doctrine\DBAL\Driver\PDO\Exception {#1140 …} -query: Doctrine\DBAL\Query {#1277 …} : { { Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException … › |