search

Arkania / ArkCORE-NG

Cataclysm 4.3.4 emulator.. with archeology..
http://gpn39f.spdns.de/forum1/
GNU General Public License v2.0
71 stars 93 forks source link

SQL error #271

Closed ghost closed 7 years ago

ghost commented 7 years ago

when i run sql>base>auth.sql in heidisql program i get an error : SQL Error (1293): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

kepkivagas

How can i solve this ??

gpn39f commented 7 years ago

its saved with navicat.. i will look at this..

ghost commented 7 years ago

thank you :)

gpn39f commented 7 years ago

no errors here using current heidi version in windows 10.. i go into heidiSql, create new database coose: name: ng_auth.. Collation: utf8_unicode_ci then i choose load sql file from icon-menu and click on RUN button.. its end with report window: 45 warnings.. but none errors.. all data are present..

note: it's importend to have the correct Collation..

note: use snapshoot from 2017, Jun 1 !!!! older can have failure..

gpn39f commented 7 years ago

pls report what you have done :-).. thanks..