Ok, seems my app has broken again. I had to fix this same issue when I
updated to Rev. 6238. I just updated again to Rev 6278.
Platform: Win
Python Version: 2.6.5 on win32
Dabo Version: Version 0.9.3; Revision ~6278
UI Version: 2.8.11.0 on wxMSW
I get the following error and traceback:
2010-12-24 10:00:58 - ERROR - Database Execution failed with response:
(1064, "You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL
server version for the right syntax to use near '%s \n limit 1' at line
12")
Traceback (most recent call last):
File "C:\src\dabo\ui\uiwx\dControlMixin.py", line 27, in _onWxHit
self.raiseEvent(dEvents.Hit, evt, *args, **kwargs)
File "C:\src\dabo\ui\uiwx\dPemMixin.py", line 1009, in raiseEvent
super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args,
**kwargs)
File "C:\src\dabo\lib\eventMixin.py", line 96, in raiseEvent
bindingFunction(event)
File "c:\docume~1\admini~1\locals~1\temp\tmpejegch.py", line 819, in
onHit <------------------- For my search function, Possible issue??
self.Form.search()
File "c:\docume~1\admini~1\locals~1\temp\tmpejegch.py", line 663, in
search <------------------- For my search function, Possible issue??
biz.RowNumber = 0
File "C:\src\dabo\biz\dBizobj.py", line 2439, in _setRowNumber
self.requeryAllChildren()
File "C:\src\dabo\biz\dBizobj.py", line 1564, in requeryAllChildren
child.requery()
File "C:\src\dabo\biz\dBizobj.py", line 992, in requery
oldDataStructure = self.DataStructure
File "C:\src\dabo\biz\dBizobj.py", line 2213, in _getDataStructure
return self._CurrentCursor.DataStructure
File "C:\src\dabo\db\dCursorMixin.py", line 2567, in _getDataStructure
ds = self.BackendObject.getStructureDescription(self)
File "C:\src\dabo\db\dBackend.py", line 468, in getStructureDescription
aux.execute(structure_only_sql)
File "C:\src\dabo\db\dCursorMixin.py", line 367, in execute
raise dException.DBQueryException(errMsg)
dabo.dException.DBQueryException: (1064, "You have an error in your SQL
syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near '%s \n limit 1' at line 12")
Here is the db log:
2010-12-24 10:00:03 - INFO - SQL: select id, buildername from builders order
by buildername
2010-12-24 10:00:58 - INFO - SQL: select `contacts`.`id`,
`contacts`.`builderfk`, `builders`.`buildername`,
`contacts`.`firstname`, `contacts`.`lastname`,
`contacts`.`address1`, `contacts`.`address2`,
`contacts`.`city`, `contacts`.`stateprov`,
`contacts`.`postalcode`, `contacts`.`phonenumber`,
`contacts`.`faxnumber`, `contacts`.`cellnumber`,
`contacts`.`emailaddress` from `contacts` inner join `builders` on
contacts.builderfk = builders.id limit 1
2010-12-24 10:00:58 - INFO - SQL: describe `contacts`
2010-12-24 10:00:58 - INFO - SQL: select `contacts`.`id`,
`contacts`.`builderfk`, `builders`.`buildername`,
`contacts`.`firstname`, `contacts`.`lastname`,
`contacts`.`address1`, `contacts`.`address2`,
`contacts`.`city`, `contacts`.`stateprov`,
`contacts`.`postalcode`, `contacts`.`phonenumber`,
`contacts`.`faxnumber`, `contacts`.`cellnumber`,
`contacts`.`emailaddress` from `contacts` inner join `builders` on
contacts.builderfk = builders.id where firstname like %s limit 1000,
PARAMS: %rh%
2010-12-24 10:00:58 - INFO - FAILED SQL: select `builders`.`id`,
`builders`.`buildername`, `builders`.`address1`,
`builders`.`address2`, `builders`.`city`,
`builders`.`provstate`, `builders`.`postalcode`,
`builders`.`phonenumber`, `builders`.`faxnumber`,
`builders`.`url` from `builders` where `builders`.id = %s limit 1
2010-12-24 10:00:58 - INFO - DBQueryException encountered in execute():
(1064, "You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'%s \n limit 1' at line 12")
select `builders`.`id`,
`builders`.`buildername`,
`builders`.`address1`,
`builders`.`address2`,
`builders`.`city`,
`builders`.`provstate`,
`builders`.`postalcode`,
`builders`.`phonenumber`,
`builders`.`faxnumber`,
`builders`.`url`
from `builders`
where `builders`.id = %s
limit 1
I do not have a limit 1 clause and if I understand the above where clause
the builders.id in not being picked up. Builders is a child of Contacts.
This was all working fine prior to the update to 6278, but even if I revert
back to 6238 where it was working before, it doesn't work there either. I'm
puzzled
HELP!!
Carey
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
