+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Another File Upload Problem (/showthread.php?tid=1683)
RE: Another File Upload Problem - Ben - Oct 18th, 2011
No worries - I'm extremely sorry it came at such a poor time.
Your Export Manager problem has actually uncovered something very big. I'm still working it through, but there's definitely a problem with the Core & module update functionality.
- Ben
RE: Another File Upload Problem - dethompsOWU - Oct 19th, 2011
Okay...just ran the Database Integrity module and, sure enough, the error log lists:
FORM TOOLS CORE - ft_hook_calls - Invalid column: action_location
- is: enum('start','end')
- should be: varchar(100)
Everything else passed.
I don't recall exactly when I installed FormTools 2, but I definitely waited until it was non-beta, since I wanted to use it in a production environment.
Hope this info helps,
RE: Another File Upload Problem - Ben - Oct 19th, 2011
Hi Doug,
Yup, that's the culprit - same as Jeff (and other's, apparently).
So it turns out this is actually a very old bug, that just one didn't cause any issues until now.
The "action_location" field in the database was changed to a varchar (of size 100) back in a late version of the 2.0.0 Beta. However, other people who *weren't* running that version still encountered the problem, which implies that it was re-introduced by mistake at some point. I haven't yet identified when it occurred (I've checked most of the main builds).
That field stores information about the hook, namely, at what location in the code/template the code should get executed. The old value for the field was "start" and "end", which covers most scenarios. So in most cases it would work fine. But both the Export Manager and File Upload fields rely on setting *different* values for that field, so simply put: neither get called! File uploads don't take place and the Export Manager doesn't show up. Same problem.
In order to fix it, we need to do a manual update to your database. I can't automate it because the data itself (i.e. the values in that field) need to be fixed in some cases.
EDIT: I'm going to review each module now and come up with a general solution that assesses what you have installed then only upgrade the pertinent rows. This'll work for other people encountering the problem. I'll post back when I have it completed.
- Ben
RE: Another File Upload Problem - KevinACrider - Nov 1st, 2011
This may or may not be related, but I thought I would post it here to get some help. I have a form with a file upload field and the files are uploading to the server fine. My problem is the email that is sent after the submission is not including a link to the uploaded file. If this is not related, I can start my own thread.
RE: Another File Upload Problem - dethompsOWU - Nov 1st, 2011
I just realized I never posted back that Ben's last fix fixed all my issues!
Thanks, Ben, for all your amazingly quick work on this.
RE: Another File Upload Problem - Ben - Nov 3rd, 2011
(Nov 1st, 2011, 5:47 AM)KevinACrider Wrote: This may or may not be related, but I thought I would post it here to get some help. I have a form with a file upload field and the files are uploading to the server fine. My problem is the email that is sent after the submission is not including a link to the uploaded file. If this is not related, I can start my own thread.
Hi Kevin,
(Sorry for the long response time!). I think this is probably unrelated. Give this page a read over:
http://modules.formtools.org/field_type_file/documentation.php?page=debugging
It contains some tips to figure out why the files aren't uploading. If you're still having trouble, start another thread and we'll go from there.
- Ben