This topic contains 4 replies, has 2 voices, and was last updated by  Jorge 2 months, 1 week ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #47263

    Jorge
    Participant

    Hi all, I’ve installed Phreebooks R37RC1.zip in OpenSuse Leap.

    I grateful if some one could help me with this problems:

    I had problems when I tried to save data that I’ve fill in different process after setup the beginning setup:

    a-Making a new Branch
    b-Making a new Employee
    c-Making a General Ledger entry

    I got the trace file each time with this error:

    a-Making a new Branch : In this case I don’t understand why the system request “tax id” if there is not fill to input:

    Trace information for debug purposes. Phreedom release 3.7.1, generated 2017-01-09 20:30:21.

    GET Vars = Array ( [module] => contacts [page] => main [type] => b )
    POST Vars = Array ( [action] => save [f0] => [id] => [rowSeq] => [del_crm_note] => [payment_id] => [short_name] => 100 [contact_first] => J [contact_middle] => R [contact_last] => F [address] => Array ( [bm] => Array ( [primary_name] => Pruebas [telephone1] => [address_id] => [contact] => [telephone2] => [address1] => Calles [telephone3] => [address2] => [telephone4] => [city_town] => San José [email] => [state_province] => San José [website] => [postal_code] => 1000 [country_code] => CRI [notes] => ) ) [crm_rep_id] => 0 [crm_date] => 09/01/2017 [crm_action] => [crm_note] => )
    REQUEST Vars = Array ( [module] => contacts [page] => main [type] => b [action] => save [f0] => [id] => [rowSeq] => [del_crm_note] => [payment_id] => [short_name] => 100 [contact_first] => J [contact_middle] => R [contact_last] => F [address] => Array ( [bm] => Array ( [primary_name] => Pruebas [telephone1] => [address_id] => [contact] => [telephone2] => [address1] => Calles [telephone3] => [address2] => [telephone4] => [city_town] => San José [email] => [state_province] => San José [website] => [postal_code] => 1000 [country_code] => CRI [notes] => ) ) [crm_rep_id] => 0 [crm_date] => 09/01/2017 [crm_action] => [crm_note] => )
    SESSION Vars = Array ( [language] => en_us [LAST_ACTIVITY] => 1483993740 [companies] => Array ( [1] => mysql ) [admin_id] => 1 [display_name] => [admin_email] => jrodriguez17@cpcecr.com [admin_prefs] => Array ( [role] => 0 [def_store_id] => 0 [def_cash_acct] => [def_ar_acct] => [def_ap_acct] => [restrict_store] => 0 [restrict_period] => 0 ) [company] => mysql [account_id] => 0 [admin_security] => Array ( [26] => 4 [49] => 4 [16] => 4 [88] => 4 [29] => 4 [35] => 4 [28] => 4 [32] => 4 [30] => 4 [34] => 4 [31] => 4 [40] => 4 [38] => 4 [51] => 4 [89] => 4 [54] => 4 [59] => 4 [53] => 4 [58] => 4 [55] => 4 [61] => 4 [57] => 4 [60] => 4 [151] => 4 [152] => 4 [153] => 4 [156] => 0 [102] => 4 [111] => 4 [107] => 4 [109] => 4 [103] => 4 [101] => 4 [112] => 4 [108] => 4 [110] => 4 [105] => 4 [104] => 4 [39] => 4 [113] => 4 [126] => 4 [130] => 4 [4] => 4 [129] => 4 [19] => 4 [76] => 4 [2] => 4 [18] => 4 [3] => 4 [13] => 4 [7] => 4 [11] => 4 [1] => 4 [5] => 4 [15] => 4 [6] => 4 ) [department] => [f0] => 1 )
    Time: 58 ms, 6 SQLs 5 ms =>
    The failing sql was: insert into phreecontacts (contact_first, contact_last, contact_middle, inactive, short_name, type, contacts_level, store_id, gl_type_account, gov_id_number, dept_rep_id, account_number, special_terms, price_sheet, tax_id, last_update, first_date) values (‘J’, ‘F’, ‘R’, ‘0’, ‘100’, ‘b’, ”, ”, ”, ”, ”, ”, ”, ”, ”, now(), now())
    Time: 58 ms, 6 SQLs 5 ms =>
    mySQL returned: 1366 Incorrect integer value: ” for column ‘tax_id’ at row 1

    b-Making a new Employee: In this case I can’t understand why request again ‘tax id’:

    Trace information for debug purposes. Phreedom release 3.7.1, generated 2017-01-09 17:49:39.

    GET Vars = Array ( [module] => contacts [page] => main [type] => e )
    POST Vars = Array ( [action] => save [f0] => [id] => [rowSeq] => [del_crm_note] => [payment_id] => [account_number] => [short_name] => 1 [gov_id_number] => 654646 [contact_first] => Q [contact_middle] => M [contact_last] => K [dept_rep_id] => [gl_type_account] => Array ( [e] => 1 ) [address] => Array ( [em] => Array ( [primary_name] => Prueba [telephone1] => [address_id] => [contact] => [telephone2] => [address1] => Avenida [telephone3] => [address2] => [telephone4] => [city_town] => San José [email] => [state_province] => San José [website] => [postal_code] => 1000 [country_code] => CRI [notes] => ) ) [crm_rep_id] => 0 [crm_date] => 09/01/2017 [crm_action] => [crm_note] => )
    REQUEST Vars = Array ( [module] => contacts [page] => main [type] => e [action] => save [f0] => [id] => [rowSeq] => [del_crm_note] => [payment_id] => [account_number] => [short_name] => 1 [gov_id_number] => 654646 [contact_first] => Q [contact_middle] => M [contact_last] => K [dept_rep_id] => [gl_type_account] => Array ( [e] => 1 ) [address] => Array ( [em] => Array ( [primary_name] => Prueba [telephone1] => [address_id] => [contact] => [telephone2] => [address1] => Avenida [telephone3] => [address2] => [telephone4] => [city_town] => San José [email] => [state_province] => San José [website] => [postal_code] => 1000 [country_code] => CRI [notes] => ) ) [crm_rep_id] => 0 [crm_date] => 09/01/2017 [crm_action] => [crm_note] => )
    SESSION Vars = Array ( [language] => en_us [LAST_ACTIVITY] => 1483984033 [companies] => Array ( [1] => mysql ) [admin_id] => 1 [display_name] => [admin_email] => jrodriguez17@cpcecr.com [admin_prefs] => [company] => mysql [account_id] => 0 [admin_security] => Array ( [151] => 4 [152] => 4 [153] => 4 [3] => 4 [102] => 4 [111] => 4 [107] => 4 [109] => 4 [103] => 4 [101] => 4 [112] => 4 [108] => 4 [110] => 4 [105] => 4 [104] => 4 [39] => 4 [113] => 4 [126] => 4 [130] => 4 [4] => 4 [129] => 4 [19] => 4 [2] => 4 [18] => 4 [13] => 4 [7] => 4 [11] => 4 [1] => 4 [5] => 4 [6] => 4 [26] => 4 [49] => 4 [16] => 4 [88] => 4 [29] => 4 [35] => 4 [28] => 4 [32] => 4 [30] => 4 [34] => 4 [31] => 4 [40] => 4 [38] => 4 [51] => 4 [89] => 4 [54] => 4 [59] => 4 [53] => 4 [58] => 4 [55] => 4 [61] => 4 [57] => 4 [60] => 4 [76] => 4 [] => ) [department] => [f0] => [contactse] => Array ( [sf] => [so] => asc [list] => 1 [search] => [period] => 4 [date] => ) )
    Time: 53 ms, 6 SQLs 5 ms =>
    The failing sql was: insert into phreecontacts (account_number, contact_first, contact_last, contact_middle, dept_rep_id, gl_type_account, gov_id_number, inactive, short_name, type, contacts_level, store_id, special_terms, price_sheet, tax_id, last_update, first_date) values (”, ‘Q’, ‘K’, ‘M’, ”, ‘e’, ‘654646’, ‘0’, ‘1’, ‘e’, ”, ”, ”, ”, ”, now(), now())
    Time: 53 ms, 6 SQLs 5 ms =>
    mySQL returned: 1366 Incorrect integer value: ” for column ‘tax_id’ at row 1

    c-Making a General Ledger entry: I can’t find what is the error:

    Trace information for debug purposes. Phreedom release 3.7.1, generated 2017-01-09 20:26:08.

    GET Vars = Array ( [module] => phreebooks [page] => journal )
    POST Vars = Array ( [action] => save [id] => [recur_id] => 0 [recur_frequency] => 0 [purchase_invoice_id] => 1 [post_date] => 09/01/2017 [auto_complete] => 1 [store_id] => 0 [acct_1] => 1020 [id_1] => [desc_1] => Aporte Inicial de Capital de Socio A [debit_1] => 10.000.000,00 [credit_1] => [acct_2] => 3100 [id_2] => [desc_2] => Aporte Inicial de Capital de Socio A [debit_2] => [credit_2] => 10.000.000,00 [debit_total] => 10.000.000,00 [credit_total] => 10.000.000,00 [balance_total] => 0,00 )
    REQUEST Vars = Array ( [module] => phreebooks [page] => journal [action] => save [id] => [recur_id] => 0 [recur_frequency] => 0 [purchase_invoice_id] => 1 [post_date] => 09/01/2017 [auto_complete] => 1 [store_id] => 0 [acct_1] => 1020 [id_1] => [desc_1] => Aporte Inicial de Capital de Socio A [debit_1] => 10.000.000,00 [credit_1] => [acct_2] => 3100 [id_2] => [desc_2] => Aporte Inicial de Capital de Socio A [debit_2] => [credit_2] => 10.000.000,00 [debit_total] => 10.000.000,00 [credit_total] => 10.000.000,00 [balance_total] => 0,00 )
    SESSION Vars = Array ( [language] => en_us [LAST_ACTIVITY] => 1483993476 [companies] => Array ( [1] => mysql ) [admin_id] => 3 [display_name] => J [admin_email] => jrodriguez17@cpcecr.com [admin_prefs] => Array ( [role] => 2 [def_store_id] => 0 [def_cash_acct] => [def_ar_acct] => [def_ap_acct] => [restrict_store] => 0 [restrict_period] => 0 ) [company] => mysql [account_id] => 0 [admin_security] => Array ( [26] => 4 [49] => 4 [16] => 4 [88] => 4 [29] => 4 [35] => 4 [28] => 4 [32] => 4 [30] => 4 [34] => 4 [31] => 4 [40] => 4 [38] => 4 [51] => 4 [89] => 4 [54] => 4 [59] => 4 [53] => 4 [58] => 4 [55] => 4 [61] => 4 [57] => 4 [60] => 4 [151] => 4 [152] => 4 [153] => 4 [156] => 4 [102] => 4 [111] => 4 [107] => 4 [109] => 4 [103] => 4 [101] => 4 [112] => 4 [108] => 4 [110] => 4 [105] => 4 [104] => 4 [39] => 4 [113] => 4 [126] => 4 [130] => 4 [4] => 4 [129] => 4 [19] => 4 [76] => 4 [2] => 4 [18] => 4 [13] => 4 [7] => 4 [1] => 4 [5] => 4 [15] => 4 [6] => 4 ) [department] => [f0] => )
    Time: 42 ms, 3 SQLs 1 ms => Start validating purchase_invoice_id … specified ID but no dups, returning OK.
    Time: 43 ms, 4 SQLs 2 ms => Checking for re-post records … end check for Re-post with no action.
    Time: 43 ms, 4 SQLs 2 ms => Starting to Post indexes to be Posted = Array ( [0] => 2017-01-09:00000000 )
    Time: 43 ms, 4 SQLs 2 ms => /********* Posting Journal main … id = 0 and journal_id = 2
    Time: 43 ms, 4 SQLs 2 ms => Checking for re-post records … end check for Re-post with no action.
    Time: 43 ms, 4 SQLs 2 ms => Removing system generated gl rows. Started with 2 rows and ended with 2 rows.
    Time: 43 ms, 4 SQLs 2 ms => journal_main array = Array ( [id] => [period] => 4 [journal_id] => 2 [post_date] => 2017-01-09 [total_amount] => 10000000 [description] => General Journal Entry [purchase_invoice_id] => 1 [currencies_code] => CRC [currencies_value] => 1 [admin_id] => 3 [bill_primary_name] => Aporte Inicial de Capital de Socio A [recur_id] => 0 [store_id] => 0 )
    Time: 43 ms, 4 SQLs 2 ms =>
    The failing sql was: insert into phreejournal_main (id, period, journal_id, post_date, total_amount, description, purchase_invoice_id, currencies_code, currencies_value, admin_id, bill_primary_name, recur_id, store_id) values (”, ‘4’, ‘2’, ‘2017-01-09’, ‘10000000’, ‘General Journal Entry’, ‘1’, ‘CRC’, ‘1’, ‘3’, ‘Aporte Inicial de Capital de Socio A’, ‘0’, ‘0’)
    Time: 43 ms, 4 SQLs 2 ms =>
    mySQL returned: 1366 Incorrect integer value: ” for column ‘id’ at row 1

    Thank in advance,

    Jorge Rodríguez

    #47264

    Dave
    Keymaster

    All these errors are the same issue, it appears you have your mysql set to strict. Turn off the strict requirement and they should go away.

    Dave

    #47267

    Jorge
    Participant

    Hi:

    Thank you very much for your tip. I Googlee to these web sites:

    https://support.kayako.com/article/472-how-do-i-disable-mysql-strict-mode-on-the-server

    How to Disable MySQL Strict Mode

    And there I found how to eliminate the strict mode of MySQL.

    But I have a dude:

    They said that if we eliminate the strict mode would happen that if I input for example a number or a name longer than the field specifications it save the data but cut it to the specifications field. For example, in US would use for example as max to middle company US 100,000,000 and the field is to define with this argument, but in Latin America would use more than that, then if we input a number upper than it MySQL cut the number when it is save but not send any message.

    It could happen in Phreebooks R37RC1 ?

    Thank you again,

    Jorge Rodríguez

    #47269

    Dave
    Keymaster

    Possibly but most of the numbers are set to double which should be able to handle long integers. It is true that numbers and strings can get truncated, but with strict on you will never get past the mysql errors and get PhreeBooks working. I recommend you turn strict off and try some extreme, but realistic, examples to see what happens.

    Dave

    #47270

    Jorge
    Participant

    Hi:

    Thank you for your answer to clarify my dude and for your suggestions.

    Regards,

    Jorge Rodríguez

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.