Mysource error when trying to add WYSIWYG content type

Squiz Matrix Support
1

After our upgrade to 3.16.2 I cannot create a WYSIWYG content area, nor change a previously raw html content area to WYSIWYG. I get a nastly red mysource error. Should I be contacting Squiz Support, or is this a bug having to do with the new snippet plugin (as I see it in the backtrace).

    *MySource Error*
    File : [SYSTEM_ROOT]/core/include/assertions.inc
    Line : 508
    Version : 3.16.2
    DB Type : pgsql
    
    [ASSERT EXCEPTION] DB Error: syntax errorselect
    					minorid
    				from
    					sq_ast_lnk
    				where
    					minorid in ('6830') and
    					majorid in ()
    				group by
    					majorid, sort_order, minorid
    				order by
    					majorid, sort_order [nativecode=ERROR:  syntax error at or near ")" at character 102] (LINE 8047 IN [SYSTEM_ROOT]/core/include/asset_manager.inc) [SYS0270]


    *Back Trace*
    0 => array (
    	"function" => "sq_error_handler",
    	"args" => array (
    		0 => 256,
    		1 => "[ASSERT EXCEPTION] DB Error: syntax error
select\n\t\t\t\t\tminorid\n\t\t\t\tfrom\n\t\t\t\t\tsq_ast_lnk\n\t\t\t\twhere\n\t\t\t\t\tminorid in (\'6830\') and\n\t\t\t\t\tmajorid in ()\n\t\t\t\tgroup by\n\t\t\t\t\tmajorid, sort_order, minorid\n\t\t\t\torder by\n\t\t\t\t\tmajorid, sort_order [nativecode=ERROR:  syntax error at or near \")\" at character 102] (LINE 8047 IN [SYSTEM_ROOT]/core/include/asset_manager.inc) [SYS0270]",
    		2 => "[SYSTEM_ROOT]/core/include/locale_manager.inc",
    		3 => 504,
    		4 => array (
    			[Max Depth Reached]
    		) 
    	) 
    ),
    1 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/locale_manager.inc",
    	"line" => 504,
    	"function" => "trigger_error",
    	"args" => array (
    		0 => "[ASSERT EXCEPTION] DB Error: syntax error
select\n\t\t\t\t\tminorid\n\t\t\t\tfrom\n\t\t\t\t\tsq_ast_lnk\n\t\t\t\twhere\n\t\t\t\t\tminorid in (\'6830\') and\n\t\t\t\t\tmajorid in ()\n\t\t\t\tgroup by\n\t\t\t\t\tmajorid, sort_order, minorid\n\t\t\t\torder by\n\t\t\t\t\tmajorid, sort_order [nativecode=ERROR:  syntax error at or near \")\" at character 102] (LINE 8047 IN [SYSTEM_ROOT]/core/include/asset_manager.inc) [SYS0270]",
    		1 => 256 
    	) 
    ),
    2 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/general.inc",
    	"line" => 1119,
    	"function" => "raiseerror",
    	"class" => "locale_manager",
    	"type" => "->",
    	"args" => array (
    		0 => "SYS0270",
    		1 => 256,
    		2 => array (
    			[Max Depth Reached]
    		) 
    	) 
    ),
    3 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/assertions.inc",
    	"line" => 508,
    	"function" => "trigger_localised_error",
    	"args" => array (
    		0 => "SYS0270",
    		1 => 256,
    		2 => "DB Error: syntax error
select\n\t\t\t\t\tminorid\n\t\t\t\tfrom\n\t\t\t\t\tsq_ast_lnk\n\t\t\t\twhere\n\t\t\t\t\tminorid in (\'6830\') and\n\t\t\t\t\tmajorid in ()\n\t\t\t\tgroup by\n\t\t\t\t\tmajorid, sort_order, minorid\n\t\t\t\torder by\n\t\t\t\t\tmajorid, sort_order [nativecode=ERROR:  syntax error at or near \")\" at character 102]",
    		3 => 8047,
    		4 => "[SYSTEM_ROOT]/core/include/asset_manager.inc" 
    	) 
    ),
    4 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/assertions.inc",
    	"line" => 421,
    	"function" => "trigger_exception",
    	"args" => array (
    		0 => "DB Error: syntax error
select\n\t\t\t\t\tminorid\n\t\t\t\tfrom\n\t\t\t\t\tsq_ast_lnk\n\t\t\t\twhere\n\t\t\t\t\tminorid in (\'6830\') and\n\t\t\t\t\tmajorid in ()\n\t\t\t\tgroup by\n\t\t\t\t\tmajorid, sort_order, minorid\n\t\t\t\torder by\n\t\t\t\t\tmajorid, sort_order [nativecode=ERROR:  syntax error at or near \")\" at character 102]",
    		1 => ,
    		2 => 1 
    	) 
    ),
    5 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/asset_manager.inc",
    	"line" => 8047,
    	"function" => "assert_valid_db_result",
    	"args" => array (
    		0 => new db_error Object (
    			[Max Depth Reached]
    		) 
    	) 
    ),
    6 => array (
    	"file" => "[SYSTEM_ROOT]/core/assets/content_types/content_type_wysiwyg/content_type_wysiwyg_edit_fns.inc",
    	"line" => 136,
    	"function" => "getsnippetkeywords",
    	"class" => "asset_manager",
    	"type" => "->",
    	"args" => array (
    		[Empty]
    	) 
    ),
    7 => array (
    	"file" => "[SYSTEM_ROOT]/core/assets/content_types/content_type_wysiwyg/content_type_wysiwyg_edit_fns.inc",
    	"line" => 262,
    	"function" => "_createeditor",
    	"class" => "content_type_wysiwyg_edit_fns",
    	"type" => "->",
    	"args" => array (
    		0 => new content_type_wysiwyg Object (
    			[Max Depth Reached]
    		),
    		1 => "bodycopy_262_content_type_wysiwyg_13211" 
    	) 
    ),
    8 => array (
    	"file" => "[SYSTEM_ROOT]/core/assets/bodycopy/bodycopy_containers/bodycopy_div/bodycopy_div_edit_fns.inc",
    	"line" => 316,
    	"function" => "paintbackend",
    	"class" => "content_type_wysiwyg_edit_fns",
    	"type" => "->",
    	"args" => array (
    		0 => new content_type_wysiwyg Object (
    			[Max Depth Reached]
    		),
    		1 => "bodycopy_262_content_type_wysiwyg_13211" 
    	) 
    ),
    9 => array (
    	"file" => "[SYSTEM_ROOT]/core/assets/bodycopy/bodycopy/bodycopy_edit_fns.inc",
    	"line" => 278,
    	"function" => "paintcontainer",
    	"class" => "bodycopy_div_edit_fns",
    	"type" => "->",
    	"args" => array (
    		0 => new bodycopy_div Object (
    			[Max Depth Reached]
    		),
    		1 => new backend_outputter Object (
    			[Max Depth Reached]
    		),
    		2 => "bodycopy_262" 
    	) 
    ),
    10 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/asset_edit_interface.inc",
    	"line" => 1049,
    	"function" => "paintbodycopy",
    	"class" => "bodycopy_edit_fns",
    	"type" => "->",
    	"args" => array (
    		0 => new bodycopy Object (
    			[Max Depth Reached]
    		),
    		1 => new backend_outputter Object (
    			[Max Depth Reached]
    		),
    		2 => "bodycopy_262" 
    	) 
    ),
    11 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/asset_edit_interface.inc",
    	"line" => 733,
    	"function" => "printeditinterface",
    	"class" => "asset_edit_interface",
    	"type" => "->",
    	"args" => array (
    		0 => "screen_contents",
    		1 => new bodycopy Object (
    			[Max Depth Reached]
    		),
    		2 => new backend_outputter Object (
    			[Max Depth Reached]
    		),
    		3 => ,
    		4 => array (
    			[Max Depth Reached]
    		) 
    	) 
    ),
    12 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/asset.inc",
    	"line" => 4224,
    	"function" => "paint",
    	"class" => "asset_edit_interface",
    	"type" => "->",
    	"args" => array (
    		0 => new bodycopy Object (
    			[Max Depth Reached]
    		),
    		1 => new backend_outputter Object (
    			[Max Depth Reached]
    		),
    		2 =>  
    	) 
    ),
    13 => array (
    	"file" => "[SYSTEM_ROOT]/core/assets/bodycopy/bodycopy/bodycopy.inc",
    	"line" => 211,
    	"function" => "paintbackend",
    	"class" => "asset",
    	"type" => "::",
    	"args" => array (
    		0 => new backend_outputter Object (
    			[Max Depth Reached]
    		) 
    	) 
    ),
    14 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/asset_manager_edit_fns.inc",
    	"line" => 215,
    	"function" => "paintbackend",
    	"class" => "bodycopy",
    	"type" => "->",
    	"args" => array (
    		0 => new backend_outputter Object (
    			[Max Depth Reached]
    		) 
    	) 
    ),
    15 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/asset_manager.inc",
    	"line" => 7333,
    	"function" => "paintbackend",
    	"class" => "asset_manager_edit_fns",
    	"type" => "->",
    	"args" => array (
    		[Empty]
    	) 
    ),
    16 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/backend.inc",
    	"line" => 1343,
    	"function" => "paintbackend",
    	"class" => "asset_manager",
    	"type" => "->",
    	"args" => array (
    		0 => new backend Object (
    			[Max Depth Reached]
    		) 
    	) 
    ),
    17 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/backend.inc",
    	"line" => 189,
    	"function" => "_printmain",
    	"class" => "backend",
    	"type" => "->",
    	"args" => array (
    		[Empty]
    	) 
    ),
    18 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/mysource.inc",
    	"line" => 355,
    	"function" => "paint",
    	"class" => "backend",
    	"type" => "->",
    	"args" => array (
    		[Empty]
    	) 
    ),
    19 => array (
    	"file" => "[SYSTEM_ROOT]/core/web/index.php",
    	"line" => 31,
    	"function" => "start",
    	"class" => "mysource",
    	"type" => "->",
    	"args" => array (
    		[Empty]
    	) 
    )
