No subject
Mon Aug 23 13:42:47 EDT 2004
when using SSL the two links "Add All to Cart" and "Add Checked to Cart" =
drop you out of https. Caused by controller.xml not specifying <security =
https=3D"true" auth=3D"false"/> for uri "addordertocart".
CatalogMgr:
http://localhost:8080/catalog/control/EditProductFeatures?productId=3DGZ-=
2644 fails:-
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while =
executing the following:SELECT PF.PRODUCT_FEATURE_ID, =
PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID, =
PF.DESCRIPTION, PF.UOM_ID, PF.NUMBER_SPECIFIED, PF.DEFAULT_SEQUENCE_NUM, =
PF.ABBREV, PF.ID_CODE, PFA.PRODUCT_ID, PFA.PRODUCT_FEATURE_APPL_TYPE_ID, =
PFA.FROM_DATE, PFA.THRU_DATE, PFA.SEQUENCE_NUM, PFA.AMOUNT FROM =
PRODUCT_FEATURE PF JOIN PRODUCT_FEATURE_APPL PFA ON =
PF.PRODUCT_FEATURE_ID=3DPFA.PRODUCT_FEATURE_ID WHERE PFA.PRODUCT_ID=3D? =
ORDER BY PFA.SEQUENCE_NUM, PFA.PRODUCT_FEATURE_APPL_TYPE_ID, =
PF.PRODUCT_FEATURE_TYPE_ID, PF.DESCRIPTION (Syntax error or access =
violation: You have an error in your SQL syntax near 'ON =
PF.PRODUCT_FEATURE_ID=3DPFA.PRODUCT_FEATURE_ID WHERE =
PFA.PRODUCT_ID=3D'GZ-2644' O' at line 1)
Auto create keywords fails:- (and obviously "Re-induce Keywords" also =
fails)
1304922[ ProductEvents.java:232:WARN ] =
[ProductEvents.updateAllKeywords] Could not create
product-keyword (write error); message: SQL Exception while executing =
the following:SELECT PF.PRODUCT_FEATURE_ID, PF.PRODUCT_FEATURE_TYPE_ID, =
PF.PRODUCT_FEATURE_CATEGORY_ID, PF.DESCRIPTION, PF.UOM_ID, =
PF.NUMBER_SPECIFIED, PF.DEFAULT_SEQUENCE_NUM, PF.ABBREV, PF.ID_CODE, =
PFA.PRODUCT_ID, PFA.PRODUCT_FEATURE_APPL_TYPE_ID, PFA.FROM_DATE, =
PFA.THRU_DATE, PFA.SEQUENCE_NUM, PFA.AMOUNT FROM PRODUCT_FEATURE PF JOIN =
PRODUCT_FEATURE_APPL PFA ON =
PF.PRODUCT_FEATURE_ID=3DPFA.PRODUCT_FEATURE_ID WHERE PFA.PRODUCT_ID=3D? =
(Syntax error or access violation: You have an error in your SQL syntax =
near 'ON PF.PRODUCT_FEATURE_ID=3DPFA.PRODUCT_FEATURE_ID WHERE =
PFA.PRODUCT_ID=3D'GZ-2644'' at line 1)
OrderMgr:
Create an order and try to view it - =
http://localhost:8080/ordermgr/control/orderview?order_id=3D10000 =
fails:-
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while =
executing the following:SELECT OD.ORDER_ID, ND.NOTE_ID, ND.NOTE_NAME, =
ND.NOTE_INFO, ND.NOTE_DATE_TIME, PR.PARTY_ID, PR.FIRST_NAME, =
PR.LAST_NAME FROM (ORDER_HEADER_NOTE OD JOIN NOTE_DATA ND ON =
OD.NOTE_ID=3DND.NOTE_ID) JOIN PERSON PR ON ND.NOTE_PARTY=3DPR.PARTY_ID =
WHERE OD.ORDER_ID=3D? ORDER BY ND.NOTE_DATE_TIME DESC (Syntax error or =
access violation: You have an error in your SQL syntax near 'ON =
OD.NOTE_ID=3DND.NOTE_ID) JOIN PERSON PR ON ND.NOTE_PARTY=3DPR.PARTY_ID =
WHERE OD.O' at line 1)
WebTools:
Changes for controller.xml SSL issues:
Main link drops out of https: (this is also broken in WorkEffort)
<request-map uri=3D"main">
<security https=3D"false" auth=3D"false"/>
should be:
<request-map uri=3D"main">
<security https=3D"true" auth=3D"false"/>
View also has the same problem:
<request-map uri=3D"view">
<security https=3D"false" auth=3D"false"/>
should be
<request-map uri=3D"view">
<security https=3D"true" auth=3D"true"/>
WorkEffort:
The "New Project" link in the "Projects" section fails:-
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while =
executing the following:SELECT WE.WORK_EFFORT_ID, =
WE.WORK_EFFORT_TYPE_ID, WE.WORK_EFFORT_PURPOSE_TYPE_ID, =
WE.WORK_EFFORT_PARENT_ID, WE.CURRENT_STATUS_ID, WE.LAST_STATUS_UPDATE, =
WE.UNIVERSAL_ID, WE.SCOPE_ENUM_ID, WE.PRIORITY, WE.WORK_EFFORT_NAME, =
WE.DESCRIPTION, WE.LOCATION_DESC, WE.REVISION_NUMBER, WE.FIXED_ASSET_ID, =
WE.FACILITY_ID, WE.CREATED_DATE, WE.CREATED_BY_PARTY_ID, =
WE.LAST_MODIFIED_DATE, WE.LAST_MODIFIED_BY_PARTY_ID, =
WE.ESTIMATED_START_DATE, WE.ESTIMATED_COMPLETION_DATE, =
WE.ESTIMATED_MILLI_SECONDS, WE.TOTAL_MILLI_SECONDS_ALLOWED, =
WE.TOTAL_MONEY_ALLOWED, WE.MONEY_UOM_ID, WE.ACTUAL_START_DATE, =
WE.ACTUAL_COMPLETION_DATE, WE.ACTUAL_MILLI_SECONDS, WE.SPECIAL_TERMS, =
WE.TIME_TRANSPARENCY, WE.INFO_URL, WE.RECURRENCE_INFO_ID, =
WE.RUNTIME_DATA_ID, WE.NOTE_ID, WE.SERVICE_LOADER_NAME, WEPA.PARTY_ID, =
WEPA.ROLE_TYPE_ID, WEPA.FROM_DATE, WEPA.THRU_DATE, WEPA.FACILITY_ID, =
WEPA.STATUS_ID, WEPA.STATUS_DATE_TIME, WEPA.COMMENTS, WEPA.MUST_RSVP, =
WEPA.EXPECTATION_ENUM_ID FROM WORK_EFFORT WE JOIN =
WORK_EFFORT_PARTY_ASSIGNMENT WEPA ON =
WE.WORK_EFFORT_ID=3DWEPA.WORK_EFFORT_ID WHERE WE.WORK_EFFORT_ID IS NULL =
(Syntax error or access violation: You have an error in your SQL syntax =
near 'ON WE.WORK_EFFORT_ID=3DWEPA.WORK_EFFORT_ID WHERE WE.WORK_EFFORT_ID =
IS NULL' at line 1)
------=_NextPart_000_027C_01C25860.ACA05A90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Some of these are serious and some not =
so serious,=20
but all worth tidying up.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Tested against W2K SP3, 1.4.0_01, =
Tomcat 4.0.4,=20
MySQL 3.23.51:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>PartyMgr:<BR>Party ID lookup on "admin" =
fails:-<BR>org.ofbiz.core.entity.GenericDataSourceException: SQL =
Exception while=20
executing the following:SELECT PR.PARTY_ID, RT.ROLE_TYPE_ID, =
</FONT><FONT=20
face=3DArial size=3D2>RT.DESCRIPTION FROM ROLE_TYPE RT JOIN PARTY_ROLE =
PR ON=20
RT.ROLE_TYPE_ID=3DPR.ROLE_TYPE_ID WHERE PR.PARTY_ID=3D? (Syntax =
</FONT><FONT=20
face=3DArial size=3D2>error or access violation: You have an error in =
your SQL=20
syntax near 'ON RT.ROLE_TYPE_ID=3DPR.ROLE_TYPE_ID WHERE =
PR.PARTY_ID=3D'admin''=20
</FONT><FONT face=3DArial size=3D2>at line 1)<BR>User Login ID on "admin =
fails:-<BR>Cannot get party entities (read failure): SQL Exception while =
executing the following:SELECT PTY.PARTY_ID, PTY.PARTY_TYPE_ID, =
</FONT><FONT=20
face=3DArial size=3D2>ULN.USER_LOGIN_ID, ULN.CURRENT_PASSWORD, =
ULN.PASSWORD_HINT,=20
ULN.ENABLED, ULN.DISABLED_DATE_TIME, </FONT><FONT face=3DArial=20
size=3D2>ULN.SUCCESSIVE_FAILED_LOGINS FROM PARTY PTY JOIN USER_LOGIN ULN =
ON=20
PTY.PARTY_ID=3DULN.PARTY_ID WHERE </FONT><FONT face=3DArial=20
size=3D2>UPPER(ULN.USER_LOGIN_ID) LIKE ? (Syntax error or access =
violation: You=20
have an error in your SQL syntax near 'ON </FONT><FONT face=3DArial=20
size=3D2>PTY.PARTY_ID=3DULN.PARTY_ID WHERE UPPER(ULN.USER_LOGIN_ID) LIKE =
'%ADMIN%' '=20
at line 1)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>ecommerce:<BR>Giant Widget is reporting =
"This item=20
is out of stock." in product summary when catalog is first loaded and no =
orders=20
have been placed, the product list </FONT><FONT face=3DArial =
size=3D2>displays the=20
"Choose Variation" link, but you can't choose it!<BR>View Cart's =
Recalculate=20
Cart - when used on an empty cart causes JavaScript error.<BR>Order =
History,=20
crashes with an exception in the server and browser. Simple Collection =
to List=20
fix need in orderhistory.jsp.<BR>Order Confirmation shows a "=C2" in the =
Unit=20
Price column just before the local specific currency symbol =
"=A3".<BR>Micro cart=20
and mini cart total are displaying always "$" rather than the system=20
local.<BR>Credit card has to be validated online by default now. No =
obvious=20
replacement for "order.payment.service" setting for turning payment =
service off,=20
could </FONT><FONT face=3DArial size=3D2>at guess at setting =
"hostAddress" blank in=20
payflow.properties?!<BR>From the order history link <A=20
href=3D"https://localhost:8080/ecommerce/control/orderstatus?order_id=3D1=
0000">https://localhost:8080/ecommerce/control/orderstatus?order_id=3D100=
00</A>=20
when using SSL the two links "Add All to Cart" and </FONT><FONT =
face=3DArial=20
size=3D2>"Add Checked to Cart" drop you out of https. Caused by =
controller.xml not=20
specifying <security https=3D"true" auth=3D"false"/> for uri=20
"addordertocart".</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>CatalogMgr:<BR><A=20
href=3D"http://localhost:8080/catalog/control/EditProductFeatures?product=
Id=3DGZ-2644">http://localhost:8080/catalog/control/EditProductFeatures?p=
roductId=3DGZ-2644</A>=20
fails:-<BR>org.ofbiz.core.entity.GenericDataSourceException: SQL =
Exception while=20
executing the following:SELECT PF.PRODUCT_FEATURE_ID, </FONT><FONT =
face=3DArial=20
size=3D2>PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID,=20
PF.DESCRIPTION, PF.UOM_ID, PF.NUMBER_SPECIFIED, </FONT><FONT =
face=3DArial=20
size=3D2>PF.DEFAULT_SEQUENCE_NUM, PF.ABBREV, PF.ID_CODE, PFA.PRODUCT_ID, =
PFA.PRODUCT_FEATURE_APPL_TYPE_ID, </FONT><FONT face=3DArial =
size=3D2>PFA.FROM_DATE,=20
PFA.THRU_DATE, PFA.SEQUENCE_NUM, PFA.AMOUNT FROM PRODUCT_FEATURE PF JOIN =
PRODUCT_FEATURE_APPL </FONT><FONT face=3DArial size=3D2>PFA ON=20
PF.PRODUCT_FEATURE_ID=3DPFA.PRODUCT_FEATURE_ID WHERE PFA.PRODUCT_ID=3D? =
ORDER BY=20
PFA.SEQUENCE_NUM, </FONT><FONT face=3DArial=20
size=3D2>PFA.PRODUCT_FEATURE_APPL_TYPE_ID, PF.PRODUCT_FEATURE_TYPE_ID,=20
PF.DESCRIPTION (Syntax error or access violation: You have an =
</FONT><FONT=20
face=3DArial size=3D2>error in your SQL syntax near 'ON=20
PF.PRODUCT_FEATURE_ID=3DPFA.PRODUCT_FEATURE_ID WHERE =
PFA.PRODUCT_ID=3D'GZ-2644' O'=20
at line 1)<BR>Auto create keywords fails:- (and obviously =
"Re-induce=20
Keywords" also fails)<BR>1304922[ =20
ProductEvents.java:232:WARN ] [ProductEvents.updateAllKeywords] Could =
not=20
create<BR>product-keyword (write error); message: SQL Exception while =
executing=20
the following:SELECT PF.PRODUCT_FEATURE_ID, </FONT><FONT face=3DArial=20
size=3D2>PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID,=20
PF.DESCRIPTION, PF.UOM_ID, PF.NUMBER_SPECIFIED, </FONT><FONT =
face=3DArial=20
size=3D2>PF.DEFAULT_SEQUENCE_NUM, PF.ABBREV, PF.ID_CODE, PFA.PRODUCT_ID, =
PFA.PRODUCT_FEATURE_APPL_TYPE_ID, </FONT><FONT face=3DArial =
size=3D2>PFA.FROM_DATE,=20
PFA.THRU_DATE, PFA.SEQUENCE_NUM, PFA.AMOUNT FROM PRODUCT_FEATURE PF JOIN =
PRODUCT_FEATURE_APPL </FONT><FONT face=3DArial size=3D2>PFA ON=20
PF.PRODUCT_FEATURE_ID=3DPFA.PRODUCT_FEATURE_ID WHERE PFA.PRODUCT_ID=3D? =
(Syntax=20
error or access violation: You have an </FONT><FONT face=3DArial =
size=3D2>error in=20
your SQL syntax near 'ON PF.PRODUCT_FEATURE_ID=3DPFA.PRODUCT_FEATURE_ID =
WHERE=20
PFA.PRODUCT_ID=3D'GZ-2644'' at line 1)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>OrderMgr:<BR>Create an order and try to =
view it -=20
<A=20
href=3D"http://localhost:8080/ordermgr/control/orderview?order_id=3D10000=
">http://localhost:8080/ordermgr/control/orderview?order_id=3D10000</A>=20
fails:-<BR>org.ofbiz.core.entity.GenericDataSourceException: SQL =
Exception while=20
executing the following:SELECT OD.ORDER_ID, ND.NOTE_ID, </FONT><FONT =
face=3DArial=20
size=3D2>ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, PR.PARTY_ID,=20
PR.FIRST_NAME, PR.LAST_NAME FROM (ORDER_HEADER_NOTE </FONT><FONT =
face=3DArial=20
size=3D2>OD JOIN NOTE_DATA ND ON OD.NOTE_ID=3DND.NOTE_ID) JOIN PERSON PR =
ON=20
ND.NOTE_PARTY=3DPR.PARTY_ID WHERE OD.ORDER_ID=3D? </FONT><FONT =
face=3DArial=20
size=3D2>ORDER BY ND.NOTE_DATE_TIME DESC (Syntax error or access =
violation: You=20
have an error in your SQL syntax near 'ON </FONT><FONT face=3DArial=20
size=3D2>OD.NOTE_ID=3DND.NOTE_ID) JOIN PERSON PR ON =
ND.NOTE_PARTY=3DPR.PARTY_ID WHERE=20
OD.O' at line 1)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>WebTools:<BR>Changes for controller.xml =
SSL=20
issues:<BR>Main link drops out of https: (this is also broken in=20
WorkEffort)<BR> <request-map =
uri=3D"main"><BR> =20
<security https=3D"false" auth=3D"false"/><BR>should be:<BR> =
<request-map uri=3D"main"><BR> =
<security=20
https=3D"true" auth=3D"false"/><BR>View also has the same=20
problem:<BR> <request-map=20
uri=3D"view"><BR> =
<security=20
https=3D"false" auth=3D"false"/><BR>should be<BR> =20
<request-map =
uri=3D"view"><BR> =20
<security https=3D"true" auth=3D"true"/></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>WorkEffort:<BR>The "New Project" link =
in the=20
"Projects" section =
fails:-<BR>org.ofbiz.core.entity.GenericDataSourceException:=20
SQL Exception while executing the following:SELECT WE.WORK_EFFORT_ID,=20
</FONT><FONT face=3DArial size=3D2>WE.WORK_EFFORT_TYPE_ID,=20
WE.WORK_EFFORT_PURPOSE_TYPE_ID, WE.WORK_EFFORT_PARENT_ID, =
WE.CURRENT_STATUS_ID,=20
</FONT><FONT face=3DArial size=3D2>WE.LAST_STATUS_UPDATE, =
WE.UNIVERSAL_ID,=20
WE.SCOPE_ENUM_ID, WE.PRIORITY, WE.WORK_EFFORT_NAME, WE.DESCRIPTION, =
</FONT><FONT=20
face=3DArial size=3D2>WE.LOCATION_DESC, WE.REVISION_NUMBER, =
WE.FIXED_ASSET_ID,=20
WE.FACILITY_ID, WE.CREATED_DATE, </FONT><FONT face=3DArial=20
size=3D2>WE.CREATED_BY_PARTY_ID, WE.LAST_MODIFIED_DATE,=20
WE.LAST_MODIFIED_BY_PARTY_ID, WE.ESTIMATED_START_DATE, </FONT><FONT =
face=3DArial=20
size=3D2>WE.ESTIMATED_COMPLETION_DATE, WE.ESTIMATED_MILLI_SECONDS,=20
WE.TOTAL_MILLI_SECONDS_ALLOWED, </FONT><FONT face=3DArial=20
size=3D2>WE.TOTAL_MONEY_ALLOWED, WE.MONEY_UOM_ID, WE.ACTUAL_START_DATE,=20
WE.ACTUAL_COMPLETION_DATE, </FONT><FONT face=3DArial=20
size=3D2>WE.ACTUAL_MILLI_SECONDS, WE.SPECIAL_TERMS, =
WE.TIME_TRANSPARENCY,=20
WE.INFO_URL, WE.RECURRENCE_INFO_ID, </FONT><FONT face=3DArial=20
size=3D2>WE.RUNTIME_DATA_ID, WE.NOTE_ID, WE.SERVICE_LOADER_NAME, =
WEPA.PARTY_ID,=20
WEPA.ROLE_TYPE_ID, WEPA.FROM_DATE, </FONT><FONT face=3DArial=20
size=3D2>WEPA.THRU_DATE, WEPA.FACILITY_ID, WEPA.STATUS_ID, =
WEPA.STATUS_DATE_TIME,=20
WEPA.COMMENTS, WEPA.MUST_RSVP, </FONT><FONT face=3DArial=20
size=3D2>WEPA.EXPECTATION_ENUM_ID FROM WORK_EFFORT WE JOIN=20
WORK_EFFORT_PARTY_ASSIGNMENT WEPA ON </FONT><FONT face=3DArial=20
size=3D2>WE.WORK_EFFORT_ID=3DWEPA.WORK_EFFORT_ID WHERE WE.WORK_EFFORT_ID =
IS NULL=20
(Syntax error or access violation: You have an </FONT><FONT face=3DArial =
size=3D2>error in your SQL syntax near 'ON =
WE.WORK_EFFORT_ID=3DWEPA.WORK_EFFORT_ID=20
WHERE WE.WORK_EFFORT_ID IS NULL' at line 1)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_027C_01C25860.ACA05A90--
More information about the Dev
mailing list