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.

[SOLVED] Error whil...
 
Notifications
Clear all

[SOLVED] Error while configuring

15 Posts
2 Users
0 Reactions
9,750 Views
(@ripal)
Posts: 53
Active Member
Topic starter
 
[#4034]

2017-01-23 13:01:07.657 ** ERROR ** Error on SqlElement to get 'dontReceiveTeamMails' for Class 'User' : field 'dontReceiveTeamMails' not found in Database.
2017-01-23 13:01:07.674 ** ERROR ** Error on SqlElement to get 'apiKey' for Class 'User' : field 'apiKey' not found in Database.
2017-01-23 13:01:09.411 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2017-01-23 13:01:09.426 ** ERROR ** For query : select * from user where user.name='admin' and user.isUser = '1'
2017-01-23 13:01:09.440 ** ERROR ** Strack trace :
2017-01-23 13:01:09.970 ** ERROR ** #0 Sql->query called at [G:PleskVhostspm-logic.comhttpdocswebprojeqtormodelpersistenceSqlElement.php:1803]
2017-01-23 13:01:09.982 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [G:PleskVhostspm-logic.comhttpdocswebprojeqtortoolloginCheck.php:68]
2017-01-23 13:01:09.997 ===== TRACE ===== Login error for user 'admin'
2017-01-23 13:01:12.575 ** ERROR ** Error on SqlElement to get 'dontReceiveTeamMails' for Class 'User' : field 'dontReceiveTeamMails' not found in Database.
2017-01-23 13:01:12.588 ** ERROR ** Error on SqlElement to get 'apiKey' for Class 'User' : field 'apiKey' not found in Database.
2017-01-23 13:01:23.107 ** ERROR ** Error on SqlElement to get 'dontReceiveTeamMails' for Class 'User' : field 'dontReceiveTeamMails' not found in Database.
2017-01-23 13:01:23.625 ** ERROR ** Error on SqlElement to get 'apiKey' for Class 'User' : field 'apiKey' not found in Database.
2017-01-23 13:01:24.821 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2017-01-23 13:01:24.842 ** ERROR ** For query : select * from user where user.name='admin' and user.isUser = '1'
2017-01-23 13:01:24.856 ** ERROR ** Strack trace :
2017-01-23 13:01:24.868 ** ERROR ** #0 Sql->query called at [G:PleskVhostspm-logic.comhttpdocswebprojeqtormodelpersistenceSqlElement.php:1803]
2017-01-23 13:01:25.417 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [G:PleskVhostspm-logic.comhttpdocswebprojeqtortoolloginCheck.php:68]
2017-01-23 13:01:25.430 ===== TRACE ===== Login error for user 'admin'


 
Posted : 25 Jan 2017 7H52
(@babynus)
Posts: 14952
Member Admin
 

What is version of your database (table parameter, line with parameterCode='dbVersion')
and version of your code (version of ProjeQtOr installed) ?


 
Posted : 25 Jan 2017 23H43
(@ripal)
Posts: 53
Active Member
Topic starter
 

Hello,

1. dbVersion is showing V0.3.0

2. Where can I see version of ProjeQtOr ?

Regards
Ripal Shah


 
Posted : 26 Jan 2017 5H01
(@babynus)
Posts: 14952
Member Admin
 

It seems the upgrade phase did not end correctly.
Possibly you faced a timeout from php / apache.

Try and migrated step by step : to V1.0, then to V2.0, and so on.


 
Posted : 26 Jan 2017 10H05
(@ripal)
Posts: 53
Active Member
Topic starter
 

I am sorry but I am new to PHP.

Please elaborate procedure. suggested by You

Regards
Ripal Shah


 
Posted : 26 Jan 2017 10H55
(@babynus)
Posts: 14952
Member Admin
 

Do to dowload page and download V1.0.0, V2.0.0, V3.0.0, ....
Then install V1.0.0, V2.0.0, V3.0.0, .... up to V6.0.7


 
Posted : 26 Jan 2017 21H31
(@ripal)
Posts: 53
Active Member
Topic starter
 

Hello,

It works with 5.4.0...

Any possibilities for upgrade.....?

Regards
Ripal Shah


 
Posted : 27 Jan 2017 21H14
(@ripal)
Posts: 53
Active Member
Topic starter
 

Error while installing V4.0.0

2017-01-28 13:56:56 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist

Regards
Ripal


 
Posted : 28 Jan 2017 16H00
(@babynus)
Posts: 14952
Member Admin
 

I don't unserstant :
it works with V.5.40
but you've got error installing 4.0.0

Please explain what you do, I don't understand.

If install is correct on V5.4.0, thant install V5.5 over this one, ther V6.0...


 
Posted : 28 Jan 2017 16H20
(@ripal)
Posts: 53
Active Member
Topic starter
 

After installing 5.4 tried to install 6.0.

so again error started...

So I started from 4.0 and getting this error.

Regards
Ripal Shah


 
Posted : 28 Jan 2017 16H49
(@babynus)
Posts: 14952
Member Admin
 

If install is ok up to 5.4, don't revert to 4.0.

Install 5.4, then 6.0 and report log file here.


 
Posted : 28 Jan 2017 19H36
(@ripal)
Posts: 53
Active Member
Topic starter
 

Login accepted with below error.....:)

