SQLSTATE[HY000]: General error: 1364 Field 'shopping_cart_id' doesn't have a default value (SQL: insert into `orders` (`recipient_name`, `line1`, `city`, `state`, `postal_code`, `country_code`, `updated_at`, `created_at`) values (test buyer, 1 Main St, San Jose, CA, 95131, US, 2017-07-29 20:16:34, 2017-07-29 20:16:34))
-
check_circle_outlineMódulo 1 | 8 clases
Introducción
expand_more -
check_circle_outlineMódulo 2 | 7 clases
Primeros pasos y autenticación
expand_more -
check_circle_outlineMódulo 3 | 10 clases
Productos
expand_more -
check_circle_outlineMódulo 4 | 10 clases
Carrito de compras
expand_more -
check_circle_outlineMódulo 5 | 6 clases
Paypal
expand_more -
check_circle_outlineMódulo 6 | 9 clases
Manejo de órdenes
expand_more-
done_all
Clase 1
42.- Tabla de órdenes
-
done_all
Clase 2
43.- Guardar datos de la orden
-
done_all
Clase 3
44.- Mostrar datos de la orden
-
done_all
Clase 4
45.- Generar IDs no consecutivos
-
done_all
Clase 5
46.- Permalink de órdenes
-
done_all
Clase 6
47.- Mostrar órdenes del mes
-
done_all
Clase 7
48.- Datos de ventas
-
done_all
Clase 8
49.- Actualización con x-editable
-
done_all
Clase 9
50.- Actualización y CsrfToken
-
-
check_circle_outlineMódulo 7 | 3 clases
Middlewares
expand_more -
check_circle_outlineMódulo 8 | 6 clases
Correos electrónicos
expand_more -
check_circle_outlineMódulo 9 | 7 clases
Mejoras a la tienda
expand_more -
check_circle_outlineMódulo 10 | 6 clases
Deploy hosting cloud
expand_more -
check_circle_outlineMódulo 11 | 4 clases
Deploy hosting compartido
expand_more -
check_circle_outlineMódulo 12 | 3 clases
Paypal producción
expand_more
12 comentario(s)
(2/2) QueryException
SQLSTATE[HY000]: General error: 1364 Field 'shopping_cart_id' doesn't have a default value (SQL: insert into `orders` (`recipient_name`, `line1`, `city`, `state`, `postal_code`, `country_code`, `updated_at`, `created_at`) values (test buyer, 1 Main St, San Jose, CA, 95131, US, 2017-07-29 20:16:34, 2017-07-29 20:16:34))
PayPalConnectionException {#222 ▼ -url: "https://api.sandbox.paypal.com/v1/payments/payment" -data: "{"name":"VALIDATION_ERROR","details":[{"field":"transactions[0]","issue":"Item amount must add up to specified amount subtotal (or total if amount details not s ▶" #message: "Got Http response code 400 when accessing https://api.sandbox.paypal.com/v1/payments/payment." #code: 400 #file: "/opt/lampp/htdocs/ecommerce4/vendor/paypal/rest-api-sdk-php/lib/PayPal/Core/PayPalHttpConnection.php" #line: 154 trace: {▼ /opt/lampp/htdocs/ecommerce4/vendor/paypal/rest-api-sdk-php/lib/PayPal/Core/PayPalHttpConnection.php:154: {▶} /opt/lampp/htdocs/ecommerce4/vendor/paypal/rest-api-sdk-php/lib/PayPal/Transport/PayPalRestCall.php:73: {▶} /opt/lampp/htdocs/ecommerce4/vendor/paypal/rest-api-sdk-php/lib/PayPal/Common/PayPalResourceModel.php:102: {▶} /opt/lampp/htdocs/ecommerce4/vendor/paypal/rest-api-sdk-php/lib/PayPal/Api/Payment.php:562: {▶} /opt/lampp/htdocs/ecommerce4/app/PayPal.php:31: {▶} /opt/lampp/htdocs/ecommerce4/app/Http/Controllers/ShoppingCartsController.php:19: {▶} App\Http\Controllers\ShoppingCartsController->index(): {} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:55: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:44: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Route.php:203: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Route.php:160: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Router.php:574: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:65: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:59: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Router.php:576: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Router.php:535: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Router.php:513: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:46: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:148: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151: {▶} /opt/lampp/htdocs/ecommerce4/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116: {▶} /opt/lampp/htdocs/ecommerce4/public/index.php:53: {▶} } }
El problema lo causa $orderData = $orderData[key($orderData)];
El coddigo tiene que ser asi:
El coddigo tiene que ser asi:
$payer = $response->payer; $orderData = (array) $payer->payer_info->shipping_address; $orderData = $orderData[key($orderData)]; $orderData["email"] = $payer->payer_info->email; $orderData["total"] = $shopping_cart->total(); $orderData["shopping_cart_id"] = $shopping_cart->id;
return Order::create($orderData);
SQLSTATE [HY000]: Error general: 'shopping_cart_id' 1364 El campo no tiene un valor predeterminado (SQL: insertar en `orders` (` recipient_name`, `line1`,` ciudad `` state`, `postal_code`,` country_code`, `updated_at`, valores)` created_at` (Lautaro Bustos, 1 Main St, San Jose, CA, 95131, EE.UU., 04/06/2017 00:06:23 , 04/06/2017 00:06:23))
Me tira error Undefined index en Order.php en la línea 20:
$orderData = $orderData[ key($orderData) ];
$orderData = $orderData[ key($orderData) ];
PayPalConnectionException in PayPalHttpConnection.php line 176:
Got Http response code 400 when accessing https://api.sandbox.paypal.com/v1/payments/payment/PAY-32V265336U555393KLATYBMA/execute.
QueryException in Connection.php line 764:
SQLSTATE[HY000]: General error: 1364 Field 'line2' doesn't have a default value (SQL: insert into `orders` (`recipient_name`, `line1`, `city`, `state`, `postal_code`, `country_code`, `email`, `total`, `shopping_cart_id`, `updated_at`, `created_at`) values (Osmar Perez, 1 Main St, San Jose, CA, 95131, US, compradorcodigo.com, 900.00, 6, 2016-10-27 01:55:22, 2016-10-27 01:55:22))
ErrorException in Model.php line 2697:
Relationship method must return an object of type Illuminate\Database\Eloquent\Relations\Relation (View: C:\xampp\htdocs\ecommerce\resources\views\shopping_carts\completed.blade.php)
protected $fillable = ['recipient_name', 'line1', 'line2', 'city', 'country_code', 'state', 'postal_code', 'email', 'shopping_cart_id', 'status', 'total', 'guide_number']
Clase 43