+- 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: Search error (/showthread.php?tid=1430)
Search error - DaRichMan - Jul 1st, 2011
After entering a search value I get this error;
http://......./forms/%3C?=$_SERVER['PHP_SELF']?>
Any ideas ?
RE: Search error - Ben - Jul 1st, 2011
Where does this error occur, exactly? In Form Tools?
- Ben
RE: Search error - DaRichMan - Jul 3rd, 2011
(Jul 1st, 2011, 7:31 AM)Ben Wrote: Where does this error occur, exactly? In Form Tools?
- Ben
When I enter a search entry in one (any) of my forms and hit enter
RE: Search error - Ben - Jul 4th, 2011
Do you have any other problems with the script besides this? What version of Form Tools are you using?
- Ben
RE: Search error - DaRichMan - Jul 6th, 2011
(Jul 4th, 2011, 6:40 AM)Ben Wrote: Do you have any other problems with the script besides this? What version of Form Tools are you using?
- Ben
Everything else works fine but it's a very old version, 1.4.5
Is there a way to migrate to a newer version? Or to install a newer version and import the forms and the entries?
RE: Search error - Ben - Jul 6th, 2011
Ah... I see! Wow, that *is* an old version! Nice to see people get mileage out of it, though.
Yes, you can update to Form Tools 2.0.6 using the FT1 Data Import module, but unfortunately it's not really an upgrade. Form Tools 1 and 2 are very different so that module merely imports the data from your old database into the new one. There are also other limitations, and you'd need to reconfigure your forms to point to the new Form Tools 2 database. So yeah, it's a bit of work - take a look at the help doc for more info.
But to address your original problem, it looks like maybe PHP Short Tags are disabled on your system. Short tags let you enter PHP code like so:
<?= ... ?>
Instead of the more long-winded:
<?php echo ... ?>
I believe I'd removed all short tags by 1.5.0, but you could just manually replace it yourself. Edit the file with the problem and change:
<?=$_SERVER['PHP_SELF']?>
to:
<?php echo $_SERVER["PHP_SELF"]; ?>
You may find that that fixes it.
I wish I could be more help... but good luck!
- Ben
RE: Search error - DaRichMan - Jul 6th, 2011
(Jul 6th, 2011, 1:07 PM)Ben Wrote: Ah... I see! Wow, that *is* an old version! Nice to see people get mileage out of it, though.
Yes, you can update to Form Tools 2.0.6 using the FT1 Data Import module, but unfortunately it's not really an upgrade. Form Tools 1 and 2 are very different so that module merely imports the data from your old database into the new one. There are also other limitations, and you'd need to reconfigure your forms to point to the new Form Tools 2 database. So yeah, it's a bit of work - take a look at the help doc for more info.
But to address your original problem, it looks like maybe PHP Short Tags are disabled on your system. Short tags let you enter PHP code like so:
<?= ... ?>
Instead of the more long-winded:
<?php echo ... ?>
I believe I'd removed all short tags by 1.5.0, but you could just manually replace it yourself. Edit the file with the problem and change:
<?=$_SERVER['PHP_SELF']?>
to:
<?php echo $_SERVER["PHP_SELF"]; ?>
You may find that that fixes it.
I wish I could be more help... but good luck!
- Ben
We do not meet the requirements for upgrading;
You are running Form Tools 1.5.0 or 1.5.1. This module only imports the data from those two versions.
I tried <?php echo $_SERVER["PHP_SELF"]; ?> but this gives me an other error;
get_form, failed query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
RE: Search error - Ben - Jul 8th, 2011
Quote:I tried <?php echo $_SERVER["PHP_SELF"]; ?> but this gives me an other error;
get_form, failed query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Hmm... sorry, I think you must have been editing a code file, not the template with the form in it.
I'm really, really sorry, but we just don't support 1.x versions any more - Form Tools 2 has been around for years now and we have a hard enough time supporting this version!
I'm afraid you'll need to find a programmer to look at it for you. I'm very sorry.
- Ben