Posts: 2,456
Threads: 39
Joined: Dec 2008
Reputation:
6
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
Posts: 41
Threads: 15
Joined: Jul 2009
Reputation:
0
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,
Posts: 2,456
Threads: 39
Joined: Dec 2008
Reputation:
6
Oct 19th, 2011, 9:23 AM
(This post was last modified: Oct 19th, 2011, 9:45 AM by Ben.)
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
Posts: 6
Threads: 1
Joined: Aug 2011
Reputation:
0
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.
Posts: 41
Threads: 15
Joined: Jul 2009
Reputation:
0
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.
