One of my MYSQL tables the auto increment changes to 2147483647 from 1. A quick google search said that number is = to myisam_max_sort_file_size.

My insert query looks like this.

PHP Code:

INSERT INTO issues (issue_date, volume, issue, church, active, current) VALUES ('".$issue_date."','".$_POST['issue']."','".$_POST['volume']."','".$_POST['church']."','".$_POST['active']."','".$_POST['current']."') 


I'm pretty sure there isn't anything wrong with the query and it's all in the MYSQL table.

Is that a table that once was filled and you deleted all the data? If so, the auto_increment value may still be set to the last increment number.

You can try to empty the table or reset the auto_increment number through phpMyAdmin or passing a query like: ALTER TABLE 'issues' AUTO_INCREMENT = 0

2147483647 is the largest positive number that can be stored in a signed integer field.

What it displays as may well depend on what you are viewing it in.

so is it a column type of signed integer?

I created a new table based on the same information and the problem still occurs. The auto increment table is set to INT.

signed or unsigned ?

viewing it in what ?

I'm viewing it in PHPMyAdmin so I do not know if it is signed or not

You can edit the field and you can set aqn option of unsigned. You can also edit the table in PHPmyAdmin to reset the AutoIncrement value. I think it's under operations or something.