problem after upgrading with MYSQL

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

problem after upgrading with MYSQL

Post 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
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: problem after upgrading with MYSQL

Post 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.
Daniele Pistollato - IW3HMH
iz2onz
Novice Class
Posts: 3
Joined: 20 Apr 2014, 10:47

Re: problem after upgrading with MYSQL

Post 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
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: problem after upgrading with MYSQL

Post 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
Daniele Pistollato - IW3HMH
iz2onz
Novice Class
Posts: 3
Joined: 20 Apr 2014, 10:47

Re: problem after upgrading with MYSQL

Post 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
Locked