Hello everyone and thanks for taking time to read this. I've been trying to install a blog section onto my site, I tried the XPress_ME_Intergration one,everything seemed ok and was working, but then got the XoopsLogger error so abandoned that one. trying to install the popupblog one now and get this syntax error:::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 '(14) NOT NULL , email varchar(60) , emailalias varchar(60) , PRIMARY KEY (' at line 11.... did some research and could not really find much.. my php version is 5.3.8 I hope someone can tell me what to change in that line. thanks in advance for your time and help.

Most probably it is about "TYPE=MyISAM"

Change it to: "ENGINE=MyISAM" and you should be OK.

Thanks for the quick replt Mamba, however they are all already changed. here is what the sql file is,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

-- $Id: mysql.sql,v 2.60 2006/11/06 19:46:11 yoshis Exp $

-- blog information table
-- uid :
-- xoops uid
-- last_update:
-- update time
-- Auther : Yoshi.Sakai @ bluemooninc.biz
-- post blog from email. Work under pop.php.
CREATE TABLE popnupblog_info (
blogid int(5) unsigned NOT NULL auto_increment,
uid int(5) unsigned NOT NULL default '0',
cat_id smallint(5) unsigned NOT NULL default '0',
title varchar(200) binary,
blog_desc text,
group_post varchar(255) default NULL,
group_read varchar(255) default NULL,
group_comment varchar(255) default NULL,
group_vote varchar(255) default NULL,
last_update DATETIME NOT NULL ,
email varchar(60) default NULL,
plugin varchar(30) default NULL,
ml_function smallint(1) unsigned NOT NULL default '0',
pop_server varchar(30) default NULL,
pop_user varchar(30) default NULL,
pop_password varchar(20) default NULL,
pop_address varchar(60) default NULL,
default_status tinyint(1) NOT NULL default '1',
PRIMARY KEY (blogid)
) ENGINE=MyISAM;

-- blog data table
-- uid :
-- xoops uid
-- blog_date :
-- date of blog
-- title :
-- title of blog
-- post_text :
-- blog data
-- alter table xoops_popnupblog add last_update timestamp not null;
CREATE TABLE popnupblog (
postid int(5) UNSIGNED NOT NULL auto_increment,
uid int(5) unsigned NOT NULL default '0',
blogid int(5) unsigned NOT NULL default '0',
blog_count INT(5) UNSIGNED DEFAULT '0' NOT NULL,
blog_date DATETIME not null,
title varchar(200),
post_text text,
last_update DATETIME NOT NULL,
votes_yes int(5) unsigned NOT NULL default '0',
votes_no int(5) unsigned NOT NULL default '0',
notifypub tinyint(1) NOT NULL default '0',
status tinyint(1) NOT NULL default '0',
PRIMARY KEY (postid),
KEY blog_count ( `blogid` , `blog_count` )
) ENGINE=MyISAM;


-- blog comment table
-- uid :
-- xoops uid
-- blog_date :
-- date of blog
-- comment_id :
-- sequential comment id.
-- comment_uid :
-- uid of comment user. set value to 0 if guest user
-- comment_name :
-- guest user name.
-- post_text :
-- comment data
CREATE TABLE popnupblog_comment (
blogid int(5) unsigned NOT NULL default '0',
postid INT(5) UNSIGNED DEFAULT '0' NOT NULL,
comment_id int(8) unsigned NOT NULL auto_increment,
comment_uid int(5) unsigned NOT NULL default '0',
comment_name varchar(200),
post_text text,
create_date DATETIME not null,
vote tinyint(1) NOT NULL default '0',
notifypub tinyint(1) NOT NULL default '0',
status tinyint(1) NOT NULL default '0',
KEY (postid),
PRIMARY KEY (comment_id)
) ENGINE=MyISAM;

CREATE TABLE popnupblog_application (
uid int(5) unsigned NOT NULL,
group_post varchar(255) default NULL,
cat_id smallint(5) unsigned NOT NULL default '0',
title varchar(200) binary,
blog_desc text,
permission smallint(1) unsigned NOT NULL default '0',
group_read varchar(255) default NULL,
group_comment varchar(255) default NULL,
group_vote varchar(255) default NULL,
create_date timestamp(14) NOT NULL ,
email varchar(60) ,
emailalias varchar(60) ,
PRIMARY KEY (uid)
) ENGINE=MyISAM;

-- tbid, excerpt added by kazy 2006.11.18
CREATE TABLE popnupblog_trackback (
tbid INT(5) unsigned NOT NULL auto_increment,
blogid int(5) unsigned NOT NULL,
postid INT(5) UNSIGNED DEFAULT '0' NOT NULL,
t_date DATETIME not null,
count int(8) unsigned,
title varchar(250),
url text,
excerpt text,
KEY(postid),
PRIMARY KEY (tbid)
) ENGINE=MyISAM;

-- moblog email alias table added by hoshiyan@hoshiba-farm.com 2004.8.3
-- uid :
-- xoops uid
-- public:
-- 0: closed it for other member
-- 1:
-- email:
-- another email address for moblog posting. Work under pop.php.
CREATE TABLE popnupblog_emailalias (
blogid int(5) unsigned NOT NULL default '0',
public tinyint(1) NOT NULL default '1',
email varchar(60) NOT NULL,
uid int(5) unsigned NOT NULL default '0',
PRIMARY KEY (blogid,public,email)
) ENGINE=MyISAM;

CREATE TABLE popnupblog_categories (
cat_id smallint(3) unsigned NOT NULL auto_increment,
cat_title varchar(100) NOT NULL default '',
cat_order varchar(10) default NULL,
PRIMARY KEY (cat_id)
) ENGINE=MyISAM;

Hi sorry, I was thinking if it would be easier to fix the * Fatal error: Class 'XoopsLogger' not found in \modules\xpressme\include\xpress_block_render.php on line 37 *

then maybe I can get some of the other modules I was trying to install to work as well. Thanks

In line 98 of mysql.sql change



With


The module have some more issues though.. I'll see if I cant find some time to go through it