LetoDMS Community Forum
Error msg when editing user details. - Printable Version

+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: Technical Support (https://community.letodms.com/forumdisplay.php?fid=10)
+--- Thread: Error msg when editing user details. (/showthread.php?tid=299)

Error msg when editing user details. - caos - 04-28-2011

Hi everyone
firstly im sorry if i sound like a clueless chook without an idea as i am a relative new born to web sites scripts etc etc etc...

i installed letodms 3.0 Rc5 and after i got everything work finally (After hours of trying to figure it out)
now every time i edit or add user details i get an error message :
''
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?= LetoDMS_Core_User::role_user ?> WHERE id = 3' at line 1
UPDATE tblUsers SET role = <?= LetoDMS_Core_User::role_user ?> WHERE id = 3

Warning: Cannot modify header information - headers already sent by (output started at X:\XXX\xampp\htdocs\XXXX\LetoDMS_Core\Core\inc.DBAccess.php:154) in X:\XXX\XXX\htdocs\XXX\op\op.UsrMgr.php on line 232
''

( XXX are the paths i just coverd up Smile )
this is gibberish to me so i dont know the exact problem is but i do remember getting similar errors from previous letodms releases when i tried to edit description and information of the documents within the DMS.
i downloaded the check.php and got no errors or faults??
my system is as follows

windows server Apache Mysql and PhP (xampp)

any help would be apprciatedConfused

RE: Error msg when editing user details. - administrator - 04-28-2011

(04-28-2011, 05:44 AM)caos Wrote: Hi everyone
firstly im sorry if i sound like a clueless chook without an idea as i am a relative new born to web sites scripts etc etc etc...

i installed letodms 3.0 Rc5 and after i got everything work finally (After hours of trying to figure it out)
now every time i edit or add user details i get an error message :
''
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?= LetoDMS_Core_User::role_user ?> WHERE id = 3' at line 1
UPDATE tblUsers SET role = <?= LetoDMS_Core_User::role_user ?> WHERE id = 3

Warning: Cannot modify header information - headers already sent by (output started at X:\XXX\xampp\htdocs\XXXX\LetoDMS_Core\Core\inc.DBAccess.php:154) in X:\XXX\XXX\htdocs\XXX\op\op.UsrMgr.php on line 232
''

( XXX are the paths i just coverd up Smile )
this is gibberish to me so i dont know the exact problem is but i do remember getting similar errors from previous letodms releases when i tried to edit description and information of the documents within the DMS.
i downloaded the check.php and got no errors or faults??
my system is as follows

windows server Apache Mysql and PhP (xampp)

any help would be apprciatedConfused

hi thank you for trying LetoDMS

We appreciate your support.

ok i analyzed your problem i want you to try this . delete the database . and make a another database and import letodms database to mysql

and update the config file , with brand new database name

and try again

and please post your setting file on here. so we can make sure you have the right path in config file

thanks

LetoDMS team.

RE: Error msg when editing user details. - caos - 04-28-2011

(04-28-2011, 07:44 AM)administrator Wrote: [quote='caos' pid='1295' dateline='1303933488']
Hi everyone
firstly im sorry if i sound like a clueless chook without an idea as i am a relative new born to web sites scripts etc etc etc...

i installed letodms 3.0 Rc5 and after i got everything work finally (After hours of trying to figure it out)
now every time i edit or add user details i get an error message :
''
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?= LetoDMS_Core_User::role_user ?> WHERE id = 3' at line 1
UPDATE tblUsers SET role = <?= LetoDMS_Core_User::role_user ?> WHERE id = 3

Warning: Cannot modify header information - headers already sent by (output started at X:\XXX\xampp\htdocs\XXXX\LetoDMS_Core\Core\inc.DBAccess.php:154) in X:\XXX\XXX\htdocs\XXX\op\op.UsrMgr.php on line 232
''

( XXX are the paths i just coverd up Smile )
this is gibberish to me so i dont know the exact problem is but i do remember getting similar errors from previous letodms releases when i tried to edit description and information of the documents within the DMS.
i downloaded the check.php and got no errors or faults??
my system is as follows

windows server Apache Mysql and PhP (xampp)

any help would be apprciatedConfused

Quote:hi thank you for trying LetoDMS

We appreciate your support.

ok i analyzed your problem i want you to try this . delete the database . and make a another database and import letodms database to mysql

and update the config file , with brand new database name

and try again

and please post your setting file on here. so we can make sure you have the right path in config file

thanks





LetoDMS team.

Done all that deleted the database created new one (UTF-8) and imported the tables create_tables.sql file then updated the conf file with the new details. and again when i try to edit the admin information and add a picture i get the same error.

PhP 5.3.1
Mysql 5.1.41
Apache 2.2.14 (win32)

RE: Error msg when editing user details. - caos - 05-04-2011

(04-28-2011, 06:15 PM)caos Wrote:
(04-28-2011, 07:44 AM)administrator Wrote: [quote='caos' pid='1295' dateline='1303933488']
Hi everyone
firstly im sorry if i sound like a clueless chook without an idea as i am a relative new born to web sites scripts etc etc etc...

i installed letodms 3.0 Rc5 and after i got everything work finally (After hours of trying to figure it out)
now every time i edit or add user details i get an error message :
''
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?= LetoDMS_Core_User::role_user ?> WHERE id = 3' at line 1
UPDATE tblUsers SET role = <?= LetoDMS_Core_User::role_user ?> WHERE id = 3

Warning: Cannot modify header information - headers already sent by (output started at X:\XXX\xampp\htdocs\XXXX\LetoDMS_Core\Core\inc.DBAccess.php:154) in X:\XXX\XXX\htdocs\XXX\op\op.UsrMgr.php on line 232
''

( XXX are the paths i just coverd up Smile )
this is gibberish to me so i dont know the exact problem is but i do remember getting similar errors from previous letodms releases when i tried to edit description and information of the documents within the DMS.
i downloaded the check.php and got no errors or faults??
my system is as follows

windows server Apache Mysql and PhP (xampp)

any help would be apprciatedConfused

Quote:hi thank you for trying LetoDMS

We appreciate your support.

ok i analyzed your problem i want you to try this . delete the database . and make a another database and import letodms database to mysql

and update the config file , with brand new database name

and try again

and please post your setting file on here. so we can make sure you have the right path in config file

thanks





LetoDMS team.

Done all that deleted the database created new one (UTF-8) and imported the tables create_tables.sql file then updated the conf file with the new details. and again when i try to edit the admin information and add a picture i get the same error.

PhP 5.3.1
Mysql 5.1.41
Apache 2.2.14 (win32)

Any solution to the problem????

RE: Error msg when editing user details. - administrator - 05-04-2011

(05-04-2011, 07:14 AM)caos Wrote:
(04-28-2011, 06:15 PM)caos Wrote:
(04-28-2011, 07:44 AM)administrator Wrote: [quote='caos' pid='1295' dateline='1303933488']
Hi everyone
firstly im sorry if i sound like a clueless chook without an idea as i am a relative new born to web sites scripts etc etc etc...

i installed letodms 3.0 Rc5 and after i got everything work finally (After hours of trying to figure it out)
now every time i edit or add user details i get an error message :
''
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?= LetoDMS_Core_User::role_user ?> WHERE id = 3' at line 1
UPDATE tblUsers SET role = <?= LetoDMS_Core_User::role_user ?> WHERE id = 3

Warning: Cannot modify header information - headers already sent by (output started at X:\XXX\xampp\htdocs\XXXX\LetoDMS_Core\Core\inc.DBAccess.php:154) in X:\XXX\XXX\htdocs\XXX\op\op.UsrMgr.php on line 232
''

( XXX are the paths i just coverd up Smile )
this is gibberish to me so i dont know the exact problem is but i do remember getting similar errors from previous letodms releases when i tried to edit description and information of the documents within the DMS.
i downloaded the check.php and got no errors or faults??
my system is as follows

windows server Apache Mysql and PhP (xampp)

any help would be apprciatedConfused

Quote:hi thank you for trying LetoDMS

We appreciate your support.

ok i analyzed your problem i want you to try this . delete the database . and make a another database and import letodms database to mysql

and update the config file , with brand new database name

and try again

and please post your setting file on here. so we can make sure you have the right path in config file

thanks





LetoDMS team.

Done all that deleted the database created new one (UTF-8) and imported the tables create_tables.sql file then updated the conf file with the new details. and again when i try to edit the admin information and add a picture i get the same error.

PhP 5.3.1
Mysql 5.1.41
Apache 2.2.14 (win32)

Any solution to the problem????

hi sorry for the late reply

please run this

http://forums.letodms.com/showthread.php?tid=244

and post the result here

thanks

LetoDMS Team.


RE: Error msg when editing user details. - Doudoux - 05-05-2011

Hi

In "out/out.UsrMgr.php" file change line 142
PHP Code:
<td><select name="role"><option value="<?= LetoDMS_Core_User::role_user ?>"></option><option value="<?= LetoDMS_Core_User::role_admin ?>"><?php printMLText("role_admin"); ?></option><option value="<?= LetoDMS_Core_User::role_guest ?>"><?php printMLText("role_guest"); ?></option></select></td> 
to
PHP Code:
<td><select name="role"><option value="<?php echo LetoDMS_Core_User::role_user; ?>"></option><option value="<?php echo LetoDMS_Core_User::role_admin; ?>"><?php printMLText("role_admin"); ?></option><option value="<?php echo LetoDMS_Core_User::role_guest; ?>"><?php printMLText("role_guest"); ?></option></select></td> 


In "out/out.UsrMgr.php" file change line 267
PHP Code:
<td><select name="role"><option value="<?= LetoDMS_Core_User::role_user ?>"></option><option value="<?= LetoDMS_Core_User::role_admin ?>" <?php if($currUser->getRole() == LetoDMS_Core_User::role_admin) echo "selected"; ?>><?php printMLText("role_admin"); ?></option><option value="<?= LetoDMS_Core_User::role_guest ?>" <?php if($currUser->getRole() == LetoDMS_Core_User::role_guest) echo "selected"; ?>><?php printMLText("role_guest"); ?></option></select></td> 
to
PHP Code:
<td><select name="role"><option value="<?php echo LetoDMS_Core_User::role_user; ?>"></option><option value="<?php echo LetoDMS_Core_User::role_admin; ?>" <?php if($currUser->getRole() == LetoDMS_Core_User::role_admin) echo "selected"; ?>><?php printMLText("role_admin"); ?></option><option value="<?php echo LetoDMS_Core_User::role_guest; ?>" <?php if($currUser->getRole() == LetoDMS_Core_User::role_guest) echo "selected"; ?>><?php printMLText("role_guest"); ?></option></select></td> 



Doudoux

RE: Error msg when editing user details. - caos - 05-12-2011

(05-04-2011, 07:14 AM)caos Wrote:
(04-28-2011, 06:15 PM)caos Wrote:
(04-28-2011, 07:44 AM)administrator Wrote: [quote='caos' pid='1295' dateline='1303933488']
Hi everyone
firstly im sorry if i sound like a clueless chook without an idea as i am a relative new born to web sites scripts etc etc etc...

i installed letodms 3.0 Rc5 and after i got everything work finally (After hours of trying to figure it out)
now every time i edit or add user details i get an error message :
''
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?= LetoDMS_Core_User::role_user ?> WHERE id = 3' at line 1
UPDATE tblUsers SET role = <?= LetoDMS_Core_User::role_user ?> WHERE id = 3

Warning: Cannot modify header information - headers already sent by (output started at X:\XXX\xampp\htdocs\XXXX\LetoDMS_Core\Core\inc.DBAccess.php:154) in X:\XXX\XXX\htdocs\XXX\op\op.UsrMgr.php on line 232
''

( XXX are the paths i just coverd up Smile )
this is gibberish to me so i dont know the exact problem is but i do remember getting similar errors from previous letodms releases when i tried to edit description and information of the documents within the DMS.
i downloaded the check.php and got no errors or faults??
my system is as follows

windows server Apache Mysql and PhP (xampp)

any help would be apprciatedConfused

Quote:hi thank you for trying LetoDMS

We appreciate your support.

ok i analyzed your problem i want you to try this . delete the database . and make a another database and import letodms database to mysql

and update the config file , with brand new database name

and try again

and please post your setting file on here. so we can make sure you have the right path in config file

thanks





LetoDMS team.

Done all that deleted the database created new one (UTF-8) and imported the tables create_tables.sql file then updated the conf file with the new details. and again when i try to edit the admin information and add a picture i get the same error.

PhP 5.3.1
Mysql 5.1.41
Apache 2.2.14 (win32)

Any solution to the problem????

Check Apache configuration

Apache version: Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_jk/1.2.28 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1

mod_rewrite : Ok
Check PHP configuration

PHP version: 5.3.1

gd2 : Ok
mbstring : Ok
database - mysql - : Ok
ldap (optional) : Error
Active PHP extension: php_ldap (optional)

Check LetoDMS configuration

settings->_rootDir : Ok
settings->_coreDir : Ok
settings->_httpRoot : Ok
settings->_ADOdbPath : Ok
database : Ok
LetoDMS version: 3.0.0 (2011-05-11 11:36:21)

database : Ok
Check other configuration

Cookies : OK
Informations

Limit size for uploading file (upload_max_filesize): 928M

Limit size for uploading file (post_max_size): 128M

SMTP server (SMTP): localhost

Limits of the execution time (max_execution_time): 60 s

Safe mode (safe_mode): OK

Open Basedir (open_basedir): OK

END
(05-05-2011, 05:13 AM)Doudoux Wrote: Hi

In "out/out.UsrMgr.php" file change line 142
PHP Code:
<td><select name="role"><option value="<?= LetoDMS_Core_User::role_user ?>"></option><option value="<?= LetoDMS_Core_User::role_admin ?>"><?php printMLText("role_admin"); ?></option><option value="<?= LetoDMS_Core_User::role_guest ?>"><?php printMLText("role_guest"); ?></option></select></td> 
to
PHP Code:
<td><select name="role"><option value="<?php echo LetoDMS_Core_User::role_user; ?>"></option><option value="<?php echo LetoDMS_Core_User::role_admin; ?>"><?php printMLText("role_admin"); ?></option><option value="<?php echo LetoDMS_Core_User::role_guest; ?>"><?php printMLText("role_guest"); ?></option></select></td> 


In "out/out.UsrMgr.php" file change line 267
PHP Code:
<td><select name="role"><option value="<?= LetoDMS_Core_User::role_user ?>"></option><option value="<?= LetoDMS_Core_User::role_admin ?>" <?php if($currUser->getRole() == LetoDMS_Core_User::role_admin) echo "selected"; ?>><?php printMLText("role_admin"); ?></option><option value="<?= LetoDMS_Core_User::role_guest ?>" <?php if($currUser->getRole() == LetoDMS_Core_User::role_guest) echo "selected"; ?>><?php printMLText("role_guest"); ?></option></select></td> 
to
PHP Code:
<td><select name="role"><option value="<?php echo LetoDMS_Core_User::role_user; ?>"></option><option value="<?php echo LetoDMS_Core_User::role_admin; ?>" <?php if($currUser->getRole() == LetoDMS_Core_User::role_admin) echo "selected"; ?>><?php printMLText("role_admin"); ?></option><option value="<?php echo LetoDMS_Core_User::role_guest; ?>" <?php if($currUser->getRole() == LetoDMS_Core_User::role_guest) echo "selected"; ?>><?php printMLText("role_guest"); ?></option></select></td> 



Doudoux

Did all that Doudoux,
getting this error now Sad

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?= LetoDMS_Core_User::role_admin ?> WHERE id = 1' at line 1
UPDATE tblUsers SET role = <?= LetoDMS_Core_User::role_admin ?> WHERE id = 1

Warning: Cannot modify header information - headers already sent by (output started at D:\web\xampp\htdocs\library\LetoDMS_Core\Core\inc.DBAccess.php:154) in D:\web\xampp\htdocs\library\op\op.UsrMgr.php on line 232...

arrrrr is it just me that can get this script to work... Sad(
Ok tried adding a new user with admin privileges . after i log in with the new user account i tired to edit other users information and the errors seem to be gone ???? but when editing other users logged in as admin the error returns...

RE: Error msg when editing user details. - Doudoux - 05-12-2011

hi

your database is maybe corrupted.

can you restart with an empty database ?

doudoux

RE: Error msg when editing user details. - pimotl - 05-29-2011

(05-12-2011, 09:03 PM)Doudoux Wrote: hi

your database is maybe corrupted.

can you restart with an empty database ?

doudoux
Hi, Doudoux.
No.
Database is not corrupted.
So..after two fresh installations on different computers/platforms.. the error is quite the same when trying to edit some user detail..
check.php [ offered at http://forums.letodms.com/showthread.php?tid=244 ] shows everything is OK.
Has someone pinpointed the bug Huh?
---
I've observed that in spite of the displayed error..the changes are made.


RE: Error msg when editing user details. - caos - 05-29-2011

(05-29-2011, 02:42 AM)pimotl Wrote:
(05-12-2011, 09:03 PM)Doudoux Wrote: hi

your database is maybe corrupted.

can you restart with an empty database ?

doudoux
Hi, Doudoux.
No.
Database is not corrupted.
So..after two fresh installations on different computers/platforms.. the error is quite the same when trying to edit some user detail..
check.php [ offered at http://forums.letodms.com/showthread.php?tid=244 ] shows everything is OK.
Has someone pinpointed the bug Huh?
---
I've observed that in spite of the displayed error..the changes are made.

Same still same error after 3 fresh installs letodms and 2 intalls of XAMPP.
the funny thing is now it wont let me upload files Sad((( a wellll i still continue to search for a DMS system... i really like LetoDMS simplicity and uncluttered layout but just about to rip all my hair out on my head trying to get it work :/