Question: Database Error After Updating

Database Error After Updating

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

FR

Felipe Ramos

Asked

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!

  • FR

    Felipe Ramos

    Answered

    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’

  • FR

    Felipe Ramos

    Answered

    Solved, sorry thanks!

  • MS

    Mian Saleem

    Answered

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

  • FR

    Felipe Ramos

    Answered

    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!

  • MS

    Mian Saleem

    Answered

    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

  • FR

    Felipe Ramos

    Answered

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

  • MS

    Mian Saleem

    Answered

    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

  • FR

    Felipe Ramos

    Answered

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

  • Login to Reply