Messages

121

Feature requests / Re: Full-text search in uploaded documents

« on: February 08, 2009, 04:32:33 pm »

Perhaps bringing an existing full text search tool to OpenGoo would make things easier.

Besides Lucene, i think Swish-e (http://swish-e.org) and Sphinx (http://www.sphinxsearch.com) could come in handy.

Nuno.

122

Feature requests / Re: handling large files

« on: February 05, 2009, 10:32:55 pm »

I have sent you a message yesterday regarding this subject.
Once you find some time to answer, bring it on.

We are utmost interested in this feature

Nuno.

123

Feature requests / Re: handling large files

« on: January 29, 2009, 01:19:07 pm »

My scripting knowledge does go that far as to implement uberuploader
But, if you welcome bribery, we could $ponsor that feature entirely.

The websserver i tend to set up lately is Nginx (with PHP/FastCGI), because of its outstanding performance even on tight resources.
Nginx is also configured to accept file uploads up to 30 MB (it has a special directive to address that).
The issue i have reported only happens with larger files.
I'll try the same operatio under Apache2.

124

Feature requests / handling large files

« on: January 28, 2009, 05:57:28 pm »

The way OpenGoo handles file uploads is very inefficient when files larger than 10 MB have to be stored.

I have my php.ini file set to process up to 30 MB, with really large values for max_execution_time, max_input_time and memory_limit, besides 30 M for upload_max_filesize and post_max_size

When i try to upload a 15 MB file (a PPS slideshow), the upload process halts at some point and nothing happens.

As far as i know, PERL handles file uploads through HTTP way better than PHP.
You should consider adding a tool like Uberuploader, which features a net progress bar and works a treat.
http://uber-uploader.sourceforge.net/

[EDIT]

The file is ultimately uploaded as a physical object to /uploads/, but OpenGoo 1.2 Beta does not add it.
Might be a bug.

125

Feng Office 1 / Re: 1.1 - upgrade - db query error

« on: January 12, 2009, 08:53:50 pm »

Did you run the upgrade process from version 1.0 to 1.1 by going to <your_opengoo>/public/upgrade? Did it give any errors? Were you using version 1.0?

Precisely. It was a 1.0 -> 1.1 upgrade.

I have downloaded 1.1, copied the files from public/upgrade over to the previous 1.0 installation and then ran the script.
Am i supposed to do anything else?

Thanks.

126

Feng Office 1 / 1.1 - upgrade - db query error

« on: January 11, 2009, 08:29:29 pm »

Upgrading from 1.0 to 1.1 using the upgrade script has ended up in tragedy.

Code: [Select]

uery failed with message 'Unknown column 'project_id' in 'where clause''
Error params:
File: /var/www/path_to/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 371
Sql: SELECT * FROM `og_application_logs` WHERE `is_private` <= '1' AND `is_silent` <= '1' AND `project_id` IN ('1', '2') ORDER BY `created_on` DESC LIMIT 0, 15
Error number: 1054
Error message: Unknown column 'project_id' in 'where clause'
Backtrace:
#0 /var/www/path_to/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php(289): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /var/www/path_to/opengoo/environment/library/database/DB.class.php(194): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /var/www/path_to/opengoo/environment/classes/dataaccess/DataManager.class.php(182): DB::executeAll('SELECT * FROM `...')
#3 /var/www/path_to/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(101): DataManager->find(Array)
#4 /var/www/path_to/opengoo/environment/classes/dataaccess/DataManager.class.php(210): BaseApplicationLogs->find(Array)
#5 /var/www/path_to/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(118): DataManager->findAll(Array)
#6 /var/www/path_to/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(120): BaseApplicationLogs->findAll(Array)
#7 /var/www/path_to/opengoo/application/models/application_logs/ApplicationLogs.class.php(174): BaseApplicationLogs::findAll(Array)
#8 /var/www/path_to/opengoo/application/controllers/DashboardController.class.php(52): ApplicationLogs::getOverallLogs(true, true, Array, 15)
#9 /var/www/path_to/opengoo/environment/classes/controller/Controller.class.php(69): DashboardController->index()
#10 /var/www/path_to/opengoo/environment/classes/controller/PageController.class.php(62): Controller->execute('index')
#11 /var/www/path_to/opengoo/environment/classes/Env.class.php(157): PageController->execute('index')
#12 /var/www/path_to/opengoo/init.php(151): Env::executeAction('dashboard', 'index')
#13 /var/www/path_to/opengoo/index.php(9): require('/var/www/egw.re...')
#14 {main}
Autoglobal varibles:
$_GET:
$_POST:
$_COOKIE: Array (
  ['id'] => (string) '1'
  ['token'] => (string) '797045cbe4075a5bf7773a0fcd8b71c2ac4016b0'
  ['remember'] => (string) '1'
  ['PHPSESSID'] => (string) '2291ec16fe25a70c11823e9a89dbf81c'
)
$_SESSION: Array (
  ['cal_version'] => true
  ['month'] => (string) '1'
  ['year'] => (string) '2009'
  ['day'] => (string) '11'
)
Execution time:
Total execution time: 0.078031 seconds

127

Feng Office 1 / Re: Failed to upload file

« on: December 19, 2008, 08:07:25 pm »

It's a pain to upload files through PHP.
I have php.ini set up with really high values and still Opengoo hangs with a 6 MB file.

Here are my current settings:

max_execution_time = 900
max_input_time = 1800
memory_limit = 128M

upload_max_filesize = 20M
post_max_size = 20M

A Perl based upload script would do a much better job.
Something like Uberuploader.

Nuno.