On 5/2/05, Patrick Bierans <[EMAIL PROTECTED]> wrote: > Well. It's a very basic error which was born by the create statement of your > table. You have a "tinyint" as type for the field used as primary key or > something alike. Because it is signed you can only use 0-127. 128 would > become 0 again which is already in use. The primary key of the table > (normally based on the field called "id") should be of type "bigint unsigned" > or equal. Fix it by executing this statement once: alter table busnz modify > id bigint unsigned; <
Thanks :) Its going :) Has anyone got (or creating) a website about common MYSQL errors - & possible causes ? (thats not inter-spersed in other mysql instructions... - ie a one-stop quick-fix ? (good idea ?) -- G Stewart NZ: [EMAIL PROTECTED] NZ Bus Website update form http://busnz.kwister.com/feedback.php Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
