problem after upgrading with MYSQL

Yes, sometimes it happens... Please report any bugs here
Post Reply
iz2onz
Novice Class
Posts: 3
Joined: 20 Apr 2014, 10:47

problem after upgrading with MYSQL

Post by iz2onz » 20 Apr 2014, 10:57

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

User avatar
IW3HMH
Site Admin
Posts: 2357
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: problem after upgrading with MYSQL

Post by IW3HMH » 20 Apr 2014, 13:58

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.
Daniele Pistollato - IW3HMH

iz2onz
Novice Class
Posts: 3
Joined: 20 Apr 2014, 10:47

Re: problem after upgrading with MYSQL

Post by iz2onz » 20 Apr 2014, 15:06

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

User avatar
IW3HMH
Site Admin
Posts: 2357
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: problem after upgrading with MYSQL

Post by IW3HMH » 20 Apr 2014, 16:55

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
Daniele Pistollato - IW3HMH

iz2onz
Novice Class
Posts: 3
Joined: 20 Apr 2014, 10:47

Re: problem after upgrading with MYSQL

Post by iz2onz » 21 Apr 2014, 08:45

..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

Post Reply