• Registered: 2006-06-13
  • Posts: 25

Topic: Private messages for 1.2.12

Does anybody of you knof a mod for private messages that can be run on punbb version 1.2.12?
I've allready tried Private Message System and Private Message mod v1.2.2 but both didn't work.
Can anybody help me?

I'm from Germany, so my english might be wrong sometimes. Sorry!
  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Private messages for 1.2.12

They both should work, you might just have to edit install_mod.php to add your version in

3 Reply by Therminator007 (edited by Therminator007 2006-06-14 19:44)

  • Registered: 2006-06-13
  • Posts: 25

Re: Private messages for 1.2.12

Every Time i want to run the install_mod.php of private message mod v.1.2.2 i get this error:

An error was encountered
File: ********************************************/install_mod.php
Line: 62

PunBB reported: Unable to create table forum_messages.

Database reported: Invalid default value for 'owner' (Errno: 1067)

I'm from Germany, so my english might be wrong sometimes. Sorry!
  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: Private messages for 1.2.12

Show me the query please.

  • Alecks
  • Junior Member
  • Offline
  • Registered: 2006-05-29
  • Posts: 5

Re: Private messages for 1.2.12

Open install_mod.php and find:

 default:
    
                $sql = 'CREATE TABLE '.$db->prefix."messages (
                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                        owner int(10) NOT NULL DEFAULT '',
                        subject VARCHAR(120) NOT NULL DEFAULT '',
                        message TEXT,
                        sender VARCHAR(120) NOT NULL DEFAULT '',
                        sender_id int(10) NOT NULL DEFAULT '',
                        posted INT(10) NOT NULL DEFAULT '',
                        sender_ip VARCHAR(120),
                        smileys TINYINT DEFAULT '1',
                        status TINYINT DEFAULT '0',
                        showed TINYINT DEFAULT '0',
                        PRIMARY KEY (id)
                        ) TYPE=MyISAM;";
                $db->query($sql) or error('Unable to create table '.$db->prefix.'messages.', __FILE__, __LINE__, $db->error());
    
                break;

and change it to:

default:
    
                $sql = 'CREATE TABLE '.$db->prefix."messages (
                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                        owner int(10) NOT NULL,
                        subject VARCHAR(120) NOT NULL,
                        message TEXT,
                        sender VARCHAR(120) NOT NULL,
                        sender_id int(10) NOT NULL,
                        posted INT(10) NOT NULL,
                        sender_ip VARCHAR(120),
                        smileys TINYINT DEFAULT '1',
                        status TINYINT DEFAULT '0',
                        showed TINYINT DEFAULT '0',
                        PRIMARY KEY (id)
                        ) TYPE=MyISAM;";
                $db->query($sql) or error('Unable to create table '.$db->prefix.'messages.', __FILE__, __LINE__, $db->error());
    
                break;
aka Mr Puto
  • Registered: 2006-06-13
  • Posts: 25

Re: Private messages for 1.2.12

It worked very well, thanks a lot!

I'm from Germany, so my english might be wrong sometimes. Sorry!