[moregroupware-tracker] [ moregroupware-Bugs-1441289 ] When trying to create a new folder for uploaded files:

[SourceForge.net <no...@so...>]

Bugs item #1441289, was opened at 2006-03-01 21:58
Message generated for change (Comment added) made by stanislawnalepa
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=404018&aid=1441289&group_id=32034

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: General
Group: default
Status: Open
Resolution: None
Priority: 5
Submitted By: Stan (stanislawnalepa)
Assigned to: Nobody/Anonymous (nobody)
Summary: When trying to create a new folder for uploaded files:

Initial Comment:

Problem in Moregroupware found!
Version (config.inc.php):	0.7.3 - Finally
Version (version.inc.php):	0.7.3 - Finally
PHP version:	4.4.2
PHP OS:	Linux
register_globals:	0
magic_quotes_gpc:	0
safe_mode:	1
sql.safe_mode:	0
Server software:	Apache/1.3.34 (Unix) Sun-ONE-ASP/4.0.2
PHP/4.4.2 mod_ssl/2.8.25 OpenSSL/0.9.6b
FrontPage/5.0.2.2635 mod_throttle/3.1.2
User-Agent:	Mozilla/5.0 (Windows; U; Win 9x 4.90;
sv-SE; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1
session.use_trans_sid:	1
session.auto_start:	0
file_uploads:	1
upload_max_filesize:	100M
upload_tmp_dir:	
memory_limit:	20M
post_max_size:	19M
max_execution_time:	30
max_input_time:	-1
magic_quotes_runtime:	0
Database:	mysql / 4.0.26-standard-log (4.0.26)
Program:	/moregroupware/modules/files/index.php
File:	(I've deleted the full path, but it was here
originally)/moregroupware/modules/files/index.php
Line:	422

Error (SQL):
INSERT INTO mgw_files (id, type, resides_in, project,
category, owner, name, size, mime_type, owner_rights,
all_rights, created, modified) VALUES (5, 'f', '0',
'0', '2','1', 'Textmaterial', , 'text/plain', 7, 1,
'2006-03-01 21:45:53', '2006-03-01 21:45:53')

Error (MSG):
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 ' 'text/plain', 7, 1,
'2006-03-01 21:45:53', '2006-03-01 21:45:5

Dump:
POST:

Array
(
    [MGWSESSION] => 00eb5e710b8b140461c6036e0e91b59d
    [action] => create
    [files] => Array
        (
            [file_type] => f
            [file_location] => 0
            [file_name] => Textmaterial
            [categoryid] => 2
            [file_content] => empty
            [all_rights] => Array
                (
                    [r] => on
                )

            [create] => Save
        )

    [grouprights] => Array
        (
            [50000] => Array
                (
                    [id] => 50000
                    [r] => on
                    [w] => on
                )

        )

)


GET:

Array
(
)

----------------------------------------------------------------------

>Comment By: Stan (stanislawnalepa)
Date: 2006-03-01 23:08

Message:
Logged In: YES 
user_id=1463741

OK - seems I have solved it by deleting the "files" folder
created by script and thus owned by httpd and replacing it
with a "files" folder created locally by ftp and thus being
owned by my account's user id.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=404018&aid=1441289&group_id=32034