Search error

[DaRichMan]

After entering a search value I get this error;

http://......./forms/%3C?=$_SERVER['PHP_SELF']?>

Any ideas ?

[Ben]

Where does this error occur, exactly? In Form Tools?

- Ben

[DaRichMan]

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

[Ben]

Do you have any other problems with the script besides this? What version of Form Tools are you using?

- Ben

[DaRichMan]

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?

[Ben]

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

[DaRichMan]

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

[Ben]

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