Notice: CMSB v3.03 Beta 1 (Mar 29, 2016)

I was moving a CMSB site to a new server, and though I'd try the beta before getting it going.  It seemed to install well, but won't let me import the existing database.  I receive this:  

makeAllUploadRecordsRelative MySQL Error: Unknown column 'storage' in 'where clause'I

Is there a way around this?

Hi,

When you moved CMS Builder to the new server, did you copy over all the section editors?
/cms/data/schema/*

Do you have a field in a section editor called storage? Can you reupload that section editor?

Hi Terry,

I don't run Xampp but I do run WAMP locally and I have both the php_mysql and the php_mysqli extensions enabled.

Have you restarted the local Xampp server after making the changes?

I don't have a schema for storage, and can find nothing in the section editor, or in the schema of my older installation or in the new beta schema file if that is what you are asking.

As a test to make sure it wasn't another issue, I installed V3.20 in the same way with no issues .

Hi Damon,

OK, as you havent encountered a clash with both enabled, I'll give it a try.

Terry

Hi. I tested the beta on a fresh install and found a few things. Screenshots attached.

1) When attempting an upload, I see this error:
"Notice: Undefined variable: php_errormsg in /home/brnstrmr/public_html/cmsbeta/lib/upload_storage_strategy.php on line 65 Error moving uploaded file!"

The main image is uploaded to the upload directory, but the thumbnail folders and thumbnails are not created.
My Dreamweaver program shows a syntax error on line 149 of 'upload_storage_strategy.php'. (Not sure how accurate Dreamweaver is in detecting such errors, but thought I'd mention it.)

2) On the admin General Settings page, some of the html code is showing in the Security Settings section.

3) When using a collapsible header bar, the iframe for the upload fields (uploadIframe) within the collapsible sections are styled at 800 pixels high, instead of the usual 117 pixels high. Just wondering if this height is necessary, as it takes up a lot of vertical space.

The collapsible header bars are a very useful addition, by the way!

~ Deborah

Hi Deborah,

Thanks for the posting the beta issues with screenshots. Looking into them now.

For the large upload frame issue (800 pixels high), I wasn't able to recreate in any browsers on the PC (Chrome, Firefox, Edge, Safari).

What OS and browser are you using?

Hi celuch,

I was moving a CMSB site to a new server, and though I'd try the beta before getting it going.  It seemed to install well, but won't let me import the existing database.  I receive this:  

makeAllUploadRecordsRelative MySQL Error: Unknown column 'storage' in 'where clause'I

Is there a way around this?

Yes, to resolve this:

call createMissingSchemaTablesAndFields() function before makeAllUploadRecordsRelative() on line 231 of cmsb/lib/menus/admin/actionHandler.php

The whole elseif block should now look like this:

elseif ($action == 'restore') {
  security_dieUnlessPostForm();
  security_dieUnlessInternalReferer();
  security_dieOnInvalidCsrfToken();
  disableInDemoMode('','admin/general.php');
  $restoreDatabaseFilePath = $GLOBALS['BACKUP_DIR'] . @$_REQUEST['file'];
  restoreDatabase($restoreDatabaseFilePath);
  notice("Restored backup file $restoreDatabaseFilePath");
  createMissingSchemaTablesAndFields(); // create any fields that weren't in the backup database but were in the schema files
  makeAllUploadRecordsRelative();
  showInterface('admin/general.php');
  exit;
}

The issue was caused by the missing "storage" column of the "uploads" table.

Database backup files made before v3.03 beta 1 doesn't have this column.

When we restore using a database backup, it drops the table and recreate it along with the columns and records in the backup file.

That means it recreates the "uploads" table without the "storage" column which causes the issue.

Calling createMissingSchemaTablesAndFields() function will add the missing column back after the database has been restored.

I found the same issue when installing a fresh copy v3.03 beta 1 using "Restore From Backup" option wherein the backup file doesn't have the "storage" column.

To resolve this:

call createMissingSchemaTablesAndFields() function before makeAllUploadRecordsRelative() on line 243 of cmsb/lib/admin_functions.php

NOTE: This fix will be included on the next CMSB release.

Please let us know any questions.

Thanks,