Error message when creating new asset

Hi,


when I'm trying to create any asset and typing in the name I get this error message:


[quote]MySource Error 

File: [SYSTEM_ROOT]/core/include/assertions.inc Line: 504

Message: [ASSERT EXCEPTION] DB Error: no such table

DELETE FROM sq_sch_idx WHERE assetid = '1317' [nativecode=ERROR: relation "sq_sch_idx" does not exist] (LINE 207 IN [SYSTEM_ROOT]/packages/search/search_manager/search_manager.inc) [SYS0270]

Backtrace: Show [/quote]



The backtrace shows:

    0 => array (
    	"function" => "sq_error_handler",
    	"args" => array (
      0 => 256,
      1 => "[ASSERT EXCEPTION] DB Error: no such table
DELETE FROM sq_sch_idx\n\t\t\t\tWHERE assetid = \'1317\' [nativecode=ERROR:  relation \"sq_sch_idx\" does not exist] (LINE 207 IN [SYSTEM_ROOT]/packages/search/search_manager/search_manager.inc) [SYS0270]",  2 => "[SYSTEM_ROOT]/core/include/locale_manager.inc",  3 => 516,  4 => array (  [Max Depth Reached]  ) ) ), 1 => array ( "file" => "[SYSTEM_ROOT]/core/include/locale_manager.inc", "line" => 516, "function" => "trigger_error", "args" => array (  0 => "[ASSERT EXCEPTION] DB Error: no such table
DELETE FROM sq_sch_idx\n\t\t\t\tWHERE assetid = \'1317\' [nativecode=ERROR:  relation \"sq_sch_idx\" does not exist] (LINE 207 IN [SYSTEM_ROOT]/packages/search/search_manager/search_manager.inc) [SYS0270]",  1 => 256 ) ), 2 => array ( "file" => "[SYSTEM_ROOT]/core/include/general.inc", "line" => 896, "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" => 504, "function" => "trigger_localised_error", "args" => array (  0 => "SYS0270",  1 => 256,  2 => "DB Error: no such table
DELETE FROM sq_sch_idx\n\t\t\t\tWHERE assetid = \'1317\' [nativecode=ERROR:  relation \"sq_sch_idx\" does not exist]",  3 => 207,  4 => "[SYSTEM_ROOT]/packages/search/search_manager/search_manager.inc" ) ), 4 => array ( "file" => "[SYSTEM_ROOT]/core/include/assertions.inc", "line" => 431, "function" => "trigger_exception", "args" => array (  0 => "DB Error: no such table
DELETE FROM sq_sch_idx\n\t\t\t\tWHERE assetid = \'1317\' [nativecode=ERROR:  relation \"sq_sch_idx\" does not exist]",  1 => ,  2 => 1 ) ), 5 => array ( "file" => "[SYSTEM_ROOT]/packages/search/search_manager/search_manager.inc", "line" => 207, "function" => "assert_valid_db_result", "args" => array (  0 => new db_error Object (  [Max Depth Reached]  ) ) ), 6 => array ( "file" => "[SYSTEM_ROOT]/packages/search/search_manager/search_manager.inc", "line" => 155, "function" => "flushkeydata", "class" => "search_manager", "type" => "->", "args" => array (  0 => "1317",  1 =>   ) ), 7 => array ( "file" => "[SYSTEM_ROOT]/core/include/event_manager.inc", "line" => 277, "function" => "onrequestreindex", "class" => "search_manager", "type" => "->", "args" => array (  0 => new page_standard Object (  [Max Depth Reached]  ),  1 => array (  [Max Depth Reached]  ) ) ), 8 => array ( "file" => "[SYSTEM_ROOT]/core/include/asset.inc", "line" => 4226, "function" => "broadcastevent", "class" => "event_manager", "type" => "->", "args" => array (  0 => new page_standard Object (  [Max Depth Reached]  ),  1 => "requestReindex",  2 => array (  [Max Depth Reached]  ) ) ), 9 => array ( "file" => "[SYSTEM_ROOT]/core/include/asset.inc", "line" => 2626, "function" => "informchanges", "class" => "page_standard", "type" => "->", "args" => array (  [Empty] ) ), 10 => array ( "file" => "[SYSTEM_ROOT]/core/include/asset.inc", "line" => 373, "function" => "saveattributes", "class" => "page_standard", "type" => "->", "args" => array (  0 => 1 ) ), 11 => array ( "file" => "[SYSTEM_ROOT]/core/include/asset.inc", "line" => 3479, "function" => "create", "class" => "page_standard", "type" => "->", "args" => array (  0 => array (  [Max Depth Reached]  ) ) ), 12 => array ( "file" => "[SYSTEM_ROOT]/core/include/asset_manager_edit_fns.inc", "line" => 122, "function" => "processbackend", "class" => "page_standard", "type" => "->", "args" => array (  0 => new backend_outputter Object (  [Max Depth Reached]  ),  1 => array (  [Max Depth Reached]  ) ) ), 13 => array ( "file" => "[SYSTEM_ROOT]/core/include/asset_manager.inc", "line" => 5290, "function" => "paintbackend", "class" => "asset_manager_edit_fns", "type" => "->", "args" => array (  [Empty] ) ), 14 => array ( "file" => "[SYSTEM_ROOT]/core/include/backend.inc", "line" => 1037, "function" => "paintbackend", "class" => "asset_manager", "type" => "->", "args" => array (  0 => new backend Object (  [Max Depth Reached]  ) ) ), 15 => array ( "file" => "[SYSTEM_ROOT]/core/include/backend.inc", "line" => 170, "function" => "_printmain", "class" => "backend", "type" => "->", "args" => array (  [Empty] ) ), 16 => array ( "file" => "[SYSTEM_ROOT]/core/include/mysource.inc", "line" => 329, "function" => "paint", "class" => "backend", "type" => "->", "args" => array (  [Empty] ) ), 17 => array ( "file" => "[SYSTEM_ROOT]/core/web/index.php", "line" => 37, "function" => "start", "class" => "mysource", "type" => "->", "args" => array (  [Empty] ) )


Anyone who can give me some help on this?

Have you installed the search package recently? It looks like the search pakage is installed but you have to run install/step_02.php to create the DB tables still.