Doctrine Exception When Attempting to Edit the Output of a New Page Type After Updating to 8.3.2

Permalink 0 1 Browser Info Environment
Receiving the following error when attempting to update the output on a new pagetype:

Doctrine \ DBAL \ Exception \ SyntaxErrorException
An exception occurred while executing 'select cID from Pages where cParentID in () and cInheritPermissionsFromCID = ': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and cInheritPermissionsFromCID =' at line 1

Steps to Reproduce:
1. Updated from 8.2.1 to 8.3.1 by uploading the package to the updates folder and then using the GUI to complete the update. No issues.
2. Go to "Page Types" under Pages & Themes in the Dashboard.
3. Add a Page Type (in this case "Left Sidebar").
4. Click "Output"
5. Choose "Left Sidebar"

Result: Above error received.
Expected: Page template to edit.

Thanks!


Status: New
TooqInc
SmoothPixel replied on at Permalink Reply
SmoothPixel
I have followed your steps exactly and everything worked - no errors for me.

concrete5 Environment Information

# concrete5 Version
Core Version - 8.3.2
Version Installed - 8.3.2
Database Version - 20180122213656

# concrete5 Packages
Buttons Factory Pro (2.2), C5DK Blog (8.3.1.4), Cloneamental (0.9.3), Custom Block (1.0), ExchangeCore reCAPTCHA (1.1.1), GalleryES (2.5.8), HonestWebsites Simple testimonials (1.0.0), Mega Menu (1.6.2.2), Quick Tabs (1.0), Supermint Theme (3.4.1), Wetu Itinerary (0.002)

# concrete5 Overrides
blocks/page_list/templates/safari_slider/accommodation/serviced-camping-1.png, blocks/page_list/templates/safari_slider/accommodation/lodge-serviced-camping-2.png, blocks/page_list/templates/safari_slider/accommodation/serviced-camping-3.png, blocks/page_list/templates/safari_slider/accommodation/2-to-3-accomodation.png, blocks/page_list/templates/safari_slider/accommodation/3-to-4-accomodation.png, blocks/page_list/templates/safari_slider/accommodation/lodge-serviced-camping-3.png, blocks/page_list/templates/safari_slider/accommodation/serviced-camping-2.png, blocks/page_list/templates/safari_slider/accommodation/lodge.png, blocks/page_list/templates/safari_slider/accommodation/adventure-camping-1.png, blocks/page_list/templates/safari_slider/accommodation/lodge-serviced-camping-1.png, blocks/page_list/templates/safari_slider/accommodation/beach-resort.png, blocks/page_list/templates/safari_slider/accommodation, blocks/page_list/templates/safari_slider/no_image.png, blocks/page_list/templates/safari_slider/view.css, blocks/page_list/templates/safari_slider/vehicle/light-aircraft.png, blocks/page_list/templates/safari_slider/vehicle/overland-truck.png, blocks/page_list/templates/safari_slider/vehicle/open-sided-4wd.png, blocks/page_list/templates/safari_slider/vehicle/closed-4wd.png, blocks/page_list/templates/safari_slider/vehicle/minivan.png, blocks/page_list/templates/safari_slider/vehicle, blocks/page_list/templates/safari_slider/view.php, blocks/page_list/templates/safari_slider, blocks/page_list/templates/safari_list/accommodation/serviced-camping-1.png, blocks/page_list/templates/safari_list/accommodation/lodge-serviced-camping-2.png, blocks/page_list/templates/safari_list/accommodation/serviced-camping-3.png, blocks/page_list/templates/safari_list/accommodation/2-to-3-accomodation.png, blocks/page_list/templates/safari_list/accommodation/3-to-4-accomodation.png, blocks/page_list/templates/safari_list/accommodation/lodge-serviced-camping-3.png, blocks/page_list/templates/safari_list/accommodation/serviced-camping-2.png, blocks/page_list/templates/safari_list/accommodation/lodge.png, blocks/page_list/templates/safari_list/accommodation/adventure-camping-1.png, blocks/page_list/templates/safari_list/accommodation/lodge-serviced-camping-1.png, blocks/page_list/templates/safari_list/accommodation/beach-resort.png, blocks/page_list/templates/safari_list/accommodation, blocks/page_list/templates/safari_list/no_image.png, blocks/page_list/templates/safari_list/view.css, blocks/page_list/templates/safari_list/vehicle/light-aircraft.png, blocks/page_list/templates/safari_list/vehicle/overland-truck.png, blocks/page_list/templates/safari_list/vehicle/open-sided-4wd.png, blocks/page_list/templates/safari_list/vehicle/closed-4wd.png, blocks/page_list/templates/safari_list/vehicle/minivan.png, blocks/page_list/templates/safari_list/vehicle, blocks/page_list/templates/safari_list/view.php, blocks/page_list/templates/safari_list, blocks/page_list/templates, blocks/page_list, blocks/page_attribute_display/templates/wetu/view.php, blocks/page_attribute_display/templates/wetu, blocks/page_attribute_display/templates, blocks/page_attribute_display, blocks/simple_stack_display/edit.php, blocks/simple_stack_display/db.xml, blocks/simple_stack_display/add.php, blocks/simple_stack_display/view.php, blocks/simple_stack_display/controller.php, blocks/simple_stack_display, blocks/safari_flip/edit.php, blocks/safari_flip/db.xml, blocks/safari_flip/composer.php, blocks/safari_flip/icon.png, blocks/safari_flip/config.json, blocks/safari_flip/add.php, blocks/safari_flip/view.css, blocks/safari_flip/form.php, blocks/safari_flip/view.php, blocks/safari_flip/controller.php, blocks/safari_flip, controllers/single_page/search.php, controllers/single_page, single_pages/page_not_found.php, single_pages/search.php, themes/supermint/elements/header.php, themes/supermint/elements, themes/supermint/safari.php, themes/supermint

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache

# Server API
cgi-fcgi

# PHP Version
7.0.27

# PHP Extensions
bcmath, calendar, cgi-fcgi, Core, ctype, curl, date, dom, fileinfo, filter, ftp, gd, hash, iconv, json, libxml, mbstring, mcrypt, mysqli, mysqlnd, openssl, pcntl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, readline, Reflection, session, SimpleXML, soap, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, zlib

# PHP Settings
max_execution_time - 90
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - -1
max_input_vars - 1000
memory_limit - 512M
post_max_size - 8M
sql.safe_mode - Off
upload_max_filesize - 2M
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36