bgerp/bgerp — Issue #92: fin/bank - "гърми" при опит за дефиниране на Банкови сметки на фирмата
Author: arsov
Created: 2011-10-21 14:52:51+00:00
State: open
Labels: bank, Грешка

ФИНАНСИ, подменю Банки, страница Наши банкови сметки ( http://test.bgerp.com/alpha/bank_OwnAccounts/ ) - при опит за дефиниране на Банкови сметки на фирмата (необходими за примера в cloud.bgerp.com/demo базата като пера на номенклатурата) с бутон Нов запис - гърми:

http://test.bgerp.com/alpha/bank_OwnAccounts/add/

```
Прекъсване на линия 635 в /var/www/dev/mitko/ef_root/alpha/ef/core/Db.class.php

(string) ГРЕШКА В БАЗАТА ДАННИ

(string) Грешка в БД при изпълняване на заявка

(array)
query : (string) SELECT `bank_accounts`.`id` AS `id` , `bank_accounts`.`contragent_id` AS `contragentId` , `bank_accounts`.`title` AS `title` , `bank_accounts`.`number` AS `number` , `bank_accounts`.`iban` AS `iban` , `bank_accounts`.`bic` AS `bic` , `bank_accounts`.`bank_id` AS `bankId` , `bank_accounts`.`type_id` AS `typeId` , `bank_accounts`.`currency_id` AS `currencyId` , `bank_accounts`.`min_balance` AS `minBalance` , `bank_accounts`.`comment` AS `comment` FROM `bank_accounts` WHERE (`bank_accounts`.`contragent_id` = )
error : (string) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 16

Стек

(array)
file : (string) /var/www/dev/mitko/ef_root/alpha/ef/core/Db.class.php
line : (integer) 635
function : (string) error
args : (array)
0 : (string) Грешка в БД при изпълняване на заявка
1 : (array)
query : (string) SELECT `bank_accounts`.`id` AS `id` , `bank_accounts`.`contragent_id` AS `contragentId` , `bank_accounts`.`title` AS `title` , `bank_accounts`.`number` AS `number` , `bank_accounts`.`iban` AS `iban` , `bank_accounts`.`bic` AS `bic` , `bank_accounts`.`bank_id` AS `bankId` , `bank_accounts`.`type_id` AS `typeId` , `bank_accounts`.`currency_id` AS `currencyId` , `bank_accounts`.`min_balance` AS `minBalance` , `bank_accounts`.`comment` AS `comment` FROM `bank_accounts` WHERE (`bank_accounts`.`contragent_id` = )
error : (string) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 16

2 : (string) ГРЕШКА В БАЗАТА ДАННИ

(array)
file : (string) /var/www/dev/mitko/ef_root/alpha/ef/core/Db.class.php
line : (integer) 150
function : (string) checkForErrors
class : (string) core_Db
object : (core_Db)
dbName : (string) alpha
dbUser : (string) test
dbHost : (string) localhost
link : (resource) Resource id #28
lastRes : (NULL)
loadList : (NULL)
pluginsList : (NULL)
invocableMethods : (array)

dbCharset : (string) utf8
query : (string) SELECT `bank_accounts`.`id` AS `id` , `bank_accounts`.`contragent_id` AS `contragentId` , `bank_accounts`.`title` AS `title` , `bank_accounts`.`number` AS `number` , `bank_accounts`.`iban` AS `iban` , `bank_accounts`.`bic` AS `bic` , `bank_accounts`.`bank_id` AS `bankId` , `bank_accounts`.`type_id` AS `typeId` , `bank_accounts`.`currency_id` AS `currencyId` , `bank_accounts`.`min_balance` AS `minBalance` , `bank_accounts`.`comment` AS `comment` FROM `bank_accounts` WHERE (`bank_accounts`.`contragent_id` = )

type : (string) ->
args : (array)
0 : (string) изпълняване на заявка
1 : (boolean) FALSE

(array)
file : (string) /var/www/dev/mitko/ef_root/alpha/ef/core/Query.class.php
line : (integer) 338
function : (string) query
class : (string) core_Db
object : (core_Db)
dbName : (string) alpha
dbUser : (string) test
dbHost : (string) localhost
link : (resource) Resource id #28
lastRes : (NULL)
loadList : (NULL)
pluginsList : (NULL)
invocableMethods : (array)

dbCharset : (string) utf8
query : (string) SELECT `bank_accounts`.`id` AS `id` , `bank_accounts`.`contragent_id` AS `contragentId` , `bank_accounts`.`title` AS `title` , `bank_accounts`.`number` AS `number` , `bank_accounts`.`iban` AS `iban` , `bank_accounts`.`bic` AS `bic` , `bank_accounts`.`bank_id` AS `bankId` , `bank_accounts`.`type_id` AS `typeId` , `bank_accounts`.`currency_id` AS `currencyId` , `bank_accounts`.`min_balance` AS `minBalance` , `bank_accounts`.`comment` AS `comment` FROM `bank_accounts` WHERE (`bank_accounts`.`contragent_id` = )

type : (string) ->
args : (array)
0 : (string) SELECT `bank_accounts`.`id` AS `id` , `bank_accounts`.`contragent_id` AS `contragentId` , `bank_accounts`.`title` AS `title` , `bank_accounts`.`number` AS `number` , `bank_accounts`.`iban` AS `iban` , `bank_accounts`.`bic` AS `bic` , `bank_accounts`.`bank_id` AS `bankId` , `bank_accounts`.`type_id` AS `typeId` , `bank_accounts`.`currency_id` AS `currencyId` , `bank_accounts`.`min_balance` AS `minBalance` , `bank_accounts`.`comment` AS `comment` FROM `bank_accounts` WHERE (`bank_accounts`.`contragent_id` = )
```