Hi All,
I need some help and not to stress to much but i am in a kind of time shortage.
I built the form and set all info to a correct settings for mysql db. But i receive the following error:

Your form could not be submitted for the following reason(s):

Warning: [ err 2/line 190/datasavecsv.cls.php] file_exists(): open_basedir restriction in effect. File(/sites/vh02/vankoten1.org/www/kandidaten reg/storage/csv/geregistreerde EHBO kandidaten1.csv) is not within the allowed path(s): (/sites/vh02/vankoten.org:/var/www:/usr/share/php)
Warning: [ err 2/line 192/datasavecsv.cls.php] rename(): open_basedir restriction in effect. File(/sites/vh02/vankoten1.org/www/kandidaten reg/storage/csv/geregistreerde EHBO kandidaten1.csv) is not within the allowed path(s): (/sites/vh02/vankoten.org:/var/www:/usr/share/php)
Failed to archive data file.
Failed to record the data because the server is too busy or doesn't have write permission.

Data is stored in the DB!!!!!!!! but why the errors and no showing of the confirmation page???

i changed the user and then i received this error:

Your form could not be submitted for the following reason(s):

Failed to open database [1045] SQLSTATE[28000] [1045] Access denied for user '2731_admin'@'web01-vz03.hostfx.eu' (using password: YES).

I have made the db and no tables as said in the forum with similar issues.

Please advise me.

test site: http://www.vankoten.org/ehbo_registratie.html


question 2:
How do I make a field that store a dutch zip code. it must be set as followed: 1234AA, four numerics and two uppercase or lowercase alpha
I tried with the reg. expression but do not know how to set the expression.

question 3:
Can i make a feature that checks if the user has allready stored their information? their should be a max of 4 possible entries with one email adress from one ip adress, example a company registers 4 people for a course.

The error looks like a CSV error. Did you select to save to csv also? If you did make sure there's a folder called storage in your myformname directory and that the permissions is set to allow access. Otherwise uncheck "Save to CSV"

Yes there is a storage directory and a csv file in it, which it seems to look like saves the data.
Any other possiblities?
I'll uncheck csv now to see what happens. In which file is this value set, or should I enter via prog. and uncheck it.


BTW, Have you got an answer for question 3?

For number three you'll have to replace the myformname.php with your own script so you can check your database for the needed values.

unchecked the csv option an d it seems to work correctly now. Still a bit strange that this selction makes a db go bad.

Is there a setting I can make in the reg expression to get the zip code checked and limited to input possibilities?

thx.

The csv selection probably means a permissions issue or the folder doesn't exist. I usually create a fake form_results.csv and upload it to the server.
Regular expressions are awesome.
Try this one.

thx Eric,
the folder does excist, but ok leave that for what it is.

Could you explain the code you gave me for the zip code?

^\d{5}(?:[-\s]\d{4})?$
Will allow this format.

Condition 1. 12345
Condition 2. 12345-6789
Condition 3. 12345 1234