problem with previewing a new document

I’have a problem.

When i create a new document under a parent and i have filled all the text fields with the right content.
The i save the document to see preview without publishing it.

Then i get the next error:
SELECT fullname FROM `depluimb_modx`.`modx_user_attributes` WHERE `depluimb_modx`.`modx_user_attributes`.id =

I tried different things to locate them problem, but wihtout any results.


This are the system details:

MODx versie 0.9.6.3
Versie codenaam rev 4565
phpInfo() Bekijken
Toegangsrechten Ingeschakeld
Server tijd 20:22:06
Lokale tijd 20:22:06
Server verschil 0 h
Database naam depluimb_modx
Database server localhost
Database Version: 5.0.67-community
Database Karakterset latin1
Database Collatie Karakterset latin1_swedish_ci
Tabel voorvoegsel (prefix) modx_

Does somebody has a idea to solve this problem?

Can you save the document correctly?

Can you post the entire error you’re seeing? That only looked like part of it.

Do you have access to the MySQL command prompt? Or to something like PhpMyAdmin where you can execute SQL queries?

The document is saved correctly, but everytime i will see this error notice.

I have acces tot the database in phpmyadmin to run sql queries.

Yes, please paste the ENTIRE error. That wasn’t the entire error. It was only part of it.

If you have access to PhpMyAdmin, can you do:

SELECT * FROM site_content WHERE id=xxx;

and xxx is your page id. Are there any missing fields there? Do you get an error in MySQL?

I have done the next sqlquery
SELECT * FROM `modx_site_content`
WHERE (
(
`modx_site_content`.`id` =277
)
)
AND (
id =277
)

with the next result

I add the result a file

mmm... nothing looks strange in your Excel sheet..

Your first SQL error is strange though... it’s an error about an unrelated table. At least... that table SHOULDN’T be related.

Can you execute this query on your database:


What does that produce?

What’s on the page, and why are users involved? You may want to go to "Security-->Manager Users" and see if your information is complete in there.

What document group does the one document belong to? (The one that you are trying to add a child to).

It looks like it’s choking on trying a check for permissions to that document?

Is the document a member of any document groups? If so, try removing it from all of them. If that fixes things, there may be something wrong with the way you have premissions set.

Quote from: BobRay at May 08, 2009, 12:29 PM

Is the document a member of any document groups? If so, try removing it from all of them. If that fixes things, there may be something wrong with the way you have premissions set.

The document is member of document group"Redacteuren". I have tried several things called above but it doensn’t solve the problem.

Is there good documentation about how to set the total security configuration for modx.
Or can somebody help me to have look into my security for the manager??

An other problem is now:
When a user is in the group "redacteuren" and someone in that group is making a new item. Then on the new item there is no security at all.
There’s no inheritance security from the parent al all.

Is there a way to set the inheritance for new items?

There might be an easier way, but one way would be to use a plugin to guide the inheritance. It could listen to the event that corresponds to a manager creating a new document.

My guess is that something like that is already in the repository (since it is a common task). Have a look at the "Inherit Parent Template" plugin (Resources --> Manage Resources --> Plugins) -- it’s basically doing the exact type of thing, it’s just guiding the inheritance of a different field. The event it listens to is named "OnDocFormPrerender" -- maybe search the forum and/or repository for that and see what you find.