Aug 17th, 2011, 2:44 PM (This post was last modified: Aug 17th, 2011, 2:48 PM by filch.)
I am trying to move the tables from one working install of formtools to another install on a different server, with the intention of deleting all the forms from formtools on the new destination server that are not relative to the new server. So I created a new empty database on the new server and then exported all the tables from the source server and imported them into the new database on the destination server. I updated the config.php file to reflect the new servers db connection requirements.
I renamed the install folder so the script does not try to re-install the database tables. When I go to the new site, I get a "The page isn't redirecting properly" error.
Seems to me I saw a solution for that here sometime back Ben but I searched for it and came up empty.
Can you help me out with this Ben?
Dave
Safari produces an interesting error. See attached.
Well I resolved the not directing thing by installing a fresh copy and them importing individual tables. Note to Ben: what a great idea for a module. The transport or copy module to move one form from one server to another.
At any rate, now I cannot get the form to submit to formtools. I've tried everything. Then I tried adding a new instance of this form but I cannot even get formtools to complete the test submission. Not even in test mode. Won't open the thank you page. When I submit it just clears the form and reloads the page.
I am just a tad frustrated with this. Moving sites and changing servers really really sucks!!!
Anyway Ben, if you can help me figure out why this form will not talk to the api I would sincerely appreciate it.
Yeah, moving servers is a total pain. Especially with 2.0.x: the "page not redirecting" error is such a nuisance to debug.
So what you did first time 'round was totally right. The redirect problem is usually caused by the settings in the config.php file not being correct after the move. Once that's resolved, you'd need to look through the database and update all paths & URLs.
Regarding your current problem I'm not sure... it actually sounds like a problem with the form itself and not anything else. If you like, I can help debug the problem directly on your site. Failing that, could you post your forms so I could take a look (or email me them)?
Quote:Note to Ben: what a great idea for a module. The transport or copy module to move one form from one server to another.
I TOTALLY agree. As you can imagine, I do a great deal of testing - new installations, new form configurations etc. I've wanted to write some sort of export/import mechanism for entire forms for a long time. Did I mention the end goal of this? Well, in short, I want to create not just the import/export for form data (probably in XML format), but a "form market" on this site where people can post their forms & configurations. That way you just browse, find a form that's something like what you want, then import it.
That's the goal. It's a long way off yet, but we're getting there.
Ben, I am in a serious bind here as I need to get these sites moved by this evening. I have spoken to the support people for these servers and they are using suphp, which may or may not be causing some problems. Basically it allows php to execute as the user/owner of webasite. I initially, as you know, was trying to run one instance of formtools on a server and have all sites on that server use this one instance. I have not had much luck with these servers for that, I think because of this suphp. So, I figured I would simply install an instance for each site ( a pain ) but even when I do that and try to make the initial test submission, the form page simply refreshes and reloads itself without seemingly talking to the API at all.
I sincerely would appreciate any insight you can provide here as it is getting a bit desperate.
Aug 19th, 2011, 2:45 PM (This post was last modified: Aug 19th, 2011, 3:00 PM by filch.)
Well, trying to get to the bottom of this, I have added var_dump($params) to the top and all of that seems to be fine. However, it simply will not call the api. I really am stumped!!
I put an echo statement in the api and it shows that it is indeed being included but absolutely nothing is happening.
So then I went to my other new server where I had installed formtools as a single instance and tried to submit a form that I had already configured and I got the following ( see attachment ). The only thing that is different from any other formtools install I have is the version: 2.1.0. Could there be an issue with this?
Aug 20th, 2011, 8:46 AM (This post was last modified: Aug 20th, 2011, 8:56 AM by filch.)
I am going to keep asking questions until I get to the bottom of this ;-(
I have decided to try going back to 2.0.6 as this was the last known version that ran, at least on my other servers. However, after downloaded several times, making sure I was getting core 2.0.6 and api 1.01, every time I go to install, the version shown is 2.1.0. I know where to check the version of the api but where can I check the version of the core that is on the server?
Dave
I feel like I'm having a conversation with myself here :-)
Ben, are yu entirely sure that your download section is not incorrectly adding the 2.1.0 core even though I am asking for the 2.06? I have just verified that even though I downloaded and installed what should have been core 2.0.6, it is actually 2.1.0. Very very frustrating this!
Aug 21st, 2011, 1:05 PM (This post was last modified: Aug 21st, 2011, 2:01 PM by filch.)
So now I have discovered that it almost works if I use the process.php script. At least I can create the form. However, when I try and submit something I get: Table 'streetk_formtools.ft_form_2_history' doesn't exist. I have installed this from scratch a few times and as noted in other crazed rants in previous posts, eben when I wanted to downgrade to 2.0.6, I was unable to.
I do not really want to use the process.php method but I need to get SOMETHING going.
Please, if anyone has any insight as to what the hell is going on here, I would really appreciate it.
Dave
(Aug 21st, 2011, 1:05 PM)filch Wrote: So now I have discovered that it almost works if I use the process.php script. At least I can create the form. However, when I try and submit something I get: Table 'streetk_formtools.ft_form_2_history' doesn't exist. I have installed this from scratch a few times and as noted in other crazed rants in previous posts, even when I wanted to downgrade to 2.0.6, I was unable to.
I do not really want to use the process.php method but I need to get SOMETHING going.
Please, if anyone has any insight as to what the hell is going on here, I would really appreciate it.
Dave
OK, for other who may come across this error "Table 'streetk_formtools.ft_form_2_history' doesn't exist", this was due to the module Client Submissions. Not sure but I guess it is not compatible with 2.1.0?? Disabling it made the error go away.
Dave
Ben,
I am becoming more and more convinced that the problem I am having is that out-of-the-box, Formtools will not run, using the API, on a server using suPHP. What is your opinion about this?
Drat, yes there's a problem with the custom build script. I'll look into that as soon as I can. In the meantime, here's a direct link to the file: http://www.formtools.org/files/FormTools2.0.6.zip
Quote:However, when I try and submit something I get: Table 'streetk_formtools.ft_form_2_history'
This sounds like a problem with the Submission History table. A hook is being called that's attempting to add a record to the history table, but the table doesn't exist. Try disabling or re-installing the Submission History module.
Regarding compatibility with suPHP, I really just don't know.. I've never heard of it before, but unless they're doing something extremely strange (doesn't look like it from the site), FT should be compatible.
You around tonight? Feel free to email me ben.keen@gmail.com and I'll see if I can help out for a bit.
