Download & Extend
Private Message Growl » Issues

Works only for 32767 messages, not more

Posted by andrej11235 on November 30, 2010 at 8:29pm
Project:Private Message Growl
Version:6.x-1.1-beta1
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:needs work

Issue Summary

Becasue in database table pmgrowl_close, the PMID is only SmallInt(6). So the maximum message number can be 32767. I have reached this number, and got lots of errors:

Duplicate entry '32767-2393' for key 1 query: INSERT INTO pmgrowl_close (mid, uid, closed) VALUES (32897, 2393, 1)

So I have changed the PMID in database table from SmallInt(6) to Int(10), and it works perfectly.

Login or register to post comments

Comments

#1

Posted by Berdir on January 6, 2011 at 11:53am
Status:active» needs review

Confirmed, attaching a patch, should work on 6.x-1.x and 6.x-2.x, can someone please test?

AttachmentSize
pmgrowl_small_mid.patch 1015 bytes

#2

Posted by doitDave on March 23, 2011 at 10:41pm

The UID should also be set to INT without "size=small" (since this is drupal default). Rest looks good.

#3

Posted by doitDave on November 2, 2011 at 2:40am
Status:needs review» needs work

(status)