CMS 3.3.6 upgrade to 4.1.1 - Campaign (etc) sections empty (but the campaigns do exist)

Get Help CMS Installation
1

CMS Version

CMS version 4.1.1

Installation Method

Custom install on Windows Server with IIS

  • Upgraded from 3.3.6
  • Updated MySQL 5.5 to 8.3
  • Updated PHP 7.2 to 8.3.4
  • Ran the “php vendor/bin/phinx migrate -c phinx.php” command

Operating System

Windows Server 2019 with IIS.

Issue

Not sure where i’ve gone wrong or what step i’ve missed!

I have completed the upgrade / migration and the new site loads. The dashboard shows all of the data i expect. However:
Most of the menu items do not display their contents. (including Schedule, Campaigns, Layouts, Templates, Playlists, Media, Datasets, Menu Boards, Displays, Display Groups, Users, Users Groups)

The items do exist (for example, i can login using my user, despite the userlist being empty and i can select a default campaign from the full list of campaigns despite the Campaign list being empty.

When i enable “Developer Mode” with F12 in Edge, and load “Campaigns”, i get:

DataTables warning: table id=campaigns - Ajax error. For more information about this error, please see 7. Warning: Ajax error

In my actual database however, the table is singular campaign. This singular / plural discrepancy is the same for each section (playlist vs playlists etc).

Image showing empty Campaigns section:

image
image1775×887 92.6 KB

Image showing actual campaigns in the default selection option:

image
image1427×904 56.3 KB

Even the logs section is doing it to me which is hampering my troubleshooting a bit!

Any advice would be appreciated!

5

I’ve now done a fresh install on the same server, but with the following changes:

Fresh install with 4.1.2
Completely clean database.
PHP 8.2.10 (for ZMQ compatibility)
MySQL 8.3

After install finished, all i did was create a folder below root, called “Main Displays”, then a campaign, then as soon as i create my first layout, i get the same problem again: Nothing visible in the lists for campaign, layouts, users, logs etc.

I’m really stuck. My production install is sitting on 3.7 on the same server. :frowning:

No errors in PHP error log. The only evidence i can see of the issue is using Edge F12 mode where i get the following:

vendor.bundle.min.js?v=4.1.2&rev=f52c38cf0c8bca77c75b2452e74ac04a2312d765:2

GET
404 (Not Found)

https: //hostname/layout?draw=1&columns%5B0%5D%5Bdata%5D=campaignId&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=layout&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=function&columns%5B2%5D%5Bname%5D=publishedStatus&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=&columns%5B3%5D%5Bname%5D=description&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=function&columns%5B4%5D%5Bname%5D=duration&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=function&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=false&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=orientation&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=thumbnail&columns%5B7%5D%5Bname%5D=&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=false&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B8%5D%5Bdata%5D=owner&columns%5B8%5D%5Bname%5D=&columns%5B8%5D%5Bsearchable%5D=true&columns%5B8%5D%5Borderable%5D=true&columns%5B8%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B8%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B9%5D%5Bdata%5D=groupsWithPermissions&columns%5B9%5D%5Bname%5D=&columns%5B9%5D%5Bsearchable%5D=true&columns%5B9%5D%5Borderable%5D=true&columns%5B9%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B9%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B10%5D%5Bdata%5D=function&columns%5B10%5D%5Bname%5D=status&columns%5B10%5D%5Bsearchable%5D=true&columns%5B10%5D%5Borderable%5D=true&columns%5B10%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B10%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B11%5D%5Bdata%5D=function&columns%5B11%5D%5Bname%5D=enableStat&columns%5B11%5D%5Bsearchable%5D=true&columns%5B11%5D%5Borderable%5D=true&columns%5B11%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B11%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B12%5D%5Bdata%5D=createdDt&columns%5B12%5D%5Bname%5D=&columns%5B12%5D%5Bsearchable%5D=true&columns%5B12%5D%5Borderable%5D=true&columns%5B12%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B12%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B13%5D%5Bdata%5D=modifiedDt&columns%5B13%5D%5Bname%5D=&columns%5B13%5D%5Bsearchable%5D=true&columns%5B13%5D%5Borderable%5D=true&columns%5B13%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B13%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B14%5D%5Bdata%5D=layoutId&columns%5B14%5D%5Bname%5D=&columns%5B14%5D%5Bsearchable%5D=true&columns%5B14%5D%5Borderable%5D=true&columns%5B14%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B14%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B15%5D%5Bdata%5D=code&columns%5B15%5D%5Bname%5D=&columns%5B15%5D%5Bsearchable%5D=true&columns%5B15%5D%5Borderable%5D=true&columns%5B15%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B15%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B16%5D%5Bdata%5D=function&columns%5B16%5D%5Bname%5D=&columns%5B16%5D%5Bsearchable%5D=true&columns%5B16%5D%5Borderable%5D=false&columns%5B16%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B16%5D%5Bsearch%5D%5Bregex%5D=false&order%5B0%5D%5Bcolumn%5D=1&order%5B0%5D%5Bdir%5D=asc&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&campaignId=&layout=&logicalOperatorName=OR&tags=&logicalOperator=OR&codeLike=&orientation=&folderId=1&retired=1&layoutStatusId=1&showDescriptionId=2&mediaLike=&layoutId=&modifiedSinceDt=&_=1731492116724 404 (Not Found)

6

Okay,
for any poor soul wandering in to this dark corner of the community forums, the answer is this:

  1. In IIS, select your virtual site and click on “Request Filtering”. Next, Choose “Edit Feature Settings” from the list on the very right hand side.

  2. Increase the “Maximum Query String (Bytes)” variable from 2048 to 8192.

  3. Go make yourself a cup of tea.