Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by Wilson Edwards
at 2024-08-25 16:07:43
ModifyPoint:500 Replies:2 POST_ID:829242USER_ID:12108
Topic:
mysql;phpMyAdmin;centos7
When I want to change default of one field key ,comment_date, in my table, it reported the error
"can not alter comment_date becoz invalid default from comment_date_gmt from mysql"
When try to fix the default of comment_date_gmt, it reported error
"can not alter comment_date_gmt becoz invalid default from comment_date from mysql"
the error is in looping so I can not fix this issue, Any comment ?
Please Advise
rwnice
Accepted Solution
Expert: D Ft replied at 2024-08-25 16:13:51
500 points Excellent
try this sql query on phpMyAdmin
$query="set global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';";
Probably, it will solve your issue
Regards
Accepted Solution
Expert: D Ft replied at 2024-08-25 16:10:37
500 points Excellent
try to read this linkhttps://stackoverflow.com/questions/36882149/error-1067-42000-invalid-default-value-for-created-at
