View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED]provider tenders display - ProjeQtOr
 
 

[SOLVED]provider tenders display

More
06 Dec 2018 11:38 - 06 Dec 2018 15:49 #1 by Iaurkano
[SOLVED]provider tenders display was created by Iaurkano
Hi all,

I'm using Projeqtor 7.2.3 on linux with MySQL database.

When i'm connected to projeqtor using Admin account i can see provider tenders.

When i'm connected using team leader or supervisor account provider tenders screen il always empty. I can create a provider tender, but i never can see it in the screen.

I searched in log and i found this error :
2018-12-06 11:20:58.261 ===== TRACE ===== NEW CONNECTED USER 'admin'
2018-12-06 11:25:30.515 ===== TRACE ===== DISCONNECTED USER 'admin'
2018-12-06 11:25:34.534 ===== TRACE ===== NEW CONNECTED USER 'u0561688'
2018-12-06 11:25:48.159 ***** ERROR ***** [V7.2.3] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tender.plannedAmount' in 'field list'
2018-12-06 11:25:48.159 ***** ERROR ***** [V7.2.3]    For query : select tender.id as id, T1.name as nameProject, T2.name as nameTenderType, tender.name as name, convert(concat(COALESCE(T3.sortOrder,''),'#split#',T3.name,'#split#',COALESCE(T3.color,'')) using utf8) as colorNameTenderStatus, tender.evaluationValue as evaluationValue, tender.plannedAmount as plannedAmount, convert(concat(COALESCE(T4.sortOrder,''),'#split#',T4.name,'#split#',COALESCE(T4.color,'')) using utf8) as colorNameStatus, tender.idle as idle, tender.totalUntaxedAmount as totalUntaxedAmount,tender.idProject as idproject from tender left join project as T1 on tender.idProject = T1.id left join type as T2 on tender.idTenderType = T2.id left join tenderstatus as T3 on tender.idTenderStatus = T3.id left join status as T4 on tender.idStatus = T4.id where tender.idle=0 and ( (tender.idProject not in (0) or tender.idProject is null ) and (tender.idProject not in (0) or tender.idProject is null or (tender.idResource='16') ) and (tender.idProject not in (0) or tender.idProject is null or (tender.idUser='16') ) ) order by tender.id desc
2018-12-06 11:25:48.160 ***** ERROR ***** [V7.2.3]    Strack trace :
2018-12-06 11:25:48.160 ***** ERROR ***** [V7.2.3]    #0 Sql->query called at [/produits/www/projeqtor/tool/jsonQuery.php:567]
2018-12-06 11:26:10.957 ===== TRACE ===== DISCONNECTED USER 'u0561688'
Could you help me to understand why i cannont see provider tenders when i'm using standard user account.

thank's for all.
Last edit: 06 Dec 2018 15:49 by Iaurkano.

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

More
06 Dec 2018 14:16 #2 by babynus
Replied by babynus on topic provider tenders display
It is because some columns have been renames.
Clear the columns configuration

Click on "Reset"
Babynus
Administrator of ProjeQtOr web site
Attachments:

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

More
06 Dec 2018 15:49 #3 by Iaurkano
Replied by Iaurkano on topic provider tenders display
Ok perfect it works...

thank's a lot for your quick answer.

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

Moderators: babynus, protion
Time to create page: 0.046 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.

Login Form