#108 OPT 1.1: Db Error

[Martin Vernooij]

My first user started working on OPT MAX 1.1 by
entering some data in timesheets. I received the
following error (by (email):

The OPT system at www.somesite.com issued a database error:
--------------------------
The following query failed:
select count(*) num from company2project where
company=1 and project=n/a
and role='Developer'
Unknown column 'n' in 'where clause'
--------------------------
This error occured while abc def was accessing
/OPT/documents/leftMenu/?proj=n/a&doc=0&dir=n/a
The user came here from
https://www.somesite.com/OPT/index.php?OPT_Session=510afd1ec5f1ba4013504d7877665299
OPT 1.1.0 Max
GET variables:
proj = n/a
doc = 0
dir = n/a

Register globals: Off
User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows
NT 5.0)

Does this mean the use made a mistake by e.g. not
selecting a project, or is this more general? There are
2 projects and around 50 tasks in the system defined.

Thanks, Martin.

[Anonymous]

Logged In: YES
user_id=22084

This is definitely a bug. A user shouldn't be able to cause
it. I've been trying to track down the exact navigation
steps users are doing to cause this error for a week or two
now. I hope to have this fixed in the next release. Thanks
for reporting it.

Guy

[Martin Vernooij]

Logged In: YES
user_id=608879

Oke, have some additional info about this. This error seems
to happen when uploading 'big' files e.g. to the project ->
document area.

In php.ini I have post_max_size = 8M

However in my apache error log I have an error:
[Tue Oct 7 18:15:36 2003] [error] PHP Warning:
upload_max_filesize of 2097152 bytes exceeded - file
[data=C:\somefile.ppt] not saved in Unknown on line 0

As an administrator I receive an email with the OPT error:
The OPT system at www.somehost.com issued a database error:
--------------------------
The following query failed:
select count(*) num from company2project where company=1 and
project=n/a
and role='Developer'
Unknown column 'n' in 'where clause'
--------------------------
This error occured while abc def was accessing
/OPT/documents/leftMenu/?proj=n/a&doc=0&dir=n/a
The user came here from
https://www.somesite.com/OPT/index.php?OPT_Session=efb2a6a7f8b70da090c51df088f51e2b
OPT 1.1.0 Max
GET variables:
proj = n/a
doc = 0
dir = n/a

Register globals: Off
User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.0; .NET CLR
1.1.4322)

Perhaps this helps narrowing down this issue. I couldn't
find any setting limiting the upload to 2M. I do have quite
some files that need to be uploaded of a much bigger size.....

Thanks, Martin

[Anonymous]

Logged In: YES
user_id=22084

This could also be caused by someone uploading a document
with no title. Basically the problem was the left menu was
loading before enough checks had been performed. I've fixed
this issue now.

You'll still want to change your php.ini to allow your users
to upload large files. See the mailing list archives for
examples of which settings to change. This has come up many
times.

Thanks for pointing out this SQL error. It will be fixed in
the next release.