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!
0
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
Solved, sorry thanks!
0
I am glad to know that you have solved it yourself. Thank you for updating
0
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
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
Hello! Thank you for the answer, they are both null, looking forward to your comments regards!
0
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
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.