+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: Installation Problems (https://community.letodms.com/forumdisplay.php?fid=9)
+--- Thread: Unknown column 'tblUsers.isAdmin' in 'where clause' (/showthread.php?tid=258)
Pages:
1
2
Unknown column 'tblUsers.isAdmin' in 'where clause' - mohammadthalif - 03-09-2011
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')
RE: Unknown column 'tblUsers.isAdmin' in 'where clause' - administrator - 03-09-2011
hi
thanks for using LetoDMS
can you please post what version of letodms are you running . php and mysql & operating system
Thanks
LetoDMS team.
RE: Unknown column 'tblUsers.isAdmin' in 'where clause' - mohammadthalif - 03-10-2011
Hi,
Please find the details below.
Letodms version: letoDMS-2.0.2
php version: PHP 5.3.2-1
mysql version: 5.1.41
OS: (Ubuntu 10.04.1 LTS) Linux 2.6.32-26-generic #47-Ubuntu SMP Wed Nov 17 15:59:05 UTC 2010 i686 GNU/Linux
RE: Unknown column 'tblUsers.isAdmin' in 'where clause' - administrator - 03-10-2011
(03-10-2011, 02:16 PM)mohammadthalif Wrote: Hi,
Please find the details below.
Letodms version: letoDMS-2.0.2
php version: PHP 5.3.2-1
mysql version: 5.1.41
OS: (Ubuntu 10.04.1 LTS) Linux 2.6.32-26-generic #47-Ubuntu SMP Wed Nov 17 15:59:05 UTC 2010 i686 GNU/Linux
is your problem resolved? because i see another thread in technical support?
thanks
LetoDMS team.
RE: Unknown column 'tblUsers.isAdmin' in 'where clause' - mohammadthalif - 03-11-2011
(03-10-2011, 09:29 PM)administrator Wrote: is your problem resolved? because i see another thread in technical support?
thanks
LetoDMS team.
No. Still I am having the this issue.
Every one in my org like LetoDMS, this is the only problem we have now. I am ready to provide the details you need to resolve, please let me know if you need any.
I have query on how to user name for each user in my org. So I had raised it separately.
Thanks,
Thalib.
RE: Unknown column 'tblUsers.isAdmin' in 'where clause' - administrator - 03-12-2011
(03-11-2011, 10:26 PM)mohammadthalif Wrote:(03-10-2011, 09:29 PM)administrator Wrote: is your problem resolved? because i see another thread in technical support?
thanks
LetoDMS team.
No. Still I am having the this issue.
Every one in my org like LetoDMS, this is the only problem we have now. I am ready to provide the details you need to resolve, please let me know if you need any.
I have query on how to user name for each user in my org. So I had raised it separately.
Thanks,
Thalib.
hi can you please run this
http://forums.letodms.com/showthread.php?tid=229
and post the result here
thanks
LetoDMS Team.
RE: Unknown column 'tblUsers.isAdmin' in 'where clause' - mohammadthalif - 03-12-2011
(03-12-2011, 03:01 PM)administrator Wrote: hi can you please run this
http://forums.letodms.com/showthread.php?tid=229
and post the result here
thanks
LetoDMS Team.
Please find the results below.
LetoDMS 2.0.2 check configuration
Check Apache configuration
Apache version: Apache/2.2.14 (Ubuntu)
mod_rewrite : Error
Check PHP configuration
PHP version: 5.3.2-1ubuntu4.7
gd2 : Ok
mbstring : Ok
database - mysql - : Ok
ldap (optional) : Error
Check LetoDMS configuration
settings->_rootDir : Ok
settings->_httpRoot : Ok
settings->_contentDir : Ok
settings->_ADOdbPath : Ok
database : Ok
Check other configuration
Cookies : OK
I have found mod_rewrite is not enabled so I enabled it and now test results are below.
LetoDMS 2.0.2 check configuration
Check Apache configuration
Apache version: Apache/2.2.14 (Ubuntu)
mod_rewrite : Ok
Check PHP configuration
PHP version: 5.3.2-1ubuntu4.7
gd2 : Ok
mbstring : Ok
database - mysql - : Ok
ldap (optional) : Error
Check LetoDMS configuration
settings->_rootDir : Ok
settings->_httpRoot : Ok
settings->_contentDir : Ok
settings->_ADOdbPath : Ok
database : Ok
Check other configuration
Cookies : OK
RE: Unknown column 'tblUsers.isAdmin' in 'where clause' - Doudoux - 03-12-2011
Hi
I've update the check.php file to find your error.
Can you use the last version please
[letoDMS v2.0.2] Check configuration after an installation
Thanks
Doudoux
RE: Unknown column 'tblUsers.isAdmin' in 'where clause' - mohammadthalif - 03-15-2011
Please find this output of the check.php.
LetoDMS 2.0.2 check configuration (check version : 2.02-04)
Check Apache configuration
Apache version: Apache/2.2.14 (Ubuntu)
mod_rewrite : Ok
Check PHP configuration
PHP version: 5.3.2-1ubuntu4.7
gd2 : Ok
mbstring : Ok
database - mysql - : Ok
ldap (optional) : Error
Check LetoDMS configuration
settings->_rootDir : Ok
settings->_httpRoot : Ok
settings->_contentDir : Ok
settings->_ADOdbPath : Ok
database - table 'tblAcls' : Error
table 'tblAcls' Table not found
database - table 'tblUsers' : Error
table 'tblUsers' 'isAdmin' not found ;
database : Error
Check other configuration
Cookies : OK
Informations
Limit size for uploading file (upload_max_filesize): 2M
Limit size for uploading file (post_max_size): 8M
SMTP server (SMTP): localhost
Limits of the execution time (max_execution_time): 30 s
END
RE: Unknown column 'tblUsers.isAdmin' in 'where clause' - Doudoux - 03-15-2011
Hi
Your database is corrupted
Is this a new installation?
If yes, you use the script to create database of version 3.0?
If not, you have data to keep it inside?
doudoux