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
problem after upgrading with MYSQL
- IW3HMH
- Site Admin
- Posts: 2925
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: problem after upgrading with MYSQL
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.
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
Re: problem after upgrading with MYSQL
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
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
- IW3HMH
- Site Admin
- Posts: 2925
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: problem after upgrading with MYSQL
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
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
Re: problem after upgrading with MYSQL
..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 !!
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 !!