Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Wednesday, April 20, 2016

Traccar windows service start then stop ,The Traccar service terminated with service-specific error Incorrect function..

This problem happened when I changed from H2 database to mysql didn't remove the old database the had been created by an old version of traccar.
to solve it : just remove the old database of traccar and create a new one.
Another Problem is when you have a no password database , and made a space in the password place in the configuration file traccar.xml
 
<entry key='database.user'>root</entry> 
<entry key='database.password'> </entry>

to solve it: remove the space in this field and start traccar service again.
 
<entry key='database.user'>root</entry> 
<entry key='database.password'></entry>

Saturday, August 10, 2013

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

This error happened if you are updating from MySQL 5.5 to MySQL 5.6 or when are using data folder that was on 5.5 server on 5.6 server . 
Anyway the solution is very easy and it is just a Warning but it is great to clear such things when you found it on your event log file.
 Add this line to MySQL configuration file , my.cnf or my.ini :

 explicit_defaults_for_timestamp = TRUE 

 restart your MySQL server and check your events log file.

Sunday, February 10, 2013

Wamp on Windows 7 Startup

Problem:
Localhost is running automatically on Windows 7 start up .
To Solve that Just change its Startup type from Automatic to Manual  through the services panel .
From the command prompt enter : Services.mcs
Enter
look for Wampapache and Wampmysqld  Services and change their startup type to Manual



If you want to run Wamp whenever Windows startup then change manual to Automatic