Delete support ticket

56 views
Skip to first unread message

John Hooks

unread,
Feb 5, 2014, 3:28:58 PM2/5/14
to erpnext-dev...@googlegroups.com
When I place a check beside the ticket and then click the delete icon, the check disappears but the ticket remains.  I cleared the cache and it is still there.  Is this on purpose or should it actually delete?  Thanks!

rushabh

unread,
Feb 5, 2014, 11:30:10 PM2/5/14
to erpnext-dev...@googlegroups.com
there was an error - whats is there in your js console?

John Hooks

unread,
Feb 6, 2014, 8:34:03 AM2/6/14
to erpnext-dev...@googlegroups.com
Traceback (innermost last): File "lib/webnotes/widgets/reportview.py", line 366, in delete_items dt_obj.on_trash() File "app/support/doctype/support_ticket/support_ticket.py", line 54, in on_trash where support_ticket=%s""", (self.doc.name,)) File "lib/webnotes/db.py", line 102, in sql self._cursor.execute(query, values) File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1054, "Unknown column 'support_ticket' in 'where clause'")


Thanks!

Nabin Hait

unread,
Feb 7, 2014, 1:21:31 AM2/7/14
to erpnext-dev...@googlegroups.com
Fixed the issue in develop branch. It will be merged in master by the end of today.

--
Note:
 
If you are posting an issue,
1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
 
End of Note
---
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/5bfb3045-b3cb-48b1-b734-2351c5b07bbc%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Nabin Hait

unread,
Feb 7, 2014, 5:56:33 AM2/7/14
to erpnext-dev...@googlegroups.com
The fix has been merged into master

John Hooks

unread,
Feb 7, 2014, 1:16:21 PM2/7/14
to erpnext-dev...@googlegroups.com
Thanks!


On Friday, February 7, 2014 5:56:33 AM UTC-5, Nabin Hait wrote:
The fix has been merged into master
On 07-Feb-2014, at 11:51 AM, Nabin Hait wrote:

Fixed the issue in develop branch. It will be merged in master by the end of today.
On 06-Feb-2014, at 7:04 PM, John Hooks wrote:

Traceback (innermost last): File "lib/webnotes/widgets/reportview.py", line 366, in delete_items dt_obj.on_trash() File "app/support/doctype/support_ticket/support_ticket.py", line 54, in on_trash where support_ticket=%s""", (self.doc.name,)) File "lib/webnotes/db.py", line 102, in sql self._cursor.execute(query, values) File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1054, "Unknown column 'support_ticket' in 'where clause'")


Thanks!

On Wednesday, February 5, 2014 3:28:58 PM UTC-5, John Hooks wrote:
When I place a check beside the ticket and then click the delete icon, the check disappears but the ticket remains.  I cleared the cache and it is still there.  Is this on purpose or should it actually delete?  Thanks!

--
Note:
 
If you are posting an issue,
1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
 
End of Note
---
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+unsub...@googlegroups.com.

Sebastian Lungu

unread,
Feb 19, 2014, 5:14:26 AM2/19/14
to erpnext-dev...@googlegroups.com
Hi Nabin,

I have the same problem related into this post. Can you describe how to patch this master of my erpnext (v.3.6.6)?

BR


On Friday, February 7, 2014 12:56:33 PM UTC+2, Nabin Hait wrote:
The fix has been merged into master
On 07-Feb-2014, at 11:51 AM, Nabin Hait wrote:

Fixed the issue in develop branch. It will be merged in master by the end of today.
On 06-Feb-2014, at 7:04 PM, John Hooks wrote:

Traceback (innermost last): File "lib/webnotes/widgets/reportview.py", line 366, in delete_items dt_obj.on_trash() File "app/support/doctype/support_ticket/support_ticket.py", line 54, in on_trash where support_ticket=%s""", (self.doc.name,)) File "lib/webnotes/db.py", line 102, in sql self._cursor.execute(query, values) File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1054, "Unknown column 'support_ticket' in 'where clause'")


Thanks!

On Wednesday, February 5, 2014 3:28:58 PM UTC-5, John Hooks wrote:
When I place a check beside the ticket and then click the delete icon, the check disappears but the ticket remains.  I cleared the cache and it is still there.  Is this on purpose or should it actually delete?  Thanks!

--
Note:
 
If you are posting an issue,
1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
 
End of Note
---
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+unsub...@googlegroups.com.

Nabin Hait

unread,
Feb 19, 2014, 5:17:29 AM2/19/14
to erpnext-dev...@googlegroups.com
Run lib/wnf.py --update origin master

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/1f5c3ead-3378-464b-a220-af9572d69419%40googlegroups.com.

Sebastian Lungu

unread,
Feb 19, 2014, 5:55:44 AM2/19/14
to erpnext-dev...@googlegroups.com
Hi Nabin,

Thanks for your quick reply. 
The problem persist: Support ticket can't be deleted. I must do something else?

Command output: 

lib/wnf.py --update origin master
remote: Counting objects: 12, done.
remote: Compressing objects: 100% (12/12), done.
remote: Total 12 (delta 3), reused 0 (delta 0)
Unpacking objects: 100% (12/12), done.
 * branch            master     -> FETCH_HEAD

Updating dd52519..f079faa
Fast-forward
 config.json                        |    2 +-
 public/js/wn/views/query_report.js |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)
remote: Counting objects: 10, done.
remote: Compressing objects: 100% (10/10), done.
remote: Total 10 (delta 3), reused 0 (delta 0)
Unpacking objects: 100% (10/10), done.
 * branch            master     -> FETCH_HEAD
Updating fc274e2..3b5c616
Fast-forward
 config.json                                                |    4 ++--
 patches/1401/update_billing_status_for_zero_value_order.py |   27 ++++++++++++++-------------
 2 files changed, 16 insertions(+), 15 deletions(-)
Building js and css files...
Wrote public/css/all-web.css - 124k
Wrote public/js/all-web.min.js - 41k
Wrote public/js/editor.min.js - 26k
Wrote public/css/all-app.css - 163k
Wrote public/js/all-app.min.js - 556k
Wrote public/js/slickgrid.min.js - 102k


Remarks: into the "About Version" tab it is the same software version, 3.6.6 Theare are other commands to upgrade to 3.8.7?

BR

Sebastian Lungu

unread,
Feb 19, 2014, 6:08:20 AM2/19/14
to erpnext-dev...@googlegroups.com
Solved. I restart gunicorn service and the version of ERPNext is now ok. 3.8.7

Thanks again for your help
Reply all
Reply to author
Forward
0 new messages