(anonymous guest) (logged out)
My Prefs

25.05.2019  

×
   
SCRIPT ERROR (1):
ShowEditPrewrwrwerojects jreturn:JavaException: org.postgresql.util.PSQLException: FEHLER: ungültige Eingabesyntax für ganze Zahl: „null“ Position: 76 ((ProjectsPage/anonamous script)#3163)

LAST OUTPUT

1  : 

------------------------

NARROW TRACE (error line 3163 +- 5 lines in anonamous script):

3159:     } catch(e) {
3160:         if(tcon != null) {
3161:           tcon.rollback();
3162:         }
3163*:         throw "ShowEditPrewrwrwerojects jreturn:" + e;
3164:     } finally {
3165:         if(tcon != null) {
3166:             jrt.release(tcon);
3167:         }
3168:     }
3169:     // get all categories by current project


WIDE TRACE (error line 3163 +- 150 lines in anonamous script):

3014: "\r\n" + 
3015: "            
\r\n" + 3016: "\r\n" + 3017: " }]\r\n" + 3018: " \r\n" 3019: ; 3020: var closeTable = 3021: " [{JHtml\r\n" + 3022: "\r\n" + 3023: "
\r\n" + 3024: "\r\n" + 3025: " }]\r\n" + 3026: " \r\n" 3027: ; 3028: 3029: // get id progect from link 3030: var id_project = jpage.get("id"); 3031: if(parseInt(id_project) > 0 ) { 3032: jglobal.clear(); 3033: jglobal.set('id_project',id_project); 3034: jglobal.set("categoryIndex", 0); 3035: jglobal.set("category", 0); 3036: } else { 3037: if(jglobal.containsKey('id_project')) { 3038: var id_project = parseInt( jglobal.get('id_project')); 3039: } 3040: } 3041: 3042: // verify if the results page is accesed 3043: var results = parseInt(jpage.get('pageResults')); 3044: if(results == 1) { 3045: jglobal.set('pageResults',1); 3046: jumpToTopOfThePage(); 3047: } 3048: 3049: try { 3050: var tcon = jrt.exclusiveCon( "PP.ShowEditProjects",false); 3051: // if link activate account is accesed 3052: if(jpage.get('ac') == 1){ 3053: if(jpage.get('uuid') != null){ 3054: // get user uuid from link 3055: var uuid = jpage.get('uuid'); 3056: var querySelect = tcon.prepareStatement("SELECT * FROM clients WHERE uuid='" + uuid + "'").executeQuery(); 3057: 3058: while(querySelect.next()) { 3059: var email= querySelect.getString('email'); 3060: var clientId= querySelect.getInt('id_client'); 3061: jglobal.set('email',email); 3062: jglobal.set('clientId',clientId); 3063: var confirmed_email = querySelect.getBoolean('confirmed_email'); 3064: 3065: if(confirmed_email == true){ 3066: addMessage("information", "Willkommen zurück "+email); 3067: } else { 3068: var query = "UPDATE clients SET confirmed_email = true WHERE uuid='"+uuid+"'" ; 3069: var saveStatement = tcon.prepareStatement(query); 3070: var executeResult = saveStatement.executeUpdate(); 3071: tcon.commit(); 3072: // save user details globaly 3073: tcon.commit(); 3074: addMessage("information", "Ihr Konto wurde erfolgreich aktiviert."); 3075: } 3076: } 3077: } 3078: } 3079: } catch(e) { 3080: if(tcon != null) tcon.rollback(); 3081: throw "ShowEditProjects1 jreturn:" + e; 3082: } finally { 3083: if(tcon != null) { 3084: jrt.release(tcon); 3085: } 3086: } 3087: 3088: try { 3089: var tcon = jrt.exclusiveCon( "PP.ShowEditProjects2",false); 3090: // if link see results from email is active 3091: if(jpage.get('se') == 1) { 3092: if(jpage.get('uuid') != null) { 3093: var uuid = jpage.get('uuid'); 3094: // save user details globaly 3095: var querySelect = tcon.prepareStatement("SELECT id_client, email FROM clients WHERE uuid='" + uuid + "'").executeQuery(); 3096: if(querySelect.next()) { 3097: var email= querySelect.getString('email'); 3098: var clientId= querySelect.getInt('id_client'); 3099: jglobal.set('email',email); 3100: jglobal.set('clientId',clientId); 3101: 3102: tcon.commit(); 3103: querySelect.close(); 3104: var queryUpdate = "UPDATE projects_clients set is_active = true where fk_project = "+parseInt(id_project)+ 3105: " and fk_client = "+parseInt(clientId)+" "; 3106: var queryStatement = tcon.createStatement(); 3107: queryStatement.executeUpdate(queryUpdate); 3108: tcon.commit(); 3109: queryStatement.close(); 3110: var confirmation_message = displayMessagesByKey(tcon, 'welcome_projekt'); 3111: 3112: addMessage("information", confirmation_message); 3113: } else { 3114: var link_print = 3115: " [{JHtml\r\n" + 3116: "\r\n" + 3117: "
\r\n" + 3118: "

$title_link

\r\n" + 3119: "
\r\n" + 3120: " }]\r\n" + 3121: " \r\n" 3122: ; 3123: 3124: var link_print = jutil.replace(link_print, "$title_link", title_link); 3125: 3126: jout.println(link_print); 3127: 3128: var user_deleted = displayMessagesByKey(tcon, 'user_deleted'); 3129: jout.println('|'+ user_deleted); 3130: return; 3131: } 3132: } 3133: } 3134: } catch(e) { 3135: if(tcon != null) { 3136: tcon.rollback(); 3137: } 3138: throw "ShowEditProjrweects jreturn:" + e; 3139: } finally { 3140: if(tcon != null) { 3141: jrt.release(tcon); 3142: } 3143: } 3144: 3145: try { 3146: var tcon = jrt.exclusiveCon( "PP.ShowEditProjeects2",false); 3147: var queryProject = tcon.prepareStatement("SELECT id_project, name_project, fk_status FROM projects WHERE id_project='" + id_project + "'").executeQuery(); 3148: if(queryProject.next()) { 3149: var name_project= queryProject.getString("name_project"); 3150: var fk_status= queryProject.getInt("fk_status"); 3151: } else { 3152: var name_project= ''; 3153: var fk_status= 0; 3154: } 3155: 3156: jglobal.set('name_project',name_project); 3157: tcon.commit(); 3158: queryProject.close(); 3159: } catch(e) { 3160: if(tcon != null) { 3161: tcon.rollback(); 3162: } 3163*: throw "ShowEditPrewrwrwerojects jreturn:" + e; 3164: } finally { 3165: if(tcon != null) { 3166: jrt.release(tcon); 3167: } 3168: } 3169: // get all categories by current project 3170: try { 3171: var tcon = jrt.exclusiveCon("QuestionnaireFunctions.getSubcatogoriesByCatProject",false); 3172: tcon.commit(); 3173: getCategoriesALLByProject(tcon, id_project); 3174: tcon.commit(); 3175: } catch(e) { 3176: if(tcon != null) tcon.rollback(); 3177: throw "getSubcatogoriesByCatProject jreturn:" + e; 3178: } finally { 3179: if(tcon != null) jrt.release(tcon); 3180: } 3181: 3182: try { 3183: var tcon = jrt.exclusiveCon("ProjectsPage.showCategories",false); 3184: var link_print = 3185: " [{JHtml\r\n" + 3186: "\r\n" + 3187: "
\r\n" + 3188: "

$title_link

\r\n" + 3189: "

$project_name

\r\n" + 3190: "
\r\n" + 3191: " }]\r\n" + 3192: " \r\n" 3193: ; 3194: 3195: var link_print = jutil.replace(link_print, "$title_link", title_link); 3196: var link_print = jutil.replace(link_print, "$project_name", name_project); 3197: jout.println(link_print); 3198: 3199: // SHOW MESSAGES 3200: showMessage(); 3201: 3202: tcon.commit(); 3203: 3204: if(jglobal.containsKey('categoryIndex')) { 3205: var categoryIndex = parseInt(jglobal.get("categoryIndex")); 3206: jglobal.set("categoryIndex",categoryIndex); 3207: } else { 3208: jglobal.set("categoryIndex", 0); 3209: } 3210: 3211: // link category index prom right menu, categoryIndex 3212: var categoryIndex = jpage.get("category"); 3213: if(categoryIndex != null) { 3214: jglobal.set("categoryIndex", categoryIndex); 3215: jumpToTopOfThePage(); 3216: } 3217: } catch(e) { 3218: if(tcon != null) tcon.rollback(); 3219: throw "showCategories jreturn:" + e; 3220: } finally { 3221: if(tcon != null){ 3222: jrt.release(tcon); 3223: } 3224: } 3225: 3226: var showResults = 0; 3227: var pageResults = jglobal.get('pageResults'); 3228: 3229: if(jpage.get("category") != null) { 3230: pageResults = 0; 3231: jglobal.set('pageResults', 0); 3232: } 3233: 3234: var sumAnswerd = 0; 3235: var sumTotal = 0; 3236: 3237: if(jglobal.containsKey('sumAnswerd')) { 3238: var sumAnswerd = parseInt(jglobal.get('sumAnswerd')); 3239: } 3240: if(jglobal.containsKey('sumTotal')) { 3241: var sumTotal = parseInt(jglobal.get('sumTotal')); 3242: } 3243: // verify if all questions are answerd 3244: if(sumTotal > 0 && sumAnswerd == sumTotal) { 3245: if(parseInt(pageResults)>0) { 3246: showResults = 1; 3247: } 3248: } 3249: 3250: //new overwrite show_results 3251: var is_questionnaire_completed = isQuestionnaireCompleted(); 3252: if(is_questionnaire_completed) 3253: { 3254: if(parseInt(pageResults)>0) { 3255: showResults = 1; 3256: } 3257: } 3258: 3259: // if project status is active 3260: if(fk_status == 1) { 3261: // if show results page is active 3262: if(showResults == 1) { 3263: try { 3264: var tcon = jrt.exclusiveCon("PP.showResults",false); 3265: tcon.commit(); 3266: jout.println(outerTable); 3267: jout.println(mainFraim); 3268: 3269: // show results page function 3270: showResultsPage(tcon); 3271: 3272: jout.println(closeFraim); 3273: jout.println(rightFraim); 3274: jout.println('%%commentbox'); 3275: 3276: if(jglobal.containsKey('require_pass') && jglobal.get('require_pass') == 1) { 3277: showClientEmailAdressFieldsPass(tcon); 3278: } else { 3279: showClientEmailAdressFields(tcon); 3280: } 3281: 3282: showInputFieldsUser(tcon); 3283: showCategoriesLinksProgress(tcon); 3284: 3285: jout.println(closeFraim); 3286: jout.println(closeTable); 3287: tcon.commit(); 3288: } catch(e) { 3289: if(tcon != null){ 3290: tcon.rollback(); 3291: } 3292: throw "showResults jreturn:" + e; 3293: } finally { 3294: if(tcon != null) jrt.release(tcon); 3295: } 3296: } else { 3297: 3298: try { 3299: var tcon = jrt.exclusiveCon("PP.showQuestions",false); 3300: jout.println(outerTable); 3301: jout.println(mainFraim); 3302: tcon.commit(); 3303: 3304: showQuestions(tcon); 3305: 3306: tcon.commit(); 3307: jout.println(closeFraim); 3308: jout.println(rightFraim); 3309: jout.println('%%commentbox'); 3310: 3311: if(jglobal.containsKey('require_pass') && jglobal.get('require_pass') == 1) { 3312: showClientEmailAdressFieldsPass(tcon); 3313: } else { 3314: showClientEmailAdressFields(tcon);

Powered by Nuveon CCI