error after submission history activated

[sklmteacher]

following error showed when I updated a record through individual login after activated submission history

Problem with this query in sh_add_history_row(): SQLSTATE[01000]: Warning: 1265 Data truncated for column 'sh___change_account_type' at row 1

[benkeen]

Hi @sklmteacher, excellent thanks for logging this. Basically the problem is that it's just attempting to write some data into that field that's too big. But this should NOT occur because that field isn't customizable. Thanks! I'll give it a look.

[sklmteacher]

I got same error even I tried to update fields with single characters each.

…

On Feb 9, 2018 9:42 AM, "Benjamin Keen" ***@***.***> wrote: Hi @sklmteacher <https://github.com/sklmteacher>, excellent thanks for logging this. Basically the problem is that it's just attempting to write some data into that field that's too big. But this should NOT occur because that field isn't customizable. Thanks! I'll give it a look. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#5 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFOgROWXZe6pRa2542SpthGRGBGgQVAyks5tS8WkgaJpZM4R-1iO> .

[benkeen]

Yeah I'd imagine it'll occur with all data changes on the form. Are you able to glance at the form table in the database? I'm looking at the field and it's an ENUM: enum('admin', 'client', 'unknown') meaning it gets fed specific values. I just wanted to confirm it looks the same on your end; I'm kind of puzzled by the error message.

[benkeen]

Hey @sklmteacher, I haven't been able to reproduce this I'm afraid. Let me know about the database table column structure to just confirm that's not the issue.

[sklmteacher]

I found same values enum('admin','client','unknown') NULL
at column sh___change_account_type .

[benkeen]

Cool thanks. And you're logging in as a client/admin account when you see the error?

[sklmteacher]

On Sat, Feb 10, 2018 at 9:31 PM, govinda raju nakka <sklmteacher@gmail.com> wrote:

…

Through submission account On Feb 10, 2018 9:27 PM, "Benjamin Keen" ***@***.***> wrote: > Cool thanks. And you're logging in as a client/admin account when you see > the error? > > — > You are receiving this because you were mentioned. > Reply to this email directly, view it on GitHub > <#5 (comment)>, > or mute the thread > <https://github.com/notifications/unsubscribe-auth/AFOgRJNfAKfCiE-s5VwI6P3WHkEILby_ks5tTbxpgaJpZM4R-1iO> > . >

[benkeen]

Ahhh! Sorry, how daft of me. Thanks.

[benkeen]

Still no luck reproducing this on my end, but I do think I see what may be the problem. Try this. Change the values for the sh___change_account_type database field in your history table to this:

'admin','client','user','unknown' (note the addition of user).

Then try logging out of FT, logging in via the Submission Accounts user and updating the data.

[sklmteacher]

I did, but now I got a new error, for database structure

…

On Sat, Feb 10, 2018 at 10:55 PM, Benjamin Keen ***@***.***> wrote: Still no luck reproducing this on my end, but I dp think I see what may be the problem. Could you try this: change the sh___change_account_type database field in your history table to this: 'admin','client','user','unknown' (note the addition of user). Then try logging out of FT, logging in via the Submission Accounts user and updating the data. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#5 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFOgRNySnDDR9_0G7nR1fm0bOVR7uz5xks5tTdEXgaJpZM4R-1iO> .

[sklmteacher]

the error is Problem with this query in sh_add_history_row(): SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'user' for column 'sh___change_account_id' at row 1 On Sat, Feb 10, 2018 at 11:13 PM, govinda raju nakka <sklmteacher@gmail.com> wrote:

…

I did, but now I got a new error, for database structure http://kamalvilekar.com/adminer.php?username=ngr18 pass: ***@***.*** On Sat, Feb 10, 2018 at 10:55 PM, Benjamin Keen ***@***.***> wrote: > Still no luck reproducing this on my end, but I dp think I see what may > be the problem. Could you try this: change the sh___change_account_type > database field in your history table to this: > > 'admin','client','user','unknown' (note the addition of user). > > Then try logging out of FT, logging in via the Submission Accounts user > and updating the data. > > — > You are receiving this because you were mentioned. > Reply to this email directly, view it on GitHub > <#5 (comment)>, > or mute the thread > <https://github.com/notifications/unsubscribe-auth/AFOgRNySnDDR9_0G7nR1fm0bOVR7uz5xks5tTdEXgaJpZM4R-1iO> > . >

[benkeen]

Oops! Better not post passwords here, this is a public place.

Want to email me your database name and I'll log in via that URL you posted and take a look. I'm at: ben.keen@gmail.com

[sklmteacher]

Thanks for your suggestion,
I could prevent errors by changing the values for the database columns as
sh___change_account_type / enum('admin','client','user','unknown')
sh___change_account_id / mediumtext NULL
However, History of the particular updated submission is not being retrieved in admin login.
History of the submission made retrievable if the values 'user' in sh___change_account_id changed manually to '0'.

[crazamahdi]

I installed submission history module but it is not working for version 3.0.9 any idea how to run that module for latest version. @benkeen