3.14 Database Error

9 posts by 4 authors in: Forums > CMS Builder
Last Post: September 4, 2018   (RSS)

By gkornbluth - August 30, 2018

Hi all,

I just installed V3.14 on a new site and thought everything was going well.

When I tried to access the Section editor I got the following error:

MySQL Error: Unknown column 'tableName' in 'cmsb__accesslist' - in mysql_functions.php on line 394 by __mysql_upgradeTableToUTF8mb4()

Any thoughts?

Thanks,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By gregThomas - August 31, 2018

Hey Jerry, 

I'm not sure what could be causing this, perhaps the upgrade is attempting to upgrade the tables charset before its added the new columns. I'll need to take a closer look at this site to work out what issue is. Would it be possible to send an email to support@interactivetools.com with the FTP and CMS login details for the server?

Cheers,

Greg

Greg Thomas







PHP Programmer - interactivetools.com

By gkornbluth - August 31, 2018

Hi Greg,

Sure will.

This was a new install and I tried uploading the files again.

I'll try recreating the database and see if that makes any difference (didn't think of that before)

If I get the same error I'll send the log in info.

Thanks

Jerry

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By gkornbluth - August 31, 2018

Hi Greg,

Tried everything from scratch.

New database gave the same error.

Email is on it's way.

Thanks again

Jerry

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By kitsguru - September 3, 2018 - edited: September 3, 2018

Same error upgrading from 3.13

MySQL Error: Unknown column 'tableName' in 'cmsb__accesslist' - in mysql_functions.php on line 394 by __mysql_upgradeTableToUTF8mb4()

However the column does exist.

The schema for __accesslist both userNum and maxRecords have the same label 'label' => 'User Number',

Jeff Shields

By gkornbluth - September 3, 2018

Thanks Jeff,

Hope this helps them track down the gremlin.

Jerry

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

3.14 Database Error - Fix works fine!

By celuch - September 4, 2018

Thanks, Greg... this fix worked for my install also!

celuch

3.14 Database Error - Fix works fine!

By gkornbluth - September 4, 2018

Thanks Greg,

You guys ROCK! (as always)

Jerry

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php