Install DaDaBik 10 with postgres 11.6 fails.

Martin Pfeifer

New member
Requirements check
Current PHP version: 5.6.40-15+ubuntu18.04.1+deb.sury.org+1 OK

mbsgtring extension: Installed

ioncube extension: Installed

ioncube extension version: 10.3 OK

Check DB connection: OK

postgres version: 11.6 (Ubuntu 11.6-1.pgdg18.04+1) NO (min postgres version is: 7.4)


What's wrong here please?
 

Martin Pfeifer

New member
I tried to install again with an empty database called dim.
Still fails, but with the install2.php it gave me:


Notice: Undefined offset: 1 in /var/www/html/dim/install2.php on line 0
On-line registration done......your installation code is:
 

Martin Pfeifer

New member
I don't know if it is of any importance but I also have a different version (9.2) installed. On a different location and database though.
 

eugenio

Administrator
Staff member
Hello,

Martin Pfeifer Wrote:
-------------------------------------------------------
> I don't know. The installation pops up the error a
> nd stops there.

Which error? You didn't mention the error message.

Notice: Undefined offset: 1 in /var/www/html/dim/install2.php on line 0
On-line registration done......your installation code is:

So with an empty database the error message is the same or it's another one?

Best,
 

Martin Pfeifer

New member
Install just threw me the errror screen regarding postgres.

So I have tried using Install2.php. I have created a postgres database dim with user dim which database is empty.
Created a dadabik empty appliication and got the following output.

Notice: Undefined offset: 1 in /var/www/html/dim/install2.php on line 0
On-line registration done......your installation code is:

[08] Error: during query execution. Set $debug_mode to 1 in your config.php to get further error information



Also tried to import xlsx and csv


Warning: move_uploaded_file(/var/www/html/dim/uploads_import/5e3fc0e4529e31.06936194.csv): failed to open stream: Permission denied in /var/www/html/dim/install2.php on line 0

Warning: move_uploaded_file(): Unable to move '/tmp/phpzbUa0k' to '/var/www/html/dim/uploads_import/5e3fc0e4529e31.06936194.csv' in /var/www/html/dim/install2.php on line 0
There was an error during file upload.
 

Martin Pfeifer

New member
On-line registration done......your installation code is: 152815e3fc3dfe9db3

[08] Error: during query execution. ALTER TABLE "dadabik_groups" ADD "dadabik_id" BIGINT UNSIGNED UNIQUE NOT NULL AUTO_INCREMENT
The DBMS server said: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "UNSIGNED" LINE 1: ...ER TABLE "dadabik_groups" ADD "dadabik_id" BIGINT UNSIGNED U... ^
 

eugenio

Administrator
Staff member
Hello Martin,
install.php is the right file to launch; I still don't see which error you got during the first attempt, you said:

Install just threw me the errror screen regarding postgres.

but I don't see the error.

I think I've understood the problem, though; could you please try to edit /include/db_functions.pdo.php and change

function get_unique_field_db($table_name, $directly_from_db = 0, $fallback_to_db = 0, $check_multiple_pk = 1)

with:

function get_unique_field_db($table_name, $directly_from_db = 0, $fallback_to_db = 0, $check_multiple_pk = 0)

?

About the move_uploaded_file error, this is unrelated and you are getting this error because the Web server doesn't have permissions to write in your uploads_import folder.

Best,
 

Martin Pfeifer

New member
Hello,

I did replace the function as you suggested.
Although I still have to use install2.php everything works like a charm now.
Many thanks for you're response.

Martin
 

eugenio

Administrator
Staff member
Hello Martin,
you are welcome.
Install.php, however, is the file you should use; what's the error message you get?
 
Top