Shareef hiasat shareefhiasat
😃
shareefhiasat
/ 14 may 2017 memory leak catalina log
Created
May 14, 2017 18:10
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Feb 20, 2017 1:06:57 PM org.apache.catalina.startup.ClassLoaderFactory validateFile | |
| WARNING: Problem with directory [/usr/share/tomcat7/common/classes], exists: [false], isDirectory: [false], canRead: [false] | |
| Feb 20, 2017 1:06:57 PM org.apache.catalina.startup.ClassLoaderFactory validateFile | |
| WARNING: Problem with directory [/usr/share/tomcat7/common], exists: [false], isDirectory: [false], canRead: [false] | |
| Feb 20, 2017 1:06:57 PM org.apache.catalina.startup.ClassLoaderFactory validateFile | |
| WARNING: Problem with directory [/usr/share/tomcat7/server/classes], exists: [false], isDirectory: [false], canRead: [false] | |
| Feb 20, 2017 1:06:57 PM org.apache.catalina.startup.ClassLoaderFactory validateFile | |
| WARNING: Problem with directory [/usr/share/tomcat7/server], exists: [false], isDirectory: [false], canRead: [false] | |
| Feb 20, 2017 1:06:57 PM org.apache.catalina.startup.ClassLoaderFactory validateFile | |
| WARNING: Problem with directory [/usr/share/tomcat7/shared/classes], exists: [false], isDirectory: [false], canRead: [fa |
shareefhiasat
/ 14 may 2017 catalina out
Created
May 14, 2017 18:11
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| log4j:WARN Failure in post-close rollover action | |
| May 14, 2017 6:28:27 AM com.dtcm.service.client.DTCMClientService handelWebRequestException | |
| SEVERE: Not Found | |
| May 14, 2017 6:28:27 AM com.dtcm.service.client.DTCMClientService handelWebRequestException | |
| SEVERE: GET performances/EWTC2016960/availabilities | |
| May 14, 2017 6:28:27 AM com.dtcm.service.client.DTCMClientService handelWebRequestException | |
| SEVERE: {sellerCode=ASAJI1, channel=W} | |
| May 14, 2017 6:28:27 AM com.dtcm.service.client.DTCMClientService handelWebRequestException | |
| SEVERE: 0 |
shareefhiasat
/ sample 1 very slow almost forever
Created
May 15, 2017 15:25
on my pc it took 60 seconds
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select SQL_CACHE part1.id,part1.event_date,part1.ticket_type,part1.order_id, | |
| COALESCE(part1.entry1,part2.entry2),COALESCE(part2.entry2,part1.entry1) from | |
| ( SELECT `order_item`.id as id,(case when DATE_FORMAT(CONVERT_TZ | |
| (`event_date`.`start_date`,'+0:00','+2:00'),'%d/%m/%Y %H:%i') != | |
| DATE_FORMAT(CONVERT_TZ(`event_date`.`end_date`,'+0:00','+2:00'),'%d/%m/%Y %H:%i') | |
| then CONCAT(DATE_FORMAT(CONVERT_TZ(`event_date`.`start_date`,'+0:00','+2:00'),'%d/%m/%Y %H:%i'), | |
| ' - ',DATE_FORMAT(CONVERT_TZ(`event_date`.`end_date`,'+0:00','+2:00'),'%d/%m/%Y %H:%i')) | |
| else DATE_FORMAT(CONVERT_TZ(`event_date`.`start_date`,'+0:00','+2:00'),'%d/%m/%Y %H:%i') end) | |
| as event_date,`product`.`name` as ticket_type,`order_item`.order_id | |
| as order_id,GROUP_CONCAT(DISTINCT(case when submission_entry1.text='' then concat(question1.var,': ') |
shareefhiasat
/ load all orders with no event id
Created
May 15, 2017 16:00
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT SQL_NO_CACHE `payment`.`id` as id,`order`.`id` as order_id,GROUP_CONCAT(DISTINCT (case when submission_entry.text='' OR submission_entry.text is NULL then ' ' else submission_entry.text end) ORDER BY question.var DESC SEPARATOR 0x1D) as buyer,event.name as event,COUNT(DISTINCT CASE WHEN `order_item`.status >0 THEN `order_item`.id ELSE NULL END) as qty,payment.currency AS `currency`,ROUND(payment.total + COALESCE(refunds_total, 0), 2) as 'total',`payment_type`.`name` as payment_type,payment_status.name as status,`payment_status`.`id` as status_id,DATE_FORMAT(CONVERT_TZ(payment.`paid_on`,'+0:00','-9:00'),'%d/%m/%Y %H:%i') as 'created',`user`.`name` as 'agent',order.last_log,order.log_history,event.id as event_id,payment.checked,DATE_FORMAT(CONVERT_TZ(payment.checked_date,'+0:00','-9:00'),'%d/%m/%Y'),`payment`.`settled` AS `settled`,DATE_FORMAT(CONVERT_TZ(`payment`.`settled_date`,'+0:00','-9:00'),'%d/%m/%Y') AS `settled date`,`payment`.`delivery_status` AS `delivered` FROM `order_item` INNER JOIN `paymen |
shareefhiasat
/ error jawr
Created
May 16, 2017 18:22
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| May 16, 2017 9:21:59 PM org.apache.catalina.core.StandardWrapperValve invoke | |
| SEVERE: Servlet.service() for servlet [dispatcher] in context with path [/sajilni] threw exception [An exception occurred processing JSP page /WEB-INF/theme/default/index.jsp at line 7 | |
| 4: <!DOCTYPE html> | |
| 5: <html xmlns:fb="http://ogp.me/ns/fb#"> | |
| 6: <head> | |
| 7: <jsp:include page = "jsp/head.jsp" flush="true" /> | |
| 8: </head> | |
| 9: <body data-buy-source="0" > | |
| 10: <!-- templates --> |
shareefhiasat
/ redirects
Last active
May 23, 2017 12:14
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| if domain equal old.sajilni or new.sajilni then redirect to https://www.sajilni.com | |
| <rule> | |
| <name>Domain Name Check</name> | |
| <note>Check that users are using the correct domain name to get to your site. ie, users gong to https://sajilni.com/blah will be redirected to https://www.sajilni.com/blah</note> | |
| <condition name="host" operator="equal">www.sajilni.com</condition> | |
| <condition name="host" operator="equal">new.sajilni.com</condition><!-- put not equal instead of not equal for A B testing --> | |
| <condition name="host" operator="equal">old.sajilni.com</condition><!-- put not equal instead of not equal for A B testing --> | |
| <condition name="host" operator="equal">https://new.sajilni.com</condition><!-- put not equal instead of not equal for A B testing --> | |
| <condition name="host" operator="equal">https://old.sajilni.com</condition><!-- put not equal instead of not equal for A B testing --> |
shareefhiasat
/ refund_item_VS_make_order_free.sql
Created
June 17, 2017 19:51
new column added please modify test cases
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT SQL_CACHE | |
| `payment`.`id` AS id, | |
| `order_item`.`order_id` AS order_id, | |
| GROUP_CONCAT(DISTINCT (CASE WHEN submission_entry.text = '' OR submission_entry.text IS NULL | |
| THEN ' ' | |
| ELSE submission_entry.text END) ORDER BY question.var DESC SEPARATOR 0x1D) AS buyer, | |
| event.name AS event, | |
| COUNT(DISTINCT CASE WHEN (`order_item`.status > 0 OR (`order_item`.status != -1 AND `order_item`.status >= -2 AND | |
| `payment`.payment_type_id != 8 and payment.make_order_free = 1)) | |
| THEN `order_item`.id |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Jul 12, 2017 12:03:30 PM org.apache.catalina.core.ApplicationDispatcher invoke | |
| SEVERE: Servlet.service() for servlet jsp threw exception | |
| javax.servlet.ServletException: File "/WEB-INF/theme/admin/jsp/footer-scripts-Sajilni.jsp" not found | |
| at org.apache.jasper.servlet.JspServlet.handleMissingResource(JspServlet.java:412) | |
| at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) | |
| at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) | |
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) | |
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) | |
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
| at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749) |
shareefhiasat
/ media
Created
October 20, 2017 09:11
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="UTF-8"?> | |
| <!-- | |
| Licensed to the Apache Software Foundation (ASF) under one | |
| or more contributor license agreements. See the NOTICE file | |
| distributed with this work for additional information | |
| regarding copyright ownership. The ASF licenses this file | |
| to you under the Apache License, Version 2.0 (the | |
| "License"); you may not use this file except in compliance | |
| with the License. You may obtain a copy of the License at |
shareefhiasat
/ bug template
Created
October 25, 2017 07:11
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| INSERT INTO security_3.html_template (pos, json, name, html, description, owner_id, template_name, default_template, wkhtml_options, lang, event_id, product_id) VALUES (0, '[{"position":{"x":0,"y":0},"orientation":"Landscape","angle":0,"pos":0,"isDefaultTmpl":1,"format":"","backgroundUrl":"","fillColor":"transparent","width":"175.006mm","height":"101.6mm","$type":"TicketLayout"},{"position":{"x":100,"y":100},"angle":0,"url":"//placehold.it/100x100","strokeWidth":"0","strokeColor":"#ffffff","width":"100","height":"100","text":"https://localhost:8443/chart/encode/code128.html?width={{width}}&height={{height}}&code=CODE_128","variable":"https://localhost:8443/chart/encode/code128.html?width={{width}}&height={{height}}&code=${orderItem.referenceNumber}","$type":"BarcodeVar"},{"position":{"x":193.92832946777344,"y":101},"angle":0,"url":"//placehold.it/100x100","strokeWidth":"0","strokeColor":"#ffffff","width":"100","height":"100","text":"https://localhost:8443/chart/encode/qrcode.html?width={{width}}&height={{heig |