javascript
▼ 展开
报错信息如上,解析就是:
REPLACE 语句的作用是:如果 uid=3 的记录存在则替换,不存在则新增。但 common_member_profile 表设计时,除了 uid 之外,还有其他字段设置了 NOT NULL(非空)约束,你没有给这些必填字段赋值,数据库拒绝执行。
但看报错记录,显示你网站的数据库是
MySQL
10.5.27-MariaDB-log
所以,不符合数据库要求,是MariaDB对于mysql不兼容的部分
.ce-block { margin-bottom: 20px;}.ce-block__content,.ce-toolbar__content { /* max-width:calc(100% - 50px) */ margin-left: auto; margin-right: auto; position: relative;}/* 主容器 */.editorjs-codeFlask_Wrapper { border: 1px solid #dcdfe6; border-radius: 5px; background-color: #f6f8fa; margin-bottom: 10px; position: relative; transition: all 0.3s ease; width: 100%; min-height: 100px; overflow: hidden;}/* 标题栏 */.editorjs-codeFlask_Header { display: flex; justify-content: flex-end; align-items: center; padding: 8px 12px; background-color: #e9ecef; border-bottom: 1px solid #dcdfe6; position: relative; z-index: 0; /* 从10降低到2 */}/* 语言显示 */.editorjs-codeFlask_LangDisplay { padding: 2px 8px; background-color: #409eff; color: white; border-radius: 3px; font-size: 12px; font-weight: 500; position: absolute; left: 12px; top: 50%; transform: translateY(-50%);}/* 内容容器 - 禁止纵向滚动 */.editorjs-codeFlask_ContentContainer { position: relative; min-height: 100px; overflow-x: hidden; /* 禁止横向滚动 */ overflow-y: hidden; transition: height 0.3s ease;}/* 编辑器容器 - 禁止纵向滚动 */.editorjs-codeFlask_Editor { position: relative; min-height: 100px; overflow-x: hidden; /* 禁止横向滚动 */ overflow-y: hidden; transition: height 0.3s ease;}/* 底部按钮容器 - 优化为更简洁的样式 */.editorjs-codeFlask_BottomButtonContainer { display: flex; justify-content: center; align-items: center; padding: 4px; background-color: #f8f9fa; border-top: 1px solid #e9ecef; position: relative; z-index: 0;}/* 底部横向折叠/展开按钮 - 优化样式,使其更融入设计 */.editorjs-codeFlask_BottomToggle { width: 100%; background-color: transparent; color: #606266; border: none; border-radius: 4px; padding: 6px 12px; font-size: 12px; font-weight: 400; cursor: pointer; transition: all 0.3s ease; display: flex; align-items: center; justify-content: center; gap: 4px; text-align: center; position: relative;}.editorjs-codeFlask_BottomToggle:hover { background-color: #e9ecef; color: #409eff;}.editorjs-codeFlask_BottomToggle:active { background-color: #dee2e6;}.editorjs-codeFlask_BottomToggle .toggle-icon { font-size: 11px; transition: transform 0.3s ease;}/* 展开按钮(显示"展开"文本)上边缘添加渐变虚化效果 */.editorjs-codeFlask_BottomToggle:has(span.toggle-icon:contains("▲"))::before { content: ''; position: absolute; top: 0; left: 0; right: 0; height: 6px; background: linear-gradient(to bottom, rgba(248, 249, 250, 0) 0%, rgba(248, 249, 250, 1) 100%); pointer-events: none;}/* 展开按钮(显示"展开"文本)上边缘添加渐变虚化效果 *//* 删除不被广泛支持的:contains()选择器 */.editorjs-codeFlask_BottomToggle.expand-mode::before { content: ''; position: absolute; top: -60px; left: 0; right: 0; height: 60px; background: linear-gradient(to bottom, rgb(255 255 255 / 0%) 0%, rgba(248, 249, 250, 1) 100%); pointer-events: none;}/* CodeFlask 主容器样式 */.editorjs-codeFlask_Editor .codeflask { position: relative; background: #fafafa; border-radius: 0 0 4px 4px; min-height: 100px; overflow-x: hidden; /* 禁止横向滚动 */ overflow-y: hidden; font-family: 'Consolas', 'Monaco', 'Courier New', monospace;}/* 行号容器 */.editorjs-codeFlask_Editor .codeflask.codeflask--has-line-numbers:before { content: ''; position: absolute; left: 0; top: 0; bottom: 0; width: 40px; background-color: #f5f5f5; border-right: 1px solid #e0e0e0; z-index: 0;}/* 行号 */.editorjs-codeFlask_Editor .codeflask__lines { position: absolute; left: 0; top: 0; bottom: 0; width: 40px; padding: 10px 0; background-color: #f5f5f5; border-right: 1px solid #e0e0e0; z-index: 0; font-family: 'Consolas', 'Monaco', 'Courier New', monospace; font-size: 14px; line-height: 21px; color: #666; text-align: right; user-select: none; overflow: hidden;}.editorjs-codeFlask_Editor .codeflask__lines__line { padding-right: 8px;}/* 文本区域 - 输入框 */.editorjs-codeFlask_Editor .codeflask__textarea { position: absolute; top: 0; left: 0; width: 100%; height: 100%; padding: 10px; border: none; background: transparent; color: transparent; caret-color: #333; resize: none; font-family: 'Consolas', 'Monaco', 'Courier New', monospace; font-size: 14px; line-height: 21px; z-index: 1; overflow-x: hidden; /* 禁止横向滚动 */ overflow-y: hidden; white-space: pre-wrap; /* 自动换行 */ tab-size: 4; outline: none;}/* 添加选中文本样式 */.editorjs-codeFlask_Editor .codeflask__textarea::selection { background-color: #b3d4fc; color: #333;}.editorjs-codeFlask_Editor .codeflask__textarea::-moz-selection { background-color: #b3d4fc; color: #333;}/* 代码预览区域 */.editorjs-codeFlask_Editor .codeflask__pre { position: absolute; top: 0; left: 0; width: 100%; /* 确保宽度不超出容器 */ height: 100%; padding: 10px; margin: 0; border: none; background: transparent; font-family: 'Consolas', 'Monaco', 'Courier New', monospace; font-size: 14px; line-height: 21px; z-index: 0; overflow-x: hidden; /* 禁止横向滚动 */ overflow-y: hidden; white-space: pre-wrap; /* 自动换行 */ pointer-events: none;}/* 代码高亮区域 */.editorjs-codeFlask_Editor .codeflask__code { display: block; font-family: 'Consolas', 'Monaco', 'Courier New', monospace; font-size: 14px; line-height: 21px; color: #333; white-space: pre-wrap; /* 自动换行 */ tab-size: 4; overflow: visible;}/* 语法高亮样式 - 确保Prism.js样式正确应用 */.editorjs-codeFlask_Editor .codeflask__code[class*="language-"] { background: transparent !important;}/* 通用语法高亮token样式 */.editorjs-codeFlask_Editor .token.comment,.editorjs-codeFlask_Editor .token.prolog,.editorjs-codeFlask_Editor .token.doctype,.editorjs-codeFlask_Editor .token.cdata { color: #708090;}.editorjs-codeFlask_Editor .token.punctuation { color: #999;}.editorjs-codeFlask_Editor .token.namespace { opacity: 0.7;}.editorjs-codeFlask_Editor .token.property,.editorjs-codeFlask_Editor .token.tag,.editorjs-codeFlask_Editor .token.boolean,.editorjs-codeFlask_Editor .token.number,.editorjs-codeFlask_Editor .token.constant,.editorjs-codeFlask_Editor .token.symbol,.editorjs-codeFlask_Editor .token.deleted { color: #905;}.editorjs-codeFlask_Editor .token.selector,.editorjs-codeFlask_Editor .token.attr-name,.editorjs-codeFlask_Editor .token.string,.editorjs-codeFlask_Editor .token.char,.editorjs-codeFlask_Editor .token.builtin,.editorjs-codeFlask_Editor .token.inserted { color: #690;}.editorjs-codeFlask_Editor .token.operator,.editorjs-codeFlask_Editor .token.entity,.editorjs-codeFlask_Editor .token.url,.editorjs-codeFlask_Editor .language-css .token.string,.editorjs-codeFlask_Editor .style .token.string { color: #9a6e3a; background: hsla(0, 0%, 100%, 0.5);}.editorjs-codeFlask_Editor .token.atrule,.editorjs-codeFlask_Editor .token.attr-value,.editorjs-codeFlask_Editor .token.keyword { color: #07a;}.editorjs-codeFlask_Editor .token.function,.editorjs-codeFlask_Editor .token.class-name { color: #dd4a68;}.editorjs-codeFlask_Editor .token.regex,.editorjs-codeFlask_Editor .token.important,.editorjs-codeFlask_Editor .token.variable { color: #e90;}/* 复制按钮样式 */.editorjs-codeFlask_CopyButton { background-color: #409eff; color: white; border: none; border-radius: 3px; padding: 6px 12px; margin-right: 8px; font-size: 12px; cursor: pointer; transition: background-color 0.2s ease; display: flex; align-items: center; justify-content: center; min-width: 28px; height: 28px;}.editorjs-codeFlask_CopyButton:hover { background-color: #66b1ff;}.editorjs-codeFlask_CopyButton.copied { background-color: #67c23a;}/* 折叠/展开按钮样式 */.editorjs-codeFlask_Toggle { background-color: #909399; color: white; border: none; border-radius: 3px; padding: 0 8px; font-size: 12px; cursor: pointer; transition: background-color 0.2s ease; display: flex; align-items: center; justify-content: center; min-width: 28px; height: 28px; font-weight: bold;}.editorjs-codeFlask_Toggle:hover { background-color: #a6a9ad;}/* 响应式调整 */@media (max-width: 768px) { .editorjs-codeFlask_Header { padding: 6px 8px; } .editorjs-codeFlask_Editor .codeflask__textarea, .editorjs-codeFlask_Editor .codeflask__pre, .editorjs-codeFlask_Editor .codeflask__code { font-size: 13px; line-height: 19px; padding: 8px; } .editorjs-codeFlask_Editor .codeflask.codeflask--has-line-numbers:before { width: 35px; } .editorjs-codeFlask_Editor .codeflask__lines { width: 35px; font-size: 12px; }}/* 滚动条样式 - 完全隐藏纵向滚动条 */.editorjs-codeFlask_Wrapper ::-webkit-scrollbar { width: 0; /* 纵向滚动条宽度为0 */ height: 6px; /* 横向滚动条保持6px宽度 */}.editorjs-codeFlask_Wrapper ::-webkit-scrollbar-track { background: transparent; border-radius: 0;}.editorjs-codeFlask_Wrapper ::-webkit-scrollbar-thumb { background: transparent; border-radius: 0;}/* Firefox 滚动条隐藏 */.editorjs-codeFlask_Wrapper { scrollbar-width: none; /* Firefox 隐藏纵向滚动条 */}.editorjs-codeFlask_Wrapper ::-moz-scrollbar { width: 0; height: 6px;}/* 焦点状态 */.editorjs-codeFlask_Wrapper:focus-within { border-color: #409eff; box-shadow: 0 0 0 2px rgba(64, 158, 255, 0.2);}/* 只读模式样式 */.editorjs-codeFlask_Wrapper.readonly .editorjs-codeFlask_Header { background-color: #f5f7fa;}.editorjs-codeFlask_Wrapper.readonly .editorjs-codeFlask_Editor .codeflask__textarea { cursor: default;}/* 确保所有元素正确显示 */.editorjs-codeFlask_Wrapper * { box-sizing: border-box;}/* 修复行号对齐 */.editorjs-codeFlask_Editor .codeflask--has-line-numbers .codeflask__textarea,.editorjs-codeFlask_Editor .codeflask--has-line-numbers .codeflask__pre { padding-left: 50px;}.editorjs-codeFlask_Editor .codeflask--has-line-numbers .codeflask__lines { padding-top: 10px;}/* 语言显示元素 - 添加点击样式 */.editorjs-codeFlask_LangDisplay { padding: 2px 8px; background-color: #409eff; color: white; border-radius: 3px; font-size: 12px; font-weight: 500; position: absolute; left: 12px; top: 50%; transform: translateY(-50%); cursor: pointer; transition: all 0.2s ease;}.editorjs-codeFlask_LangDisplay:hover { background-color: #66b1ff; box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);}/* 语言选择弹窗 */.editorjs-codeFlask_LanguagePopup { background-color: white; border: 1px solid #dcdfe6; border-radius: 4px; box-shadow: 0 2px 12px 0 rgba(0, 0, 0, 0.1); width: 250px; max-height: 300px; z-index: 1000; overflow: hidden;}/* 搜索框 */.editorjs-codeFlask_LanguageSearch { width: 100%; padding: 8px 12px; border: none; border-bottom: 1px solid #ebeef5; font-size: 12px; outline: none; box-sizing: border-box;}/* 语言列表 */.editorjs-codeFlask_LanguagesList { max-height: 250px; overflow-y: auto;}/* 语言选项 */.editorjs-codeFlask_LanguageItem { padding: 8px 12px; font-size: 12px; cursor: pointer; transition: background-color 0.2s ease;}.editorjs-codeFlask_LanguageItem:hover { background-color: #f5f7fa;}.editorjs-codeFlask_LanguageItem.selected { background-color: #ecf5ff; color: #409eff; font-weight: 500;}/* 滚动条样式 */.editorjs-codeFlask_LanguagesList::-webkit-scrollbar { width: 6px;}.editorjs-codeFlask_LanguagesList::-webkit-scrollbar-track { background-color: #f5f7fa;}.editorjs-codeFlask_LanguagesList::-webkit-scrollbar-thumb { background-color: #c0c4cc; border-radius: 3px;}.editorjs-codeFlask_LanguagesList::-webkit-scrollbar-thumb:hover { background-color: #909399;}.ce-block { margin-bottom: 20px;}.ce-block__content,.ce-toolbar__content { /* max-width:calc(100% - 50px) */ margin-left: auto; margin-right: auto;}.ce-paragraph { line-height: 1.6em; outline: none; text-indent: 2em; font-size: 16px;}.ce-paragraph--right { text-align: right;}.ce-paragraph--center { text-align: center;}.ce-paragraph--left { text-align: left;}.ce-paragraph--justify { text-align: justify;}.ce-paragraph-text-indent { text-align: justify;}.ce-paragraph[data-placeholder]:empty::before{ content: attr(data-placeholder); color: #707684; font-weight: normal; opacity: 0;}/** Show placeholder at the first paragraph if Editor is empty */.codex-editor--empty .ce-block:first-child .ce-paragraph[data-placeholder]:empty::before { opacity: 1;}.codex-editor--toolbox-opened .ce-block:first-child .ce-paragraph[data-placeholder]:empty::before,.codex-editor--empty .ce-block:first-child .ce-paragraph[data-placeholder]:empty:focus::before { opacity: 0;}.ce-paragraph p:first-of-type{ margin-top: 0;}.ce-paragraph p:last-of-type{ margin-bottom: 0;}.svg-icon { width: 1em; height: 1em;}.svg-icon path,.svg-icon polygon,.svg-icon rect { fill: #4691f6;}.svg-icon circle { stroke: #4691f6; stroke-width: 1;}.ce-block { margin-bottom: 20px;}.ce-block__content,.ce-toolbar__content { /* max-width:calc(100% - 50px) */ margin-left: auto; margin-right: auto;}.tc-wrap { --color-background:#f9f9fb; --color-text-secondary:#7b7e89; --color-border:#e8e8eb; --cell-size:0px; --toolbox-icon-size:18px; --toolbox-padding:6px; --toolbox-aiming-field-size:calc(var(--toolbox-icon-size) + var(--toolbox-padding)*2); border:1px solid var(--color-border); position:relative; height:100%; width:100%; margin-top:var(--toolbox-icon-size); box-sizing:border-box; display:grid; grid-template-columns:calc(100% - var(--cell-size)) var(--cell-size);}.tc-wrap--readonly { grid-template-columns:100% var(--cell-size)}.tc-wrap svg { vertical-align:top}@media print { .tc-wrap { border-left-color:var(--color-border); border-left-style:solid; border-left-width:1px; grid-template-columns:100% var(--cell-size)}}@media print { .tc-wrap .tc-row:after { display:none}}.tc-table { position:relative; width:100%; height:100%; display:grid; font-size:14px; line-height:1.4;}.tc-table:after { width:calc(var(--cell-size)); height:100%; left:calc(var(--cell-size)*-1); top:0}.tc-table:after,.tc-table:before { position:absolute; content:""}.tc-table:before { width:100%; height:var(--toolbox-aiming-field-size); top:calc(var(--toolbox-aiming-field-size)*-1); left:0}.tc-table--heading .tc-row:first-child { font-weight:600; border-bottom:2px solid var(--color-border);}.tc-table--heading .tc-row:first-child [contenteditable]:empty:before { content:attr(heading); color:var(--color-text-secondary)}.tc-table--heading .tc-row:first-child:after { bottom:-2px; border-bottom:2px solid var(--color-border)}.tc-add-column,.tc-add-row { display:flex; color:var(--color-text-secondary)}@media print { .tc-add { display:none}}.tc-add-column { padding:4px 0; justify-content:center; border-top:1px solid var(--color-border);}@media print { .tc-add-column { display:none}}.tc-add-row { height:var(--cell-size); align-items:center; padding-left:4px; position:relative;}.tc-add-row:before { content:""; position:absolute; right:calc(var(--cell-size)*-1); width:var(--cell-size); height:100%}@media print { .tc-add-row { display:none}}.tc-add-column,.tc-add-row { transition:0s; cursor:pointer; will-change:background-color;}.tc-add-column:hover,.tc-add-row:hover { transition:background-color .1s ease; background-color:var(--color-background)}.tc-add-row { margin-top:1px;}.tc-add-row:hover:before { transition:.1s; background-color:var(--color-background)}.tc-row { display:grid; grid-template-columns:repeat(auto-fit,minmax(10px,1fr)); position:relative; border-bottom:1px solid var(--color-border);}.tc-row:after { content:""; pointer-events:none; position:absolute; width:var(--cell-size); height:100%; bottom:-1px; right:calc(var(--cell-size)*-1); border-bottom:1px solid var(--color-border)}.tc-row--selected { background:var(--color-background)}.tc-row--selected:after { background:var(--color-background)}.tc-cell { border-right:1px solid var(--color-border); padding:6px 12px; overflow:hidden; outline:none; line-break:normal;}.tc-cell--selected { background:var(--color-background)}.tc-wrap--readonly .tc-row:after { display:none}.tc-toolbox { --toolbox-padding:6px; --popover-margin:30px; --toggler-click-zone-size:30px; --toggler-dots-color:#7b7e89; --toggler-dots-color-hovered:#1d202b; position:absolute; cursor:pointer; z-index:1; opacity:0; transition:opacity .1s; will-change:left,opacity;}.tc-toolbox--column { top:calc(var(--toggler-click-zone-size)*-1); transform:translateX(calc(var(--toggler-click-zone-size)*-1/2)); will-change:left,opacity}.tc-toolbox--row { left:calc(var(--popover-margin)*-1); transform:translateY(calc(var(--toggler-click-zone-size)*-1/2)); margin-top:-1px; will-change:top,opacity}.tc-toolbox--showed { opacity:1}.tc-toolbox .tc-popover { position:absolute; top:0; left:var(--popover-margin)}.tc-toolbox__toggler { display:flex; align-items:center; justify-content:center; width:var(--toggler-click-zone-size); height:var(--toggler-click-zone-size); color:var(--toggler-dots-color); opacity:0; transition:opacity .15s ease; will-change:opacity;}.tc-toolbox__toggler:hover { color:var(--toggler-dots-color-hovered)}.tc-toolbox__toggler svg { fill:currentColor}.tc-wrap:hover .tc-toolbox__toggler { opacity:1}.tc-settings .cdx-settings-button { width:50%; margin:0}.tc-popover { --color-border:#eaeaea; --color-background:#fff; --color-background-hover:rgba(232,232,235,0.49); --color-background-confirm:#e24a4a; --color-background-confirm-hover:#d54040; --color-text-confirm:#fff; background:var(--color-background); border:1px solid var(--color-border); box-shadow:0 3px 15px -3px rgba(13,20,33,.13); border-radius:6px; padding:6px; display:none; will-change:opacity,transform;}.tc-popover--opened { display:block; animation:menuShowing .1s cubic-bezier(.215,.61,.355,1) forwards}.tc-popover__item { display:flex; align-items:center; padding:2px 14px 2px 2px; border-radius:5px; cursor:pointer; white-space:nowrap; -webkit-user-select:none; -moz-user-select:none; user-select:none;}.tc-popover__item:hover { background:var(--color-background-hover)}.tc-popover__item:not(:last-of-type) { margin-bottom:2px}.tc-popover__item-icon { display:inline-flex; width:26px; height:26px; align-items:center; justify-content:center; background:var(--color-background); border-radius:5px; border:1px solid var(--color-border); margin-right:8px}.tc-popover__item-label { line-height:22px; font-size:14px; font-weight:500}.tc-popover__item--confirm { background:var(--color-background-confirm); color:var(--color-text-confirm);}.tc-popover__item--confirm:hover { background-color:var(--color-background-confirm-hover)}.tc-popover__item--confirm .tc-popover__item-icon { background:var(--color-background-confirm); border-color:rgba(0,0,0,.1);}.tc-popover__item--confirm .tc-popover__item-icon svg { transition:transform .2s ease-in; transform:rotate(90deg) scale(1.2)}.tc-popover__item--hidden { display:none}@keyframes menuShowing { 0% { opacity:0; transform:translateY(-8px) scale(.9)}70% { opacity:1; transform:translateY(2px)}to { transform:translateY(0)}}.ce-block { margin-bottom: 20px;}.ce-block__content,.ce-toolbar__content { /* max-width:calc(100% - 50px) */ margin-left: auto; margin-right: auto;}.image-tool { --bg-color: #cdd1e0; --front-color: #388ae5; --border-color: #e8e8eb;} .image-tool__image { border-radius: 3px; overflow: hidden; margin-bottom: 10px; } .image-tool__image-picture { max-width: 100%; vertical-align: bottom; display: block; margin-left: auto; margin-right: auto; } .image-tool__image-preloader { width: 50px; height: 50px; border-radius: 50%; background-size: cover; margin: auto; position: relative; background-color: #cdd1e0; background-position: center center; } .image-tool__image-preloader::after { content: ""; position: absolute; z-index: 3; width: 60px; height: 60px; border-radius: 50%; border: 2px solid #cdd1e0; border-top-color: #388ae5; left: 50%; top: 50%; margin-top: -30px; margin-left: -30px; animation: image-preloader-spin 2s infinite linear; box-sizing: border-box; } .image-tool__caption[contentEditable="true"][data-placeholder]::before { position: absolute !important; content: attr(data-placeholder); color: #707684; font-weight: normal; display: none; } .image-tool__caption[contentEditable="true"][data-placeholder]:empty::before { display: block; } .image-tool__caption[contentEditable="true"][data-placeholder]:empty:focus::before { display: none; } .image-tool--empty .image-tool__image { display: none; } .image-tool--empty .image-tool__caption, .image-tool--loading .image-tool__caption { display: none; } .image-tool .cdx-button { display: flex; align-items: center; justify-content: center; } .image-tool .cdx-button svg { height: auto; margin: 0 6px 0 0; } .image-tool--filled .cdx-button { display: none; } .image-tool--filled .image-tool__image-preloader { display: none; } .image-tool--loading .image-tool__image { min-height: 200px; display: flex; border: 1px solid #e8e8eb; background-color: #fff; } .image-tool--loading .image-tool__image-picture { display: none; } .image-tool--loading .cdx-button { display: none; } /** * Tunes * ---------------- */ .image-tool--withBorder .image-tool__image { border: 1px solid #e8e8eb; } .image-tool--withBackground .image-tool__image { padding: 15px; background: #cdd1e0; } .image-tool--withBackground .image-tool__image-picture { max-width: 60%; margin: 0 auto; } .image-tool--stretched .image-tool__image-picture { width: 100%; } .image-tool__caption { text-align: center; font-size: 14px; color: #a3a3a3; }@keyframes image-preloader-spin { 0% { transform: rotate(0deg); } 100% { transform: rotate(360deg); }}.inline-code { background: rgba(250, 239, 240, 0.78); color: #b44437; padding: 3px 4px; border-radius: 5px; margin: 0 1px; font-family: inherit; font-size: 0.86em; font-weight: 500; letter-spacing: 0.3px;} |