Unknown column 'tblUsers.isAdmin' in 'where clause'

[mohammadthalif]

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')

[administrator]

hi

thanks for using LetoDMS

can you please post what version of letodms are you running . php and mysql & operating system

Thanks

LetoDMS team.

[mohammadthalif]

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

[administrator]

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.

[mohammadthalif]

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.

[administrator]

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.

[mohammadthalif]

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

[Doudoux]

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

[mohammadthalif]

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

[Doudoux]

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