Subject: Errors at miniraktar24.hu (DEV)
From: [email-masked]
To: [email-masked]
Date: Tue, 14 Oct 2025 09:56:24 +0200

2025-10-14 09:56:24 [88.151.102.206][3][-][error][application]
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column
'pictureId' in 'WHERE' in
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/Command.php:1320
Stack trace:
#0
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/Command.php(1320):
PDOStatement->execute()
#1
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/Command.php(1186):
yii\db\Command->internalExecute()
#2
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/Command.php(417):
yii\db\Command->queryInternal()
#3
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/Query.php(249):
yii\db\Command->queryAll()
#4
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveQuery.php(133):
yii\db\Query->all()
#5
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveRelationTrait.php(187):
yii\db\ActiveQuery->all()
#6
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/BaseActiveRecord.php(299):
yii\db\ActiveQuery->findFor()
#7 /home/vjgwowje/public_html/app/models/File.php(68):
yii\db\BaseActiveRecord->__get()
#8
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveRecord.php(770):
app\models\File->afterDelete()
#9
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveRecord.php(724):
yii\db\ActiveRecord->deleteInternal()
#10 /home/vjgwowje/public_html/app/db/ActiveRecord.php(217):
yii\db\ActiveRecord->delete()
#11 /home/vjgwowje/public_html/app/db/ActiveRecord.php(234):
app\db\ActiveRecord->delete()
#12 /home/vjgwowje/public_html/app/models/Photo.php(77):
app\db\ActiveRecord->deleteRelated()
#13
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveRecord.php(770):
app\models\Photo->afterDelete()
#14
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveRecord.php(724):
yii\db\ActiveRecord->deleteInternal()
#15 /home/vjgwowje/public_html/app/db/ActiveRecord.php(217):
yii\db\ActiveRecord->delete()
#16
/home/vjgwowje/public_html/app/modules/admin/action/Delete.php(87):
app\db\ActiveRecord->delete()
#17
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/base/Controller.php(178):
app\modules\admin\action\Delete->runWithParams()
#18
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/base/Module.php(552):
yii\base\Controller->runAction()
#19
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/web/Application.php(103):
yii\base\Module->runAction()
#20
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/base/Application.php(384):
yii\web\Application->handleRequest()
#21 /home/vjgwowje/public_html/app/web/index.php(20):
yii\base\Application->run()
#22 {main}

Next yii\db\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown
column 'pictureId' in 'WHERE'
The SQL being executed was: SELECT * FROM `content` WHERE
`pictureId`=798 in
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/Schema.php:676
Stack trace:
#0
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/Command.php(1325):
yii\db\Schema->convertException()
#1
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/Command.php(1186):
yii\db\Command->internalExecute()
#2
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/Command.php(417):
yii\db\Command->queryInternal()
#3
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/Query.php(249):
yii\db\Command->queryAll()
#4
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveQuery.php(133):
yii\db\Query->all()
#5
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveRelationTrait.php(187):
yii\db\ActiveQuery->all()
#6
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/BaseActiveRecord.php(299):
yii\db\ActiveQuery->findFor()
#7 /home/vjgwowje/public_html/app/models/File.php(68):
yii\db\BaseActiveRecord->__get()
#8
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveRecord.php(770):
app\models\File->afterDelete()
#9
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveRecord.php(724):
yii\db\ActiveRecord->deleteInternal()
#10 /home/vjgwowje/public_html/app/db/ActiveRecord.php(217):
yii\db\ActiveRecord->delete()
#11 /home/vjgwowje/public_html/app/db/ActiveRecord.php(234):
app\db\ActiveRecord->delete()
#12 /home/vjgwowje/public_html/app/models/Photo.php(77):
app\db\ActiveRecord->deleteRelated()
#13
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveRecord.php(770):
app\models\Photo->afterDelete()
#14
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/db/ActiveRecord.php(724):
yii\db\ActiveRecord->deleteInternal()
#15 /home/vjgwowje/public_html/app/db/ActiveRecord.php(217):
yii\db\ActiveRecord->delete()
#16
/home/vjgwowje/public_html/app/modules/admin/action/Delete.php(87):
app\db\ActiveRecord->delete()
#17
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/base/Controller.php(178):
app\modules\admin\action\Delete->runWithParams()
#18
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/base/Module.php(552):
yii\base\Controller->runAction()
#19
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/web/Application.php(103):
yii\base\Module->runAction()
#20
/home/vjgwowje/public_html/app/vendor/yiisoft/yii2/base/Application.php(384):
yii\web\Application->handleRequest()
#21 /home/vjgwowje/public_html/app/web/index.php(20):
yii\base\Application->run()
#22 {main}
Additional Information:
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'pictureId' in 'WHERE'
)

    in /home/vjgwowje/public_html/app/db/ActiveRecord.php:219
    in /home/vjgwowje/public_html/app/db/ActiveRecord.php:234
    in /home/vjgwowje/public_html/app/models/Photo.php:77
