mysql-errorexception:发送查询包时出错pid=6865

f3temu5u 于 2021-06-15 发布在 Mysql

关注(0)|答案(1)|浏览(398)

在laravel中创建表时出现以下错误-
表创建语法-

$sql = 'CREATE TABLE `temp_mobile_03b1effe4c12` (
  `id` bigint(20) unsigned NOT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `operator` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `circle` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `temp_mobile_03b1effe4c12_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci';

DB::connection()->getpdo()->exec($sql);

错误-

[2019-01-08 15:18:38] local.ERROR: ErrorException: Error while sending QUERY packet. PID=6865 in /var/www/html/listmanager/deploy/releases/20190107104605/app/Jobs/UpdateBulkListSubscribers.php:303
Stack trace:

# 0 [internal function]: Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(2, 'Error while sen...', '/var/www/html/l...', 303, Array)

# 1 /var/www/html/listmanager/deploy/releases/20190107104605/app/Jobs/UpdateBulkListSubscribers.php(303): PDO->exec('CREATE TABLE  t...')

# 2 /var/www/html/listmanager/deploy/releases/20190107104605/app/Jobs/UpdateBulkListSubscribers.php(264): App\Jobs\UpdateBulkListSubscribers::createTempTable('temp_mobile_00d...', Array, Array)

# 3 /var/www/html/listmanager/deploy/releases/20190107104605/app/Jobs/UpdateBulkListSubscribers.php(227): App\Jobs\UpdateBulkListSubscribers->updateMobileInfo()

mysql pdo laravel-5

来源：https://stackoverflow.com/questions/54089376/mysql-errorexception-error-while-sending-query-packet-pid-6865