1
TherealLoki
Re: Installing popnupblog errors
  • 2012/2/6 17:18

  • TherealLoki

  • Just popping in

  • Posts: 4

  • Since: 2012/1/22


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



2
TherealLoki
Re: Installing popnupblog errors
  • 2012/2/6 15:21

  • TherealLoki

  • Just popping in

  • Posts: 4

  • Since: 2012/1/22


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;




3
TherealLoki
Installing popnupblog errors

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.



4
TherealLoki
Re: Bot Scout
  • 2012/1/22 18:17

  • TherealLoki

  • Just popping in

  • Posts: 4

  • Since: 2012/1/22


TIA
Being as I am not a module builder, that part I leave to the smart people. lol
For the "where to find the IP's all I did for my site was to gotohttp://smartcounter.com ,signup for the free account, make the counter that suited me, then I pasted the output code into the footer section in admin/preferences/system options/meta tags and footer,(at the bottom). I placed the code just before the powered by xoops part. by putting it in the footer it will count the visitors to all your pages. when you click on the stat button it will take you to your counter page and you can see all IP's / ISP's/ everything. Hope this may help you.

Regards Loki




TopTop



Login

Who's Online

237 user(s) are online (154 user(s) are browsing Support Forums)


Members: 0


Guests: 237


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits