Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hello everyone!
I installed Project'or on my webspace but after trying to login I got this error message. Before it updated the SQL database and after second click on OK it showed this message:
201 ERRORS DURING UPDATE TO VERSION
I checked the log file and it says user doesn't exist.
Can you please help me with this issue?
Hi,
Your parameters to log to the database may not be correct.
Check the /files/config/parameters.php file, particuliarly values for parameters :
$paramDbType = 'mysql';
$paramDbHost
$paramDbUser
$paramDbPassword
$paramDbName
You can also set $logLevel = '4'; and run again.
Log file should contain detailed desciption of issue.
Regards.
Babynus.
Hi Babynus
thx for the reply. I checked the paramaters and they are correct. I also checked the SQL Database and found the created tables of projectoria. Also if I set the parameter to 4 it doesn't work.
In the SQL user table I found the user admin and user guest, but the log file shows following:
2011-08-10 20:16:16 ** ERROR ** [1146] SQL Error : Table '****.proj_user' doesn't exist
select * from proj_user where proj_user.name = 'admin' and proj_user.password = '21232f297a57a5a743894a0e4a801fc3'
2011-08-10 20:16:16 ** ERROR ** [1146] SQL Error : Table '****.proj_parameter' doesn't exist
select * from proj_parameter where proj_parameter.idUser is null and proj_parameter.idProject is null and proj_parameter.parameterCode = 'dbVersion'
2011-08-10 20:16:16 ** ERROR ** [1146] SQL Error : Table '****.proj_parameter' doesn't exist
select * from proj_parameter where proj_parameter.idUser is null and proj_parameter.idProject is null and proj_parameter.parameterCode = 'dbVersion'
2011-08-10 20:16:16 ===== TRACE =====
2011-08-10 20:16:16 ===== TRACE ===== =====================================
2011-08-10 20:16:16 ===== TRACE =====
2011-08-10 20:16:16 ===== TRACE ===== DataBase actual Version =
2011-08-10 20:16:16 ===== TRACE ===== ProjectOR actual Version = V1.5.5
2011-08-10 20:16:16 ===== TRACE =====
2011-08-10 20:16:16 ===== TRACE ===== =====================================
2011-08-10 20:16:16 ===== TRACE =====
2011-08-10 20:16:16 ===== TRACE ===== VERSION V0.3.0
2011-08-10 20:16:16 ===== TRACE =====
2011-08-10 20:16:16 ** ERROR ** [1050] SQL Error : Table 'PROJ_accessprofile' already exists
CREATE TABLE `PROJ_accessprofile` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`description` varchar(4000) DEFAULT NULL,
`idAccessScopeRead` int(12) DEFAULT NULL,
`idAccessScopeCreate` int(12) DEFAULT NULL,
`idAccessScopeUpdate` int(12) DEFAULT NULL,
`idAccessScopeDelete` int(12) DEFAULT NULL,
`sortOrder` int(3) DEFAULT NULL,
`idle` int(1) unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2011-08-10 20:16:16 ===== TRACE =====
** SQL ERROR WHILE EXECUTING SQL REQUEST **
2011-08-10 20:16:16 ===== TRACE =====
2011-08-10 20:16:16 ===== TRACE ===== SQL Error : Table 'PROJ_accessprofile' already exists
CREATE TABLE `PROJ_accessprofile` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`description` varchar(4000) DEFAULT NULL,
`idAccessScopeRead` int(12) DEFAULT NULL,
`idAccessScopeCreate` int(12) DEFAULT NULL,
`idAccessScopeUpdate` int(12) DEFAULT NULL,
`idAccessScopeDelete` int(12) DEFAULT NULL,
`sortOrder` int(3) DEFAULT NULL,
`idle` int(1) unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2011-08-10 20:16:16 ===== TRACE =====
2011-08-10 20:16:16 ===== TRACE ===== **********************************************
2011-08-10 20:16:16 ===== TRACE =====
2011-08-10 20:16:16 ** ERROR ** [1062] SQL Error : Duplicate entry '1' for key 'PRIMARY'
INSERT INTO `PROJ_accessprofile` (`id`, `name`, `description`, `idAccessScopeRead`, `idAccessScopeCreate`, `idAccessScopeUpdate`, `idAccessScopeDelete`, `sortOrder`, `idle`) VALUES
(1, 'accessProfileRestrictiedReader', 'Read only his projects', 3, 1, 1, 1, 100, 0),
(2, 'accessProfileGlobalReader', 'Read all projects', 4, 1, 1, 1, 150, 0),
(3, 'accessProfileRestrictedUpdater', 'Read and Update only his projects', 3, 1, 3, 1, 200, 0),
(4, 'accessProfileGlobalUpdater', 'Read and Update all projects', 4, 1, 4, 1, 250, 0),
(5, 'accessProfileRestricedCreator', 'Read only his projectsnCan createnUpdate and delete his own elements', 3, 3, 2, 2, 300, 0),
(6, 'accessProfileGlobalCreator', 'Read all projectsnCan createnUpdate and delete his own elements', 4, 4, 2, 2, 350, 0),
(7, 'accessProfileRestrictedManager', 'Read only his projectsnCan createnUpdate and delete his projects', 3, 3, 3, 3, 400, 0),
(8, 'accessProfileGlobalManager', 'Read all projectsnCan createnUpdate and delete his projects', 4, 4, 4, 4, 450, 0),
(9, 'accessProfileNoAccess', 'no access allowed', 1, 1, 1, 1, 999, 0);
2011-08-10 20:16:16 ===== TRACE =====
** SQL ERROR WHILE EXECUTING SQL REQUEST *****
Hi,
There is an error in your parameters : the database prefix must respect the case !
Its seems you have a diffence of case between existing and parameter.
This is not important on Windows, but it is on Linux/Unix.
Regards.
Babynus.
Hey Babynus!
Thx for the help! I deleted the tables and installed the parameters again without prefix. Now it works and I can login.
The prefix of the table and the parameters was the same but somehow it didn't work.
Regards
Shidai