[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Erw-devel] 1.0b2 problem with XP & IE6
From: |
erw-devel |
Subject: |
[Erw-devel] 1.0b2 problem with XP & IE6 |
Date: |
Thu, 9 Oct 2003 13:26:59 +1000 |
Hi,
I have been told over the phone about a problem with the main browse lists
after I upgraded an ERW installation from 0.9.9b3 to 1.0b2
(on Debian 3.0, Apache 1.3.26, php 4.1.2, mysql 3.23.49).
Starting at index.php & clicking on any of the table/type links will launch
the browse list for that entity (list.php?type=......) Although the browse
list was displayed there were no entities in the list. The laptop was using
Internet Explorer 6.0.2800.1106.xpsp2.030422-1633 & Windows XP Professional
version 2002.sp1. The problem continued to occur after emptying the browser
cache, rebooting & trying ERW again.
I was able to login (custom authentication checking usr.login & password) as
the same user on Linux/Mozilla & Windows 98/IE 6.0 and use the same browse
lists with no problems, seeing all entities. And without XP here it will be
difficult to easily reproduce the browse list problem.
I had changed tbl to type as mentioned in ERW-1.0b2/CHANGES & used ertool
--defs & --sql etc & then imported old entity data from 0.9.9b3 into the
1.0b2 database. The database has entries in type (nee tbl) and row
authorisation, but the problem occured with & without row authorisation. As
the server is part of a development environment I have reverted back to the
last working version 0.9.9b3, so unfortunately cant simply include a link to
the website.
Below I have included some relevant Apache log data with the remote XP/IE6
user that was unable to see entities in browse list.
I'm wondering if this is related to the comment in the annoucement of 1.0b2
replacing 1.0b1 that the new was needed due to an Internet Explorer problem?
I hope this is enough information,
Jason.
Apache access.log:
192.168.0.2 - jwood [09/Oct/2003:10:55:58 +1000] "GET
/erw/list.php?type=altresponsecode HTTP/1.0" 200 6354
Apache error.log with DEBUG on in ERW-conf.php (trimmed slightly):
DEBUG: Loading global definitions from
"/var/www/asoka/questions/erw/defs/questions.php" (/usr/local/share/ER
W-1.0b2/php/ERW.php:291)
DEBUG: Negotiated locale en_AU with browser
(/usr/local/share/ERW-1.0b2/php/ERW.php:402)
DEBUG: Actual locale is en_AU located in
/usr/local/share/asoka/questions/locale (/usr/local/share/ERW-1.0b2/
php/ERW.php:413)
DEBUG: Opening database URL ..... (/usr/local/share/ERW-1.0b2/php/ERW.
php:1725)
DEBUG: Loading definitions for 'altresponsecode' from
/var/www/asoka/questions/erw/defs/altresponsecode.php (
/usr/local/share/ERW-1.0b2/php/ERW.php:674)
DEBUG: DB getOne: SELECT id from usr WHERE
login='jwood' (/usr/local/share/ERW-1.0b2/php/ERW.php:1821)
DEBUG: DB getOne: SELECT id_primary_grp
from usr where id=4 (/usr/local/share/ERW-1.0b2/php/ERW.php:1821)
DEBUG: Authenticated user with id 4 and
primary group 2 (/usr/local/share/ERW-1.0b2/php/ERW.php:1197)
DEBUG: Loading definitions for 'type' from
/var/www/asoka/questions/erw/defs/type.php (/usr/local/share/ERW-1
.0b2/php/ERW.php:674)
DEBUG: Loading definitions for 'usr' from
/var/www/asoka/questions/erw/defs/usr.php (/usr/local/share/ERW-1.0
b2/php/ERW.php:674)
DEBUG: Loading custom file for 'usr' from
/var/www/asoka/questions/erw/defs/custom/usr.php (/usr/local/share/
ERW-1.0b2/php/ERW.php:696)
DEBUG: Loading definitions for 'grp' from
/var/www/asoka/questions/erw/defs/grp.php (/usr/local/share/ERW-1.0
b2/php/ERW.php:674)
DEBUG: DB query: UNLOCK TABLES .....
DEBUG: DB getOne: SELECT id FROM type WHERE name='altresponsecode'
(/usr/local/share/ERW-1.0b2/php/ERW.php:18
21)
DEBUG: DB getRow: SELECT selectpriv,
updatepriv, insertpriv, deletepriv, usrselectpriv, usrupdatepriv, usrdel
etepriv, grpselectpriv, grpupdatepriv, grpdeletepriv from type where
name='altresponsecode' (/usr/local/share/ERW-1.0b2/php/ERW.php:1802)
DEBUG: DB getRow: SELECT selectpriv,
updatepriv, insertpriv, deletepriv, usrselectpriv, usrupdatepriv, usrdel
etepriv, grpselectpriv, grpupdatepriv, grpdeletepriv from usrauth where
id0_usr=4 and id1_type=2 (/usr/local/share/ERW-1.0b2/php/ERW.php:1802)
DEBUG: DB getRow: SELECT selectpriv,
updatepriv, insertpriv, deletepriv, usrselectpriv, usrupdatepriv, usrdel
etepriv, grpselectpriv, grpupdatepriv, grpdeletepriv from grpauth where
id0_grp=2 and id1_type=2 (/usr/local/share/ERW-1.0b2/php/ERW.php:1802)
DEBUG: DB getRow: SELECT
MAX(ASCII(selectpriv)-ASCII('0')), MAX(ASCII(updatepriv)-ASCII('0')),
MAX(ASCII(insertpriv)-ASCII('0')), MAX(ASCII(deletepriv)-ASCII('0')),
MAX(ASCII(usrselectpriv)-ASCII('0')), MAX(ASCII(usrupdatepriv)-ASCII('0')),
MAX(ASCII(usrdeletepriv)-ASCII('0')), MAX(ASCII(grpselectpriv)-ASCII('0')),
MAX(ASCII(grpupdatepriv)-ASCII('0')), MAX(ASCII(grpdeletepriv)-ASCII('0'))
from belongs inner join grpauth on belongs.id1_grp=grpauth.id0_grp where
belongs.id0_usr=4 and grpauth.id1_type=2 (/usr/local/share/ERW-1.0b2/php/ERW
.php:1802)
DEBUG: DB getOne: SELECT COUNT(*) from
belongs where id0_usr=4 and id1_grp=0 (/usr/local/share/ERW-1.0b2/php/
ERW.php:1821)
DEBUG: DB query: UNLOCK TABLES
(/usr/local/share/ERW-1.0b2/php/ERW.php:1767)
INFO: Granting user 4 select, update, insert, delete privileges for
altresponsecode. (/usr/local/share/ERW-1.0b2/php/ERW.php:1362)
DEBUG: Printing form for altresponsecode
(/usr/local/share/ERW-1.0b2/php/ERW.php:3404)
Now, with the same database & same ERW site but this is me using Win98/IE 6 &
I was able to see entities and modify any of them. Previously I also used
Linux/Mozilla 1.1 with no problems too.
Apache access.log
192.168.0.2 - jason [09/Oct/2003:10:54:06 +1000] "GET
/erw/list.php?type=altresponsecode HTTP/1.0" 200 6354
192.168.0.2 - jason [09/Oct/2003:10:54:07 +1000] "GET
/erw/load.php?;n[]=m_altresponsecode HTTP/1.0" 200 967
End of message!
- [Erw-devel] 1.0b2 problem with XP & IE6,
erw-devel <=