Login Error

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 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<br/><br/>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<br/><br/>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<br/><br/>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<br/><br/>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 ===== <br/>***** 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<br/><br/>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'<br/><br/>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 projects\nCan create\nUpdate and delete his own elements', 3, 3, 2, 2, 300, 0),
(6, 'accessProfileGlobalCreator', 'Read all projects\nCan create\nUpdate and delete his own elements', 4, 4, 2, 2, 350, 0),
(7, 'accessProfileRestrictedManager', 'Read only his projects\nCan create\nUpdate and delete his projects', 3, 3, 3, 3, 400, 0),
(8, 'accessProfileGlobalManager', 'Read all projects\nCan create\nUpdate 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 ===== <br/>***** SQL ERROR WHILE EXECUTING SQL REQUEST *****

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