Re: [Phpgroupware-users] Sitemgr config problem

[Patrick Walsh (mr_e)]

    OK, your problem is extremely strange.  We're going to have to do a
little bit of debugging.  Let's ignore categories for now and concentrate on
the preferences page.  I assume when that starts working, everything will.
The thing with the categories is that the phpgw api handles the writes.

    Before I give suggestions as to things to try to debug, please drop to
your file system and make sure there is one user and one group owning the
entire phpgw tree (except maybe if you have special virtual file manager
directories).  Then make sure that all of the files are publicly readable.
Something like this would do:

cd /path/to/phpgroupware
chown -R user.group *
chmod -R 755 *
chmod -R 644 *.php *.tpl *.gif *.png

(there are fancier ways to do this with the find command, but this should
suffice)

    This way we can be assured that there isn't some odd file permissions
problem.

    What version of MySQL are you using?

    Next, if the problem persists, edit
sitemgr/inc/class.sitePreference_SO.inc.php.  Go to the setPreference
function and first lets just make sure it's getting called.  So before the
first line of the function put this:

    echo 'Setting preference ' . $name . ' to ' . $value . '<br>';

    (that was line 13)

    Next, if you are seeing that line above when you save your preferences
(you should see it 10 or so times over), then the function is being called
but apparently something is still wrong.  Find the two '$sql = ' lines,
ignoring the very first 'SELECT' one.  Right before the '$this->db->query'
lines put this: 

    echo '  Query: ' . $sql . '<br>';

    Now when you save your page, look for blank values anywhere, like quotes
that go '' and such.

    At this point report back to us and we'll figure out where to go from
there.  Maybe save some of the debug output for us to look over (just copy
and paste it).

..Patrick


On 12/5/02 8:31 AM, "Brett Shadbolt" <address@hidden> wrote:

> Sorry guys,
> 
> I have played with register_gloabals - turned it on off on again - no
> difference. I have left it turned off.
> 
> It seems that sitemgr is not writing to the mysql tables. The
> sitemgr_preferences table only had the catsupdated record and no others. I
> have manually entered some of the name/value pairs suggested and they stick,
> i.e. when I return to phpgw they appear in the sitemgr setup area. Only
> pronlem is I don't know some of the variable defaults (interface. themesel,
> etc and the sitemgr-site-name-en doesn't seems to be correct as this doesn't
> come up).
> 
> The problem is now that I cannot add categories via phpgw sitemgr control
> system. As discussed before, when I click the add button it just refreshes
> and comes back to the same page.
> 
> There is no sitemgr-categories table, I presume that all categories are stored
> in the phpgw_categories table. If so can someone give me an example category
> record that I can try.
> 
> If this works then I know the only outstanding problem is getting sitemgr to
> write to the tables itself.
> 
> I have checked the log files - no errors anywhere that I can see.
> 
> It just seems that sitemgr does have any links to mysql. Sitemgr obviously
> reads from the correct table but cannot write to it.
> 
> Regards,
> 
> Brett Shadbolt
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>