2025-10-14 09:56:24 [88.151.102.206][3][-][info][application] $_GET =
[
    'id' => '798'
    'expand' => 'photos'
    'propagates' => '{\"storageId\":231,\"locationId\":10}'
]

$_POST = []

$_FILES = []

$_COOKIE = [
    '_cookieSettings' =>
'{\"R\":true,\"S\":true,\"M\":true,\"P\":true}'
    'timezone' => 'Europe/Berlin'
    'cpsession' =>
'vjgwowje:V7dVh6AiGxzUruLG,bba5b5020063ba60f1d86986fe323df7'
    'PHPSESSID' => 'ro6nvnruqmrcvmha87sjv4qod7'
    '_csrf' =>
'4d796107d7082ab0bb3558ecde0c2a533f5dd46f75c3a57c9d82a88c44499f76a:2:{i:0;s:5:\"_csrf\";i:1;s:32:\"i16lo1n5-k9WDBvqQS7hvTil-JHDb83W\";}'
]

$_SESSION = [
    '__flash' => []
    '__returnUrl' => 'https://miniraktar24.hu/admin/locations/index'
    '__id' => 3
    '__authKey' => 'nAYLS0nIcYpNZ7EzYeLs9axcylkbbd7_'
    '__expire' => 1760514984
    'lastPingTime' => 1760428563
]

