Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Query Exception on step 3 of installation

C K Siew   ( User )

Commented 4 years ago

Hi, I have encountered a Query Exception when I reached step 3 of installation. I have configured to connect to an SQL Server database.


(3/3) QueryException


 


SQLSTATE[22018]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value '01-01' to data type int. (SQL: insert into [ak_settings] ([company_id], [key], [value]) values (1, general.default_account, 1), (1, general.financial_start, 01-01), (1, general.timezone, Europe/London), (1, general.date_format, d M Y), (1, general.date_separator, space), (1, general.percent_position, after), (1, general.invoice_number_prefix, INV-), (1, general.invoice_number_digit, 5), (1, general.invoice_number_next, 1), (1, general.default_payment_method, offlinepayment.cash.1), (1, general.email_protocol, mail), (1, general.email_sendmail_path, /usr/sbin/sendmail -bs), (1, general.send_invoice_reminder, 0), (1, general.schedule_invoice_days, 1,3,5,10), (1, general.send_bill_reminder, 0), (1, general.schedule_bill_days, 10,5,3,1), (1, general.send_item_reminder, 0), (1, general.schedule_item_stocks, 3,5,7), (1, general.schedule_time, 09:00), (1, general.admin_theme, skin-green-light), (1, general.list_limit, 25), (1, general.use_gravatar, 0), (1, general.session_handler, file), (1, general.session_lifetime, 30), (1, general.file_size, 2), (1, general.file_types, pdf,jpeg,jpg,png), (1, general.wizard, 0), (1, general.invoice_item, settings.invoice.item), (1, general.invoice_price, settings.invoice.price), (1, general.invoice_quantity, settings.invoice.quantity), (1, general.company_name, ABC), (1, general.company_email, [email protected]), (1, general.default_currency, USD), (1, general.default_locale, ), (1, offlinepayment.methods, [{"code":"offlinepayment.cash.1","name":"Cash","order":"1","description":null},{"code":"offlinepayment.bank_transfer.2","name":"Bank Transfer","order":"2","description":null}]))   I hope that someone would be able to guide me on the above issue.Thank you :)

Marco Bridge   ( User )

Commented 4 years ago

What is the structure of _settings table?

C K Siew   ( User )

Commented 4 years ago

Hi Marco, thank you for your response. The structure of _settings table is as followed:


CREATE TABLE [dbo].[ak_settings]( [id] [int] IDENTITY(1,1) NOT NULL, [company_id] [int] NOT NULL, [key] [nvarchar](191) NOT NULL, [value] [nvarchar](max) NULL,PRIMARY KEY CLUSTERED 


( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


 

Please login or register to leave a response.

Showing 1 to 3 of 3 discussions