mystycs Posted July 11, 2007 Share Posted July 11, 2007 I have mysql on one of my dedi servers and i got this problem When i upload my database on PHPmyAdmin i get this error #1426 - Too big precision 253 specified for column 'baseprice'. Maximum is 65. How do i make the maximum more? And what file do i edit? thanks Link to comment Share on other sites More sharing options...
qwidjib0 Posted July 13, 2007 Share Posted July 13, 2007 I would dump the database and take a look at the Create statement for the table 'baseprice'. Generally you define the constraints on your MySQL table with the MySQL statement that creates it. Link to comment Share on other sites More sharing options...
adamnp Posted July 14, 2007 Share Posted July 14, 2007 Error: 1426 SQLSTATE: 42000 (ER_TOO_BIG_PRECISION) Message: Too big precision %d specified for column '%s'. Maximum is %d. -- I would do the same as qwid said, use EditPadPro to edit the SQL if its Large, then you should find the create entry for baseprice and change the entry of 65 to higher than 253, save, and try to re-import it. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.