Edit Record Facility deleting record information

Permalink Browser Info Environment
Sorry to be a nuisance, and I would add to this to my previous support ticket, but the tickets edit link has disappeared.

Which takes me smoothly to Formify's edit button - when I attempt to edit a record, all the information disappears; not like what happens in the demo.

Has this been tested against Version - 5.7.5.7?

This I can live without for a bit, but the previous issue re: search facilities is a priority. Hopefully someone will advise on this shortly and not keep me hanging like customers in previous posts.

Cheers

Gerald

Cheers

Type: Ticket
Status: Archived
adminEasy
View Replies:
adminEasy replied on at Permalink Reply
adminEasy
I have sofar, deleted Formify, and upgraded PHP to 5.6, and determined the following:

1. The Concrete5 uninstall does not delete the info from the sites DB, so a re-installation of Formify brings back the same Form data.
2. So I deleted all Formify tables from the DB
3. So from a vanilla Concrete5.7 PHP 5.6 install I created a form Test and entered 2 records, and a corresponding List Template.
4. I created a Formify View; still no search capability.
5. I created another Form Test2, but when I tried to enter NEW fields it was bringing up the fields that I had entered in form Test !!!!

So I am completely stuck here. Help, Help, Help
PhilYoung replied on at Permalink Reply
PhilYoung
Hi,

I just checked the latest version of Formify (1.3) on a 5.7.5.6 installation and i am seeing some odd behaviour using two forms. I can edit records in first form but when I try to edit the second form it brings up the fields of the first form. So definitely some issue here.

You are correct in that at the moment you need to manually deleted the db fields for formify to have a completely clean install.

Phil
jgarcia replied on at Permalink Reply
jgarcia
Regarding the "Edit Record" functionality pulling up the wrong form/record...I'm a bit stumped at the moment. Phil has been kind enough to grant me access to his C5 site to test, so I definitely see the problem, but I can't replicate it on my end. I'm on the same Formify and C5 version, and everything is working okay on my system.

I'm continuing to dig into this and will keep you updated.
adminEasy replied on at Permalink Reply
adminEasy
Hi Justin,

Just to clarify what I am now experiencing:

I have installed Concrete Version - 5.7.5.7; PHP Version 5.6.21

After I upgraded to Formify 1.3.1, the issue where creating a new form bringing up the fields of a previous form has disappeared. (Tick)

The following issues remain:
1. Prospective buyers/renters to have search facilities
2. Display images of properties - I can view static images by Insert Path To File <img src="{{ url[fID:'NoXXX'] }}" />, but no matter what coding I put around the dynamic file field, it will just not display.
3. Editing a record clears the saved information

From a selfish point of view, this is my priority order to get my Property Portfolio site up and running properly.

Are these on your roadmap, or are they a long way off from being implemented? It would be great to have some timing information, so I know if I should stick or twist.

Cheers
jgarcia replied on at Permalink Reply
jgarcia
1. Coming up in the next version. Will be posted by EOD Monday...likely sooner.
2. That should look like this:
<img src="{{field-handle.url}}" />

3. This is a Concrete5 caching issue. Go to "Cache & Speed Settings" in the Dashboard, and set "CSS & Javascript Cache" to "Off". I believe there's a way I can address this in the Formify code so that this is not required, but until I get that figured, this solution should work.
adminEasy replied on at Permalink Reply
adminEasy
Hi Justin,

1. Great - that will really help me out.
2. When I Insert file/attachment, it does not have the .url suffix as advised here {{field-handle.url}}, only {{field-handle}}
3. Everything is off in my cache including CSS & Javascript Cache - not a major issue for me right now though.
jgarcia replied on at Permalink Reply
jgarcia
Regarding #2, technically the "value" of these fields is the ID of the file. Formify knows that this isn't very useful so the default functionality is to output a link to the file. In order to only output the URL, you add the .url extension, which should work for instances such as rendering an image.
adminEasy replied on at Permalink Reply 1 Attachment
adminEasy
Hi Justin,

I did try earlier and got the error message attached.
adminEasy replied on at Permalink Reply 1 Attachment
adminEasy
Hi Justin,

Downloaded 1.3.1.2 and the getApprovedVersion() error message has now disappeared. But I still cannot view dynamic images.

Test Template below, and output attached:

===============================================================
<h6>Advert Active? <font color="Green">{{ activate-advert }}</font></h6>

