phpBB.com

tlavery wrote:

tlavery wrote:Ok I Installed with easymod and got these errors:

SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually

'Read your Error Report

I did not get any errors from easymod about not being able to find any certain codes when it does it's initial check before performing the install, so maybe all the errors are related to SQL. I am not real familure with how to manually do the SQL changes, so maybe I totally screwed it up. If someone can give me some pointers I would appreciate it immensly! If I was supposed to do one line at a time I would appreciate knowing that

Thanks a MILLION guys!!

Just thought I would bump this since there seems to be some help here now. Thanks!!

ninosportif wrote: lol tlavery,

First, your SQL is not done. So, lets start there now. Log in into your myphpAdmin -> into your phpbb board ( I assume is your 3rd board)

In there, select the phpbb_users

In there, make a 'new field' at the 'end of the table' -> Go ... then do it one by one...

For example user_realname -> VARCHAR(25) -> NOT NULL
(there is 30 new field, so if you want you can type in 30 fields and input one by one)

After you have done this section in phpbb_users you should have all this field in phpbb_users.

Same again for phpbb_sessions & phpbb_ranks

last but not least for phpbb_buddy, you must do it inside phpbb_-_ -> SQL Query

When all this is done, it should work.

Like Posco said, after you have done all this, run from brownser 1st, if this issue still exsit, somehow, then you need to check the instructions of PCP and make any appropriate changes in the title of phpbb3 ( as this is your version...)

P.S. Make sure you have all files uploaded, (do a check on it)

##   _________________________________________________________________________________________ 
## 
## 
##     / \ 
##    / ! \   The next CHMODs are required to allow the editing of the mentioned files by the ACP tools 
##   /_____\ 
## 
## 
##   CHMOD 666 to apply : 
## 
##      profilcp/def/def_userfields.php 
##      profilcp/def/def_usermaps.php 
## 
##   COPY to each of your language installed directories (ie: languages/lang_english/) and 
##   CHMOD 666 those files : 
##      COPY mod-lang_settings/lang_extend.php TO language/lang_*/lang_extend.php 
##

General Error

Could not obtain buddys information.

DEBUG MODE

SQL Error : 1146 Table 'dishinstallers_net_-_phpbb3.buddy' doesn't exist

SELECT * FROM buddy WHERE user_id=3 and buddy_id in (3)

Line : 216
File : page_header.php

ninosportif wrote: IWQ

Try to aim to look for this words... one of them out of this three will do, as you will find the lines.

should be around line 40-75[ {L_WHOSONLINE_MOD} ]

I said around line 40-75, just because i have MODs already in there.

If for any reaon you can't find it, upload a link to it and i find it for ya for free... hehehe (I am not making business here, but rather, i would like to help...)

tlavery wrote: Well, it appears that I solved my problem. I deleted the table php_buddy and altered the SQL query I was supposed to run to show the new table name as buddy instead of php_buddy and it WORKS!! WOO HOO!! Thanks so much for everyone's help!!

Edit:

I came across one bug. When I try and delete any pm's in the in box, out box, sent box, or saved box I get a General Error "Invalid_session". I get the same error when trying to send a PM too. Any ideas??

Well, I logged out and back in and now it seems to be working just fine.

CREATE TABLE phpbb3_buddy ( 
  user_id mediumint(8) NOT NULL default '0', 
  buddy_id mediumint(8) NOT NULL default '0', 
  buddy_ignore tinyint(1) NOT NULL default '0', 
  buddy_visible tinyint(1) NOT NULL default '0', 
  PRIMARY KEY  (user_id, buddy_id) 
) TYPE=MyISAM; 

CREATE TABLE phpbb3_users (
  ADD user_realname VARCHAR(25) NOT NULL; 
  ADD user_gender TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL; 
  ADD user_birthday VARCHAR(8) DEFAULT '0' NOT NULL; 
  ADD user_last_birthday INT(11) UNSIGNED DEFAULT '0' NOT NULL; 
  ADD user_home_phone VARCHAR(20); 
  ADD user_home_fax VARCHAR(20); 
  ADD user_work_phone VARCHAR(20); 
  ADD user_work_fax VARCHAR(20); 
  ADD user_cellular VARCHAR(20); 
  ADD user_pager VARCHAR(20); 
  ADD user_summer_time TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL; 
  ADD user_list_option VARCHAR(255); 
  ADD user_allow_email TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_allow_website TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_allow_messanger TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_allow_real TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_allow_sig TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewpm TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewwebsite TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewmessanger TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewreal TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewavatar TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewsig TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewimg TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_buddy_friend_display TINYINT(1) DEFAULT '1'; 
  ADD user_buddy_ignore_display TINYINT(1) DEFAULT '1'; 
  ADD user_buddy_friend_of_display TINYINT(1) DEFAULT '1'; 
  ADD user_buddy_ignored_by_display TINYINT(1) DEFAULT '1'; 
  ADD user_watched_topics_per_page SMALLINT(3) DEFAULT '15'; 
  ADD user_privmsgs_per_page SMALLINT(3) DEFAULT '5'; 

CREATE TABLE phpbb3_ranks (
   ADD rank_title VARCHAR(255) NOT NULL; 
   ADD rank_max MEDIUMINT(8) NOT NULL AFTER rank_min;

CREATE TABLE phpbb3_sessions (
   ADD session_robot VARCHAR(32);

lwq wrote:

ninosportif wrote:IWQ

Try to aim to look for this words... one of them out of this three will do, as you will find the lines.

should be around line 40-75[ {L_WHOSONLINE_MOD} ]

I said around line 40-75, just because i have MODs already in there.

If for any reaon you can't find it, upload a link to it and i find it for ya for free... hehehe (I am not making business here, but rather, i would like to help...)

I can't find it.None of the variables is there.(not even one....)

ninosportif wrote:

lwq wrote:

ninosportif wrote:IWQ

Try to aim to look for this words... one of them out of this three will do, as you will find the lines.

should be around line 40-75[ {L_WHOSONLINE_MOD} ]

I said around line 40-75, just because i have MODs already in there.

If for any reaon you can't find it, upload a link to it and i find it for ya for free... hehehe (I am not making business here, but rather, i would like to help...)

I can't find it.None of the variables is there.(not even one....)

Upload a link of that file here and i have a look...

Riamus wrote: In the member list, PCP shows the last time a person visited the board. However, it appears as though it will only update that the next time the person visits, so it's never really accurate.

Examples:

Scenario: NICK joined on 6/25/05 and never returned
Result: "Last Visited" field is blank

Scenario: NICK joined on 6/25/05 and visited on 6/26/05
Result: "Last Visited" field shows the 6/25/05 time

Scenario: NICK joined on 6/25/05, visited on 6/26/05, and again on 6/27/05
Result: "Last Visited" field shows the 6/26/05 time

.....

JustinS wrote: I love the mod., but it's imperative that I close registration on my board. It's for a high school related activity and either I close registration and register everyone manually, or the school rejects it and doens't allow me to have it.
I installed the disable registration mod., but I can't disable them. If I select "yes" with the radio button as soon as i hit submit and return to the config. page, it says "no" I have another mod. installed that doesn't allow guests to see certain pages, and the radio button for this is also broken. This stuff was all fine prior to my intalling the PCP, any ideas?