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" notifications@github.com 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 https://github.com/formtools/module-submission_accounts/issues/5#issuecomment-364330089, 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" notifications@github.com 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 https://github.com/formtools/module-submission_accounts/issues/5#issuecomment-364665054, 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 notifications@github.com 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 https://github.com/formtools/module-submission_accounts/issues/5#issuecomment-364673784, 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: ftools@18

On Sat, Feb 10, 2018 at 10:55 PM, Benjamin Keen notifications@github.com 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 https://github.com/formtools/module-submission_accounts/issues/5#issuecomment-364673784, 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_accounttype / enum('admin','client','user','unknown') shchange_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

[crazamahdi]

On clicking load history(submission history) nothing is displayed it is not working @benkeen