SQLSTATE[HY000] [2002] Нет такого файла или каталога (Соединение: mysql, SQL: ...) При обновлении записей БДPhp

Кемеровские программисты php общаются здесь
Ответить Пред. темаСлед. тема
Anonymous
 SQLSTATE[HY000] [2002] Нет такого файла или каталога (Соединение: mysql, SQL: ...) При обновлении записей БД

Сообщение Anonymous »

Подключение к БД запрещено только с сайта.
PHP 8.2.4
laravel 10.31.0
у меня 2 на сервере есть веб-сайт.
1- имеет главную БД.
2- имеет подчиненную БД.
.env-файл для главного сервера БД:

Код: Выделить всё

DB_CONNECTION=mysql
DB_HOST=localhost
DB_WRITE_HOST=
DB_PORT=3306
DB_DATABASE=
DB_USERNAME=
DB_PASSWORD=
DB_SSL_MODE=

MYSQL_ATTR_SSL_VERIFY_SERVER_CERT=false
MYSQL_ATTR_SSL_CA=
MYSQL_ATTR_SSL_KEY=
MYSQL_ATTR_SSL_CERT=
База данных.php:

Код: Выделить всё

'mysql' => [
'read'        => [
'host' => env( 'DB_HOST', '127.0.0.1' ),
'options' => []
],
'write'       => [
'host'    => env( 'DB_WRITE_HOST', '127.0.0.1' ),
'sslmode' => env( 'DB_SSL_MODE', false ) ? 'require' : 'prefer',
'options' => [], //  'mysql',
'url'         => env( 'DATABASE_URL' ),
'port'        => env( 'DB_PORT', '3306' ),
'database'    => env( 'DB_DATABASE', 'forge' ),
'username'    => env( 'DB_USERNAME', 'forge' ),
'password'    => env( 'DB_PASSWORD', '' ),
'unix_socket' => env( 'DB_SOCKET', '' ),
'charset'     => 'utf8mb4',
'collation'   => 'utf8mb4_unicode_ci',
'prefix'      => '',
'prefix_indexes' => true,
'strict'      => true,
'engine'      =>  null,
],
при подключении чтения к БД все идет нормально.
при записи любого запроса происходит сбой.
пример:

Код: Выделить всё

Illuminate\Database\QueryException:
SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL:  update `posts` set `views` = 643,  ` p o s t s ` . ` u p d a t e d _ a t `   =   2 0 2 4 - 0 7 - 0 4   1 3 : 2 2 : 0 4   w h e r e   ` i d `   =   4 2 ) < b r   / > < b r   / >     a t   / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 8 2 9 < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; r u n Q u e r y C a l l b a c k ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 9 8 3 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; t r y A g a i n I f C a u s e d B y L o s t C o n n e c t i o n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 9 6 2 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; h a n d l e Q u e r y E x c e p t i o n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 7 8 5 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; r u n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 6 0 0 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; a f f e c t i n g S t a t e m e n t ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 5 5 2 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; u p d a t e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / Q u e r y / B u i l d e r . p h p : 3 5 6 0 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ Q u e r y \ B u i l d e r - & g t ; u p d a t e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / E l o q u e n t / B u i l d e r . p h p : 1 0 6 1 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ E l o q u e n t \ B u i l d e r - & g t ; u p d a t e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / E l o q u e n t / M o d e l . p h p : 1 2 1 3 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ E l o q u e n t \ M o d e l - & g t ; p e r f o r m U p d a t e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / E l o q u e n t / M o d e l . p h p : 1 1 3 0 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ E l o q u e n t \ M o d e l - & g t ; s a v e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / t c g / v o y a g e r / s r c / M o d e l s / P o s t . p h p : 3 0 ) < b r   / >     a t   T C G \ V o y a g e r \ M o d e l s \ P o s t - & g t ; s a v e ( ) < b r   / >           ( / v a r / w w w / h t m l / a p p / H t t p / C o n t r o l l e r s / P o s t s C o n t r o l l e r . p h p : 6 2 ) < b r   / >     a t   A p p \ H t t p \ C o n t r o l l e r s \ P o s t s C o n t r o l l e r - & g t ; s h o w ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / C o n t r o l l e r . p h p : 5 4 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ C o n t r o l l e r - & g t ; c a l l A c t i o n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / C o n t r o l l e r D i s p a t c h e r . p h p : 4 3 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ C o n t r o l l e r D i s p a t c h e r - & g t ; d i s p a t c h ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / R o u t e . p h p : 2 5 9 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ R o u t e - & g t ; r u n C o n t r o l l e r ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / R o u t e . p h p : 2 0 5 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ R o u t e - & g t ; r u n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / R o u t e r . p h p : 8 0 6 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ R o u t e r - & g t ; I l l u m i n a t e \ R o u t i n g \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / P i p e l i n e / P i p e l i n e . p h p : 1 4 4 ) < b r   / >     a t   I l l u m i n a t e \ P i p e l i n e \ P i p e l i n e - & g t ; I l l u m i n a t e \ P i p e l i n e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / a p p / H t t p / M i d d l e w a r e / L a n g u a g e . p h p : 2 3 ) < b r   / >     a t   A p p \ H t t p \ M i d d l e w a r e \ L a n g u a g e - & g t ; h a n d l e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / P i p e l i n e / P i p e l i n e . p h p : 1 8 3 ) < b r   / >     a t   I l l u m i n a t e \ P i p e l i n e \ P i p e l i n e - & g t ; I l l u m i n a t e \ P i p e l i n e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / M i d d l e w a r e / S u b s t i t u t e B i n d i n g s . p h p : 5 0 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ M i d d l e w a r e \ S u b s t i t u t e B i n d i n g s - & g t ; h a n d l e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / P i p e l i n e / P i p e l i n e . p h p : 1 8 3 ) < b r   / >     a t   I l l u m i n a t e \ P i p e l i n e \ P i p e l i n e - & g t ; I l l u m i n a t e \ P i p e l i n e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / F o u n d a t i o n / H t t p / M i d d l e w a r e / V e r i f y C s r f T o k e n . p h p : 7 8 ) < b r   / >     a t   I l l u m i n a t e \ F o u n d a t i o n \ H t t p \ M i d d l e w a r e \ V e r i f y C s r f T o k e n - & g t ; h a n d l e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / P i p e l i n e / P i p e l i n e . p h p : 1 8 3 ) < b r   / >     a t   I l l u m i n a t e \ P i p e l i n e \ P i p e l i n e - & g t ; I l l u m i n a t e \ P i p e l i n e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / V i e w / M i d d l e w a r e / S h a r e E r r o r s F r o m S e s s i o n . p h p : 4 9 ) < b r   / >     a t   I l l u m i n a t e \ V i e w \ M i d d l e w a r e \ S h a r e E r r o r s F r o m S e s s i o n - & g t ; h a n d l e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / P i p e l i n e / P i p e l i n e . p h p : 1 8 3 ) < b r   / >     a t   I l l u m i n a t e \ P i p e l i n e \ P i p e l i n e - & g t ; I l l u m i n a t e \ P i p e l i n e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n dor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:121)
at Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64)
at Illuminate\Session\Middleware\StartSession->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37)
at Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67)
at Illuminate\Cookie\Middleware\EncryptCookies->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:119)
at Illuminate\Pipeline\Pipeline->then()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:805)
at Illuminate\Routing\Router->runRouteWithinStack()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:784)
at Illuminate\Routing\Router->runRoute()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:748)
at Illuminate\Routing\Router->dispatchToRoute()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:737)
at Illuminate\Routing\Router->dispatch()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200)
at Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:144)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31)
at Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:40)
at Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27)
at Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:99)
at Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:39)
at Illuminate\Http\Middleware\TrustProxies->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:119)
at Illuminate\Pipeline\Pipeline->then()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175)
at Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144)
at Illuminate\Foundation\Http\Kernel->handle()
(/var/www/html/public/index.php:51)      < b r   / > < / c o d e > < b r   / > P D O E x c e p t i o n : < / p > < b r   / > < c o d e > S Q L S T A T E [ H Y 0 0 0 ]   [ 2 0 0 2 ]   N o   s u c h   f i l e   o r   d i r e c t o r y < b r   / > < b r   / >     a t   / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t o r s / C o n n e c t o r . p h p : 6 5 < b r   / >     a t   P D O - & g t ; _ _ c o n s t r u c t ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t o r s / C o n n e c t o r . p h p : 6 5 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t o r s \ C o n n e c t o r - & g t ; c r e a t e P d o C o n n e c t i o n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t o r s / C o n n e c t o r . p h p : 8 3 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t o r s \ C o n n e c t o r - & g t ; t r y A g a i n I f C a u s e d B y L o s t C o n n e c t i o n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t o r s / C o n n e c t o r . p h p : 4 8 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t o r s \ C o n n e c t o r - & g t ; c r e a t e C o n n e c t i o n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t o r s / M y S q l C o n n e c t o r . p h p : 2 4 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t o r s \ M y S q l C o n n e c t o r - & g t ; c o n n e c t ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t o r s / C o n n e c t i o n F a c t o r y . p h p : 1 8 4 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t o r s \ C o n n e c t i o n F a c t o r y - & g t ; I l l u m i n a t e \ D a t a b a s e \ C o n n e c t o r s \ { c l o s u r e } ( ) < b r   / >     a t   c a l l _ u s e r _ f u n c ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 1 3 3 9 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; g e t P d o ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 6 0 8 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; I l l u m i n a t e \ D a t a b a s e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 8 1 6 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; r u n Q u e r y C a l l b a c k ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 9 8 3 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; t r y A g a i n I f C a u s e d B y L o s t C o n n e c t i o n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 9 6 2 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; h a n d l e Q u e r y E x c e p t i o n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 7 8 5 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; r u n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 6 0 0 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; a f f e c t i n g S t a t e m e n t ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / C o n n e c t i o n . p h p : 5 5 2 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ C o n n e c t i o n - & g t ; u p d a t e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / Q u e r y / B u i l d e r . p h p : 3 5 6 0 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ Q u e r y \ B u i l d e r - & g t ; u p d a t e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / E l o q u e n t / B u i l d e r . p h p : 1 0 6 1 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ E l o q u e n t \ B u i l d e r - & g t ; u p d a t e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / E l o q u e n t / M o d e l . p h p : 1 2 1 3 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ E l o q u e n t \ M o d e l - & g t ; p e r f o r m U p d a t e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / D a t a b a s e / E l o q u e n t / M o d e l . p h p : 1 1 3 0 ) < b r   / >     a t   I l l u m i n a t e \ D a t a b a s e \ E l o q u e n t \ M o d e l - & g t ; s a v e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / t c g / v o y a g e r / s r c / M o d e l s / P o s t . p h p : 3 0 ) < b r   / >     a t   T C G \ V o y a g e r \ M o d e l s \ P o s t - & g t ; s a v e ( ) < b r   / >           ( / v a r / w w w / h t m l / a p p / H t t p / C o n t r o l l e r s / P o s t s C o n t r o l l e r . p h p : 6 2 ) < b r   / >     a t   A p p \ H t t p \ C o n t r o l l e r s \ P o s t s C o n t r o l l e r - & g t ; s h o w ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / C o n t r o l l e r . p h p : 5 4 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ C o n t r o l l e r - & g t ; c a l l A c t i o n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / C o n t r o l l e r D i s p a t c h e r . p h p : 4 3 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ C o n t r o l l e r D i s p a t c h e r - & g t ; d i s p a t c h ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / R o u t e . p h p : 2 5 9 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ R o u t e - & g t ; r u n C o n t r o l l e r ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / R o u t e . p h p : 2 0 5 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ R o u t e - & g t ; r u n ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / R o u t e r . p h p : 8 0 6 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ R o u t e r - & g t ; I l l u m i n a t e \ R o u t i n g \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / P i p e l i n e / P i p e l i n e . p h p : 1 4 4 ) < b r   / >     a t   I l l u m i n a t e \ P i p e l i n e \ P i p e l i n e - & g t ; I l l u m i n a t e \ P i p e l i n e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / a p p / H t t p / M i d d l e w a r e / L a n g u a g e . p h p : 2 3 ) < b r   / >     a t   A p p \ H t t p \ M i d d l e w a r e \ L a n g u a g e - & g t ; h a n d l e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / P i p e l i n e / P i p e l i n e . p h p : 1 8 3 ) < b r   / >     a t   I l l u m i n a t e \ P i p e l i n e \ P i p e l i n e - & g t ; I l l u m i n a t e \ P i p e l i n e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / R o u t i n g / M i d d l e w a r e / S u b s t i t u t e B i n d i n g s . p h p : 5 0 ) < b r   / >     a t   I l l u m i n a t e \ R o u t i n g \ M i d d l e w a r e \ S u b s t i t u t e B i n d i n g s - & g t ; h a n d l e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / P i p e l i n e / P i p e l i n e . p h p : 1 8 3 ) < b r   / >     a t   I l l u m i n a t e \ P i p e l i n e \ P i p e l i n e - & g t ; I l l u m i n a t e \ P i p e l i n e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / F o u n d a t i o n / H t t p / M i d d l e w a r e / V e r i f y C s r f T o k e n . p h p : 7 8 ) < b r   / >     a t   I l l u m i n a t e \ F o u n d a t i o n \ H t t p \ M i d d l e w a r e \ V e r i f y C s r f T o k e n - & g t ; h a n d l e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / P i p e l i n e / P i p e l i n e . p h p : 1 8 3 ) < b r   / >     a t   I l l u m i n a t e \ P i p e l i n e \ P i p e l i n e - & g t ; I l l u m i n a t e \ P i p e l i n e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / V i e w / M i d d l e w a r e / S h a r e E r r o r s F r o m S e s s i o n . p h p : 4 9 ) < b r   / >     a t   I l l u m i n a t e \ V i e w \ M i d d l e w a r e \ S h a r e E r r o r s F r o m S e s s i o n - & g t ; h a n d l e ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n d o r / l a r a v e l / f r a m e w o r k / s r c / I l l u m i n a t e / P i p e l i n e / P i p e l i n e . p h p : 1 8 3 ) < b r   / >     a t   I l l u m i n a t e \ P i p e l i n e \ P i p e l i n e - & g t ; I l l u m i n a t e \ P i p e l i n e \ { c l o s u r e } ( ) < b r   / >           ( / v a r / w w w / h t m l / v e n dor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:121)
at Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64)
at Illuminate\Session\Middleware\StartSession->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37)
at Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67)
at Illuminate\Cookie\Middleware\EncryptCookies->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:119)
at Illuminate\Pipeline\Pipeline->then()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:805)
at Illuminate\Routing\Router->runRouteWithinStack()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:784)
at Illuminate\Routing\Router->runRoute()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:748)
at Illuminate\Routing\Router->dispatchToRoute()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:737)
at Illuminate\Routing\Router->dispatch()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200)
at Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:144)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31)
at Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21)
at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:40)
at Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27)
at Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:99)
at Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:39)
at Illuminate\Http\Middleware\TrustProxies->handle()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183)
at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:119)
at Illuminate\Pipeline\Pipeline->then()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175)
at Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
(/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144)
at Illuminate\Foundation\Http\Kernel->handle()
(/var/www/html/public/index.php:51)
Пытался удалить все параметры хоста записи,
пробовал проверить соединение MySQL из командной строки, все работает нормально. не получается только с веб-сайта.
проверьте кеш
проверьте права доступа к файлу.
проверьте, чтобы запустить запрос на обновление в БД с помощью CMD, работает нормально.
попробовал изменить с
127.0.0.1 -> localhost и наоборот

