Error after update

Sndan ( User )

Commented 6 years ago

The issue start to happen after I updated the application

Steps to reproduce the issue

creating a customer

Expected result

creating a new customer

Actual result

something went wromf

System information (Akaunting, PHP versions)

PHP ver 7.1
latest software

Additional comments

this is the debug

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'reference' in 'field list' (SQL: insert into jze_customers (name, email, tax_number, currency_code, phone, website, address, enabled, reference, company_id, updated_at, created_at) values (Alqattan, [email protected], , SAR, 966540800300, alqattan1.com, , 1, mohad buali, 1, 2019-01-05 10:18:30, 2019-01-05 10:18:30))

<p style="box-sizing: border-box; margin-bottom: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol'; font-size: 15px; margin-top: 0px !important;">The issue start to happen after I updated the application</p><br />
<h3 style="box-sizing: border-box; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; font-size: 1.25em; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol';">Steps to reproduce the issue</h3><br />
<p style="box-sizing: border-box; margin-bottom: 16px; margin-top: 0px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol'; font-size: 15px;">creating a customer</p><br />
<h3 style="box-sizing: border-box; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; font-size: 1.25em; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol';">Expected result</h3><br />
<p style="box-sizing: border-box; margin-bottom: 16px; margin-top: 0px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol'; font-size: 15px;">creating a new customer</p><br />
<h3 style="box-sizing: border-box; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; font-size: 1.25em; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol';">Actual result</h3><br />
<p style="box-sizing: border-box; margin-bottom: 16px; margin-top: 0px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol'; font-size: 15px;">something went wromf</p><br />
<h3 style="box-sizing: border-box; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; font-size: 1.25em; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol';">System information (Akaunting, PHP versions)</h3><br />
<p style="box-sizing: border-box; margin-bottom: 16px; margin-top: 0px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol'; font-size: 15px;">PHP ver 7.1<br style="box-sizing: border-box;" />latest software</p><br />
<h3 style="box-sizing: border-box; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; font-size: 1.25em; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol';">Additional comments</h3><br />
<p style="box-sizing: border-box; margin-bottom: 16px; margin-top: 0px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol'; font-size: 15px;">this is the debug</p><br />
<blockquote style="box-sizing: border-box; margin: 0px 0px 16px; border-left: 0.25em solid #dfe2e5; color: #6a737d; padding: 0px 1em; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol'; font-size: 15px;"><br />
<p style="box-sizing: border-box; margin-bottom: 0px; margin-top: 0px;">SQLSTATE[42S22]: Column not found: 1054 Unknown column 'reference' in 'field list' (SQL: insert into <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">jze_customers</code> (<code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">name</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">email</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">tax_number</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">currency_code</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">phone</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">website</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">address</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">enabled</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">reference</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">company_id</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">updated_at</code>, <code style="box-sizing: border-box; font-family: Consolas, 'Liberation Mono', Courier, monospace; background-color: rgba(27, 31, 35, 0.05); border-radius: 3px; font-size: 12.75px; margin: 0px; padding: 0.2em 0.4em;">created_at</code>) values (Alqattan, <a style="box-sizing: border-box; color: #0366d6; text-decoration-line: none;" href="mailto:cattan14@hotmail.com">cattan14@hotmail.com</a>, , SAR, 966540800300, alqattan1.com, , 1, mohad buali, 1, 2019-01-05 10:18:30, 2019-01-05 10:18:30))</p><br />
</blockquote>

Please login or register to leave a response.

Showing 1 to 1 of 1 discussions

Forum