Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
"Database Error 1406 CRITICAL" attempting to create invoice SOLVED
01-14-2023, 08:40 AM,
#11
RE: "Database Error 1406 CRITICAL" attempting to create invoice
No worries, I need to learn what's involved in an upgrade first.

Congrats on your anniversary! How do they put up with us... ;-)
http://www.dalescott.net
Reply
01-15-2023, 12:11 AM,
#12
RE: "Database Error 1406 CRITICAL" attempting to create invoice
Hi Dale, do you know if Victor Chiu managed to get an account set up? I am a bit concerened if people are not able to create accounts.

Tim
Reply
01-17-2023, 10:35 AM, (This post was last modified: 01-17-2023, 10:36 AM by TurboPT.)
#13
RE: "Database Error 1406 CRITICAL" attempting to create invoice
I found the new reference from the 12th, and activated the account. (there's another thread about this too)

Also, ready to do the pull whenever I see the request come through.
Reply
01-18-2023, 01:43 PM, (This post was last modified: 01-18-2023, 01:58 PM by dalescott.)
#14
RE: "Database Error 1406 CRITICAL" attempting to create invoice
I'm thinking a database change also requires a version change. Is that correct? If so, should changing the reference column size wait until 4.15.3? I'm not familar with the release process, so please advise what the best process would be. E.g. if a release stabilization branch will be created to stabilize 4.15.3 prior to release, I assume I need to wait until the branch is created and then send a pull request for the stabilization branch.

However.....  I'm also not clear what code changes are needed to do this. I looked at UpgradeDatabase.php and upgrade4.15.1-4.15.2.sql. Am I correct to understand I would need to update UpgradeDatabase.php and create a new upgrade4.15.2-4.15.3.sql file? Are these the only files involved?

Also I'm thinking the width of debtortrans:reference should be tested first, and only if it is still varchar(20) (the size in the current default.sql), should it be increased to varchar(50). I.e. if the size has been intentionally modified, then it shouldn't be changed. What do you think?
http://www.dalescott.net
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)