Подробнее здесь: https://stackoverflow.com/questions/787 ... ysql-sql-w
Реклама
Ответить Пред. темаСлед. тема

Быстрый ответ

Изменение регистра текста: 
Смайлики
:) :( :oops: :roll: :wink: :muza: :clever: :sorry: :angel: :read: *x)
Ещё смайлики…
   
К этому ответу прикреплено по крайней мере одно вложение.

Если вы не хотите добавлять вложения, оставьте поля пустыми.

Максимально разрешённый размер вложения: 15 МБ.

  • Похожие темы
    Ответы
    Просмотры
    Последнее сообщение
  • SQLSTATE[HY000] [2002] Нет такого файла или каталога (Соединение: mysql, SQL: ...) При обновлении записей БД
    Anonymous » » в форуме Php
    0 Ответы
    23 Просмотры
    Последнее сообщение Anonymous
  • CDbConnection не удалось открыть соединение с БД: SQLSTATE[HY000] [2002] Нет такого файла или каталога PHP+DOCKER+YII+MY
    Anonymous » » в форуме Php
    0 Ответы
    95 Просмотры
    Последнее сообщение Anonymous
  • Cakephp испечь SQLSTATE[HY000] [2002] Нет такого файла или каталога
    Anonymous » » в форуме Php
    0 Ответы
    48 Просмотры
    Последнее сообщение Anonymous
  • PDOException SQLSTATE[HY000] [2002] Нет такого файла или каталога
    Anonymous » » в форуме Php
    0 Ответы
    20 Просмотры
    Последнее сообщение Anonymous
  • Как устранить эту ошибку: SQLSTATE[HY000] [2002] Нет такого файла или каталога?
    Anonymous » » в форуме Php
    0 Ответы
    22 Просмотры
    Последнее сообщение Anonymous

Вернуться в «Php»