|
03-04-2004, 06:16 PM | #1 |
Green Mole
Join Date: Feb 2004
Posts: 3
|
keywords.key_id is too small
Since keywords.key_id is only a tinyint it will hit the end at 8.4 million. All entries after that will fail and autoincrement returns a 0 which puts many key_id=0 entries for the same spider_id which should be prevented with a composite unique constraint on spider_id/key_id.
To fix the key_id problem it should be made a bitint instead. |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
keywords duplicates and unwanted keywords | jerrywin5 | How-to Forum | 5 | 04-06-2005 04:20 PM |
Very small bug in PhpDig v.1.8.7 | Edomondo | Bug Tracker | 0 | 03-17-2005 02:50 AM |
Looks Like A Small Bug In 1.8.1 | vinyl-junkie | Troubleshooting | 6 | 07-07-2004 09:04 PM |
Language small bug | TiM | Bug Tracker | 0 | 03-04-2004 01:17 PM |
Small bug in phpdigRewriteUrl() | Goth | Bug Tracker | 0 | 02-10-2004 04:03 PM |