unable to create table [Solved]

Hi,
I use Joomla 1.5.25 (german backend) and CF 4.
I set up a form with 2 fields and save it. It is shown in the Forms Manager.
The I select the check box in front of the form name and press the icon Create Table.
It shows me a table with a lot of cf... fields and after that the names of my 2 fields.
When I then press the Save icon, there is no table connected in the Forms Manager shown.
I got no error message. What is going wrong?

I have now tried this again on an other site from an other computer (but on the same host). It is also not possible to connect a table to the form.
Please give me a hint.

Hi tibi38,

The Create Table icon only creates a table. You need to use the DB Save action to save the data from your form to the table. Please see the video below.

Bob

[flash=640,360]http://www.youtube.com/v/kRL__AsJw9g[/flash]

Dear Bob,
I follow again your video.
Doing everything correct, I got no reply that the database was saved successfully after saving the table (see Bild2 attached). Also the table is not view in the selectionbox of the db save action. When I select here an other existing table (f.e. jos_chronoforms) then the form works as designed. The only problem is to create a new table.

Hi tibi38,

Hard to say :-( We've sent his occastionally with server security blocking some activities.

If you turn on Site Debug temporarily you should be able to see the query and check if that looks OK. If you copy and paste it from there you can probably run it in PHPMyAdmin.

Bob

Dear Bob,
i switch on the debugging in Site-konfiguration and the debug-plugin too.
After clicking on Save in Table creation I got only select-statements for the Forms-manager shown. I don't see any insert - commands.

Hi tibi38 ,

Hmmm . . . then it does sound as though there may be a problem with the server security. If suhosin is enabled then I think it can be set to block MySQL queries.

Bob

my config:
Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8g DAV/2 PHP/5.2.9 with Suhosin-Patch

sql.safe_mode Off
suhosin.log.phpscript.is_safe Off

suhosin
This server is protected with the Suhosin Extension 0.9.27

Copyright (c) 2006-2007 Hardened-PHP Project
Copyright (c) 2007-2008 SektionEins GmbH

Directive Local Value Master Value
suhosin.apc_bug_workaround Off Off
suhosin.cookie.checkraddr 0 0
suhosin.cookie.cryptdocroot On On
suhosin.cookie.cryptkey [ protected ] [ protected ]
suhosin.cookie.cryptlist no value no value
suhosin.cookie.cryptraddr 0 0
suhosin.cookie.cryptua On On
suhosin.cookie.disallow_nul 1 1
suhosin.cookie.disallow_ws 1 1
suhosin.cookie.encrypt Off Off
suhosin.cookie.max_array_depth 50 50
suhosin.cookie.max_array_index_length 64 64
suhosin.cookie.max_name_length 64 64
suhosin.cookie.max_totalname_length 256 256
suhosin.cookie.max_value_length 10000 10000
suhosin.cookie.max_vars 100 100
suhosin.cookie.plainlist no value no value
suhosin.coredump Off Off
suhosin.disable.display_errors Off Off
suhosin.executor.allow_symlink Off Off
suhosin.executor.disable_emodifier Off Off
suhosin.executor.disable_eval Off Off
suhosin.executor.eval.blacklist no value no value
suhosin.executor.eval.whitelist no value no value
suhosin.executor.func.blacklist no value no value
suhosin.executor.func.whitelist no value no value
suhosin.executor.include.blacklist no value no value
suhosin.executor.include.max_traversal 0 0
suhosin.executor.include.whitelist no value no value
suhosin.executor.max_depth 0 0
suhosin.filter.action no value no value
suhosin.get.disallow_nul 1 1
suhosin.get.disallow_ws 0 0
suhosin.get.max_array_depth 50 50
suhosin.get.max_array_index_length 64 64
suhosin.get.max_name_length 64 64
suhosin.get.max_totalname_length 256 256
suhosin.get.max_value_length 512 512
suhosin.get.max_vars 100 100
suhosin.mail.protect 0 0
suhosin.memory_limit 0 0
suhosin.mt_srand.ignore On On
suhosin.multiheader Off Off
suhosin.perdir 0 0
suhosin.post.disallow_nul 1 1
suhosin.post.disallow_ws 0 0
suhosin.post.max_array_depth 50 50
suhosin.post.max_array_index_length 64 64
suhosin.post.max_name_length 64 64
suhosin.post.max_totalname_length 256 256
suhosin.post.max_value_length 65000 65000
suhosin.post.max_vars 200 200
suhosin.protectkey On On
suhosin.request.disallow_nul 1 1
suhosin.request.disallow_ws 0 0
suhosin.request.max_array_depth 50 50
suhosin.request.max_array_index_length 64 64
suhosin.request.max_totalname_length 256 256
suhosin.request.max_value_length 65000 65000
suhosin.request.max_varname_length 64 64
suhosin.request.max_vars 200 200
suhosin.server.encode On On
suhosin.server.strip On On
suhosin.session.checkraddr 0 0
suhosin.session.cryptdocroot On On
suhosin.session.cryptkey [ protected ] [ protected ]
suhosin.session.cryptraddr 0 0
suhosin.session.cryptua On On
suhosin.session.encrypt On On
suhosin.session.max_id_length 128 128
suhosin.simulation Off Off
suhosin.sql.bailout_on_error Off Off
suhosin.sql.comment 0 0
suhosin.sql.multiselect 0 0
suhosin.sql.opencomment 0 0
suhosin.sql.union 0 0
suhosin.sql.user_postfix no value no value
suhosin.sql.user_prefix no value no value
suhosin.srand.ignore On On
suhosin.stealth On On
suhosin.upload.disallow_binary 0 0
suhosin.upload.disallow_elf 1 1
suhosin.upload.max_uploads 25 25
suhosin.upload.remove_binary 0 0
suhosin.upload.verification_script no value no value


But when the insert is blocked, than it should not be possible to install cf on the server or I'm wrong?
Maybe the setup-values helps to detect the problem.

I got also in contact with the support for hosting. They check the server logs for SQL related issues and found nothing there what could point to this issue.

I have add for 1 table the structure manually on the database. After that the connection is established and I can use this form.
But for the other forms i need a real solution. So please keep on running....

Hi tibi38,

There's nothing more to do here. It still looks to me that you need to reconfigure the suhosin settings. My guess is that max post vars 200 isn't enough.

Bob

Dear Bob,
we have now allocate the problem.
The solution is to change following values:
php_value suhosin.post.max_vars 2000
php_value suhosin.request.max_vars 2000

After setting this values everything is fine

Hi tibi38,

Great, thanks for letting us know.

Bob

Hi Bob,

I have the same problem like tibi38. I am unable to create the table using the form manager. I am using the v4, 1.6.6. I will try to create the table manually with the suggested fields in the Create table and see how it goes there. Will let you know but any idea why I am unable to create table using the form manager? Thanks.

Hi jmarian1 ,

Possibly for the same reason as Thomas?

If suhosin is running then these three settings need to be at least 1,000 (possibly 2,000 if you use large forms).

suhosin.get.max_vars
suhosin.post.max_vars
suhosin.request.max_vars]

Bob

Thanks Bob. Although it doesn't give any confirmation if the table is saved in the form manager, I looked into the database and the table is created. Thanks for your help. This is solved.🙂

Hi jmarian1,

You should see a Joomla! system message to confirm that the table has been created - and a similar system error message if there is a problem.

Bob

Hi Bob. As far as seeing the confirmation that you mentioned below in creating a table, it doesn't give any notification if save or if there is an error but it is saved in the database when I checked it. Not sure what the problem but I am ok for now as long as it is created in db. Still hoping to find the solution for this though. Thanks.

Hi jmarian1,

It sounds as though you may be using an admin template that doesn't support Joomla! system messages. Is that possible?

Bob

I am using the Bluestork admin template which is I believe the recommended one. PLease advice. Thanks. I am using 1.7.4.

Hi jmarian1,

Me too.

Bob