File uploading error
This is an open discussion with 9 replies, filed under Troubleshooting.
Search
-
-
- creativedutchmen
- 17 Aug 10, 9:37 pm
- Comment #2
What version of symphony are you using?
-
-
- whgdesign
- 19 Aug 10, 6:17 am
- Comment #3
Version: 2.0.8RC3
-
-
- creativedutchmen
- 20 Aug 10, 1:02 am
- Comment #4
As a temporary fix, you can replace:
$meta['creation'] = DateTimeObj::get('c', filemtime($file));
on line 469 of symphony/lib/toolkit/fields/field.upload.php
with:
$meta['creation'] = DateTimeObj::get('c', @filemtime($file));
-
-
- whgdesign
- 21 Aug 10, 4:05 am
- Comment #5
I’ve changed the pice of code as you told me, but now I get this error:
Column 'size' cannot be null
An error occurred while attempting to execute the following query
* INSERT INTO `sym_entries_data_182` (`entry_id`, `file`, `mimetype`, `size`, `meta`) VALUES ('186', 'Test CV.doc', 'unknown', NULL, 'a:1:{s:8:"creation";s:25:"2010-08-20T18:02:44+00:00";}')
Backtrace:
* [/var/www/g33026/psy-match.nl/HTML/symphony/lib/toolkit/class.mysql.php:267] MySQL->__error();
* [/var/www/g33026/psy-match.nl/HTML/symphony/lib/toolkit/class.mysql.php:211] MySQL->query();
* [/var/www/g33026/psy-match.nl/HTML/symphony/lib/toolkit/class.entrymanager.php:147] MySQL->insert();
* [/var/www/g33026/psy-match.nl/HTML/symphony/lib/toolkit/class.entry.php:197] EntryManager->edit();
* [/var/www/g33026/psy-match.nl/HTML/symphony/lib/toolkit/events/event.section.php:125] Entry->commit();
* [/var/www/g33026/psy-match.nl/HTML/symphony/lib/toolkit/events/event.section.php:310] __doit();
* [/var/www/g33026/psy-match.nl/HTML/workspace/events/event.formulieren.php:145] include();
* [/var/www/g33026/psy-match.nl/HTML/workspace/events/event.formulieren.php:141] eventformulieren->__trigger();
* [/var/www/g33026/psy-match.nl/HTML/symphony/lib/toolkit/class.frontendpage.php:549] eventformulieren->load();
* [/var/www/g33026/psy-match.nl/HTML/symphony/lib/toolkit/class.frontendpage.php:233] FrontendPage->processEvents();
* [/var/www/g33026/psy-match.nl/HTML/symphony/lib/toolkit/class.frontendpage.php:63] FrontendPage->__buildPage();
* [/var/www/g33026/psy-match.nl/HTML/symphony/lib/core/class.frontend.php:50] FrontendPage->generate();
* [/var/www/g33026/psy-match.nl/HTML/index.php:25] Frontend->display();
-
-
- designermonkey
- 21 Aug 10, 5:25 am
- Comment #6
I’d just comment out the entire line, it’ll most likely work then…
-
-
- creativedutchmen
- 21 Aug 10, 6:52 am
- Comment #7
No, the line indicates the database is set too strict for the commented out line to work.
If you open up phpmyadmin, and allow the size field of table sym_entries_data_182 to be null, everything should work again.
-
-
- whgdesign
- 26 Aug 10, 8:14 am
- Comment #8
Inside the phpmyadmin I only have these fields inside the table sym_entries_data_182
- id
- entry_id
- handle
- value
-
-
- designermonkey
- 27 Aug 10, 12:00 am
- Comment #9
Well, I’ve commented out the line before and it worked… It was another extension and the exact same function and error…
-
-
- creativedutchmen
- 27 Aug 10, 3:46 am
- Comment #10
Inside the phpmyadmin I only have these fields inside the table symentriesdata_182
* id * entry_id * handle * value
That’s odd. What you could try is to set every size field in every table that contains one to allow null.
Create an account or sign in to comment.
When I try to upload a document like txt or rtf with the frontend I’ll get this error.
filemtime(): stat failed for /var/www/g33026/psy-match.nl/HTML/workspaceTest CV rtf.rtf An error occurred in /var/www/g33026/psy-match.nl/HTML/symphony/lib/toolkit/fields/field.upload.php around line 469 * 464: 'image/png', * 465: ); * 466: * 467: $meta = array(); * 468: * 469: $meta['creation'] = DateTimeObj::get('c', filemtime($file)); * 470: * 471: if(General::in_iarray($type, $imageMimeTypes) && $array = @getimagesize($file)){ * 472: $meta['width'] = $array[0]; * 473: $meta['height'] = $array[1];Backtrace
This is a piece of my source:
<div class="uploadfield"> <label>Voeg uw CV toe bij het formulier</label> <input type="file" name="fields[cv]" size="20"/> </div>Who is the guy can help me?