$_SERVER = [
    'LSPHP_ENABLE_USER_INI' => 'on'
    'PATH' => '/usr/local/bin:/usr/bin:/bin'
    'PWD' => '/'
    'HTTP_ACCEPT' => 'application/json, text/javascript, */*; q=0.01'
    'HTTP_ACCEPT_ENCODING' => 'gzip, deflate, br, zstd'
    'HTTP_ACCEPT_LANGUAGE' =>
'hu-HU,hu;q=0.9,en-US;q=0.8,en;q=0.7,sk;q=0.6,cs;q=0.5,ro;q=0.4,pl;q=0.3,de;q=0.2,ja;q=0.1,la;q=0.1'
    'CONTENT_LENGTH' => '0'
    'HTTP_COOKIE' =>
'_cookieSettings=%7B%22R%22%3Atrue%2C%22S%22%3Atrue%2C%22M%22%3Atrue%2C%22P%22%3Atrue%7D;
timezone=Europe/Berlin;
cpsession=vjgwowje%3aV7dVh6AiGxzUruLG%2cbba5b5020063ba60f1d86986fe323df7;
PHPSESSID=ro6nvnruqmrcvmha87sjv4qod7;
_csrf=4d796107d7082ab0bb3558ecde0c2a533f5dd46f75c3a57c9d82a88c44499f76a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22i16lo1n5-k9WDBvqQS7hvTil-JHDb83W%22%3B%7D'
    'HTTP_HOST' => 'miniraktar24.hu'
    'HTTP_REFERER' =>
'https://miniraktar24.hu/admin/storages/edit/231?propagates=%7B%22locationId%22%3A10%7D'
    'HTTP_USER_AGENT' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'
    'HTTP_SEC_CH_UA_PLATFORM' => '\"Windows\"'
    'HTTP_X_CSRF_TOKEN' =>
'eMiir9UXcqbcDxgQhka0Z1H8H69z0tq9TyZLxafIWrIR-ZTDuiYck_FkIUfCBMIWAK8oxwWGs9FibAOBxfBp5Q=='
    'HTTP_X_REQUESTED_WITH' => 'XMLHttpRequest'
    'HTTP_SEC_CH_UA' => '\"Google Chrome\";v=\"141\",
\"Not?A_Brand\";v=\"8\", \"Chromium\";v=\"141\"'
    'HTTP_SEC_CH_UA_MOBILE' => '?0'
    'HTTP_SEC_FETCH_SITE' => 'same-origin'
    'HTTP_SEC_FETCH_MODE' => 'cors'
    'HTTP_SEC_FETCH_DEST' => 'empty'
    'HTTP_PRIORITY' => 'u=1, i'
    'HTTP_X_HTTPS' => '1'
    'REDIRECT_UNIQUE_ID' => 'aO4CKJYHRdbsJc6hkyONuQAAAwE'
    'REDIRECT_SCRIPT_URL' => '/admin/photos/delete/798'
    'REDIRECT_SCRIPT_URI' =>
'https://miniraktar24.hu/admin/photos/delete/798'
    'REDIRECT_HTTPS' => 'on'
    'REDIRECT_SSL_TLS_SNI' => 'miniraktar24.hu'
    'REDIRECT_HTTP2' => 'on'
    'REDIRECT_H2PUSH' => 'off'
    'REDIRECT_H2_PUSH' => 'off'
    'REDIRECT_H2_PUSHED' => ''
    'REDIRECT_H2_PUSHED_ON' => ''
    'REDIRECT_H2_STREAM_ID' => '1'
    'REDIRECT_H2_STREAM_TAG' => '2312158-4448-1'
    'REDIRECT_STATUS' => '200'
    'UNIQUE_ID' => 'aO4CKJYHRdbsJc6hkyONuQAAAwE'
    'SCRIPT_URL' => '/admin/photos/delete/798'
    'SCRIPT_URI' => 'https://miniraktar24.hu/admin/photos/delete/798'
    'HTTPS' => 'on'
    'SSL_TLS_SNI' => 'miniraktar24.hu'
    'HTTP2' => 'on'
    'H2PUSH' => 'off'
    'H2_PUSH' => 'off'
    'H2_PUSHED' => ''
    'H2_PUSHED_ON' => ''
    'H2_STREAM_ID' => '1'
    'H2_STREAM_TAG' => '2312158-4448-1'
    'SERVER_SIGNATURE' => ''
    'SERVER_SOFTWARE' => 'Apache'
    'SERVER_NAME' => 'miniraktar24.hu'
    'SERVER_ADDR' => '185.33.55.28'
    'SERVER_PORT' => '443'
    'REMOTE_ADDR' => '88.151.102.206'
    'DOCUMENT_ROOT' => '/home/vjgwowje/public_html/app/web'
    'REQUEST_SCHEME' => 'https'
    'CONTEXT_PREFIX' => ''
    'CONTEXT_DOCUMENT_ROOT' => '/home/vjgwowje/public_html/app/web'
    'SERVER_ADMIN' => [email-masked]'
    'SCRIPT_FILENAME' =>
'/home/vjgwowje/public_html/app/web/index.php'
    'REMOTE_PORT' => '63395'
    'REDIRECT_URL' => '/admin/photos/delete/798'
    'REDIRECT_QUERY_STRING' =>
'expand=photos&propagates=%7B%22storageId%22%3A231%2C%22locationId%22%3A10%7D'
    'SERVER_PROTOCOL' => 'HTTP/2.0'
    'REQUEST_METHOD' => 'GET'
    'QUERY_STRING' =>
'expand=photos&propagates=%7B%22storageId%22%3A231%2C%22locationId%22%3A10%7D'
    'REQUEST_URI' =>
'/admin/photos/delete/798?expand=photos&propagates=%7B%22storageId%22%3A231%2C%22locationId%22%3A10%7D'
    'SCRIPT_NAME' => '/index.php'
    'PHP_SELF' => '/index.php'
    'REQUEST_TIME_FLOAT' => 1760428584.0421
    'REQUEST_TIME' => 1760428584
]