03-09-2011, 09:41 PM
When ever I try to add a file I get below message printed at the top of the page.
Unknown column 'tblUsers.isAdmin' in 'where clause'
(SELECT `tblUsers`.* FROM `tblUsers` WHERE (`tblUsers`.`id` = 1) OR (`tblUsers`.`isAdmin` = 1))UNION (SELECT `tblUsers`.* FROM `tblUsers` WHERE `tblUsers`.`id` != '2' ) ORDER BY `login`
If I add a new version of the file to existing on then, the newly added one goes to 0 instead of increasing.
If I add more than two version for a file I get below error message.
Unknown column 'tblUsers.isAdmin' in 'where clause'
(SELECT `tblUsers`.* FROM `tblUsers` WHERE (`tblUsers`.`id` = 1) OR (`tblUsers`.`isAdmin` = 1))UNION (SELECT `tblUsers`.* FROM `tblUsers` WHERE `tblUsers`.`id` != '2' ) ORDER BY `login`
Duplicate entry '3-0' for key 'document'
INSERT INTO tblDocumentContent (document, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (3, 'output.pdf3', 1299679479, 1, '1048576/3/', 'TS.pdf', '.pdf', 'application/pdf')
Unknown column 'tblUsers.isAdmin' in 'where clause'
(SELECT `tblUsers`.* FROM `tblUsers` WHERE (`tblUsers`.`id` = 1) OR (`tblUsers`.`isAdmin` = 1))UNION (SELECT `tblUsers`.* FROM `tblUsers` WHERE `tblUsers`.`id` != '2' ) ORDER BY `login`
If I add a new version of the file to existing on then, the newly added one goes to 0 instead of increasing.
If I add more than two version for a file I get below error message.
Unknown column 'tblUsers.isAdmin' in 'where clause'
(SELECT `tblUsers`.* FROM `tblUsers` WHERE (`tblUsers`.`id` = 1) OR (`tblUsers`.`isAdmin` = 1))UNION (SELECT `tblUsers`.* FROM `tblUsers` WHERE `tblUsers`.`id` != '2' ) ORDER BY `login`
Duplicate entry '3-0' for key 'document'
INSERT INTO tblDocumentContent (document, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (3, 'output.pdf3', 1299679479, 1, '1048576/3/', 'TS.pdf', '.pdf', 'application/pdf')