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

(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.

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

(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????

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

your database is maybe corrupted.

can you restart with an empty database ?

doudoux

(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 ?
---
I've observed that in spite of the displayed error..the changes are made.