Installing prillian seperatly

Posted:
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

Posted:
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);

Posted:
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.