bigshwa05 Posted January 22, 2007 Share Posted January 22, 2007 Hey Everyone,I'm fairly new to php and programming in general but i've been making out pretty well. I've run into another road block though. I have a form setup that enters users contact info into a MySQL database. Its been working great for the last month but now it has hit row #862 and it no longer is capturing records. There is a thing at the bottom of the php admin that says cardinality 862 so i m assuming this is limiting the entries and now blocking new ones!How can i increase that? I am afraid to think how many entries i have already lost :( Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/ Share on other sites More sharing options...
Jessica Posted January 22, 2007 Share Posted January 22, 2007 What is the field type of the primary key? Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166352 Share on other sites More sharing options...
bigshwa05 Posted January 22, 2007 Author Share Posted January 22, 2007 The field type is PRIMARY Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166369 Share on other sites More sharing options...
Jessica Posted January 22, 2007 Share Posted January 22, 2007 AFAIK that's not a field type. Is it an int? smallint, tinyint, what? Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166370 Share on other sites More sharing options...
redbullmarky Posted January 22, 2007 Share Posted January 22, 2007 [quote author=bigshwa05 link=topic=123511.msg510541#msg510541 date=1169479563]The field type is PRIMARY[/quote];Di think jesi means the datatype itself, eg INT, VARCHAR, etc Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166371 Share on other sites More sharing options...
bigshwa05 Posted January 22, 2007 Author Share Posted January 22, 2007 Oh its an INT with Length/Values set to 255 Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166380 Share on other sites More sharing options...
Jessica Posted January 22, 2007 Share Posted January 22, 2007 That's a huge honking int.Dunno, best of luck. Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166383 Share on other sites More sharing options...
bigshwa05 Posted January 22, 2007 Author Share Posted January 22, 2007 Hi Jess,Yes i changed it to that because it was the maximum length acceptable I have never seen anything like this before so i thought it was best to just max it out and cross my fingers....but no luck!! :( Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166387 Share on other sites More sharing options...
Jessica Posted January 22, 2007 Share Posted January 22, 2007 So it wasn't that before? What was it when the problem started? Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166390 Share on other sites More sharing options...
bigshwa05 Posted January 22, 2007 Author Share Posted January 22, 2007 It was originally set to 9 Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166393 Share on other sites More sharing options...
Jessica Posted January 22, 2007 Share Posted January 22, 2007 Still shouldn't cause a problem. I dunno. Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166397 Share on other sites More sharing options...
redarrow Posted January 22, 2007 Share Posted January 22, 2007 bigint Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166399 Share on other sites More sharing options...
bigshwa05 Posted January 22, 2007 Author Share Posted January 22, 2007 BIGINT was my next thought too but still no luck...I dont get it ??? Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166410 Share on other sites More sharing options...
effigy Posted January 22, 2007 Share Posted January 22, 2007 Is your code checking for errors properly? Are there multiple indexes involved? Quote Link to comment https://forums.phpfreaks.com/topic/35230-cardinality-preventing-new-inserts/#findComment-166482 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.