20
You are running a MySQL version prior to 4.1 i guess. The dump was made from 4.2.x so contains some in lower versions unsupported stuff.
Replace the content of the file
\mpmanager\sql\mysql.sql with this: (untested)
# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 26, 2004 at 04:23 AM
# Server version: 3.23.56
# PHP Version: 4.3.4
#
# Database : `xoops2`
#
# --------------------------------------------------------
#
# Table structure for table `xoops_priv_msgsave`
#
CREATE TABLE priv_msgsave (
msg_id mediumint(8) unsigned NOT NULL auto_increment,
msg_image varchar(100) default NULL,
subject varchar(255) NOT NULL default '',
sauv_userid mediumint(8) unsigned NOT NULL default '0',
from_userid mediumint(8) unsigned NOT NULL default '0',
to_userid mediumint(8) unsigned NOT NULL default '0',
msg_time int(10) unsigned NOT NULL default '0',
msg_text text NOT NULL,
read_msg tinyint(1) unsigned NOT NULL default '0',
reply_msg tinyint(1) unsigned NOT NULL default '0',
anim_msg varchar(100) default NULL,
PRIMARY KEY (msg_id),
KEY to_userid (to_userid)
) TYPE=MyISAM;
# Structure de la table `priv_msgscont`
CREATE TABLE priv_msgscont (
ct_userid mediumint(10) unsigned NOT NULL default '0',
ct_contact mediumint(10) unsigned NOT NULL default '0',
KEY userid (ct_userid)
) TYPE=MyISAM;
#
# Structure de la table `priv_msgsopt`
CREATE TABLE priv_msgsopt (
userid mediumint(8) unsigned NOT NULL default '0',
notif tinyint(1) unsigned NOT NULL default '0',
KEY userid (userid)
) TYPE=MyISAM;
#
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...
