Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Upgrading issues - 8
  5. Upgrade Issue - and mitigation code for proposal

Upgrade Issue - and mitigation code for proposal

Asked Modified Viewed 1,029 times
Back to Forum Index Previous Topic Next Topic
Print
H
heavencore
H
Semper in excremento sum, sed solum profunditas mutat...
  • Junior Member, joined since
  • Contributed 19 posts on the community forums.
  • Started 6 threads in the forums
  • Started this discussions
asked
Junior Member

I've recently had to resurrect some old sites, and to upgrade to V9 i've been upgrading them first from 7.00.XX to 7.02.07

I had trouble with the upgrade.php found in the 7.02.07 package, specifically, the following errors occurred during upgrade:

Code Download source
BLOB, TEXT, GEOMETRY or JSON column 'userlog_value_new' can't have a default value
BLOB, TEXT, GEOMETRY or JSON column 'panel_url_list' can't have a default value
Database upgrade complete.


As the error states, the TEXT mySQL type cannot have a default - however, there is some confusion over this based on your OS (i'm running PHPFusion on IIS / windows).

May i suggest the the v7 upgrade.php be changed to use VARCHAR(4000) instead of TEXT on these 3 lines:

Lines 265 & 266:
Code Download source
      userlog_value_new VARCHAR(4000) NOT NULL DEFAULT '',
      userlog_value_old VARCHAR(4000) NOT NULL DEFAULT '',


And again on line 292:

Code Download source
      $result = dbquery("ALTER TABLE ".DB_PANELS." ADD (panel_url_list VARCHAR(4000) NOT NULL DEFAULT '', panel_restriction TINYINT(1) UNSIGNED NOT NULL DEFAULT '0')");


By making this change I was able to upgrade normally and continue with the V9 upgrade, otherwise, the panel & log tables where broken when the above statements failed.

J.
Edited by heavencore on 13-04-2019 21:20,
0 replies

1 post

F
Falk
F
Falk 131
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct

(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
  • Super Admin, joined since
  • Contributed 6,201 posts on the community forums.
  • Started 639 threads in the forums
  • Answered 11 questions
answered
Super Admin

Thank you, good info.
0 replies

Category Forum

Upgrading issues - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 1 post
  • Votes 0 votes
  • Topic users 2 members

2 participants

F
F
Falk 131
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct

(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
  • Super Admin, joined since
  • Contributed 6,201 posts on the community forums.
  • Started 639 threads in the forums
  • Answered 11 questions
H
H
Semper in excremento sum, sed solum profunditas mutat...
  • Junior Member, joined since
  • Contributed 19 posts on the community forums.
  • Started 6 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet