Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 17 Aug 2014, 21:41
Terrablade Terrablade is offline
 
Join Date: Oct 2013
Delete Visitors Message Error

While trying to delete a specific user's visitor messages sent I encounter this error..


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

How to fix this issue?
Reply With Quote
  #2  
Old 19 Aug 2014, 00:43
Terrablade Terrablade is offline
 
Join Date: Oct 2013
yOOHOOOOO.. anyone knowledgeable about this issue?
Reply With Quote
  #3  
Old 19 Aug 2014, 04:34
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
What is the user. vmunreadcount for the user "astronau_heaven1" in the database?
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #4  
Old 19 Aug 2014, 07:10
Terrablade Terrablade is offline
 
Join Date: Oct 2013
Didnt understand your question :S
Reply With Quote
  #5  
Old 19 Aug 2014, 17:24
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Take a look at the user table in your database. Find the row for the user "astronau_heaven1" and then tell us what is listed for vmunreadcount for that user.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #6  
Old 25 Aug 2014, 21:17
Terrablade Terrablade is offline
 
Join Date: Oct 2013
Lynne,
Looked through the entire mysql DB and saw regardng what u asked me to look. :/
Reply With Quote
  #7  
Old 26 Aug 2014, 15:42
squidsk's Avatar
squidsk squidsk is offline
 
Join Date: Nov 2010
Is that a custom query? I'm asking because it is not designed very well and leaves a lot to be desired. The problem you have is that one (or more) of those users has no unread vms, so when you set vmunreadcount to be vmunreadcount - 1 for those users it sets the vmunreadcount to -1, which will throw that db error you're seeing.

The query should be something like this instead:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

This query assumes that all userids listed in the where clause should have their unreadvmcount lowered by 1, if possible.
Reply With Quote
  #8  
Old 26 Aug 2014, 20:50
Terrablade Terrablade is offline
 
Join Date: Oct 2013
so how to fix that?
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 02:52.

Layout Options | Width: Wide Color: