I used MySQL v4.1.22 for windows and MySQL-python v1.2.2 for python 2.4. I tested successfull the connection with Z MySQL Database Connection. While creating ERP5 site, Zope created 2 tables (message, message_queue) in db. But Zope could not drop 2 tables. I dont understand...<br><br><b><i>Rafael Monnerat <rafael@nexedi.com></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> I don't know window at all, but...<br><br>Do you have MySQL installed? is it running?<br><br>Which python mysql connector are you using? You installed a windows version?<br><br>Rafael<br><br>bao duc wrote:<br>> I used Zope 2.8.1 and this patch <br>> <http: svn.erp5.org="" spec="" windows="" patches="" zope-2.8.1-aq_dynamic.patch?revision="16817&view=markup"> <br>> for installing ERP5 on windowxp. After installed Zope and all required <br>> packages, I created an ERP5 site. It gave below error:<br>>
<br>> <br>> Site Error<br>> <br>> An error was encountered while publishing this resource.<br>> *Error Type: BadRequest*<br>> *Error Value: The id <br>> "portal_workflow\delivery_causality_interaction_workflow" contains <br>> characters illegal in URLs.*<br>> ------------------------------------------------------------------------<br>> Troubleshooting Suggestions<br>> <br>> * The URL may be incorrect.<br>> * The parameters passed to this resource may be incorrect.<br>> * A resource that this resource relies on may be encountering an error.<br>> <br>> For more detailed information about the error, please refer to the error <br>> log.<br>> If the error persists please contact the site maintainer. Thank you for <br>> your patience.<br>> In log flie:<br>> ------<br>> 2008-03-18T11:04:53 INFO Skinnable Monkeypatch __getattr__ Initial skin <br>> cache fill. This should not happen often. Current
thread id:127C<br>> ------<br>> 2008-03-18T11:04:53 WARNING ERP5Form.PreferenceTool Preference type <br>> information is not installed.<br>> ------<br>> 2008-03-18T11:04:56 INFO Script (Python) Some of your Scripts have stale <br>> code cached. Since Zope cannot use this code, startup will be slightly <br>> slower until these Scripts are edited. You can automatically recompile <br>> all Scripts that have this problem by visiting <br>> /manage_addProduct/PythonScripts/recompile of your server in a browser.<br>> ------<br>> 2008-03-18T11:05:24 INFO Business Template Updating Activity Tool<br>> ------<br>> 2008-03-18T11:05:24 ERROR ZMySQLDA query failed: DROP TABLE message <br>> (False,None,8192)<br>> ------<br>> 2008-03-18T11:05:24 ERROR DA call raise DB = <br>> <Products.ZMySQLDA.db.ThreadedDB instance="" at="" 0x0453f300="">, c = <br>> cmf_activity_sql_connection, query = DROP TABLE message<br>> <br>>
------<br>> 2008-03-18T11:05:24 WARNING CMFActivity could not drop the message table<br>> Traceback (most recent call last):<br>> File "C:\Python24\newtest\Products\CMFActivity\ActivityTool.py", line <br>> 993, in manageClearActivities<br>> folder.SQLDict_dropMessageTable()<br>> File "C:\Python24\newtest\Products\ERP5Type\patches\DA.py", line 219, <br>> in DA__call__<br>> result=DB__.query(query, self.max_rows_)<br>> File "C:\Python24\newtest\Products\ZMySQLDA\db.py", line 289, in query<br>> return self._access_db(method_id='query', args=args, kw=kw)<br>> File "C:\Python24\newtest\Products\ZMySQLDA\db.py", line 280, in <br>> _access_db<br>> return getattr(db, method_id)(*args, **kw)<br>> File "C:\Python24\newtest\Products\ZMySQLDA\db.py", line 413, in query<br>> c = self._query(qs)<br>> File "C:\Python24\newtest\Products\ZMySQLDA\db.py", line 387, in _query<br>>
self.db.query(query)<br>> OperationalError: (1051, "Unknown table 'message'")<br>> ------<br>> 2008-03-18T11:05:24 ERROR ZMySQLDA query failed: DROP TABLE <br>> message_queue (False,None,8192)<br>> ------<br>> 2008-03-18T11:05:24 ERROR DA call raise DB = <br>> <Products.ZMySQLDA.db.ThreadedDB instance="" at="" 0x0453f300="">, c = <br>> cmf_activity_sql_connection, query = DROP TABLE message_queue<br>> <br>> ------<br>> 2008-03-18T11:05:24 WARNING CMFActivity could not drop the message queue <br>> table<br>> Traceback (most recent call last):<br>> File "C:\Python24\newtest\Products\CMFActivity\ActivityTool.py", line <br>> 1004, in manageClearActivities<br>> folder.SQLQueue_dropMessageTable()<br>> File "C:\Python24\newtest\Products\ERP5Type\patches\DA.py", line 219, <br>> in DA__call__<br>> result=DB__.query(query, self.max_rows_)<br>> File "C:\Python24\newtest\Products\ZMySQLDA\db.py", line 289, in
query<br>> return self._access_db(method_id='query', args=args, kw=kw)<br>> File "C:\Python24\newtest\Products\ZMySQLDA\db.py", line 280, in <br>> _access_db<br>> return getattr(db, method_id)(*args, **kw)<br>> File "C:\Python24\newtest\Products\ZMySQLDA\db.py", line 413, in query<br>> c = self._query(qs)<br>> File "C:\Python24\newtest\Products\ZMySQLDA\db.py", line 387, in _query<br>> self.db.query(query)<br>> OperationalError: (1051, "Unknown table 'message_queue'")<br>> <br>> I need help...<br>> <br>> Thanks,<br>> Best regards<br>> <br>> ------------------------------------------------------------------------<br>> Looking for last minute shopping deals? Find them fast with Yahoo! <br>> Search. <br>> <http: us.rd.yahoo.com="" evt="51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping"> <br>> <br>> <br>> <br>>
------------------------------------------------------------------------<br>> <br>> _______________________________________________<br>> Erp5-users mailing list<br>> Erp5-users@erp5.org<br>> http://mail.nexedi.com/mailman/listinfo/erp5-users<br><br>_______________________________________________<br>Erp5-users mailing list<br>Erp5-users@erp5.org<br>http://mail.nexedi.com/mailman/listinfo/erp5-users<br></http:></Products.ZMySQLDA.db.ThreadedDB></Products.ZMySQLDA.db.ThreadedDB></http:></blockquote><br><p> 
<hr size=1>Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a>