Login or Register

RSS IconRecent posts in this topic

avatar
umcna on Jul 19. 2007. 4:17 pm
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!
avatar Staff
Ilija Studen on Jul 21. 2007. 1:17 am
You are having problems with image resizing. Turn debugging On (here are the instructions) and post the error message thrown by PHP.
activeCollab Team Member
avatar
umcna on Jul 26. 2007. 10:52 am
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?
avatar Staff
Ilija Studen on Jul 26. 2007. 1:01 pm
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.
activeCollab Team Member
avatar
umcna on Jul 26. 2007. 2:12 pm
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
avatar
umcna on Jul 27. 2007. 9:18 am
Recompiling PHP5 with an explicit --with-gd=/dir fixed the problem. Thanks again!
Topic is locked. If you have something important to say about issues discussed on this page please write at hi@a51dev.com.

RSS IconRecent posts in this topic