You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
原因:DB::table('information_schema.columns') 会自动加上前缀,导致报错
例:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bool_bool_inform
ation_schema.columns' doesn't exist (SQL: select column_name as Field, column_type as Type, is_nullable as Null, column_key as Key, c olumn_default as Default, extra as Extra, data_type as Data_Type
from bool_bool_information_schema.columns where table_schema = bool_
cms and table_name = bool_admins)
The text was updated successfully, but these errors were encountered:
nwidart\db-exporter\src\Nwidart\DbExporter\DbExporter.php
文件:37行
'information_schema.columns' 修正为 DB::raw('information_schema.columns')
原因:DB::table('information_schema.columns') 会自动加上前缀,导致报错
例:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bool_bool_inform
ation_schema.columns' doesn't exist (SQL: select
column_name
asField
,column_type
asType
,is_nullable
asNull
,column_key
asKey
,c olumn_default
asDefault
,extra
asExtra
,data_type
asData_Type
from
bool_bool_information_schema
.columns
wheretable_schema
= bool_cms and
table_name
= bool_admins)The text was updated successfully, but these errors were encountered: