DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL, SQLite and MS SQL Server; also available for Wordpress.

Welcome! Log In Create A New Profile

Advanced

Error on About/Upgrade

Posted by deep64blue 
Error on About/Upgrade
April 28, 2020 06:53PM
Dadabik v10.1 shows New version available!

Clicking link gives error:-

Quote
dadabik
[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.



Edited 1 time(s). Last edit at 04/28/2020 06:54PM by deep64blue.
Re: Error on About/Upgrade
April 29, 2020 10:49AM
Hello,
it seems you installed 10.0-PrivateBeta but you didn't correctly upgrade it to 10.0 or to 10.1?

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK founder
Re: Error on About/Upgrade
April 30, 2020 10:21AM
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).
Re: Error on About/Upgrade
April 30, 2020 10:32AM
Re: Error on About/Upgrade
April 30, 2020 03:37PM
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 |\.-./| DaDaBIK founder
Re: Error on About/Upgrade
April 30, 2020 03:39PM
I did yes, can I run it again or will that cause issues?
Re: Error on About/Upgrade
April 30, 2020 03:51PM
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,

________________________________________________________
Eugenio |\.-./| DaDaBIK founder
Re: Error on About/Upgrade
May 01, 2020 10:32AM
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.
Re: Error on About/Upgrade
May 01, 2020 11:20AM
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`);
Re: Error on About/Upgrade
May 02, 2020 08:39AM
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,

________________________________________________________
Eugenio |\.-./| DaDaBIK founder
Re: Error on About/Upgrade
May 02, 2020 11:30AM
Quote
Eugenio
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.
Sorry, only registered users may post in this forum.

Click here to login