2

Definitely contact Squiz Support.


Given your other topic, though – it does sound like your upgrade didn't go well, though – I would rollback to a backup myself and test the upgrade somewhere else first.

3

[quote]Definitely contact Squiz Support.


Given your other topic, though – it does sound like your upgrade didn't go well, though – I would rollback to a backup myself and test the upgrade somewhere else first.[/quote]



Ok, I will contact support. I did a backup before I upgraded. How would I rollback to a backup as you say?

4

You can contact Support for this as well -- they can talk you through the process of restoring the backup.
5

Was actually caused be incorrectly configured snippets, not being handled because of this bug:
http://bugs.matrix.squiz.net/view_bug.php?bug_id=2749



I have fixed your system. The bug fix will be in the next version, but the workaround just requires you to only place pages in the snippets folder rather than individual DIVs, which you need to do to get snippets working anyway.

6

[quote]Was actually caused be incorrectly configured snippets, not being handled because of this bug:
http://bugs.matrix.squiz.net/view_bug.php?bug_id=2749



I have fixed your system. The bug fix will be in the next version, but the workaround just requires you to only place pages in the snippets folder rather than individual DIVs, which you need to do to get snippets working anyway.[/quote]



Ok. So, was this an error on my part, in putting individual divs in the snippet folder? Is this what caused it? Or a combination of that and the bug?

7

The error was caused by the div in the snippet folder, but it was the bug in the error handling that caused the problems for you. Not your fault.