Editing mode "seems" that do not work

martinjesus
(@martinjesus)

10 years, 6 months ago

Hi Michael,

First of all, thank you for your awesome plugin. Is the best 🙂

I have a problem that is reflected by two ways. Let me explain:

I was doing some test in my developement site, and I sent and SQL UPDATE statement for some form submissions with some specific value in a specific field. The SQL did UPDATE some of the submissions, but some others were not updated.

So, I debuged, and I saw that the code was finding the correct field value asked in the submissions that were not updated, but the problem came when trying to extract the submited time from those submisions. The code is not extracting anything (the variable used for saving the submited time is empty).

“Oh! What a stranege thing” I thought. Because I was seeing the submited time in the phpmy admin viewer…

So, and as I bougth your editing extra plugin, I tried to change the values in the DDBB manually with you editing plugin. And my surprise is the following: in the same rows that were not possible to update them with the SQL statement, if you use the edit mode and click save after editing, the value of the field dissapears (¡!). But if you refresh the page, it appears modified again. (In the other rows that worked the SQL update statament, if you modify some value with the editing plugin, it appears modified at the moment).

So, I think that there must by any problem in some part that makes that my SQL update not work, and I think that is is correlated with the editing problem.

Probably some problem when saving the submited time? It appears to be random (In my tests, I was creating different submissions with 15 – 20 seconds of difference).

(I am using the last version of both CFTDB and editing plugins)

Sorry for all this quantity of words 🙂

I hope that you can help me with this subject. Thanks in advance.

https://wordpress.org/plugins/contact-form-7-to-database-extension/

Viewing 12 replies - 1 through 12 (of 12 total)

Plugin Author Michael Simpson
(@msimpson)

10 years, 6 months ago

The issue where the edited field disappears is most likely related to there being a duplicate entry for that field entry in the DB where one is blank. Given that you have the Editor, on the Import page, there is a button to clean up data in the DB. Run that and see if it fixes the problems.

Thread Starter martinjesus
(@martinjesus)

10 years, 6 months ago

Hi Michael,

Thanks for your response. I did the “clean up” from the import page, but it doesn’t fix the problem.

For your information, for the fields that the EDIT field disappears, all the fields for that submission dissapiear when trying to edit them. Does it give you any clue?

Thanks in advance for your response.

Thread Starter martinjesus
(@martinjesus)

10 years, 6 months ago

Hi again Michael,

More clues:

1) The one wrote in my last message (all the values of the same submission dissappear when trying to edit them)

2) The dissapearing fields seems that occurs randomly. I send the form continuosly (15 times, for example), with 1 or 2 seconds of difference, and the form is empty. So, for those 15 submissions, the empty edit field accurs for all the values of 3 or 4 submissions.

I hope that you have more information now for giving a possible solution.

Thanks in advance for your help.

Plugin Author Michael Simpson
(@msimpson)

10 years, 6 months ago

I suggest to try this:

1. From the Import page, to a Backup export of the form to a file.
2. Then rename the form to something else
3. Then import the backed up form data into the original form name

Thread Starter martinjesus
(@martinjesus)

10 years, 6 months ago

Hi Michael,

Thanks for your response, but it does not work neither. This is the result:

– The old re-named form continues having the same rows that are not possible to edit any value.

– And the new imported form (with the same old name) has “some” of the same rows that are not possible to edit any value. (I say “some”, because in the test, in the exported form there were 6 lines from 9 that had that problem, and in the imported form there is only 1 from 9 (and this one is one of those that had the problem before exporting)).

If you want to take a look to my code, please let me know and I will send you an email with the data you need.

Waiting for your response.

Plugin Author Michael Simpson
(@msimpson)

10 years, 6 months ago

So your have just one problem row left after re-import?

Suggestion 1: Resubmit the data from the bad row then delete the bad (older) row.

Suggestion 2: (if you don’t like the above), lets try this one more time to see if it shakes out.
1. You have your renamed original form data, don’t touch that
2. Export the new form data (the copy) as a backup
3. Delete the new form
4. Import the backup file into the form name

Thread Starter martinjesus
(@martinjesus)

10 years, 6 months ago

Hi Michael,

Thanks for your response, but I am wonderig that this solution is for saving the current rows, but it is not the final solution. I am developing my site with your pluging, so now I delete and create the same form and send new submissions dozen times per day. And the problem happens every day, in the 40-60% of the submission sent.

So I do not need to “safeguard” the current submissions that I had now in my form (they are not valid, they are only for testing), but to find a definitive solution for this problem not to happen in the future, when the DDBB would have hundred of rows (and can also happen in each new form submission).

Do you think that taking a look at the code of the form it would help? If you want I can send you my credentials by email, in order you to see what is happening with this form / submissions.

Waiting for your response.

Thread Starter martinjesus
(@martinjesus)

10 years, 6 months ago

Hi Michael,

Thanks for your response. Please let me know where to send you the login.

Waiting for your response.

Thread Starter martinjesus
(@martinjesus)

10 years, 5 months ago

Hi Michael,

I already sent you the credentials by email 1 minute ago.

I will be waiting for your valuable response and help.

Jesús

Moderator Jan Dembowski
(@jdembowski)

Forum Moderator and Brute Squad

10 years, 5 months ago

@msimpson I’ve deleted your offer to login to your user’s site. I’m am 100% sure you mean well but please never ask for credentials on these forums.

Now for the why: The internet is a wonderful place full of very nice people and a few very bad ones. I’m sure everyone here is very nice however, by giving some ones keys to your house you are trusting they wont steal anything. Likewise the person who takes the keys is now responsible for the house FOREVER.

If something was to go wrong, then you the author may well legally become liable for damages, which they would not normally have been as their software is provided without warranty.

Please be aware that repeatedly asking for credentials will result in us asking you to repeatedly stop before escalating up to the plugins team.

Plugin Author Michael Simpson
(@msimpson)

10 years, 5 months ago

Your lecture aside, I’ve had a number of occasions where I can’t reproduce and issue and was given access to a user’s test site to sort it out. I only ask for this as a last resort. And those who are not comfortable can simply decline. I have many other things to do in my life than maintain a plugin for free.

Moderator Jan Dembowski
(@jdembowski)

Forum Moderator and Brute Squad

10 years, 5 months ago

I’m sorry you regard this as a lecture. It’s more of a predefined reply because this happens and it’s the same verbiage each time.

I only ask for this as a last resort. And those who are not comfortable can simply decline.

I’m not accusing you of anything and I do appreciate that you’re offering free support on your own time. But please refrain from doing so again. Repeatedly asking for credentials will result in escalating this up to the plugins team.

Viewing 12 replies - 1 through 12 (of 12 total)

The topic ‘Editing mode "seems" that do not work’ is closed to new replies.