Asset map has disappeared

Squiz Matrix Installation
1

HI folks


I upgraded from 3.16.6 to 3.18.0 - all the sites work HOWEVER when I sign into the admin window the asset map doesn’t work. Tried clearing browser cache, tried a different machine. Same result:



http://87.117.201.20/brokenmap.jpg



Any Ideas?



K

2

Found this error in the source:

    Fatal error:  Uncaught exception 'Exception' with message 'Unable to adjust real sort order for majorid: 1 due to database error: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: ""' in /var/www/mysource_matrix/core/lib/asset_map/asset_map.inc:230
    Stack trace:
    #0 /var/www/mysource_matrix/core/lib/asset_map/asset_map.inc(445): Asset_Map->_getInitialLineageSelection('complex')
    #1 /var/www/mysource_matrix/core/include/backend.inc(1150): Asset_Map->embedAssetMap('complex', 275)
    #2 /var/www/mysource_matrix/core/include/backend.inc(185): Backend->_printSideNav()
    #3 /var/www/mysource_matrix/core/include/mysource.inc(368): Backend->paint()
    #4 /var/www/mysource_matrix/core/web/index.php(30): MySource->start()
    #5 {main}
      thrown in /var/www/mysource_matrix/core/lib/asset_map/asset_map.inc on line 230


What have I done wrong you reckon?

Cheers

K
3

Looks like you're using PostgreSQL 8.3 on v3.18.0. You need to upgrade to v3.18.1 (released on Monday) to support PostgreSQL 8.3 with its new strict type casting.
4

nope

    $ psql -V
    psql (PostgreSQL) 8.1.11
    contains support for command-line editing


Can I jump from 3.16.6 to 3.18.1 (using using the newer tarball rather than 3.18.0?)

K
5

Yes.

6

I’ve gone back and revisited this problem over the weekend and discovered some additional info (this is using 3.18.1)


Bit of bg info… the machine has one name ‘server1.domain.com’ and then I have various sites ‘www.site1.domain.com’, ‘www.site2.domain.com’ etc as cname entries.



I can if I go directly to the machine name (which doesn’t have a URL attached to the site but is added as a root URL) i get the admin menu working fine. If i go in via one of the defined URLs (ie http://www.site1.domain.com/_admin) the asset map throws up that error I posted above.



I’m running this on a test server with a local hosts file overridding DNS to test this out - but I can’t imagine the CMS interacting with DNS or anything? So it must be something to do with the URLs…



Any ideas? HUGE thanks in advance…



K

7

hi… I had already reported simiar issue on [topic=“4983”]this[/topic] thread. I have updated it with more information and error reporting.