Forum

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.

Login Error
 
Notifications
Clear all

Login Error

5 Posts
2 Users
0 Reactions
5,275 Views
(@guest)
Posts: 120
Active Member
Topic starter
 
[#158]

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?


 
Posted : 09 Aug 2011 10H51
(@babynus)
Posts: 14952
Member Admin
 

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.


 
Posted : 09 Aug 2011 16H25
(@guest)
Posts: 120
Active Member
Topic starter
 

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 *****


 
Posted : 10 Aug 2011 16H40
(@babynus)
Posts: 14952
Member Admin
 

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.


 
Posted : 10 Aug 2011 21H26
(@guest)
Posts: 120
Active Member
Topic starter
 

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


 
Posted : 11 Aug 2011 9H27
Share:

Scroll to Top