Database errors while trying to Preview

Squiz Matrix Support
1

Hello all.


Using the following configuration:

  • MySource 3.18
  • PHP 5.2.6
  • Oracle 10g
  • Solaris 10



    I performed the following steps:


  1. Created a site and added a standard page with one line of text.
  2. Set URL and appropriate permissions.
  3. Set Index page.
  4. Set status of site to Live.



    When I then try to preview the page, I get the following fatal error:



    [font=“Courier New”]Fatal error: Uncaught exception ‘Exception’ with message ‘Unable to get default design for asset: 111 due to database error: Unable to execute query: ORA-00933: SQL command not properly ended’ in /var/www/mysource_matrix/core/assets/site/site.inc:772 Stack trace: #0 /var/www/mysource_matrix/core/assets/site/site.inc(690): Site->paintAsset(Object(Page_Standard)) #1 /var/www/mysource_matrix/core/include/mysource.inc(504): Site->printFrontend() #2 /var/www/mysource_matrix/core/web/index.php(30): MySource->start() #3 {main} thrown in /var/www/mysource_matrix/core/assets/site/site.inc on line 772[/font]



    After seeing this I applied the Falling Leaves design to the site and tried to preview again, this time I saw the site title and the page name (with the pretty leaves) but under that I get:



    [font=“Courier New”]Fatal error: Uncaught exception ‘Exception’ with message ‘Unable to get valid menu entries due to database error: Unable to bind variable “p_permission” to query: 1036 ORA-01036: illegal variable name/number’ in /var/www/mysource_matrix/core/assets/designs/design_areas/menu/design_area_menu_type/menu_get_assets.inc:126 Stack trace: #0 /var/www/mysource_matrix/data/private/assets/design/0014/95/design_file.php(183): menu_get_assets(‘site_nav’, Array) #1 /var/www/mysource_matrix/core/assets/designs/design/design.inc(883): require_once(’/var/www/mysour…’) #2 /var/www/mysource_matrix/core/include/asset.inc(4075): Design->paint(Object(Page_Standard)) #3 /var/www/mysource_matrix/core/assets/site/site.inc(793): Asset->printFrontendAsset(Object(Page_Standard), Object(Design)) #4 /var/www/mysource_matrix/core/assets/site/site.inc(690): Site->paintAsset(Object(Page_Standard)) #5 /var/www/mysource_matrix/core/include/mysource.inc(504): Site->printFrontend() #6 /var/www/mysource_matrix/core/web/index.php(30): MySource->start() #7 { in /var/www/mysource_matrix/core/assets/designs/design_areas/menu/design_area_menu_type/menu_get_assets.inc on line 126[/font]



    I can go through the code to work out what is happening but I was hoping that someone has seen something like this before. If anyone knows what’s going on here then I would appreciate a heads up.
2

I think this was fixed in v3.18.1, released yesterday. Could you try download that and upgrading?

3

We upgraded to 3.18.1 and now we see:

- The same problem when previewing from the site level, with or without a design (Falling Leaves).
- The same problem when previewing the page directly with a design (Falling Leave).

But if we preview the page directly, without a design applied, it works.

Any ideas?
4

Please open a bug report at bugs.matrix.squiz.net and we'll take a look into the problems.

5

OK. I've raised this in the bug tracker:

http://bugs.matrix.squiz.net/view_bug.php?bug_id=3000
6

[quote]OK. I’ve raised this in the bug tracker:


http://bugs.matrix.squiz.net/view_bug.php?bug_id=3000[/quote]



I see the bug has been resolved in 3.18 and 3.19. Am I to assume this will be available when 3.18.2 is released? I’ve just upgraded to 3.18.1 and the problem still exists. Interestingly, the problem only appears if I am logged in. It displays fine for the public user


    Fatal error: Uncaught exception 'Exception' with message 'Unable to get valid menu entries due to database error: SQLSTATE[HY093]: Invalid parameter number: :p_permission' in /Library/WebServer/mysource_matrix/core/assets/designs/design_areas/menu/design_area_menu_type/menu_get_assets.inc:126 Stack trace: #0 /Library/WebServer/mysource_matrix/data/private/assets/design_customisation/0014/59/design_file.php(183): menu_get_assets('site_nav', Array) #1 /Library/WebServer/mysource_matrix/core/assets/designs/design/design.inc(883): require_once('/Library/WebSer...') #2 /Library/WebServer/mysource_matrix/core/assets/designs/design_customisation/design_customisation.inc(482): Design->paint(Object(Page_Standard), Array, Array) #3 /Library/WebServer/mysource_matrix/core/include/asset.inc(4075): Design_Customisation->paint(Object(Page_Standard)) #4 /Library/WebServer/mysource_matrix/core/assets/site/site.inc(793): Asset->printFrontendAsset(Object(Page_Standard), Object(Design_Customisation)) #5 /Library/WebServer/mysource_matrix/co in /Library/WebServer/mysource_matrix/core/assets/designs/design_areas/menu/design_area_menu_type/menu_get_assets.inc on line 126
7

Yes, the bug ix fixed in the 3.18.1+bug fixes code, which will be released as 3.18.2 on Monday. You need to read the versions in the bug tracker like that to make sense of it.