Плагин "Дата доставки" - поддержка молчит уже два дня Не принято
Добрый день!
При попытке выставить дату доставки через бекенд в заказе сделанном через Плагин "купить в один клик" получается вот что:
В заказах, где клиент сам указывал дату доставки - все ок - можно менять.
Помогите, кто понимает, пожалуйста!
Query: INSERT INTO shop_sod_date
(`date`, `start_hour`, `end_hour`, `ok`, `order_id`) VALUES ('2016-08-01', 8, 24, 0, xxxxx6)
Error: 1364
Message: Field 'user_date' doesn't have a default value <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal;mso-outline-level:3">Error with code 1364 in '/var/www/shop/data/www/.ru/wa-system/database/waModel.class.php' around line 251: <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 246 (isset($row['class']) ? $row['class'] : ''). <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 247 (isset($row['type']) ? $row['type'] : ''). <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 248 $row['function']."()\n"; <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 249 } <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 250 waLog::log($error."\nStack:\n".$stack, 'db.log'); <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> >>251 throw new waDbException($error, $this->adapter->errorCode()); <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 252 } <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 253 <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 254 return $result; <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 255 } <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 256 <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal;mso-outline-level:2">Call stack <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#0 /var/www/shop/data/www/.ru/wa-system/database/waModel.class.php(352): waModel->run('INSERT INTO sh...') <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#1 /var/www/shop/data/www/.ru/wa-system/database/waModel.class.php(574): waModel->query('INSERT INTO sh...') <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#2 /var/www/shop/data/www/.ru/wa-apps/shop/plugins/sod/lib/model/shopSodPluginDate.model.php(29): waModel->insert(Array) <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#3 /var/www/shop/data/www/.ru/wa-apps/shop/plugins/sod/lib/actions/shopSodPluginSetDate.controller.php(60): shopSodPluginDateModel->saveByOrderID(Array, 'xxxxxx6') <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#4 /var/www/shop/data/www/.ru/wa-system/controller/waController.class.php(21): shopSodPluginSetDateController->execute() <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#5 /var/www/shop/data/www/.ru/wa-system/controller/waJsonController.class.php(28): waController->run(NULL) <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#6 /var/www/shop/data/www/.ru/wa-system/controller/waFrontController.class.php(139): waJsonController->run() <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#7 /var/www/shop/data/www/.ru/wa-system/controller/waFrontController.class.php(55): waFrontController->execute('sod', 'setDate', NULL) <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#8 /var/www/shop/data/www/.ru/wa-system/waSystem.class.php(600): waFrontController->dispatch() <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#9 /var/www/shop/data/www/.ru/index.php(7): waSystem->dispatch() <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">#10 {main} <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal;mso-outline-level:2">Request <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">array ( <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 'plugin' => 'sod', <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 'module' => 'setDate', <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 'order_id' => 'xxxxx6', <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 'date' => '01.08.2016', <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 'start_hour' => '', <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> 'end_hour' => '', <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"> '_csrf' => '579xxxxxxxxxxxxxxxxxxxxxxxxx71128', <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">) <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal;mso-outline-level:2">Params <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">array ( <p class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt">)
9 комментариев
Автору плагина передали ваше сообщение.
Спасибо, Михаил!:) Я ему писала на почту, не дождалась, думала, может тут кто знает в чем дело.
Здравствуйте! Как Вы решили свою проблему?
Решение нашел!
1 - Найти таблицу в БД shop_sod_date
2 - Найти поле user_data
3 - Поставить стандартное значение для user_data
Эдуард, да никак пока не решила :) Сейчас попробуем - отпишусь:) Автор почему то снова молчит уже больше недели....
Эдуард, спасибо за решение!:) теперь хотя бы можно выставить дату в таком заказе, НО при сохранении заказа (если его редактируешь)
автоматически появляется 01.01.1970
Дата и время доставки
Указано покупателем: 01.01.1970
Указано менеджером: 18.08.2016 с 8 до 24
согласовано с покупателем
Выставляла значение NULL
Пора признать, что плагин "Дата доставки" заброшен и умер. Удивительно, но неужели никому не нужен реестр заказов по датам? Это единственная живая функция в плагине и с ужасом ждем когда и она перестанет работать. Как дальше жить без списка заказов на определенную дату и время?
Народ, давайте проголосуем чтобы этот функционал добавили в штатный функционал всех плагинов доставки.
https://support.webasyst.ru/forum/32754/zhelaemyy-interval-dostavkivremya-dostavki/