aC forum: Avatars and Images not working - fail to upload

Post #6 by umcna

umcna — Fri, 27 Jul 2007 14:18:19 UTC

Recompiling PHP5 with an explicit --with-gd=/dir fixed the problem. Thanks again!

Post #5 by umcna

umcna — Thu, 26 Jul 2007 19:12:06 UTC

Thanks! I'm the host so I'll check into that tonight. While were at it. My set up presently runs PHP4 and then PHP5 on a virt server. Do you think that is causing this error. Usually flushing the cache and reopening the browser fixes this issue. Is it not related? Thanks again for the quick support!

Query failed with message 'Lock wait timeout exceeded; try restarting transaction'
Error params:
File: /usr/www/activecollab/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 371
Sql: UPDATE `ac_users` SET `updated_on` = '2007-07-26 19:06:56', `last_activity` = '2007-07-26 19:06:56' WHERE `id` = '7'
Error number: 1205
Error message: Lock wait timeout exceeded; try restarting transaction
Backtrace:
#0 /usr/www/activecollab/environment/library/database/adapters/AbstractDBAdapter.class.php(257): AbstractDBAdapter->prepareAndExecute('UPDATE `ac_user...', NULL)
#1 /usr/www/activecollab/environment/library/database/DB.class.php(139): AbstractDBAdapter->execute('UPDATE `ac_user...', NULL)
#2 /usr/www/activecollab/environment/classes/dataaccess/DataObject.class.php(594): DB::execute('UPDATE `ac_user...')
#3 /usr/www/activecollab/environment/classes/dataaccess/DataObject.class.php(408): DataObject->doSave()
#4 /usr/www/activecollab/application/models/CompanyWebsite.class.php(218): DataObject->save()
#5 /usr/www/activecollab/application/models/CompanyWebsite.class.php(123): CompanyWebsite->setLoggedUser(Object(User), false, true)
#6 /usr/www/activecollab/application/models/CompanyWebsite.class.php(47): CompanyWebsite->initLoggedUser()
#7 /usr/www/activecollab/application/models/CompanyWebsite.class.php(49): CompanyWebsite->init()
#8 /usr/www/activecollab/application/application.php(21): CompanyWebsite::init()
#9 /usr/www/activecollab/init.php(125): require_once('/usr/www/active...')
#10 /usr/www/activecollab/index.php(9): require('/usr/www/active...')
#11 {main}
Autoglobal varibles:
$_GET: Array (
['c'] => (string) 'access'
['a'] => (string) 'login'
)
$_POST:
$_COOKIE: Array (
['id'] => (string) '7'
['token'] => (string) '041f355093c3d267142b17a3411c28d35ef68a08'
)
$_SESSION:
Execution time:
Total execution time: 50.138470888138 seconds

Post #4 by Ilija Studen

Ilija Studen — Thu, 26 Jul 2007 18:01:59 UTC

If imagecreatefromjpeg() is missing than you most probably don't have GD2 installed. Try contacting your hosting provider to see if that is true and if they can fix the problem. Without GD activeCollab cannot resize images - avatars, logos and file uploads.

Post #3 by umcna

umcna — Thu, 26 Jul 2007 15:52:42 UTC

Firstly, Ilija, you rock! Thanks for being there and for your support. I've enable debug and when I attempted to upload I got:

Fatal error: Call to undefined function imagecreatefromjpeg() in /usr/www/activecollab/library/simplegd/classes/SimpleGdImage.class.php on line 113

Perhaps I've got a bad GD install in my PHP5 installation?

Post #2 by Ilija Studen

Ilija Studen — Sat, 21 Jul 2007 06:17:19 UTC

You are having problems with image resizing. Turn debugging On (here are the instructions) and post the error message thrown by PHP.

Post #1 by umcna

umcna — Thu, 19 Jul 2007 21:17:46 UTC

I've searched the archives to no avail. I'm running AC .71 using handbuild apache 2.2.4/php5.2.3 MySQL 4.1, AC config'd such that File Storage: Database(MySQL).

File uploads appear to work execpt for images. When I upload an image as a file inside a project and then click on it, it shows the file as uploaded by the html target is empty and the div tags are not closed.

I've removed the carats from the viewed source below (url=http://activecollab.umcna.org/index.php?c=files&a=file_details&id=5&active_project=3):

div id="fileDetails" class="block"
div class="private" title="Private file" span Private file /span /div
div class="header" daemon-150.jpg /div
div class="content"
div id="fileIcon" img src="

That's it, no more html on the page.

Moreover, correctly sized jpg or png (50x50px - not interlaced), fail to upload and redirect url goes wierd to the point that I have to close the webpage, dump cookies and log back in. Same goes for company logos too.

Is there a way to upload (not using the web mechanism) the avatars and add an entry in the user table in the db?

TIA in advance and thanks for a great project management tool!