1. Installed clean Ubuntu 16.0.4
2. Downloaded and installed XAMPP 7.2.26
3. Checked http://localhost - works good. Apache, Mysql and ProFTPD started.
4. Downloaded projeqtor 8.2.4
5. Unzipped and moved to /opt/lampp/htdocs
6. Opened http://localhost in browser
7. On the Configuration page click "OK"
Got several errors:
1. SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) dsn = mysql:host=127.0.0.1;port=3306
How fixed: removed default DB rassword.
2. incorrect value for 'Log file name', cannot write to such a file : check access rig
How fixed: chmod 777 files/logs/
3. incorrect value for 'Parameter file name', cannot write to such a file : check access rights
How fixed: 1. created manually files/config/parameters.php 2. chmod 777 files/config/parameters.php
4. impossible to write '../tool/parametersLocation.php' file, cannot write to such a file : check access rights
How fixed: chmod 777 tool/
5. max_input_vars=1000 is too small - value should be at least 2000, 4000 recommended - check your php configuration (php.ini)
How fixed: added to /opt/lampp/etc/php.ini line: max_input_vars = 4000
All the erors are fixed. I see "On next page, log in as user "admin" with password "admin""
8. Click "Continue"
Now I have an error: SQL ERROR : Database type unknown
How to fix this?
Hi,
Message tells that dbType is not 'mysql' nor 'pgsql'.
Look for error in log file and paste here logged error (exact copy as it may give us some hint)
Very strange because I see in XAMPP popup:
MySQL Database Running
ProFTPD Running
Apache Web Server Running
Where is the log-file located?
Log file is where you opened rights 😉
2. incorrect value for 'Log file name', cannot write to such a file : check access rig
How fixed: chmod 777 files/logs/
/opt/lampp/htdocs/files/logs/ has index.php only. Double-checked, logs directory has 777.
Check in parametersLocation.php where oyu storeed paramerters.php file
Look in parameters.php file where you store logs.
/files/config/parametersLocation.php contains:
$parametersLocation = '../files/config/parameters.php';
File: /files/config/parameters.php contains:
$logFile = '../files/logs/projeqtor_${date}.log';
$logLevel = '2';
But I see the file contains the same data twice including: TEST<?php
So, maybe this file was broken?
So, now I can proceed to the login page.
But the message is shown before authorization: Upgrade in progress. Only admin user can connect.
After trying to login I get two more errors:
1) an error: An error occurred on 2020-01-20 at 11.22.43
2) "max_input_vars=1000 is too small - value should be at least 2000, 4000 recommended - check your php configuration (php.ini)"
Although the /opt/lampp/etc/php/ini has parameter: max_input_vars=4000
Hi,
But I see the file contains the same data twice including: TEST<?php
So, maybe this file was broken?
Possibly PHP user has possibility to update file, but not to delete it ?
But the message is shown before authorization: Upgrade in progress. Only admin user can connect.
This is completely normal.
After trying to login I get two more errors:
1) an error: An error occurred on 2020-01-20 at 11.22.43
Please post error logged in log file
2) "max_input_vars=1000 is too small - value should be at least 2000, 4000 recommended - check your php configuration (php.ini)"
Although the /opt/lampp/etc/php/ini has parameter: max_input_vars=4000
This should not be a blocking error, just a warning (ping message, not red one)
This may be due to not restarting PHP (must be restarted to take into account changes in php.ini)
Appeared the log file. New error time: 2020-01-20 13:23:40
2020-01-20 13:23:34.511 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:34.512 ** ERROR ** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:34.512 ** ERROR ** [] Strack trace :
2020-01-20 13:23:34.512 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:34.512 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:34.512 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:34.512 ** ERROR ** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/view/index.php:56]
2020-01-20 13:23:34.831 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:34.831 ** ERROR ** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:34.831 ** ERROR ** [] Strack trace :
2020-01-20 13:23:34.831 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:34.831 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:34.831 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:34.831 ** ERROR ** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:34.831 ** ERROR ** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:34.831 ** ERROR ** [] #5 require_once called at [/opt/lampp/htdocs/view/main.php:37]
2020-01-20 13:23:34.847 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.module' doesn't exist
2020-01-20 13:23:34.847 ** ERROR ** [] For query : select * from module where 1=1 order by module.sortOrder
2020-01-20 13:23:34.847 ** ERROR ** [] Strack trace :
2020-01-20 13:23:34.847 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:34.847 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Module.php:175]
2020-01-20 13:23:34.847 ** ERROR ** [] #2 Module->initializeModuleList called at [/opt/lampp/htdocs/model/Module.php:105]
2020-01-20 13:23:34.847 ** ERROR ** [] #3 Module->isModuleActive called at [/opt/lampp/htdocs/tool/projeqtor.php:4726]
2020-01-20 13:23:34.847 ** ERROR ** [] #4 isLeavesSystemActiv called at [/opt/lampp/htdocs/tool/projeqtor.php:4390]
2020-01-20 13:23:34.847 ** ERROR ** [] #5 formatIcon called at [/opt/lampp/htdocs/view/login.php:344]
2020-01-20 13:23:34.847 ** ERROR ** [] #6 include called at [/opt/lampp/htdocs/tool/projeqtor.php:285]
2020-01-20 13:23:34.847 ** ERROR ** [] #7 require_once called at [/opt/lampp/htdocs/view/main.php:37]
2020-01-20 13:23:35.782 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.783 ** ERROR ** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.783 ** ERROR ** [] Strack trace :
2020-01-20 13:23:35.783 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.783 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.783 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.783 ** ERROR ** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.783 ** ERROR ** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.783 ** ERROR ** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:35.826 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.826 ** ERROR ** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.826 ** ERROR ** [] Strack trace :
2020-01-20 13:23:35.826 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.826 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.826 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.826 ** ERROR ** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.826 ** ERROR ** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.826 ** ERROR ** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:35.862 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.862 ** ERROR ** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.862 ** ERROR ** [] Strack trace :
2020-01-20 13:23:35.862 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.862 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.862 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.862 ** ERROR ** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.862 ** ERROR ** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.862 ** ERROR ** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:35.926 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.926 ** ERROR ** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.926 ** ERROR ** [] Strack trace :
2020-01-20 13:23:35.926 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.926 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.926 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.926 ** ERROR ** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.926 ** ERROR ** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.926 ** ERROR ** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:35.958 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.958 ** ERROR ** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.958 ** ERROR ** [] Strack trace :
2020-01-20 13:23:35.958 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.958 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.958 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.958 ** ERROR ** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.958 ** ERROR ** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.958 ** ERROR ** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:35.982 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.982 ** ERROR ** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.982 ** ERROR ** [] Strack trace :
2020-01-20 13:23:35.982 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.982 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.982 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.982 ** ERROR ** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.982 ** ERROR ** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.982 ** ERROR ** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:40.378 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:40.378 ** ERROR ** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:40.378 ** ERROR ** [] Strack trace :
2020-01-20 13:23:40.378 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:40.378 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:40.378 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:40.378 ** ERROR ** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:40.378 ** ERROR ** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:40.379 ** ERROR ** [] #5 require_once called at [/opt/lampp/htdocs/tool/getHash.php:30]
2020-01-20 13:23:40.382 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.resource' doesn't exist
2020-01-20 13:23:40.382 ** ERROR ** [] For query : desc resource
2020-01-20 13:23:40.382 ** ERROR ** [] Strack trace :
2020-01-20 13:23:40.382 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:3597]
2020-01-20 13:23:40.382 ** ERROR ** [] #1 SqlElement->getFormatList called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:3147]
2020-01-20 13:23:40.382 ** ERROR ** [] #2 SqlElement->getDataType called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2448]
2020-01-20 13:23:40.382 ** ERROR ** [] #3 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2790]
2020-01-20 13:23:40.382 ** ERROR ** [] #4 SqlElement->getSingleSqlElementFromCriteria called at [/opt/lampp/htdocs/tool/getHash.php:48]
2020-01-20 13:23:40.382 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.resource' doesn't exist
2020-01-20 13:23:40.382 ** ERROR ** [] For query : select * from resource where resource.name='admin' and resource.isUser = '1'
2020-01-20 13:23:40.382 ** ERROR ** [] Strack trace :
2020-01-20 13:23:40.382 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:40.382 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2790]
2020-01-20 13:23:40.382 ** ERROR ** [] #2 SqlElement->getSingleSqlElementFromCriteria called at [/opt/lampp/htdocs/tool/getHash.php:48]
2020-01-20 13:23:40.426 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:40.427 ** ERROR ** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:40.427 ** ERROR ** [] Strack trace :
2020-01-20 13:23:40.427 ** ERROR ** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:40.427 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:40.427 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:40.427 ** ERROR ** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:40.427 ** ERROR ** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:40.427 ** ERROR ** [] #5 require_once called at [/opt/lampp/htdocs/tool/loginCheck.php:30]
2020-01-20 13:23:40.432 ** ERROR ** [] ERROR **
2020-01-20 13:23:40.432 ** ERROR ** [] on file '/opt/lampp/htdocs/db/maintenance.php' at line (81)
2020-01-20 13:23:40.432 ** ERROR ***** [] cause = fopen(../files/cron/MIGRATION): failed to open stream: Permission denied
PHP user don't have access to ../files/cron/
You sohuld give access 775 to whole files folder
chmod -R 775 files
Yes, it was one of the reasons.
Now I can't login. Tried (admin/admin and Admin/Admin). The fresh trace from the log:
2020-01-20 14:34:27.332 ** ERROR ** [V0.0.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2020-01-20 14:34:27.332 ** ERROR ** [V0.0.0] Error on SqlElement to get 'isEmployee' for Class 'User' : field 'isEmployee' not found in Database.
2020-01-20 14:34:27.332 ** ERROR ** [V0.0.0] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2020-01-20 14:34:27.415 ** ERROR ** [V0.0.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2020-01-20 14:34:27.415 ** ERROR ** [V0.0.0] For query : select * from user where user.name='admin' and user.isUser = '1'
2020-01-20 14:34:27.415 ** ERROR ** [V0.0.0] Strack trace :
2020-01-20 14:34:27.415 ** ERROR ** [V0.0.0] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 14:34:27.415 ** ERROR ** [V0.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/tool/loginCheck.php:67]
2020-01-20 14:34:27.415 ===== TRACE ===== Login error for user 'admin'
2020-01-20 14:34:37.660 ** ERROR ** [V0.0.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2020-01-20 14:34:37.660 ** ERROR ** [V0.0.0] Error on SqlElement to get 'isEmployee' for Class 'User' : field 'isEmployee' not found in Database.
2020-01-20 14:34:37.660 ** ERROR ** [V0.0.0] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2020-01-20 14:34:37.716 ** ERROR ** [V0.0.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2020-01-20 14:34:37.716 ** ERROR ** [V0.0.0] For query : select * from user where user.name='admin' and user.isUser = '1'
2020-01-20 14:34:37.716 ** ERROR ** [V0.0.0] Strack trace :
2020-01-20 14:34:37.716 ** ERROR ** [V0.0.0] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 14:34:37.716 ** ERROR ** [V0.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/tool/loginCheck.php:67]
2020-01-20 14:34:37.716 ===== TRACE ===== Login error for user 'admin'
2020-01-20 14:34:45.430 ** ERROR ** [V0.0.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2020-01-20 14:34:45.430 ** ERROR ** [V0.0.0] Error on SqlElement to get 'isEmployee' for Class 'User' : field 'isEmployee' not found in Database.
2020-01-20 14:34:45.430 ** ERROR ** [V0.0.0] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2020-01-20 14:34:45.519 ** ERROR ** [V0.0.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2020-01-20 14:34:45.519 ** ERROR ** [V0.0.0] For query : select * from user where user.name='Admin' and user.isUser = '1'
2020-01-20 14:34:45.519 ** ERROR ** [V0.0.0] Strack trace :
2020-01-20 14:34:45.519 ** ERROR ** [V0.0.0] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 14:34:45.519 ** ERROR ** [V0.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/tool/loginCheck.php:67]
2020-01-20 14:34:45.519 ===== TRACE ===== Login error for user 'Admin'
2020-01-20 14:34:56.967 ** ERROR ** [V0.0.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2020-01-20 14:34:56.968 ** ERROR ** [V0.0.0] Error on SqlElement to get 'isEmployee' for Class 'User' : field 'isEmployee' not found in Database.
2020-01-20 14:34:56.968 ** ERROR ** [V0.0.0] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2020-01-20 14:34:57.043 ** ERROR ** [V0.0.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2020-01-20 14:34:57.043 ** ERROR ** [V0.0.0] For query : select * from user where user.name='Admin' and user.isUser = '1'
2020-01-20 14:34:57.043 ** ERROR ** [V0.0.0] Strack trace :
2020-01-20 14:34:57.043 ** ERROR ** [V0.0.0] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 14:34:57.043 ** ERROR ** [V0.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/tool/loginCheck.php:67]
2020-01-20 14:34:57.043 ===== TRACE ===== Login error for user 'Admin'
2020-01-20 14:35:01.672 ** ERROR ** [V0.0.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2020-01-20 14:35:01.672 ** ERROR ** [V0.0.0] Error on SqlElement to get 'isEmployee' for Class 'User' : field 'isEmployee' not found in Database.
2020-01-20 14:35:01.672 ** ERROR ** [V0.0.0] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2020-01-20 14:35:01.728 ** ERROR ** [V0.0.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2020-01-20 14:35:01.728 ** ERROR ** [V0.0.0] For query : select * from user where user.name='admin' and user.isUser = '1'
2020-01-20 14:35:01.728 ** ERROR ** [V0.0.0] Strack trace :
2020-01-20 14:35:01.728 ** ERROR ** [V0.0.0] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 14:35:01.728 ** ERROR ** [V0.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/tool/loginCheck.php:67]
2020-01-20 14:35:01.728 ===== TRACE ===== Login error for user 'admin'
2020-01-20 14:35:05.070 ** ERROR ** [V0.0.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2020-01-20 14:35:05.070 ** ERROR ** [V0.0.0] Error on SqlElement to get 'isEmployee' for Class 'User' : field 'isEmployee' not found in Database.
2020-01-20 14:35:05.070 ** ERROR ** [V0.0.0] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2020-01-20 14:35:05.112 ** ERROR ** [V0.0.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2020-01-20 14:35:05.112 ** ERROR ** [V0.0.0] For query : select * from user where user.name='admin' and user.isUser = '1'
2020-01-20 14:35:05.112 ** ERROR ** [V0.0.0] Strack trace :
2020-01-20 14:35:05.112 ** ERROR ** [V0.0.0] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 14:35:05.112 ** ERROR ** [V0.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/tool/loginCheck.php:67]
2020-01-20 14:35:05.112 ===== TRACE ===== Login error for user 'admin'
2020-01-20 14:35:11.415 ** ERROR ** [V0.0.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2020-01-20 14:35:11.416 ** ERROR ** [V0.0.0] Error on SqlElement to get 'isEmployee' for Class 'User' : field 'isEmployee' not found in Database.
2020-01-20 14:35:11.416 ** ERROR ** [V0.0.0] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2020-01-20 14:35:11.490 ** ERROR ** [V0.0.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2020-01-20 14:35:11.490 ** ERROR ** [V0.0.0] For query : select * from user where user.name='Admin' and user.isUser = '1'
2020-01-20 14:35:11.490 ** ERROR ** [V0.0.0] Strack trace :
2020-01-20 14:35:11.490 ** ERROR ** [V0.0.0] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 14:35:11.490 ** ERROR ** [V0.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/tool/loginCheck.php:67]
2020-01-20 14:35:11.490 ===== TRACE ===== Login error for user 'Admin'
2020-01-20 14:35:16.442 ** ERROR ** [V0.0.0] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2020-01-20 14:35:16.447 ** ERROR ** [V0.0.0] Error on SqlElement to get 'isEmployee' for Class 'User' : field 'isEmployee' not found in Database.
2020-01-20 14:35:16.447 ** ERROR ** [V0.0.0] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2020-01-20 14:35:16.521 ** ERROR ** [V0.0.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2020-01-20 14:35:16.521 ** ERROR ** [V0.0.0] For query : select * from user where user.name='Admin' and user.isUser = '1'
2020-01-20 14:35:16.521 ** ERROR ** [V0.0.0] Strack trace :
2020-01-20 14:35:16.521 ** ERROR ** [V0.0.0] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 14:35:16.521 ** ERROR ** [V0.0.0] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/tool/loginCheck.php:67]
2020-01-20 14:35:16.521 ===== TRACE ===== Login error for user 'Admin'
I
Do I have to create db users, tables manually? Any migrations?
No, all is automatic.
But after several errors, db and/code may be in non stalbe state.
Please try and restart clean install, with clean DB.