{{ advert-title }}
<br> <br/>
{{ property-description-optional }}
<br> <br/>
<img src="{{ url[fID:'117'] }}" />
<br> <br/>
<img src="{{ upload-photo-1-of-the-room-optional.url }}" />

<br> <br/>
---------------------------------------------------------
<br> <br/>
jgarcia replied on at Permalink Reply
jgarcia
Yeah, I apologize about that. Version 1.3.2 should do the trick. Give it a try and let me know!
adminEasy replied on at Permalink Reply
adminEasy
Hi Justin,

Great work - images and search facilities are now working :)

On a first test of the editing records - the info still has disappeared, But I haven't tried it with a new record yet. I'll follow up when I add further records.

Thanks again for taking your w/end to look into this
adminEasy replied on at Permalink Reply
adminEasy
Hi Justin,

Quick update:

1. I have found that at random times images are not upload, i.e. not loaded into File Manager, so cannot be displayed. I have found a weird workaround - upload the image, then upload again seems to work everytime.
2. Edit removes all information from the record - so this exacerbates Item 1, as I have to re-enter all information in the hope the image is uploaded next time.
3. The search box is there, but cannot add a label or text to the search button, or implement the reset button. Also the search box is showing on the detail form.

Any advice on these?
PhilYoung replied on at Permalink Reply
PhilYoung
Hi,

I have been unable to replicate the behaviour you are getting on a form with a file a upload facility. It seems to work fine every time. Also when I edit a record the data is still there. This is on a 5.7.5.8 concrete 5 and php 5.6. Have you upgraded to formify 1.3.2.2?

As to search if you want to change the name simply go to the view.php and change line 8 entry to read what ever you like (/packages/formify/blocks/formify_view/view.php). Also looking at that code Justin does not appear to have activated search reset as yet.
adminEasy replied on at Permalink Reply
adminEasy
Hi Phil,

I have Formify 1.3.2.2 and PHP 5.6.2.1 installed.

I had Concrete 5.7.5.7 installed and upgraded to 5.7.5.8 (after your message).

The image attachment and display is working by my double click method, and I'll try later if this has resolved itself. I'm loathe to try it now whilst I'm entering data - its a pain to delete and restart the record if it hasn't picked up the attachments.

The Edit function is not working at all for me - it deletes all the information when I click edit. So this is an issue if you advise it's working OK. I have also tried adding a new Test Form with 2 fields (FName, LName). I click records and of course no records are visible. When I click add a record it brings up the fields (30+) of another form (Property). A further test showed if I try to add a record it will bring up the fields of the first form I created in Formify!

Can I assume that there is currently only one way to edit via the Formify's addon? I do not see any Edit/Delete Placeholders in the dropdown list as are currently in AF/DD. So on this note, what is the point of the record permissions if only the admin can do anything with them?

Search labels - great I'll try that shortly.
adminEasy replied on at Permalink Reply
adminEasy
Hi Phil,

Just installed Formify 1.3.2.2 on a fresh Concrete 5.7.5.8 and PHP 5.6.2.1 build, and the edit function works. I have not attempted image attachments yet.

So it looks like the bugs/issues that were in the previous versions have not been eradicated by the upgrade.

I'll export all my form data and make copies of templates - delete formify checking DB and then reinstall. Unless you have a quicker fix.
adminEasy replied on at Permalink Reply
adminEasy
Hi Phil,

Connected the test site to my DEV DB and edit mode in Formify is working now.

So there seem's to be some config or another addon creating an issue.

Copying them over in stages to determine where the issue lies - if I discover it I will know
PhilYoung replied on at Permalink Reply
PhilYoung
Hi,

Interesting! I hope you can find out where the issue is coming from. It will be invaluable inforamtion for all formify users.
Best
Phil
jgarcia replied on at Permalink Reply
jgarcia
Taking a look now. I'll follow-up shortly.
adminEasy replied on at Permalink Reply
adminEasy
Thanks PhilYoung (this post and the update on the search issue).

JGarcia - Many thanks for taking the time out to look into this; hope family life's going well. Happy to hear your back in the saddle - great app as there is very little out there that the "novice / beginner" can utilise to get the look, feel and output needed.
adminEasy replied on at Permalink Reply
adminEasy
Hi Justin,

I've just upgraded to 1.3.1, and the issue when creating a new record brings up the fields of a previous form has disappeared.

The following issues remain:
1. Editing record clears information
2. No search capabilities

Is there an ETA for this please? No that I can create multiple forms, I am thinking I can crack on an create all my forms and associated fields and import my Advanced Forms/Data Display records in the interim.

