MySql Question

Portal Home > Knowledgebase > Articles Database > MySql Question

Posted by mystycs, 07-10-2007, 12:57 AM
When i upload my database on PHPmyAdmin i get this error How do i make the maximum more? And what file do i edit? thanks
Posted by walterwoj, 07-10-2007, 01:09 AM
Is it a float, int, char or varchar? The answer is different for each one and the limits are different for each one.
Posted by mystycs, 07-10-2007, 01:12 AM
here is the whole thing i receive in phpmyadmin when i try to upload it.
Posted by mystycs, 07-10-2007, 06:03 AM
Anyone know? kinda need it now
Posted by serverhelpers, 07-10-2007, 07:32 AM
Hello, Which version of MySQL are you using ? Also try creating that table independently and then try to insert records into it. You can create table independently from phpmyadmin by selecting database in which you want that table to be created and then click on SQL tab, then paste table creation query, it should create table successfully once table is ceated try inserting all rows related to that table, it should be imported successfully, if any of yur row has bad data then it will immediately abort insertion by pointing out which row caused issue. So you can correct problem with that row or skip it and then insert all other rows. Hope this helps.
Posted by mystycs, 07-10-2007, 07:55 AM
Yah but isnt there a way to change some settings in some cfg file that i can change to make it more than 65 I am using the newest mysql on windows
Posted by mystycs, 07-10-2007, 09:45 AM
anyone have an idea?
Posted by d0m1nat10n, 07-10-2007, 01:16 PM
good luck
Posted by walterwoj, 07-10-2007, 01:34 PM
Change 'decimal' to 'float' and that hould solve your problem.
Posted by mystycs, 07-10-2007, 01:37 PM
Where do i change that. In the .sql file?
Posted by walterwoj, 07-10-2007, 02:58 PM
Yes. In the sql file. Open the file with notepad and change the words then run it again.
Posted by mystycs, 07-10-2007, 08:46 PM
alrighty ill try that
Posted by mystycs, 07-10-2007, 11:23 PM
Is there still a way to make it so Decimal has a bigger value?
Posted by foobic, 07-11-2007, 12:01 AM
The manual says... No. Do you really need 50+ digit accuracy to calculate a price?
Posted by mystycs, 07-11-2007, 12:10 AM
Well so your saying to just put it to 65? because its to great of a number to calculate anyway?
Posted by foobic, 07-11-2007, 12:24 AM
According to that quote what you had before was about 15 digit precision (1c in $1,000,000,000,000.00). To maintain that you could use M=15 (65 seems a bit like overkill)
Posted by MaximSupport, 07-11-2007, 12:42 AM
Dear mystycs, You need to use this. CREATE TABLE `nuke_hosting_order` ( `id` int( 255 ) unsigned NOT NULL AUTO_INCREMENT , `cat_id` int( 255 ) unsigned NOT NULL default '0', `name` text NOT NULL , `description` text NOT NULL , `status` tinyint( 1 ) NOT NULL default '0', `baseprice` decimal( 65, 2 ) NOT NULL default '0.00', PRIMARY KEY ( `id` ) , KEY `status` ( `status` ) ) TYPE = MYISAM ; FYI, http://forge.mysql.com/wiki/MySQL_Internals_MyISAM and http://dev.mysql.com/doc/refman/5.0/...anges.htmlBest Regards.
Posted by mystycs, 07-11-2007, 12:44 AM
I got the database working perfectly now. But Well im my last webhjosting this worked perfectly shown here http://aow.branzone.com/modules.php?name=Accounting But here on my new box it looks like this and i dont know how to fix it http://assassinsofwar.net/modules.php?name=Accounting
Posted by mystycs, 07-14-2007, 10:20 PM
So how do i still change it so #1426 - Too big precision 253 specified for column 'baseprice'. Maximum is 65. Is not maximum 65 please someone let me know
Posted by walterwoj, 07-14-2007, 10:36 PM
That is not a mysql error. your server is not parsing the PHP. It would appear that your site does not support php. That is why your page don't work.
Posted by mystycs, 07-14-2007, 10:38 PM
Oh ok well php works on my site think its something within php? http://www.assassinsofwar.net/modules.php?name=Order
Posted by foobic, 07-15-2007, 02:18 AM
http://www.webhostingtalk.com/showthread.php?t=617661
Posted by mystycs, 07-15-2007, 05:53 AM
Oh my god thank you so much, works like a charm now