search

besSejrani / MA-08-Ecommerce

Ecommerce database schema design
0 stars 0 forks source link

Fill Database #5

Open fandolfatto opened 3 years ago

fandolfatto commented 3 years ago
fandolfatto commented 3 years ago

"Conversion failed when converting date and/or time from character string." quand insertion dans table "pages". null et non 'null' pour updated_at.

fandolfatto commented 3 years ago

Pour la latitude et longitude : A .NET Framework error occurred during execution of user-defined routine or aggregate "geography": System.FormatException: 24114 : l'étiquette 37.7493 de l'entrée WKT (well-known text) n'est pas valide. Les étiquettes valides sont POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION, CIRCULARSTRING, COMPOUNDCURVE, CURVEPOLYGON et FULLGLOBE (geography Data Type only).

fandolfatto commented 3 years ago

insert into users (username, firstname, lastname, email, password, url_profile, address, city, zip) VALUES('Michale_Thompson', 'Kelvin', 'Casper', 'Callie95@hotmail.com','29RqfHVNRt8oqNh', 'http://placeimg.com/640/480/people', '2840 Tamia Manor', 'New Noemyhaven', '40694-7773') provoque l'erreur Conversion failed when converting the varchar value '40694-7773' to data type int.

fandolfatto commented 3 years ago

Insertion dans carts provoque une erreur : Conversion failed when converting date and/or time from character string.

fandolfatto commented 3 years ago

Insertion dans discounts provoque une erreur : Conversion failed when converting date and/or time from character string.

fandolfatto commented 3 years ago

Insertion dans products provoque une erreur : Conversion failed when converting date and/or time from character string.