Works only for 32767 messages, not more [#985526]

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.

Comment	File	Size	Author
#1	pmgrowl_small_mid.patch	1015 bytes	Berdir

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

Berdir

German

Switzerland

CreditAttribution: Berdir commented 6 January 2011 at 11:53

Status:

Active

» Needs review

File	Size
pmgrowl_small_mid.patch	1015 bytes

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

Comment #2

doitDave CreditAttribution: doitDave commented 23 March 2011 at 22:41

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

Comment #3

doitDave CreditAttribution: doitDave commented 2 November 2011 at 02:40

Status:

Needs review

» Needs work

(status)

Comment #4

doitDave CreditAttribution: doitDave commented 1 July 2013 at 19:02

Can we please update this issue or set the module (branch) to "no maintenance" or have someone joining the team? Is there any interest left at all in this module, regarding D6 outdating soon?

Comment #5

doitDave CreditAttribution: doitDave commented 28 July 2013 at 12:36

Considering the issue status and age, I consider this abandoned and I'm out of here. If there should still and unexpectedly be any interest in getting this solved, feel free to contact me, but I have to clean up my personal queue.