Page 1 of 1

Installing prillian seperatly

PostPosted: Thu Mar 01, 2007 3:03 pm
Author: Leadfoot
Your phpBB Version: 2.0.
phpBB Type: phpBB / IMPortal
MODs: Yes
Your knowledge: Basic Knowledge
Board URL: [url]http://[/url]

PHP Version:
MySQL Version:


What was done before the problem appeared?



What was done to try to solve the problem?




De.scription and Message

I am trying to install prillian on my 141 board. I did not install it on the initial upgrade. I have uploaded the prillian install folder to my forum root and then accessed the im_install.php file. All I get when I access that is the prillian name on the page and nothing else. I must be missing a step somewere but not sure where. Any ideas?

Re: Installing prillian seperatly

PostPosted: Thu Mar 01, 2007 5:32 pm
Author: Helter
you may have to run the sql separately
Code: Select all
 CREATE TABLE phpbb_im_prefs (   user_id mediumint(8) NOT NULL default '0',   user_allow_ims tinyint(1) NOT NULL default '1',   user_allow_shout tinyint(1) NOT NULL default '1',   user_allow_chat tinyint(1) NOT NULL default '1',   user_allow_network tinyint(1) NOT NULL default '1',   admin_allow_ims tinyint(1) NOT NULL default '1',   admin_allow_shout tinyint(1) NOT NULL default '1',   admin_allow_chat tinyint(1) NOT NULL default '1',   admin_allow_network tinyint(1) NOT NULL default '1',   new_ims smallint(5) unsigned NOT NULL default '0',   unread_ims smallint(5) unsigned NOT NULL default '0',   read_ims smallint(5) unsigned NOT NULL default '0',   total_sent mediumint(8) unsigned NOT NULL default '0',   attach_sig tinyint(1) NOT NULL default '0',   refresh_rate smallint(5) unsigned NOT NULL default '60',   success_close tinyint(1) NOT NULL default '1',   refresh_method tinyint(1) NOT NULL default '2',   auto_launch tinyint(1) NOT NULL default '1',   popup_ims tinyint(1) NOT NULL default '1',   list_ims tinyint(1) NOT NULL default '0',   show_controls tinyint(1) NOT NULL default '1',   list_all_online tinyint(1) NOT NULL default '1',   default_mode tinyint(1) NOT NULL default '1',   current_mode tinyint(1) NOT NULL default '1',   mode1_height varchar(4) NOT NULL default '400',   mode1_width varchar(4) NOT NULL default '225',   mode2_height varchar(4) NOT NULL default '225',   mode2_width varchar(4) NOT NULL default '400',   mode3_height varchar(4) NOT NULL default '100',   mode3_width varchar(4) NOT NULL default '400',   prefs_width varchar(4) NOT NULL default '500',   prefs_height varchar(4) NOT NULL default '350',   read_height varchar(4) NOT NULL default '300',   read_width varchar(4) NOT NULL default '400',   send_height varchar(4) NOT NULL default '365',   send_width varchar(4) NOT NULL default '460',   play_sound tinyint(1) NOT NULL default '1',   default_sound tinyint(1) NOT NULL default '1',   sound_name varchar(255) default NULL,   themes_id mediumint(8) unsigned NOT NULL default '1',   network_user_list tinyint(1) NOT NULL default '1',   open_pms tinyint(1) NOT NULL default '0',   auto_delete tinyint(1) NOT NULL default '0',   use_frames tinyint(1) NOT NULL default '1',   user_override tinyint(1) NOT NULL default '0',   PRIMARY KEY  (user_id)) TYPE=MyISAM;  CREATE TABLE phpbb_contact_list (   user_id mediumint(8) NOT NULL default '0',   contact_id mediumint(8) NOT NULL default '0',   user_ignore tinyint(1) NOT NULL default '0',   alert tinyint(1) NOT NULL default '0',   alert_status tinyint(1) NOT NULL default '0',   disallow tinyint(1) NOT NULL default '0',   display_name varchar(25) NOT NULL default '',   KEY contact_id (contact_id),   KEY user_id (user_id)) TYPE=MyISAM;  CREATE TABLE phpbb_im_sites (   site_id mediumint(8) NOT NULL auto_increment,   site_name varchar(50) NOT NULL default '',   site_url varchar(100) NOT NULL default '',   site_phpex varchar(4) NOT NULL default 'php',   site_profile varchar(50) NOT NULL default 'profile',   site_enable tinyint(1) NOT NULL default '1',   PRIMARY KEY  (site_id)) TYPE=MyISAM;  CREATE TABLE phpbb_im_sessions (   session_user_id mediumint(8) NOT NULL default '0',   session_id char(32) NOT NULL default '',   session_time int(11) NOT NULL default '0',   session_popup tinyint(1) NOT NULL default '0',   PRIMARY KEY  (session_id),   KEY session_user_id (session_user_id)) TYPE=MyISAM;  CREATE TABLE phpbb_im_config (   config_name varchar(255) NOT NULL default '',   config_value varchar(255) NOT NULL default '',   PRIMARY KEY  (config_name)) TYPE=MyISAM;    INSERT INTO phpbb_im_sites (site_id, site_name, site_url, site_phpex, site_profile, site_enable) VALUES (1, 'DarkMods', 'http]

then open your config.php

[code]  find  define('PHPBB_INSTALLED', true);  after add  define('PRILLIAN_INSTALLED', true);  

PostPosted: Fri Mar 02, 2007 3:21 am
Author: Leadfoot
Ran the sql query and did the config.php. Crashed my board.

This is the error I came up with:

phpBB : Critical Error

User not found in IM preferences table

DEBUG MODE

SELECT * FROM phpbb_im_prefs WHERE user_id=4

Line : 95
File : functions_im.php

I have disabled it in config.php right now and have been able to get my board back up. Been trying to figure out the debug but cant seem too.