Asset Builder error

Squiz Matrix Support
1

Hi I have a rather simple Asset Builder page that worked previously but is now causing a MySource Error:

[quote]MySource Error 

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

Message: [ASSERT EXCEPTION] DB Error: unknown error

SELECT assetid, type_code, version, name, short_name, status, languages, charset, force_secure, created, created_userid, updated, updated_userid, published, published_userid, status_changed, status_changed_userid FROM sq_ast a WHERE a.assetid IN ('62', '63', '64', '65', '165', '166', '167', '168', '185', '186', '187', '188', '181', '182', '183', '184', '1671', '1672', '1673', '1674', '194', '195', '196', '197', '947', '948', '949', '950', '1679', '574', '572', '2252', '2253', '2254', '2255', '4885', '807', '808', '809', '810', '1680', '4926', '4865', '4866', '4867', '4868', '5015', '5016', '5017', '5018', '169', '170', '171', '172', '198', '199', '200', '201', '202', '203', '204', '205', '4432', '4433', '4434', '4435', '4462', '4463', '4464', '4465', '4483', '4484', '4485', '4486', '4595', '4596', '4597', '4598', '4631', '4632', '4637', '4638', '4639', '4640', '4645', '4646', '4647', '4648', '4649', '475', '825', '826', '827', '828', '851', '852', '853'

Backtrace: Show [/quote]



The page worked previously when there was hardly any content in the site - we now have roughly 5000 assets and it produced this error when browsing to the asset builder page. I haven't logged in yet so I assume this is when it is displaying the Not Logged In bodycopy:

    You must log in to create a new page:
    
    %login_form%



It is set to create Standard Pages in Under contruction status.

It has a dynamic create location set to the root node of the entire site with infinite levels.

Any idea what could be causing this problem?

Thanks,
Sarah
2

I think you're trying to do too much with the dynamic create location. The error you are getting is due to having Matrix load too many assets at once to create the drop-down.


You may need to give people less options, or allow them backend access if you want total freedom for create locations.

3

[quote]I think you’re trying to do too much with the dynamic create location. The error you are getting is due to having Matrix load too many assets at once to create the drop-down.


You may need to give people less options, or allow them backend access if you want total freedom for create locations.

[right][post=“8062”]<{POST_SNAPBACK}>[/post][/right][/quote]



OK I changed it to have 5 dynamic location sets (we have 5 main content areas within our site).



I then gave each of the 5 sets only two levels instead of infinite and am still getting the exact same error.

4

I've now created 5 different asset builder pages for the five sections instead and that is now working.

5

Well four of the five are working…


Strangely the area/branch of the site it is not working for doesn't contain as many assets as another area/branch that an asset builder is working for?



It is set to a dynamic create location.



I have restricted it to standard pages, including both link types 1 and 2, and have even restricted it to 1 level. The root node only has 13 standard pages beneath it. A working asset builder has 25 directly beneath and depth set to infinite levels.



Could it be something other than attempting to load too many assets that is causing the problem?



Thanks

6

Is it the same error? Paste the new error in here.

7

[quote]Is it the same error? Paste the new error in here.
[right][post=“8114”]<{POST_SNAPBACK}>[/post][/right][/quote]



Same error - different asset ID’s.


[quote]MySource Error 

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

Message: [ASSERT EXCEPTION] DB Error: unknown error

SELECT assetid, type_code, version, name, short_name, status, languages, charset, force_secure, created, created_userid, updated, updated_userid, published, published_userid, status_changed, status_changed_userid FROM sq_ast a WHERE a.assetid IN ('174', '175', '176', '206', '207', '208', '209', '859', '860', '861', '862', '1412', '1413', '1414', '1415', '1420', '1421', '1422', '1423', '1429', '1430', '1431', '1432', '1443', '1444', '1445', '1446', '939', '940', '941', '942', '867', '868', '869', '870', '1563', '1564', '1565', '1566', '951', '952', '953', '954', '991', '992', '993', '994', '1469', '1470', '1471', '1472', '1478', '1481', '1483', '1484', '1485', '1486', '1487', '1488', '1525', '1526', '1527', '1528', '1583', '1584', '1585', '1586', '1000', '1001', '1002', '1003', '1116', '1117', '1118', '1119', '1639', '1640', '1641', '1642', '1012', '1013', '1014', '1015', '2475', '2476', '2477', '2478', '1232', '1233', '1234', '1235', '2423', '2424', '24

Backtrace: Show [/quote]

8

This happens when just viewing the asset builder page?

9

[quote]This happens when just viewing the asset builder page?
[right][post=“8116”]<{POST_SNAPBACK}>[/post][/right][/quote]

Yes.



If I delete the dynamic create location set I reach the not logged in bodycopy (or logged in bodycopy if I am refreshing the page I have already logged into).



The moment I re-add the dynamic create location and refresh I receive the same error.



There are a lot of assets beneath the root node of this dynamic create location however I thought setting the depth to 1 level would prevent this problem of it falling over as there are only 13 assets directly beneath it.

10

Another asset builder I have created to allow authors to upload images is returning PHP errors:

[quote]PHP Notice 

File: [SYSTEM_ROOT]/core/include/mysource.inc Line: 979

Message: Undefined index: userid

Backtrace: Show 



PHP Notice 

File: [SYSTEM_ROOT]/core/include/mysource.inc Line: 980

Message: Undefined index: user_type_code

Backtrace: Show 



PHP Notice 

File: [SYSTEM_ROOT]/core/include/mysource.inc Line: 984

Message: Undefined index: remote_addr

Backtrace: Show[/quote]



It has a fixed create location pointing to an images folder.



Any ideas?



Sarah

11

[quote]Any ideas?


Sarah

[right][post=“8143”]<{POST_SNAPBACK}>[/post][/right][/quote]



Hi Sarah,



I assume this asset builder is being accessed and causing problems when not logged in ie. with the public user?



This problem seems to be stemming from the image editor that is present on the create interface for an image asset. It is attempting to get the current session details, but due to their being no logged in details, it is causing dramas.



Regards,



Darren

12

[quote]I assume this asset builder is being accessed and causing problems when not logged in ie. with the public user?


This problem seems to be stemming from the image editor that is present on the create interface for an image asset. It is attempting to get the current session details, but due to their being no logged in details, it is causing dramas.

[right][post=“8144”]<{POST_SNAPBACK}>[/post][/right][/quote]



Thanks Darren - I have now linked to the asset builder from the Details SimpleEdit layout - this ensures the user is already logged in.



Cheers,

Sarah

13

[quote]There are a lot of assets beneath the root node of this dynamic create location however I thought setting the depth to 1 level would prevent this problem of it falling over as there are only 13 assets directly beneath it.
[right][post=“8122”]<{POST_SNAPBACK}>[/post][/right][/quote]



In regards to this problem, the levels should be working correctly now. Previously the levels were not obeyed when the ‘show as tree’ option was unchecked. Now, regardless of other options, the levels will be adhered to.



This change has been made in 3.6.x and 3.7.x and any new upgrade or release will contain the fixes.

14

[quote]This change has been made in 3.6.x and 3.7.x and any new upgrade or release will contain the fixes.
[right][post=“8148”]<{POST_SNAPBACK}>[/post][/right][/quote]



Nice one - thanks :slight_smile:



Sarah

15

[quote]This change has been made in 3.6.x and 3.7.x and any new upgrade or release will contain the fixes.
[right][post=“8148”]<{POST_SNAPBACK}>[/post][/right][/quote]



Just to confirm - as asset builders are part of the commercial modules do I have to get this latest release with the fix from Squiz - or can I download from:

http://matrix.squiz.net/download/all_versions/3.6.2



Also in regards to an upgrade is it simply a matter of re-running the 3 steps?



Cheers,

Sarah

16

You need the fix from Squiz. The upgrade will be a re-running of steps 2 and 3 at most, assuming you are on a 3.6.x release.

17

We upgraded to 3.6.4 but now seem to have a permissions (or ldap) issue.


I don't think it is ldap as our bridge is displaying correctly and all users can login/are recognised.



The problem happens when attempting to acquire locks.



Users with write permission on a particular asset cannot acquire a lock in the admin backend - the button isn't there and it just has a "Show lock details" link. When you click it says Attributes - You do not have access to edit "Page Contents" and Links - You do not have access to edit "Page Contents".



On the SimpleEdit front end if you append /_edit to the page and try to login in it throws the MySource Warning:

MySource Warning

File: [SYSTEM_ROOT]/core/hipo/hipo_job.inc Line: 500

Message: A HIPO Job with this code name is currently run by "sdelfante" (Id: #5277:CN=sdelfante,CN=Users,DC=lib-staff,DC=library,DC=uwa,DC=edu,DC=au)

. last updated at 20/01/2006 11:58:27 [HIPO0041]

Backtrace: Show



You can still change the page to Safe Edit but can't edit contents or metadata.



Strangely if you do change the page to Safe Edit in SimpleEdit and then log back into the admin backend you can edit? But this is a problem as we haven't trained our web authors in the backend - only in SimpleEdit.





I have logged this with support but can anyone quickly think what this might be? Anyone else on 3.6.4?

18

[quote]In regards to this problem, the levels should be working correctly now. Previously the levels were not obeyed when the ‘show as tree’ option was unchecked. Now, regardless of other options, the levels will be adhered to.


This change has been made in 3.6.x and 3.7.x and any new upgrade or release will contain the fixes.

[right][post=“8148”]<{POST_SNAPBACK}>[/post][/right][/quote]



We’ve just upgraded to 3.6.4 this morning and this asset builder error has persisted, in addition to the permissions error we’re now experiencing which is detailed in my post above.



:frowning:

19

In regards to the permission problem I realise now the admin/backend is fine. I just can't acquire the lock until I change the page status to Safe Edit (duh!).


So the problem seems to be SimpleEdit only - when attempting to acquire the lock it fails and throws up the MySource Warning.

20

For what it's worth, the Safe Simple Edit issue is something that we are looking into at the moment, as I've seen the same thing happen on other systems in certain situations.