[ic] Attempted database update without permission

[John Allman]

Jonathan Clark wrote:

>>>>Hi - i recently set up interchange 4.6.5 on a debian stable box (yes,
>>>>there is a reason for wanting the old version) and am now finding the
>>>>admin interface to be acting up. whenever i attempt to add a new
>>>>product
>>>>it brings me to an error page that says:
>>>>
>>>>
>>>>"The following error occurred:
>>>>
>>>>
>>>>Please correct and try again.
>>>>
>>>>
>>>>/Maybe you need to _*log in*_
>>>><http://www.houseofireland.com/cgi-bin/hoi/admin/login.html>?/ "
>>>>
>>>>
>>>>which isn't very helpful. I then must log in if i wish to view any of
>>>>the admin pages. In the error log i find the following:
>>>>
>>>>
>>>>192.168.0.145 XTQqvWU7:192.168.0.145 - [17/June/2003:12:31:58 +0100]
>>>>hoi
>>>>/cgi-bin/hoi/ui.html Attempted database update without permission,
>>>>table=products key=newproduct.
>>>>
>>>>
>>>>this results from attempting to create a product called newproduct.
>>>>
>>>>
>>>>can anyone suggest what might be causing this, or a way to work out
>>>>precicely what's going wrong?
>>>>        
>>>>
>
>This looks like an Interchange permission error, and not one coming from
>your database, or database files.
>
>It is caused when the scratch value mv_data_enable is not set.
>
>What UI login are you using? Are they a Superuser?
>
>Jonathan
>www.webmaint.net
>
Yep - i went and looked in products/access.asc and found the following line

interchange     passdeleted   Super User              1

as i understand it, the 1 means that this user is a superuser. i removed 
the encrypted password in the above line.

After logging in as the user "interchange" i did a [dump] and found the 
following:

'mv_data_enable' => 0

which seems to agree with what you said. any way for me to find out why 
it is not getting set?

thanks

John