Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Migration KB 1.2.25 issue #34

Open
adameightyfour opened this issue Jan 11, 2023 · 0 comments
Open

Migration KB 1.2.25 issue #34

adameightyfour opened this issue Jan 11, 2023 · 0 comments

Comments

@adameightyfour
Copy link

adameightyfour commented Jan 11, 2023

Hi,
maybe a not so common configuration..

I´m using KB 1.2.5

Source System:

XAMPP 3.3.0

PHP Version: 8.1.6
PHP SAPI: apache2handler
HTTP-Client: cURL
OS Version: Windows NT 10.0
DB Driver: sqlite
DB Version: 3.36.0

Destination System:

XAMPP 3.3.0

PHP Version: **8.2.0**
PHP SAPI: apache2handler
HTTP-Client: cURL
OS Version: Windows NT 10.0
Datenbanktreiber: sqlite
Datenbank Version: 3.36.0

with MariaDB Server
10.4.27-MariaDB

Copied kanboard directory to cygwin /home/username

$ ./kanboard-sqlite2mysql.sh ./kanboard -o kanboard-it.sql
results in this:

image

Copied kanboard folder from source to destination, checked kanboard working via browser, everything fine.

created new db, granted permissions to user, everything fine.

edited config.php for mysql

Login with admin Username to KB is possible

Application version: 1.2.25
PHP version: 8.2.0
PHP SAPI: apache2handler
HTTP Client: cURL
OS version: Windows NT 10.0
Database driver: mysql
Database version: 10.4.27-MariaDB

KB containing no data, but running on mysql

added following on top of the generated sqldump:

SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
SET CHARACTER SET 'utf8mb4';
SET SESSION collation_connection = 'utf8mb4_unicode_ci';

import dump via phpmyadmin results in following error message

Fehler
Statische Analyse:

6 Fehler wurden während der Analyse gefunden.

Unerwartetes Zeichen. (near "`id`" at position 14)
Unerwarteter Statement-Anfang. (near "`id`" at position 14)
Unerwarteter Statement-Anfang. (near "`external_id`" at position 19)
Unerwarteter Statement-Anfang. (near "`name`" at position 33)
Unerwarteter Statement-Anfang. (near ""groups"" at position 40)
Unerkannte Statement-Typ. (near "VALUES" at position 49)
SQL-Befehl: Kopieren

INSERT INTO (`id`,`external_id`,`name`)"groups" VALUES(1,'','IT-Fachverfahren');

MySQL meldet: Dokumentation

#1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei '(`id`,`external_id`,`name`)"groups" VALUES(1,'','IT-Fachverfahren')' in Zeile 1

reloading KB in Browser shows:

Fatal error: Uncaught TypeError: Kanboard\Core\User\UserProfile::initialize(): Argument #1 ($user) must be of type Kanboard\Core\User\UserProviderInterface, null given, called in D:\xampp\htdocs\it\app\Core\Security\AuthenticationManager.php on line 99 and defined in D:\xampp\htdocs\it\app\Core\User\UserProfile.php:49 Stack trace: #0 D:\xampp\htdocs\it\app\Core\Security\AuthenticationManager.php(99): Kanboard\Core\User\UserProfile->initialize(NULL) #1 D:\xampp\htdocs\it\app\Middleware\AuthenticationMiddleware.php(36): Kanboard\Core\Security\AuthenticationManager->preAuthentication() #2 D:\xampp\htdocs\it\app\Middleware\AuthenticationMiddleware.php(28): Kanboard\Middleware\AuthenticationMiddleware->handleAuthentication() #3 D:\xampp\htdocs\it\app\Core\Controller\BaseMiddleware.php(55): Kanboard\Middleware\AuthenticationMiddleware->execute() #4 D:\xampp\htdocs\it\app\Middleware\BootstrapMiddleware.php(23): Kanboard\Core\Controller\BaseMiddleware->next() #5 D:\xampp\htdocs\it\app\Core\Controller\Runner.php(62): Kanboard\Middleware\BootstrapMiddleware->execute() #6 D:\xampp\htdocs\it\app\Core\Controller\Runner.php(28): Kanboard\Core\Controller\Runner->executeMiddleware() #7 D:\xampp\htdocs\it\index.php(9): Kanboard\Core\Controller\Runner->execute() #8 {main} thrown in D:\xampp\htdocs\it\app\Core\User\UserProfile.php on line 49

so, where is my fault? :-)
any solutions are welcome

regards,
Adam

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant