(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 
)
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 apprciated
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>
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>
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
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...
(
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...
?