PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > Bug Tracker

Reply
 
Thread Tools
Old 03-04-2004, 05:16 PM   #1
bsw114
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
Reply

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 03:20 PM
Very small bug in PhpDig v.1.8.7 Edomondo Bug Tracker 0 03-17-2005 01:50 AM
Looks Like A Small Bug In 1.8.1 vinyl-junkie Troubleshooting 6 07-07-2004 08:04 PM
Language small bug TiM Bug Tracker 0 03-04-2004 12:17 PM
Small bug in phpdigRewriteUrl() Goth Bug Tracker 0 02-10-2004 03:03 PM


All times are GMT -8. The time now is 01:15 AM.


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