Project

General

Profile

Actions

Chyba #1066

closed

Nelze vytvořit člena pokud nemá vytvářející právo Members_Controller@registration

Added by Ondřej Fibich about 7 years ago. Updated almost 6 years ago.

Status:
Odmítnutý
Priority:
Nízká
Category:
Členi a uživatelé
Target version:
Start date:
03/02/2017
Due date:
04/02/2017
% Done:

0%

Estimated time:
0:30 h

Description

Chybí totiž výchozí hodnota pro toto pole, je nutné ji v controlleru vyplnit na 0.

Chyba v SQL dotazu - Field 'registration' doesn't have a default value - INSERT INTO `members` (`id`, `address_point_id`, `user_id`, `comment`, `name`, `type`, `organization_identifier`, `vat_organization_identifier`, `speed_class_id`, `entrance_fee`, `debt_payment_rate`, `entrance_date`, `krivonet_ap`, `krivonet_tech`, `krivonet_address`) VALUES (878481874, 9, 1, '', 'sefsefs sefsefse', 2, '', '', 1, 0.000000, 0.000000, '2017-03-02', 'sefesf sefsefsese P', '2', 'sesfse') at /home/dzolo/Projects/FreenetIS/freenetis-gitlab/system/libraries/drivers/Database/Mysqli.php:142 (44)
#0 /home/dzolo/Projects/FreenetIS/freenetis-gitlab/system/libraries/drivers/Database/Mysqli.php(90): Kohana_Mysqli_Result->__construct(Object(mysqli), true, 'INSERT INTO `me...')
#1 /home/dzolo/Projects/FreenetIS/freenetis-gitlab/system/libraries/Database.php(185): Database_Mysqli_Driver->query('INSERT INTO `me...')
#2 /home/dzolo/Projects/FreenetIS/freenetis-gitlab/system/libraries/Database.php(888): Database->query('INSERT INTO `me...')
#3 /home/dzolo/Projects/FreenetIS/freenetis-gitlab/system/libraries/ORM.php(797): Database->insert('members', Array)
#4 /home/dzolo/Projects/FreenetIS/freenetis-gitlab/system/libraries/ORM.php(1577): ORM_Core->save()
#5 /home/dzolo/Projects/FreenetIS/freenetis-gitlab/application/controllers/members.php(2845): ORM_Core->save_throwable()
#6 /home/dzolo/Projects/FreenetIS/freenetis-gitlab/system/core/Kohana.php(341): Members_Controller->add()
#7 /home/dzolo/Projects/FreenetIS/freenetis-gitlab/system/core/Event.php(217): Kohana::instance()
#8 /home/dzolo/Projects/FreenetIS/freenetis-gitlab/system/core/Bootstrap.php(55): Event::run('system.execute')
#9 /home/dzolo/Projects/FreenetIS/freenetis-gitlab/index.php(112): require('/home/dzolo/Pro...')
#10 {main}

Related issues 1 (0 open1 closed)

Is duplicate of Chyba #1067: V MySQL 5.7 nelze používat datum 0000-00-00OdmítnutýOndřej Fibich03/02/2017

Actions
Actions #1

Updated by Ondřej Fibich about 7 years ago

Bude spojeno s mým MySQL 5.7, asi je striktnější. Nefunguje přidání ani kvůli sloupci leaving_date.

Actions #2

Updated by Ondřej Fibich about 7 years ago

  • Target version changed from 1.1.21 to 1.1.22
Actions #3

Updated by Ondřej Fibich almost 6 years ago

  • Is duplicate of Chyba #1067: V MySQL 5.7 nelze používat datum 0000-00-00 added
Actions #4

Updated by Ondřej Fibich almost 6 years ago

  • Status changed from Nový to Odmítnutý

Stejné řešení jako u #1067.

Actions

Also available in: Atom PDF