2017-01-28 19:27:17.278 ** ERROR ** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'isRealWork'
2017-01-28 19:27:17.342 ** ERROR ** For query : ALTER TABLE `plannedworkbaseline` ADD `isRealWork` int(1) UNSIGNED DEFAULT 0;
2017-01-28 19:27:17.417 ** ERROR ** Strack trace :
2017-01-28 19:27:17.456 ** ERROR ** #0 Sql->query called at [G:PleskVhostspm-logic.comhttpdocswebprojeqtordbmaintenanceFunctions.php:71]
2017-01-28 19:27:17.468 ** ERROR ** #1 runScript called at [G:PleskVhostspm-logic.comhttpdocswebprojeqtordbmaintenance.php:101]
2017-01-28 19:27:17.480 ** ERROR ** #2 include called at [G:PleskVhostspm-logic.comhttpdocswebprojeqtortoolloginCheck.php:135]
2017-01-28 19:27:17.493 ===== TRACE =====
2017-01-28 19:27:17.505 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.0.6 (see above message)
2017-01-28 19:27:17.517 ===== TRACE =====
2017-01-28 19:27:17.528 ===== TRACE ===== *************************************************
2017-01-28 19:27:17.675 ===== TRACE =====
2017-01-28 19:27:17.687 ===== TRACE =====
2017-01-28 19:27:17.699 ===== TRACE ===== DATABASE UPDATED
2017-01-28 19:27:17.711 ===== TRACE ===== WITH 1 ERROR
2017-01-28 19:27:17.723 ===== TRACE =====
2017-01-28 19:27:19.201 ===== TRACE ===== =====================================
2017-01-28 19:27:19.217 ===== TRACE =====
2017-01-28 19:27:19.228 ===== TRACE ===== 3 ERRORS DURING UPDATE TO VERSION V6.0.7
2017-01-28 19:27:19.241 ===== TRACE =====
2017-01-28 19:27:19.253 ===== TRACE ===== =====================================
2017-01-28 19:27:19.265 ===== TRACE =====
2017-01-28 19:28:53.310 ===== TRACE ===== NEW CONNECTED USER 'admin'


 
Posted : 28 Jan 2017 21H34
(@babynus)
Posts: 14952
Member Admin
 

It seems you upgraded same db several times to 6.0, so errors loged are not real issues.
All should work fine now.


 
Posted : 28 Jan 2017 22H16
(@ripal)
Posts: 53
Active Member
Topic starter
 

Yes Working fine ..

Need more help to configure Email parameter....

Regards
Ripal Shah


 
Posted : 28 Jan 2017 22H20
(@babynus)
Posts: 14952
Member Admin
 

Search in forum.
Several threads will help.


 
Posted : 28 Jan 2017 22H35
Share:

Scroll to Top