Error on About/Upgrade

deep64blue

DaDaBIK Guru
Dadabik v10.1 shows New version available!

Clicking link gives error:-

dadabik said:
[08] Error: during query execution. SELECT dadabik_version_installation, dadabik_version_2_installation, date_time_installation, code_installation, url_installation FROM `zdk_installation_tab`
The DBMS server said: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'url_installation' in 'field list'

If I remove the missing field I get the following info:-

dadabik_version_installation - 10.0-PrivateBeta
dadabik_version_2_installation - enterprise
date_time_installation - 2019-09-19 12:50:22
code_installation - 148865d835d704899

The file version_first_installation says 10.1-Manarola enterprise.
 

eugenio

Administrator
Staff member
Hello,
it seems you installed 10.0-PrivateBeta but you didn't correctly upgrade it to 10.0 or to 10.1?

Best,
 

deep64blue

DaDaBIK Guru
I just did a diff between a 10.1 download and my installation and everything looks ok, the only changed files are what you would expect (config files etc).
 

eugenio

Administrator
Staff member
Files might be ok, but if you didn't run the ugprade script DaDaBIK still thinks you are running the old version; did you follow these instructions:
https://dadabik.com/index.php?function=show_documentation#installation
?
 

eugenio

Administrator
Staff member
If you did it and the database schema hasn't been upgraded, something went wrong in the first place, did you get any error message when you did it?

If you have a backup of your original installation before upgrading (which I guess was a 10.0-PrivateBeta installation), I would recover from the backup (if users have used the application after the upgrade, of course you will loose those data, though) and do the upgrade again, writing here if you get any error.

Best,
 

deep64blue

DaDaBIK Guru
I didn't get any error messages, is there something in the db schema I can check to see if it has changed properly?

If needed I'll do a fresh install of 10.1 and migrate the data.
 

deep64blue

DaDaBIK Guru
I've just done a fresh install, exported both DBs and done a compare, here are the differences:-

Clean 10.1
CREATE TABLE `zdk_installation_tab` (
`id_installation` int(11) DEFAULT NULL,
`code_installation` varchar(19) DEFAULT NULL,
`date_time_installation` datetime NOT NULL,
`dbms_type_installation` varchar(50) NOT NULL,
`dadabik_version_installation` varchar(50) NOT NULL,
`dadabik_version_2_installation` varchar(10) NOT NULL,
`other_infos_installation` varchar(255) DEFAULT NULL,
`url_installation` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

My db
CREATE TABLE `zdk_installation_tab` (
`id_installation` int(11) NOT NULL,
`code_installation` varchar(19) DEFAULT NULL,
`date_time_installation` datetime NOT NULL,
`dbms_type_installation` varchar(50) NOT NULL,
`dadabik_version_installation` varchar(50) NOT NULL,
`dadabik_version_2_installation` varchar(10) NOT NULL,
`other_infos_installation` varchar(255) DEFAULT NULL,
`url_installation` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Clean 10.1
ALTER TABLE `zdk_api_tokens`
ADD PRIMARY KEY (`id_api_token`),
ADD UNIQUE KEY `value_api_token` (`value_api_token`);

My db
ALTER TABLE `zdk_api_tokens`
ADD PRIMARY KEY (`id_api_token`),
ADD UNIQUE KEY `value_api_token` (`value_api_token`),
ADD UNIQUE KEY `value_api_token_2` (`value_api_token`);
 

eugenio

Administrator
Staff member
The strange thing is that you reported this error:

"Column not found: 1054 Unknown column 'url_installation' in 'field list'"

but from your last post it seems you have url_installation in zdk_installation_tab, are you sure the application is referring to the same db you are reporting in the last post?

If you have a working backup the cleanest way is to recover it and go through the upgrade process.

Best,
 

deep64blue

DaDaBIK Guru
Eugenio said:
The strange thing is that you reported this error:

"Column not found: 1054 Unknown column 'url_installation' in 'field list'"

Hmm, that is a very good point!!

I do have a backup but as most of my work is done with custom php files I think I am just going to work on the freshly installed build instead.
 
Top