[2023-10-12 08:31:56] local.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dev2mindz_mybizzhive.booking_payments' doesn't exist (SQL: CREATE VIEW combinedAppointmentAndBoookingView AS (SELECT bookings.id,'booking' as type, bookings.name,bookings.contact_id,null as lead_id, bookings.service_type_id, bookings.event_type, bookings.virtual_event, bookings.meeting_id, bookings.passcode, bookings.amount, bookings.received_amount, bookings.start_date,null as end_date, bookings.duration, bookings.location, bookings.lat_long, bookings.source_type_id, bookings.referred_by, bookings.website, bookings.detail,bookings.created_by,quotes.id as quote_id,quotes.quote_serial_no,quotes.quote_status_type_id,GROUP_CONCAT(DISTINCT invoices.invoice_serial_no SEPARATOR ',') AS invoice_serial_nos ,contacts.first_name,contacts.last_name,contacts.phone_type,contacts.phone,contacts.email,contacts.organization,contacts.title,contacts.first_name_information as more_information,service_types.name as service_type_name ,sum(booking_payments.payment_amount) as booking_invoice_payment_total,bookings.created_at FROM bookings left join quotes on bookings.quote_id=quotes.id join contacts on bookings.contact_id=contacts.id join service_types on bookings.service_type_id=service_types.id left join booking_payments on bookings.id=booking_payments.booking_id left join invoices on bookings.id=invoices.booking_id group by bookings.id) UNION ALL (SELECT appointments.id,'appointment' as type, appointments.name, appointments.contact_id, appointments.lead_id, null as service_type_id, null as event_type, appointments.virtual_event, appointments.meeting_id, appointments.passcode,null as amount,null as received_amount, appointments.start_date, appointments.end_date,null as duration, appointments.location, appointments.lat_long,null as source_type_id,null as referred_by,null as website, appointments.detail ,appointments.created_by,null as quote_id,null as quote_serial_no,null as quote_status_type_id,null as invoice_serial_nos,contacts.first_name,contacts.last_name,contacts.phone_type,contacts.phone,contacts.email,contacts.organization,contacts.title,contacts.first_name_information as more_information,null as service_type_name ,null as booking_invoice_payment_total,appointments.created_at FROM appointments join contacts on appointments.contact_id=contacts.id ) ) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dev2mindz_mybizzhive.booking_payments' doesn't exist (SQL: CREATE VIEW combinedAppointmentAndBoookingView AS (SELECT bookings.id,'booking' as type, bookings.name,bookings.contact_id,null as lead_id, bookings.service_type_id, bookings.event_type, bookings.virtual_event, bookings.meeting_id, bookings.passcode, bookings.amount, bookings.received_amount, bookings.start_date,null as end_date, bookings.duration, bookings.location, bookings.lat_long, bookings.source_type_id, bookings.referred_by, bookings.website, bookings.detail,bookings.created_by,quotes.id as quote_id,quotes.quote_serial_no,quotes.quote_status_type_id,GROUP_CONCAT(DISTINCT invoices.invoice_serial_no SEPARATOR ',') AS invoice_serial_nos ,contacts.first_name,contacts.last_name,contacts.phone_type,contacts.phone,contacts.email,contacts.organization,contacts.title,contacts.first_name_information as more_information,service_types.name as service_type_name ,sum(booking_payments.payment_amount) as booking_invoice_payment_total,bookings.created_at FROM bookings left join quotes on bookings.quote_id=quotes.id join contacts on bookings.contact_id=contacts.id join service_types on bookings.service_type_id=service_types.id left join booking_payments on bookings.id=booking_payments.booking_id left join invoices on bookings.id=invoices.booking_id group by bookings.id) UNION ALL (SELECT appointments.id,'appointment' as type, appointments.name, appointments.contact_id, appointments.lead_id, null as service_type_id, null as event_type, appointments.virtual_event, appointments.meeting_id, appointments.passcode,null as amount,null as received_amount, appointments.start_date, appointments.end_date,null as duration, appointments.location, appointments.lat_long,null as source_type_id,null as referred_by,null as website, appointments.detail ,appointments.created_by,null as quote_id,null as quote_serial_no,null as quote_status_type_id,null as invoice_serial_nos,contacts.first_name,contacts.last_name,contacts.phone_type,contacts.phone,contacts.email,contacts.organization,contacts.title,contacts.first_name_information as more_information,null as service_type_name ,null as booking_invoice_payment_total,appointments.created_at FROM appointments join contacts on appointments.contact_id=contacts.id ) ) at /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671) [stacktrace] #0 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('CREATE VIEW com...', Array, Object(Closure)) #1 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\\Database\\Connection->run('CREATE VIEW com...', Array, Object(Closure)) #2 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(367): Illuminate\\Database\\Connection->statement('CREATE VIEW com...') #3 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('statement', Array) #4 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/database/migrations/2021_11_26_034859_create_combine_appointment_booking_view.php(18): Illuminate\\Support\\Facades\\Facade::__callStatic('statement', Array) #5 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(392): CreateCombineAppointmentBookingView->up() #6 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(401): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}() #7 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(200): Illuminate\\Database\\Migrations\\Migrator->runMigration(Object(CreateCombineAppointmentBookingView), 'up') #8 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(165): Illuminate\\Database\\Migrations\\Migrator->runUp('/home/dev2mindz...', 1, false) #9 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(110): Illuminate\\Database\\Migrations\\Migrator->runPending(Array, Array) #10 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(72): Illuminate\\Database\\Migrations\\Migrator->run(Array, Array) #11 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(541): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}() #12 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(81): Illuminate\\Database\\Migrations\\Migrator->usingConnection(NULL, Object(Closure)) #13 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle() #14 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #15 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #16 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #17 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/Container.php(596): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #18 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\\Container\\Container->call(Array) #19 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #20 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #21 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(1005): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #22 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(299): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #23 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #24 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #25 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #26 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #27 {main} [previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dev2mindz_mybizzhive.booking_payments' doesn't exist at /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458) [stacktrace] #0 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(458): PDO->prepare('CREATE VIEW com...') #1 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('CREATE VIEW com...', Array) #2 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('CREATE VIEW com...', Array, Object(Closure)) #3 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\\Database\\Connection->run('CREATE VIEW com...', Array, Object(Closure)) #4 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(367): Illuminate\\Database\\Connection->statement('CREATE VIEW com...') #5 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('statement', Array) #6 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/database/migrations/2021_11_26_034859_create_combine_appointment_booking_view.php(18): Illuminate\\Support\\Facades\\Facade::__callStatic('statement', Array) #7 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(392): CreateCombineAppointmentBookingView->up() #8 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(401): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}() #9 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(200): Illuminate\\Database\\Migrations\\Migrator->runMigration(Object(CreateCombineAppointmentBookingView), 'up') #10 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(165): Illuminate\\Database\\Migrations\\Migrator->runUp('/home/dev2mindz...', 1, false) #11 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(110): Illuminate\\Database\\Migrations\\Migrator->runPending(Array, Array) #12 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(72): Illuminate\\Database\\Migrations\\Migrator->run(Array, Array) #13 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(541): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}() #14 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(81): Illuminate\\Database\\Migrations\\Migrator->usingConnection(NULL, Object(Closure)) #15 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle() #16 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #17 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #18 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #19 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/Container.php(596): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #20 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\\Container\\Container->call(Array) #21 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #22 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #23 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(1005): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #24 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(299): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #25 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #26 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #27 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #28 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #29 {main} "} [2023-10-12 08:32:33] local.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dev2mindz_mybizzhive.booking_payments' doesn't exist (SQL: CREATE VIEW combinedAppointmentAndBoookingView AS (SELECT bookings.id,'booking' as type, bookings.name,bookings.contact_id,null as lead_id, bookings.service_type_id, bookings.event_type, bookings.virtual_event, bookings.meeting_id, bookings.passcode, bookings.amount, bookings.received_amount, bookings.start_date,null as end_date, bookings.duration, bookings.location, bookings.lat_long, bookings.source_type_id, bookings.referred_by, bookings.website, bookings.detail,bookings.created_by,quotes.id as quote_id,quotes.quote_serial_no,quotes.quote_status_type_id,GROUP_CONCAT(DISTINCT invoices.invoice_serial_no SEPARATOR ',') AS invoice_serial_nos ,contacts.first_name,contacts.last_name,contacts.phone_type,contacts.phone,contacts.email,contacts.organization,contacts.title,contacts.first_name_information as more_information,service_types.name as service_type_name ,sum(booking_payments.payment_amount) as booking_invoice_payment_total,bookings.created_at FROM bookings left join quotes on bookings.quote_id=quotes.id join contacts on bookings.contact_id=contacts.id join service_types on bookings.service_type_id=service_types.id left join booking_payments on bookings.id=booking_payments.booking_id left join invoices on bookings.id=invoices.booking_id group by bookings.id) UNION ALL (SELECT appointments.id,'appointment' as type, appointments.name, appointments.contact_id, appointments.lead_id, null as service_type_id, null as event_type, appointments.virtual_event, appointments.meeting_id, appointments.passcode,null as amount,null as received_amount, appointments.start_date, appointments.end_date,null as duration, appointments.location, appointments.lat_long,null as source_type_id,null as referred_by,null as website, appointments.detail ,appointments.created_by,null as quote_id,null as quote_serial_no,null as quote_status_type_id,null as invoice_serial_nos,contacts.first_name,contacts.last_name,contacts.phone_type,contacts.phone,contacts.email,contacts.organization,contacts.title,contacts.first_name_information as more_information,null as service_type_name ,null as booking_invoice_payment_total,appointments.created_at FROM appointments join contacts on appointments.contact_id=contacts.id ) ) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dev2mindz_mybizzhive.booking_payments' doesn't exist (SQL: CREATE VIEW combinedAppointmentAndBoookingView AS (SELECT bookings.id,'booking' as type, bookings.name,bookings.contact_id,null as lead_id, bookings.service_type_id, bookings.event_type, bookings.virtual_event, bookings.meeting_id, bookings.passcode, bookings.amount, bookings.received_amount, bookings.start_date,null as end_date, bookings.duration, bookings.location, bookings.lat_long, bookings.source_type_id, bookings.referred_by, bookings.website, bookings.detail,bookings.created_by,quotes.id as quote_id,quotes.quote_serial_no,quotes.quote_status_type_id,GROUP_CONCAT(DISTINCT invoices.invoice_serial_no SEPARATOR ',') AS invoice_serial_nos ,contacts.first_name,contacts.last_name,contacts.phone_type,contacts.phone,contacts.email,contacts.organization,contacts.title,contacts.first_name_information as more_information,service_types.name as service_type_name ,sum(booking_payments.payment_amount) as booking_invoice_payment_total,bookings.created_at FROM bookings left join quotes on bookings.quote_id=quotes.id join contacts on bookings.contact_id=contacts.id join service_types on bookings.service_type_id=service_types.id left join booking_payments on bookings.id=booking_payments.booking_id left join invoices on bookings.id=invoices.booking_id group by bookings.id) UNION ALL (SELECT appointments.id,'appointment' as type, appointments.name, appointments.contact_id, appointments.lead_id, null as service_type_id, null as event_type, appointments.virtual_event, appointments.meeting_id, appointments.passcode,null as amount,null as received_amount, appointments.start_date, appointments.end_date,null as duration, appointments.location, appointments.lat_long,null as source_type_id,null as referred_by,null as website, appointments.detail ,appointments.created_by,null as quote_id,null as quote_serial_no,null as quote_status_type_id,null as invoice_serial_nos,contacts.first_name,contacts.last_name,contacts.phone_type,contacts.phone,contacts.email,contacts.organization,contacts.title,contacts.first_name_information as more_information,null as service_type_name ,null as booking_invoice_payment_total,appointments.created_at FROM appointments join contacts on appointments.contact_id=contacts.id ) ) at /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671) [stacktrace] #0 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('CREATE VIEW com...', Array, Object(Closure)) #1 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\\Database\\Connection->run('CREATE VIEW com...', Array, Object(Closure)) #2 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(367): Illuminate\\Database\\Connection->statement('CREATE VIEW com...') #3 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('statement', Array) #4 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/database/migrations/2021_11_26_034859_create_combine_appointment_booking_view.php(18): Illuminate\\Support\\Facades\\Facade::__callStatic('statement', Array) #5 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(392): CreateCombineAppointmentBookingView->up() #6 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(401): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}() #7 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(200): Illuminate\\Database\\Migrations\\Migrator->runMigration(Object(CreateCombineAppointmentBookingView), 'up') #8 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(165): Illuminate\\Database\\Migrations\\Migrator->runUp('/home/dev2mindz...', 2, false) #9 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(110): Illuminate\\Database\\Migrations\\Migrator->runPending(Array, Array) #10 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(72): Illuminate\\Database\\Migrations\\Migrator->run(Array, Array) #11 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(541): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}() #12 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(81): Illuminate\\Database\\Migrations\\Migrator->usingConnection(NULL, Object(Closure)) #13 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle() #14 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #15 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #16 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #17 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/Container.php(596): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #18 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\\Container\\Container->call(Array) #19 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #20 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #21 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(1005): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #22 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(299): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #23 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #24 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #25 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #26 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #27 {main} [previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dev2mindz_mybizzhive.booking_payments' doesn't exist at /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458) [stacktrace] #0 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(458): PDO->prepare('CREATE VIEW com...') #1 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('CREATE VIEW com...', Array) #2 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('CREATE VIEW com...', Array, Object(Closure)) #3 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\\Database\\Connection->run('CREATE VIEW com...', Array, Object(Closure)) #4 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(367): Illuminate\\Database\\Connection->statement('CREATE VIEW com...') #5 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('statement', Array) #6 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/database/migrations/2021_11_26_034859_create_combine_appointment_booking_view.php(18): Illuminate\\Support\\Facades\\Facade::__callStatic('statement', Array) #7 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(392): CreateCombineAppointmentBookingView->up() #8 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(401): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}() #9 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(200): Illuminate\\Database\\Migrations\\Migrator->runMigration(Object(CreateCombineAppointmentBookingView), 'up') #10 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(165): Illuminate\\Database\\Migrations\\Migrator->runUp('/home/dev2mindz...', 2, false) #11 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(110): Illuminate\\Database\\Migrations\\Migrator->runPending(Array, Array) #12 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(72): Illuminate\\Database\\Migrations\\Migrator->run(Array, Array) #13 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(541): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}() #14 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(81): Illuminate\\Database\\Migrations\\Migrator->usingConnection(NULL, Object(Closure)) #15 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle() #16 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #17 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #18 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure)) #19 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Container/Container.php(596): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL) #20 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\\Container\\Container->call(Array) #21 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #22 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle)) #23 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(1005): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #24 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(299): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #25 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #26 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #27 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #28 /home/dev2mindz/public_html/laravel/mybizzhive_websevices_aditya/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput)) #29 {main} "}