Help!! Can't get DB to work with install of PS4.5

Hi,
I am trying to use the installation wizard to set up PS4.5. When I type in the data base information, I get the error:
ERROR: Database could not be created.

Out of range value for column 'RateWeight' at row 1
What does this mean and how can I fix it?

I am using an Apache/MySql localhost set up.

Thanks,
~Vonnie

in the install/scripts/db.sql (or upgrade sql you are using), update the line that reads:

INSERT INTO `ps4_shippingrates` VALUES ('1', '1', '1000000000.00', '0.00');

to:

INSERT INTO `ps4_shippingrates` VALUES ('1', '1', '1000000.00', '0.00');

Originally Said By: Jason Byrnes

  in the install/scripts/db.sql (or upgrade sql you are using), update the line that reads:

INSERT INTO `ps4_shippingrates` VALUES ('1', '1', '1000000000.00', '0.00');

to:

INSERT INTO `ps4_shippingrates` VALUES ('1', '1', '1000000.00', '0.00');

  

Changed code as suggested and got a new error!!
ERROR: Database could not be created.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `ps4_categories` ( `CategoryID` int(11) NOT NUL' at line 1
~Giovonnae

send a copy of your sql script please.

Hi
I sent a reply about an hour ago, but it looks like it didn't post. I am attaching a copyof the db.sql file.
I don't think that the script is the problem. I was able to use the script to build the tables in the data base without getting any MySql errors. Is there any way that I can skip that part of the install wizard, or maybe the entire wizard, and get this program running? I really want to have some time to play with the application!
Thanks,
~Giovonnae

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Having exactly the same sequence of problems.
Have a support ticket going so I hope we can get it fixed.
It is a pitty you did not post the results of the above case in full.