Bug#338962: papercut: Posting message using phpbb_mysql backend fails

2005-11-24 Thread Jérémy Bobbio
tags 338962 + pending
thanks

On Monday 14 November 2005 04:06, Jonas Smedegaard wrote:
 I am testing papbercut with the phpbb_mysql backend.

 reading messages works. Authentication (when patch in separately
 filed bugreport is applied) works. But sending messages - either
 creating a new message or responding to an existing one - fails.

This will be fixed in next papercut upload.

In the meantime, you can apply the attached patch.

Regards,
-- 
Jérémy
Thu Nov 24 21:49:50 CET 2005  [EMAIL PROTECTED]
  * Fix insert_id() usage in phpBB and phpNuke storage
  
  Closes: #338962
diff -rN -u old-papercut/storage/phpbb_mysql.py new-papercut/storage/phpbb_mysql.py
--- old-papercut/storage/phpbb_mysql.py	2005-11-24 22:22:07.580181272 +0100
+++ new-papercut/storage/phpbb_mysql.py	2005-11-24 21:49:40.0 +0100
@@ -677,7 +677,7 @@
 0
 ) % (prefix, forum_id, self.quote_string(subject), poster_id)
 self.cursor.execute(stmt)
-thread_id = self.cursor.insert_id()
+thread_id = self.conn.insert_id()
 stmt = 
 INSERT INTO
 %sposts
@@ -705,7 +705,7 @@
 0
 ) % (prefix, thread_id, forum_id, poster_id, self.encode_ip(ip_address), post_username)
 self.cursor.execute(stmt)
-new_id = self.cursor.insert_id()
+new_id = self.conn.insert_id()
 if not new_id:
 return None
 else:
diff -rN -u old-papercut/storage/phpnuke_phpbb_mysql.py new-papercut/storage/phpnuke_phpbb_mysql.py
--- old-papercut/storage/phpnuke_phpbb_mysql.py	2005-11-24 22:22:07.588180056 +0100
+++ new-papercut/storage/phpnuke_phpbb_mysql.py	2005-11-24 21:49:47.0 +0100
@@ -657,7 +657,7 @@
 0
 ) % (prefix, forum_id, self.quote_string(subject), poster_id)
 self.cursor.execute(stmt)
-thread_id = self.cursor.insert_id()
+thread_id = self.conn.insert_id()
 stmt = 
 INSERT INTO
 %sposts
@@ -685,7 +685,7 @@
 0
 ) % (prefix, thread_id, forum_id, poster_id, self.encode_ip(ip_address), post_username)
 self.cursor.execute(stmt)
-new_id = self.cursor.insert_id()
+new_id = self.conn.insert_id()
 if not new_id:
 return None
 else:



pgpCPd1jRh8iQ.pgp
Description: PGP signature


Bug#338962: papercut: Posting message using phpbb_mysql backend fails

2005-11-24 Thread Jonas Smedegaard
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Thu, 24 Nov 2005 22:22:57 +0100
Jérémy Bobbio [EMAIL PROTECTED] wrote:

 On Monday 14 November 2005 04:06, Jonas Smedegaard wrote:
  I am testing papbercut with the phpbb_mysql backend.
 
  reading messages works. Authentication (when patch in separately
  filed bugreport is applied) works. But sending messages - either
  creating a new message or responding to an existing one - fails.
 
 This will be fixed in next papercut upload.
 
 In the meantime, you can apply the attached patch.

Indeed, it works.

Thanks!


 - Jonas

- -- 
* Jonas Smedegaard - idealist og Internet-arkitekt
* Tlf.: +45 40843136  Website: http://dr.jones.dk/

 - Enden er nær: http://www.shibumi.org/eoti.htm
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQFDhoDKn7DbMsAkQLgRAvLnAKCGnBUEhUetRxuk1X3l2Huhdxn05QCfeSzC
FmglHw2qqBin2qcjY2dLm6o=
=m/mr
-END PGP SIGNATURE-



Bug#338962: papercut: Posting message using phpbb_mysql backend fails

2005-11-13 Thread Jonas Smedegaard
Package: papercut
Severity: normal

I am testing papbercut with the phpbb_mysql backend.

reading messages works. Authentication (when patch in separately filed
bugreport is applied) works. But sending messages - either creating a
new message or responding to an existing one - fails.

The following is printed in errorlog:


[Sun Nov 13 20:10:24 2005] Error - Posting failed for user from 
'213.173.226.50' (exception triggered)  
  
[Sun Nov 13 20:10:24 2005] Traceback (most recent call last):   

  
  File /usr/bin/papercut, line 183, in handle 

  
self.do_POST()  

  
  File /usr/bin/papercut, line 786, in do_POST

  
result = backend.do_POST(group_name, lines, self.client_address[0], 
self.auth_username) 
  
  File /usr/share/papercut/storage/phpbb_mysql.py, line 680, in do_POST   

  
thread_id = self.cursor.insert_id() 

  
AttributeError: 'Cursor' object has no attribute 'insert_id'

  



 - Jonas


-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'stable')
Architecture: powerpc (ppc)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.13-git10+squashfs+wrr+fbsplash
Locale: LANG=da_DK, LC_CTYPE=da_DK (charmap=ISO-8859-1)


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]