Forums

Hello,

i would like to change the type of a database column. How do i do that?

Am i supposed to do it directly in the database with PHP-admin? Or should i use CF integrated functions to do that? If so how to do it?

I tried to add the table once more with same name but with changed column type. This seems not to work...

Any help apreciated!

Thanks & kindest regards,
AK

Hi,

i created a new table with needed columns. But not all of my fields are saved.

The form values are there but the insert SQL statement is wrong. Please see screenshots.

How to fix that?

Thanks & kindest regards,
AK

What i also tried:

- delete cache in CF
- delete Browser cache
- delete save action and added it again

Hi ArnKor,

What exactly is missing - it's hard to read in an image but it looks to me as if everything is there apart from the user name and email (you don't need to save those), the uploaded file info and possibly the full-text - but that appears to be empty.

Bob

Hello GreyHead,

thanks for your reply.

There are some file uploads:

[file_upload_planta]
[file_upload_fotos]

but these fields are not mentioned in the insert SQL statement. So i think the SQL is not matching my fields to save in the DB.

How to update the statement?

Hi AmKor,

a. Is the Files Upload action before the DB Save action?

b. Do you need the array names for the files - they won’t save usefully in that format?

Bob

a. Is the Files Upload action before the DB Save action?

i changed the order. Now file upload is before save. But now i get an error sending the formular:

Fatal error: Call to undefined method RuntimeException::get() in /homepages/35/d30566767/htdocs/clickandbuilds/Joomla/FEMA/libraries/legacy/error/error.php on line 536

Point b will i change after the save works with any data...

Any other ideas?

one more info:

when i deactivate the 'save action' the formalar works (without saving of course).

Ok,

i found out that i had to use an 'handle arrays acion' with my multiple file uploads...

Can someone explain why and what this action does?

Thanks & kindest regards,
AK

Hello Bob,

once again: Thank you! I really appreciate this product & this forum.
AK