@admin 求助升级后出现报错 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wxapp

官方动态功能建议插件模块风格模板问题反馈技术交流站长杂谈代码共享 V系列产品运营交流

分享 收藏 举报: X

@admin 求助升级后出现报错 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wxapp_id' in 'where cl怎么解决？

无期-6772 消费189.03元 2024-05-23 05:21 05:21

实战运营者

610: 3

升级后报错

https://www.liulangla.cn/bbs/show-3882.html

这个页面电脑端打开没有问题

手机就报错

求大佬指导

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wxapp_id' in 'where clause'

Call Stack

in Connection.php line 388
atConnection->query('SELECT `id` FROM `qb...', ['where_AND_url' => ['https://www.liulangl...', 2], 'where_AND_type' => [2, 1]], false, true) in Query.php line 227
atQuery->query('SELECT `id` FROM `qb...', ['where_AND_url' => ['https://www.liulangl...', 2], 'where_AND_type' => [2, 1]], false, true) in Query.php line 2436
atQuery->getPdo() in Query.php line 413
atQuery->value('id') in Shorturl.php line 30
atShorturl::getId('https://www.liulangl...', 2, 1, 0) in Wxapp.php line 150
atWxapp->wxapp_codeimg('https://www.liulangl...', 1, '', 0) in common.php line 77
at fun('wxapp@wxapp_codeimg', '/index.php/bbs/show-...', 1) in wap_1737b37226ec688bcac4241a7b1803cc.php line 767
at include('/home/ftp/h/hostsiai...') in File.php line 53
atFile->read('/home/ftp/h/hostsiai...', ['auto_tpl_base_layout' => '/home/ftp/h/hostsiai...', 'haibao' => 'content/haibao', 'admin' => true, ...]) in Template.php line 189
atTemplate->fetch('/home/ftp/h/hostsiai...', ['auto_tpl_base_layout' => '/home/ftp/h/hostsiai...', 'haibao' => 'content/haibao', 'admin' => true, ...], []) in Think.php line 86
atThink->fetch('/home/ftp/h/hostsiai...', ['auto_tpl_base_layout' => '/home/ftp/h/hostsiai...', 'haibao' => 'content/haibao', 'admin' => true, ...], []) in View.php line 163
atView->fetch('/home/ftp/h/hostsiai...', ['auto_tpl_base_layout' => '/home/ftp/h/hostsiai...', 'haibao' => 'content/haibao', 'admin' => true, ...], ['__ROOT__' => '', '__URL__' => '/index.php/bbs/conte...', '__STATIC__' => '/public/static', ...], []) in Controller.php line 120
atController->fetch('/home/ftp/h/hostsiai...', ['admin' => true, 'userdb' => ['idcardpic' => '', 'id' => '1', 'uid' => 1, ...], 'timestamp' => 1716412027, ...], [], []) in Base.php line 424
atBase->fetch('/home/ftp/h/hostsiai...', ['admin' => true, 'userdb' => ['idcardpic' => '', 'id' => '1', 'uid' => 1, ...], 'timestamp' => 1716412027, ...]) in C.php line 257
atC->show('3882') in Content.php line 27
atContent->show('3882')
atReflectionMethod->invokeArgs(object(Content), ['3882']) in App.php line 348
atApp::invokeMethod([object(Content), 'show'], []) in App.php line 612
atApp::module(['bbs', 'content', 'show'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 461
atApp::exec(['type' => 'module', 'module' => ['bbs', 'content', 'show'], 'convert' => false], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
atApp::run() in start.php line 19
at require('/home/ftp/h/hostsiai...') in index.php line 29

Exception Datas

PDO Error Info
SQLSTATE	42S22
Driver Error Code	1054
Driver Error Message	Unknown column 'wxapp_id' in 'where clause'

Database Status
Error Code	10501
Error Message	SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wxapp_id' in 'where clause'
Error SQL	SELECT `id` FROM `qb_shorturl` WHERE `url` = 'https://www.liulangla.cn/index.php/bbs/show-3882.html'; AND `type` = 2 AND `wxapp_id` = '' LIMIT 1

Database Config
type	mysql
hostname	127.0.0.1
database	hostsiai
hostport	3306
dsn
params	[]
charset	utf8
prefix	qb_
debug	true
deploy	0
rw_separate	false
master_num	1
slave_no
fields_strict	false
result_type	2
resultset_type	array
auto_timestamp	false
datetime_format	Y-m-d H:i:s
sql_explain	false
builder
query	\think\db\Query
break_reconnect	false

Environment Variables

GET Data

empty

POST Data

empty

Files

empty

Cookies

user_sid

6a0d5ad469

__tins__21864549

{"sid": 1716410511908, "vd": 7, "expires": 1716413816160}

__51cke__

__51laig__

__51huid__KRDYr9D5XbH6cw98

b1bb8740-ebba-5b47-b5a1-b3c85843a631

passport

1 流浪狗救助中心 VVVVDgkPBwZRVAdUVAQIDQcMVQhXUQRYDA5eUlUHBAcQIBOEDD54da26138b

_passport

1 流浪狗救助中心 VVVVDgkPBwZRVAdUVAQIDQcMVQhXUQRYDA5eUlUHBAcQIBOEDD54da26138b

browser_type

wap

label_set

set

labelhy_set

set

frompage

https://www.liulangla.cn/index.php?label_set=set&;in=wap

first_view

3959,0

admin_login

CT8DVQZSBQUBUAlVa1ZXFlYGS1EJCk1XDAAQIBOEDD53d4de5da8

Session

empty

Server/Request Data

PHPRC

/tmp/php-hostsiai.ini

PHP_FCGI_MAX_REQUESTS

PHP_INI_EXTEND

/vhs/kangle/phpini/php-hostsiai.ini

PATH

/sbin:/usr/sbin:/bin:/usr/bin

PWD

LANG

SHLVL

/vhs/kangle/bin/kangle

CERT_SERVER_SERIALNUMBER

90C6CAE167CA2AAEF984F99452A9267E

CERT_SERVER_SUBJECT

/CN=liulangla.cn

CERT_SERVER_ISSUER

/C=CN/O=TrustAsia Technologies, Inc./CN=TrustAsia RSA DV TLS CA G2

CERT_KEYSIZE

256

HTTPS

VH_NAME

hostsiai

DOCUMENT_ROOT

/home/ftp/h/hostsiai/wwwroot/

REMOTE_PORT

29963

REMOTE_ADDR

36.22.213.159

SERVER_PORT

443

SERVER_ADDR

103.150.10.73

SCRIPT_FILENAME

/home/ftp/h/hostsiai/wwwroot/index.php

PATH_TRANSLATED

/home/ftp/h/hostsiai/wwwroot/index.php/bbs/show-3882.html

PATH_INFO

/bbs/show-3882.html

SCRIPT_NAME

/index.php

HTTP_X_REWRITE_URL

/bbs/show-3882.html

REQUEST_URI

/bbs/show-3882.html

REQUEST_METHOD

GET

SERVER_PROTOCOL

HTTP/1.1

SERVER_NAME

www.liulangla.cn

GATEWAY_INTERFACE

CGI/1.1

SERVER_SOFTWARE

kangle/3.5

HTTP_HOST

www.liulangla.cn

HTTP_X_CLIENT_SCHEME

https

HTTP_COOKIE

user_sid=6a0d5ad469; __tins__21864549=%7B%22sid%22%3A%201716410511908%2C%20%22vd%22%3A%207%2C%20%22expires%22%3A%201716413816160%7D; __51cke__=; __51laig__=32; __51huid__KRDYr9D5XbH6cw98=b1bb8740-ebba-5b47-b5a1-b3c85843a631; passport=1%09%E6%B5%81%E6%B5%AA%E7%8B%97%E6%95%91%E5%8A%A9%E4%B8%AD%E5%BF%83%09VVVVDgkPBwZRVAdUVAQIDQcMVQhXUQRYDA5eUlUHBAcQIBOEDD54da26138b; _passport=1%09%E6%B5%81%E6%B5%AA%E7%8B%97%E6%95%91%E5%8A%A9%E4%B8%AD%E5%BF%83%09VVVVDgkPBwZRVAdUVAQIDQcMVQhXUQRYDA5eUlUHBAcQIBOEDD54da26138b; browser_type=wap; label_set=set; labelhy_set=set; frompage=https%3A%2F%2Fwww.liulangla.cn%2Findex.php%3Flabel_set%3Dset%26in%3Dwap; first_view=3959%2C0; admin_login=CT8DVQZSBQUBUAlVa1ZXFlYGS1EJCk1XDAAQIBOEDD53d4de5da8

HTTP_TE

trailers

HTTP_SEC_FETCH_USER

HTTP_SEC_FETCH_SITE

same-origin

HTTP_SEC_FETCH_MODE

navigate

HTTP_SEC_FETCH_DEST

document

HTTP_UPGRADE_INSECURE_REQUESTS

HTTP_REFERER

https://www.liulangla.cn/wuqi.php/bbs/list.html

HTTP_ACCEPT_ENCODING

gzip, deflate, br

HTTP_ACCEPT_LANGUAGE

zh-CN,zh;q=0.8,zh-TW;q=0.7,zh-HK;q=0.5,en-US;q=0.3,en;q=0.2

HTTP_ACCEPT

text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8

HTTP_USER_AGENT

Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0

FCGI_ROLE

RESPONDER

PHP_SELF

/index.php/bbs/show-3882.html

REQUEST_TIME_FLOAT

1716412027.6197

REQUEST_TIME

1716412027

Environment Variables

empty

ThinkPHP Constants

APP_PATH

/home/ftp/h/hostsiai/wwwroot/application/

ENTRANCE

index

THINK_VERSION

5.0.18

THINK_START_TIME

1716412027.6204

THINK_START_MEM

390800

EXT

.php

THINK_PATH

/home/ftp/h/hostsiai/wwwroot/thinkphp/

LIB_PATH

/home/ftp/h/hostsiai/wwwroot/thinkphp/library/

CORE_PATH

/home/ftp/h/hostsiai/wwwroot/thinkphp/library/think/

TRAIT_PATH

/home/ftp/h/hostsiai/wwwroot/thinkphp/library/traits/

ROOT_PATH

/home/ftp/h/hostsiai/wwwroot/

EXTEND_PATH

/home/ftp/h/hostsiai/wwwroot/extend/

VENDOR_PATH

/home/ftp/h/hostsiai/wwwroot/vendor/

RUNTIME_PATH

/home/ftp/h/hostsiai/wwwroot/runtime/

LOG_PATH

/home/ftp/h/hostsiai/wwwroot/runtime/log/

CACHE_PATH

/home/ftp/h/hostsiai/wwwroot/runtime/cache/

TEMP_PATH

/home/ftp/h/hostsiai/wwwroot/runtime/temp/

CONF_PATH

/home/ftp/h/hostsiai/wwwroot/application/

CONF_EXT

.php

ENV_PREFIX

PHP_

IS_CLI

false

IS_WIN

false

HTMLPURIFIER_PREFIX

/home/ftp/h/hostsiai/wwwroot/vendor/ezyang/htmlpurifier/library

IN_WAP

true

TEMPLATE_PATH

/home/ftp/h/hostsiai/wwwroot/template/

IS_POST

false

PUBLIC_URL

/public/

PUBLIC_PATH

/home/ftp/h/hostsiai/wwwroot/public/

UPLOAD_URL

/public/uploads/

UPLOAD_PATH

/home/ftp/h/hostsiai/wwwroot/public/uploads/

STATIC_URL

/public/static/

STATIC_PATH

/home/ftp/h/hostsiai/wwwroot/public/static/

PLUGINS_PATH

/home/ftp/h/hostsiai/wwwroot/plugins/

CACHE_DIR

/home/ftp/h/hostsiai/wwwroot/runtime/

QUN

Resource

ADMIN_FILENAME

wuqi.php

LABEL_SET

true

LOAD_INDEXBASE

true

PAGE_TYPE

show

IN_TEMPLATE

true

SHOW_SET_LABEL

true

HAVE_LOAD_REMIND

true

HAVE_LOAD_LABEL_JSFILE

true

LOAD_SHARE

true

赏礼

赏钱

点击回复

全部留言

共 3 条

码农程序开发者 消费:0元 2024-06-03 07:06 07:066楼

缺少字字段，自己在后台数据库管理那里，导入即可

ALTER TABLE `qb_shorturl` ADD `wxapp_id` VARCHAR( 256 ) NOT NULL ,
ADD INDEX ( `wxapp_id` ) ;

无期-6772 消费:189.03元 其他手机 2024-06-03 13:29

感谢

人在旅途 消费:35.58元 2024-07-29 15:03

学习了

0 赏礼回复

更多回复

你可能感兴趣的主题

经验分享

恢复多功能编辑器

X1运营交流

圈内贴子51643 圈子成员1016

本圈子内的新贴

热门分类