MySQL Error ! Please HElP

Mc2

Verified User
Joined
Jun 4, 2006
Messages
16
MySQL: Too big precision 254 specified for column 'cbank'. Maximum is 65.



there is also another error
Error at the line 578: ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

i get that while trying to upload the a old database.
 
Last edited:
I believe the column is formatted for 65 characters and you are trying to put in 254 characters. I admittedly could be wrong on this. I am not a mysql expert.
 
MySQL: Too big precision 254 specified for column 'cbank'. Maximum is 65.
Is cbank a decimal field (column)?

You don't say which version of MySQL you're using, but begnning in MySQL 5.06 the maximum precision is 65.

For more information look here.

How did you backup? From what version of MySQL? How did you restore the backup? To what version of MySQL?

Jeff
 
Back
Top