SQLSTATE

Uber clone for Web
zohir
Posts: 4
Joined: Wed Sep 16, 2015 9:57 am

SQLSTATE

Postby zohir » Wed Sep 16, 2015 10:05 am

after installation when i login admin:

Illuminate \ Database \ QueryException (42S22)

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'request.promo_payment' in 'field list' (SQL: select `request`.`request_start_time`, `walker_type`.`name` as `type`, `request`.`ledger_payment`, `request`.`card_payment`, `owner`.`first_name` as `owner_first_name`, `owner`.`last_name` as `owner_last_name`, `walker`.`first_name` as `walker_first_name`, `walker`.`last_name` as `walker_last_name`, `owner`.`id` as `owner_id`, `walker`.`id` as `walker_id`, `request`.`id` as `id`, `request`.`created_at` as `date`, `request`.`is_started`, `request`.`is_walker_arrived`, `request`.`payment_mode`, `request`.`is_completed`, `request`.`is_paid`, `request`.`is_walker_started`, `request`.`confirmed_walker`, `request`.`status`, `request`.`time`, `request`.`distance`, `request`.`total`, `request`.`is_cancelled`, `request`.`promo_payment` from `request` left join `owner` on `request`.`owner_id` = `owner`.`id` left join `walker` on `request`.`confirmed_walker` = `walker`.`id` left join `walker_type` on `walker`.`type` = `walker_type`.`id` where (`request`.`is_completed` = 1 or `request`.`is_cancelled` = 1) order by `id` desc limit 10 offset 0)

how to resolve please

Divyang Metaliya
Posts: 130
Joined: Mon Sep 21, 2015 6:15 am

Re: SQLSTATE

Postby Divyang Metaliya » Mon Sep 21, 2015 11:37 am

For this error solution you make A migration for that installation ...
using
- Populate the database by running migrations:
php artisan migrate

OR
I added uberforx.sql file link : https://www.dropbox.com/s/ozltnrewa4gx1 ... x.sql?dl=0

you can download and import this Database file and app worked 100%.

if you get any issue while installing let me know
Thanks...

zohir
Posts: 4
Joined: Wed Sep 16, 2015 9:57 am

Re: SQLSTATE

Postby zohir » Tue Sep 22, 2015 10:04 pm

thank you very much

so great

bermiento
Posts: 2
Joined: Thu Oct 22, 2015 7:25 pm

Re: SQLSTATE

Postby bermiento » Thu Nov 19, 2015 3:49 am

I have the same problem, could you explain more details about how you solve it?
thanks in advance

Divyang Metaliya
Posts: 130
Joined: Mon Sep 21, 2015 6:15 am

Re: SQLSTATE

Postby Divyang Metaliya » Mon Nov 30, 2015 11:39 am

Hello,

For this error solution,

add only request table from this database..
---------------------------------------------------------------
https://www.dropbox.com/s/ozltnrewa4gx1 ... x.sql?dl=0

this is a perfect solution for this error...

Thanks...

mrandall101
Posts: 4
Joined: Thu Jan 07, 2016 7:19 pm

Re: SQLSTATE

Postby mrandall101 » Mon Mar 07, 2016 2:15 am

I have this same problem. Anyone got the solution. Looks like the dropbox link has expired. Thanks in advance.

Divyang Metaliya
Posts: 130
Joined: Mon Sep 21, 2015 6:15 am

Re: SQLSTATE

Postby Divyang Metaliya » Wed Mar 23, 2016 10:52 am

hello,

For this error solution ,

you need to migrate the database using bellow command
=================
1.php artisan migrate
2.php artisan db:seed

OR
you can fire this query on your phpmyadmin database's SQL
--
-- Table structure for table `request`
--

CREATE TABLE IF NOT EXISTS `request` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`owner_id` int(10) unsigned NOT NULL,
`status` int(11) NOT NULL,
`confirmed_walker` int(11) NOT NULL,
`current_walker` int(11) NOT NULL,
`request_start_time` datetime NOT NULL,
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`is_walker_started` int(11) NOT NULL,
`is_walker_arrived` int(11) NOT NULL,
`is_started` int(11) NOT NULL,
`is_completed` int(11) NOT NULL,
`is_dog_rated` int(11) NOT NULL,
`is_walker_rated` int(11) NOT NULL,
`distance` float(8,2) NOT NULL,
`time` float(8,2) NOT NULL,
`total` float(8,2) NOT NULL,
`is_paid` int(11) NOT NULL,
`card_payment` float(8,2) NOT NULL,
`ledger_payment` float(8,2) NOT NULL,
`is_cancelled` int(11) NOT NULL,
`refund` float(8,2) NOT NULL DEFAULT '0.00',
`transfer_amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`later` tinyint(1) NOT NULL DEFAULT '0',
`D_latitude` double(15,8) NOT NULL DEFAULT '0.00000000',
`D_longitude` double(15,8) NOT NULL DEFAULT '0.00000000',
`security_key` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
`payment_mode` int(11) NOT NULL DEFAULT '0',
`payment_id` text COLLATE utf8_unicode_ci,
`promo_payment` float(8,2) NOT NULL DEFAULT '0.00',
`promo_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`promo_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `request_owner_id_foreign` (`owner_id`),
KEY `request_is_walker_started_index` (`is_walker_started`),
KEY `request_is_walker_arrived_index` (`is_walker_arrived`),
KEY `request_is_started_index` (`is_started`),
KEY `request_is_completed_index` (`is_completed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;




Thanks...


Return to “UberX for Web”

Who is online

Users browsing this forum: No registered users and 1 guest