Go Back > PhpDig Forums > Bug Tracker

Thread Tools
Old 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.
bsw114 is offline   Reply With Quote

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 Off
HTML code is Off
Forum Jump

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

All times are GMT -8. The time now is 02:53 AM.

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.