View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - 1ere install, impossible de se connecter - ProjeQtOr
 
 

1ere install, impossible de se connecter

More
24 Sep 2014 14:28 #1 by Hesiode
Bonjour,

je viens de faire une 1ere install tout propre toute neuve et je ne peux pas me connecter avec admin/admin il me met :
"Paramètres de connexion incorrects"

Alors que dans la base table resource, tout me parait OK.

merci

Please Log in or Create an account to join the conversation.

More
24 Sep 2014 14:30 #2 by babynus
Please post in english.
_____

Try and refresh browser cache (F5) and try again.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
24 Sep 2014 14:33 #3 by Hesiode
Ok

I just install projeqtor for the first time, and i cant to connect with admin/admin.

i have this message :
"Invalid login parameters"

In the database, resource table, i have 2 lines admin & Guest with good password (21232f297a57a5a743894a0e4a801fc3 => admin) but dont work..

Please Log in or Create an account to join the conversation.

More
24 Sep 2014 14:38 - 24 Sep 2014 14:40 #4 by Hesiode
Log :

2014-09-24 14:37:11 ***** ERROR ***** Error on SqlElement to get 'loginTry' for Class 'User' : field 'loginTry' not found in Database.
2014-09-24 14:37:11 ***** ERROR ***** Error on SqlElement to get 'apiKey' for Class 'User' : field 'apiKey' not found in Database.
2014-09-24 14:37:11 ***** ERROR ***** Error on SqlElement to get 'dontReceiveTeamMails' for Class 'User' : field 'dontReceiveTeamMails' not fo
und in Database.
2014-09-24 14:37:11 ***** ERROR ***** Error on SqlElement to get 'salt' for Class 'User' : field 'salt' not found in Database.
2014-09-24 14:37:11 ***** ERROR ***** Error on SqlElement to get 'crypto' for Class 'User' : field 'crypto' not found in Database.
2014-09-24 14:37:11 ***** ERROR ***** Error on SqlElement to get 'cookieHash' for Class 'User' : field 'cookieHash' not found in Database.
2014-09-24 14:37:11 ***** ERROR ***** Error on SqlElement to get 'passwordChangeDate' for Class 'User' : field 'passwordChangeDate' not found
in Database.
2014-09-24 14:37:11 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exis
t
2014-09-24 14:37:11 ***** ERROR ***** For query : desc user
2014-09-24 14:37:11 ***** ERROR ***** Strack trace :
2014-09-24 14:37:11 ***** ERROR ***** #0 Sql->query called at [*/www/model/persisten
ce/SqlElement.php:2107]
2014-09-24 14:37:11 ***** ERROR ***** #1 SqlElement->getFormatList called at [*/www/
model/persistence/SqlElement.php:1875]
2014-09-24 14:37:11 ***** ERROR ***** #2 SqlElement->getDataType called at [*/www/mo
del/persistence/SqlElement.php:1412]
2014-09-24 14:37:11 ***** ERROR ***** #3 SqlElement->getSqlElementsFromCriteria called at [*/www/tool/loginCheck.php:36]
2014-09-24 14:37:11 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exis
t
2014-09-24 14:37:11 ***** ERROR ***** For query : select * from user where user.name='admin' and user.isUser = '1'
2014-09-24 14:37:11 ***** ERROR ***** Strack trace :
2014-09-24 14:37:11 ***** ERROR ***** #0 Sql->query called at [/*/www/model/persisten
ce/SqlElement.php:1445]
2014-09-24 14:37:11 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [*/www/tool/loginCheck.php:36]
2014-09-24 14:37:11 ===== TRACE ===== Login error for user 'admin'
Last edit: 24 Sep 2014 14:40 by Hesiode.

Please Log in or Create an account to join the conversation.

More
24 Sep 2014 16:32 #5 by babynus
Logs show the database is not correct.
Some required fields are missing intale Resource.

Did you have any error while installing ?
Are you installing new version over existing database ?

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
24 Sep 2014 16:41 #6 by Hesiode
No errors while installing.
Its new version, i tried 3 times, 3 times dont work.
I have 107 tables in my database.

In log it say :
select * from user where user.name='admin' and user.isUser = '1'

But in database file i dont have sql who create this table, but i have "resource" :

--
-- Structure de la TABLE `${prefix}resource` (old name = user)
--

CREATE TABLE `${prefix}resource` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`fullName` varchar(100) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`description` varchar(4000) DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
`idProfile` int(12) DEFAULT NULL,
`isResource` int(1) unsigned DEFAULT '0',
`isUser` int(1) unsigned DEFAULT '0',
`locked` int(1) unsigned DEFAULT '0',
`idle` int(1) unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.037 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.