Is this worthwhile, or should I wait for the code change?
ConcreteCMS replied on at Permalink Reply
ConcreteCMS
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.

To re-open this issue, reply to this message.
mmsd replied on at Permalink Reply 1 Attachment
mmsd
3. Editing a record clears the saved information

3. This is a Concrete5 caching issue. Go to "Cache & Speed Settings" in the Dashboard, and set "CSS & Javascript Cache" to "Off". I believe there's a way I can address this in the Formify code so that this is not required, but until I get that figured, this solution should work.

I have disabled CSS & javascript caching and still having this issue. environment information attached. please advise as to a resolution, this is a form I'm trying to launch and getting blocked by this error and the lack of an apparent solution.
PhilYoung replied on at Permalink Reply
PhilYoung
Hi,
i cant replicate this issue on a live 8.4.2 instal but I am using php 7.1 which is the only difference I can see, in your set up you have php 5.6. It also worth noting that formify does not like php 7.2+
Best
Phil
mmsd replied on at Permalink Reply
mmsd
Thanks Phil, I'll look into updating PHP on the server and reply back here if it ends up solving the issue.
PhilYoung replied on at Permalink Reply
PhilYoung
I just tested an 8.4.2 with php 5.6 and all caching on with no problems on editing the records. Could it be a problem with a particular field type I wonder.
ConcreteCMS replied on at Permalink Reply
ConcreteCMS
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.

To re-open this issue, reply to this message.
ConcreteCMS replied on at Permalink Reply
ConcreteCMS
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.

To re-open this issue, reply to this message.
ConcreteCMS replied on at Permalink Reply
ConcreteCMS
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.

To re-open this issue, reply to this message.

concrete5 Environment Information

# concrete5 Version
Core Version - 5.7.5.7
Version Installed - 5.7.5.7
Database Version - 20160412000000

# concrete5 Packages
Accordion Content (1.2), Baseline 5.7 (1.0), Buttons Pro (1.3.8), Cloneamental (0.9.3), EZ Paypal (1.1.1), Formify (1.2.4.1), Login/Logout Link (1.0), Login Page Background (0.9), Stellar (1.0), SVG Social Media Icons (0.9.7), Vivid Carousel (1.0.1), Vivid Simple Accordion (1.0.1), Whale OWL Carousel (2.5.5).

# concrete5 Overrides
languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/nb_NO/LC_MESSAGES/messages.mo, languages/nb_NO/LC_MESSAGES, languages/nb_NO, languages/pl_PL/LC_MESSAGES/messages.mo, languages/pl_PL/LC_MESSAGES, languages/pl_PL, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, single_pages/account/icon.png, single_pages/account/edit_profile.php, single_pages/account/messages/inbox.php, single_pages/account/messages/view.php, single_pages/account/messages, single_pages/account/view.php, single_pages/account/avatar.php, single_pages/account, single_pages/members/view.php, single_pages/members/profile.php, single_pages/members/directory.php, single_pages/members, single_pages/login_oauth.php, single_pages/page_forbidden.php, single_pages/page_not_found.php, single_pages/download_file.php, single_pages/register.php, single_pages/login.php, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/nb_NO/LC_MESSAGES/messages.mo, languages/nb_NO/LC_MESSAGES, languages/nb_NO, languages/pl_PL/LC_MESSAGES/messages.mo, languages/pl_PL/LC_MESSAGES, languages/pl_PL, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, single_pages/account/icon.png, single_pages/account/edit_profile.php, single_pages/account/messages/inbox.php, single_pages/account/messages/view.php, single_pages/account/messages, single_pages/account/view.php, single_pages/account/avatar.php, single_pages/account, single_pages/members/view.php, single_pages/members/profile.php, single_pages/members/directory.php, single_pages/members, single_pages/login_oauth.php, single_pages/page_forbidden.php, single_pages/page_not_found.php, single_pages/download_file.php, single_pages/register.php, single_pages/login.php

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache

# Server API
cgi-fcgi

# PHP Version
5.4.45

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, enchant, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imagick, imap, intl, ionCube Loader, json, ldap, libxml, mbstring, mcrypt, mysql, mysqli, mysqlnd, odbc, openssl, pcntl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, readline, redis, Reflection, session, SimpleXML, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, XCache, XCache Cacher, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 8M
sql.safe_mode - Off
upload_max_filesize - 2M
ldap.max_links - Unlimited
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
xcache.var_maxttl - 0

Browser User-Agent String

Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.