Page 1 of 1

problem after upgrading with MYSQL

Posted: 20 Apr 2014, 10:57
by iz2onz
Hi guys.
A problem from my side after upgrade from 1.16 to 1.17.1
Problem on MySQL.

After upgrading and launched LOG4OM it appears:" MYSQL DB UPGRADE REQUIRED".
I've upgraded MYSQL to 1.1.5 but error remains.
No one log reported !!! (I'm worried ..., I'm crying :-( )

If I try to add a QSO, it appears: Unknow column "ClubLogQsoUploadDate" in 'field list' "

Guys waht I' ve to do.

SO: windows XP

Re: problem after upgrading with MYSQL

Posted: 20 Apr 2014, 13:58
by IW3HMH
I apologize, the upgrade file posted on my website won't appear.
Please download and run these scripts in your SQLITE database:

http://www.pisto.it/LogOm/mysql1171.zip

As an alternative you can recreate the DB (same name/password) and re-import data if you're not familiar with mysql.

Re: problem after upgrading with MYSQL

Posted: 20 Apr 2014, 15:06
by iz2onz
GREAT Daniele !!! ;) ;)

I've solved problem; now my feedback to you regarding script.

Your file is in not right format, some problem due to the fact that it is saved some gost character control,
to implement script I' ve performed "cut & paste" from your file.

It is necessary to disable "safe mode update" in "Edit" --> "preferences" --> "SQL Queries" in SQL Workbench just to permit update; in your file there is not indicated, in last 4 rows some data
like "WHERE" and other in order to use the safe mode.

Thank you again Daniele.

fred

P.S:
If you say me, "please, repeat it" I'm sure to not be able to perform :D

Re: problem after upgrading with MYSQL

Posted: 20 Apr 2014, 16:55
by IW3HMH
Very good,
it's strange, i cannot find any issue in the file, even opening it with some advanced editors.

Anyway i'm happy it's all OK for you. Yes, MySQL requires little more work to be upgraded because i cannot shoot update scripts as i'm doing with SQLITE.

Thanks :)
73
Daniele

Re: problem after upgrading with MYSQL

Posted: 21 Apr 2014, 08:45
by iz2onz
..you know that my computer is very particular ...
if you rember, SQL lite was not possible to install :( :(

See you friend and thanks again !!!

To the community.

I want to highlight fast time solution in Easter day. No word !! :o :o