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
Hi!
I need help! I trying install umami on my vps server on Centos 7 with mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1, but when I enter the command mysql -u username -p databasename < sql/schema.mysql.sql (all variable data specified correctly), I see error: ERROR 1293 (HY000) at line 7: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
on my own I tried the following:
Open in redactor file sql/schema.mysql.sql and delete 'created_at timestamp default current_timestamp,' and rewrite 'updated_at timestamp default current_timestamp' by 'updated_at TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP'
I'm not sure if this is correct. I am a beginner.
translated by google translate
This discussion was converted from issue #1121 on June 12, 2022 17:28.
Heading
Bold
Italic
Quote
Code
Link
Numbered list
Unordered list
Task list
Attach files
Mention
Reference
Menu
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi!
I need help! I trying install umami on my vps server on Centos 7 with mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1, but when I enter the command
mysql -u username -p databasename < sql/schema.mysql.sql
(all variable data specified correctly), I see error:ERROR 1293 (HY000) at line 7: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
on my own I tried the following:
Open in redactor file sql/schema.mysql.sql and delete 'created_at timestamp default current_timestamp,' and rewrite 'updated_at timestamp default current_timestamp' by 'updated_at TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP'
I'm not sure if this is correct. I am a beginner.
translated by google translate
Beta Was this translation helpful? Give feedback.
All reactions