[Erw-devel] 1.0b2 problem with XP & IE6

[erw-devel]

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!