WebsiteBaker Support (2.8.x) > Bakery Shop

Fatal error: Call to a member function numRows() on a non-object in

<< < (5/5)

jacobi22:

--- Quote ---There is no comma or point in 9999999
--- End quote ---
not in the installer, but then in the database after the install :wink:

dbs:
funny, in my DB is 999.00 (not 999.99)   :-D

I don't understand the technical crap like "google" or "decimal digits".
The result of our investigations is what?
Remove 2 digits from the installer?

jacobi22:

--- Quote ---The result of our investigations is what?
Remove 2 digits from the installer?
--- End quote ---

best solution ( i think)
 set the default in the installer to 99999.99  // actual value is 9999999 - no with a decimal point
the exact line 173 in the bakery- install.php

--- Code: ---. "`free_shipping` DECIMAL(7,2) NOT NULL DEFAULT '99999.99' ,"
--- End code ---

p.s. i test other solutions with a DEFAULT = 0 in the Installer and a Update later in the script, but it gives problems, if somebody need the value 0 in this setting (for free shipping every time)

dbs:
Don't understand.
0 or 0.00 is a value, right? How can this make trouble?

jacobi22:
the code say's: the value (for freeshipping) can have only and maximal 7 digits in the sum of the left and the right part from the dezimal point, the script say's also: the value has 2 digits on the right side

the DEFAULT in the install.php-script says:  use 9999999 AND 2 Digits after the point, in the sum 9 digits
for a correct mysql-code the default value is too long or is missing a decimal point (see marmot's posting)

if you have a error in the CREATE code, the script will not install this table - thats the problem

(Nachtrag): if you set a smaller value in the installer, which is in the sum of the total digits smaller then 7 and if you have no decimal point in your default value (only 999), the CREATE function use 0 for the digits after the decimal point, thats way you have 999.00 in your database entry if you use 999 as DEFAULT value

remember: this value for free shipping is a price , so you need the 2 digits after the decimal point

if you change the standard value later in your setting, the bakery script will change a simple 0 to a correct value with 2 digits after the decimal point (the price format)
the author will set a high standard value for the free shipping. if you work with zero as standard and nobody change this in the setting, every thing goes out with free shipping  :roll:

Navigation

[0] Message Index

[*] Previous page