Database Error After Updating

0

Hello, i have a database error after updating, please i need urgent help as i cant get into the site, this happened when importing database update 3.4.53 , looking forward to your comments regards!

Question Resolved For: Stock Manager Advance (Invoice & Inventory System) 0 Votes 8 Answers 607 Views
Asked by Felipe Ramos 1 year ago

0

Answered by Felipe Ramos 1 year ago

The error that gives me is:

Error
consulta SQL:

ALTER TABLE sma_settings ADD COLUMN ksa_qrcode tinyint(1) NULL

MySQL ha dicho:

#1060 - Nombre de columna duplicado 'ksa_qrcode'

0

Answered by Felipe Ramos 1 year ago

Solved, sorry thanks!

0

Answered by Mian Saleem 1 year ago

I am glad to know that you have solved it yourself. Thank you for updating

0

Answered by Felipe Ramos 1 year ago

Hello! I have noticed a error now that im using the system updated to V3.5 , every time i create a new purchase order, a new expense or a new sale the system automatically adds a attachment, i dont know why but it does, and when you clic on the attachment it shows nothing, when i put the cursor on the attachment the attachment is linked to identificator "0" (the is no identificator xxxx/admin/welcome/downloads/2312cf53sdfsd33.pdf as in the ones i upload, it shown as xxxx/admin/welcome/downloads/0 )

Looking forward to your comments regards!

0

Answered by Mian Saleem 1 year ago

Hello,

I can't think of any reason just gussing that the attachment column value is set to 0 instead null. You can try to run the following query and try to set the column to null.

UPDATE sma_sales set attachment=null where attachment=0;
UPDATE sma_expenses set attachment=null where attachment=0;

Thank you

0

Answered by Felipe Ramos 1 year ago

Hello! Thank you for the answer, they are both null, looking forward to your comments regards!

0

Answered by Mian Saleem 1 year ago

Hello,

Please take the screenshot of the page where you see the link. The old version was single attachment and udpate to multiple attachments. So the column is no more active as single attachment but as it was required in old versions so it is there. For new version it will just show the tick and attachments will be on details page.

Thank you

0

Answered by Felipe Ramos 1 year ago

Sorry that was it, it showed a tick and in the details was the document as you mention, all solved now thank you!

We use Cookies

We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.