MySQL

[NoelBank]

Hey i get this Error;

1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

can anyone help me?

[BoGuu]

Update your MySQL server ver

[BradenM]

I had this exact issue when using a MariaDB server on centOS7.

I installed MySQL instead and it worked fine.

[NoelBank]

I have MySQL the Newest version

[BradenM]

Can you please please provide your box info? (Windows, Linux distribution, dedicated, etc)

[NoelBank]

Oh yes, Linux Debian 8

[BradenM]

Ok. Can you please provide me with the output of mysql -V

Also how are you connecting to your SQL server? Remotely or are you running the scripts locally?

[NoelBank]

mysql Ver 14.14 Distrib 5.5.54, for debian-linux-gnu (x86_64) using readline 6.3

[BradenM]

Try updating to MySQL 5.7.

You can take a look at this guide

[BradenM]

Also ensure your using the altislife.sql from latest commit rather then the releases tab.

[NoelBank]

Okay!

[NoelBank]

Yes its working!!! But i dont can Find any MYSQL connect in the Life_master

[BradenM]

Awesome.

Can you elaborate on that?

[NoelBank]

Hat sich erledigt habe den fehler gefunden. aber wie erstelle warum bekomme ich diese Meldung 19:23:13 Can't find a mission collection / mission with template name: 'Altis_Life.Altis', skipping to next mission.

[BradenM]

This is an issue with your config. Make sure it has a mission file section (generally located at the bottom) and Altis_Life.Altis is spelled correctly.

Look here for more information. (Look at the example config file, where the mission selector is)

[NoelBank]

Okay Thanks i get it

[Jawshy]

@NoelBank, in future, read the guidelines for contributing and follow the provided issue template.