Latest Loots Block - EZPortal

phpBB integration forum

Latest Loots Block - EZPortal

Postby shizimu » Tue Oct 10, 2006 1:59 pm

Hey all.

Ive trying to install Latest loot, but every time i do i get errors....

OK Ive followed the instructions, but when i insert this line

include($phpbb_root_path . 'latestloot.'.$phpEx);

to the portal.php i get

Code: Select all
phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1146 Table 'databasename.phpbb_users' doesn't exist

SELECT u.* FROM phpbb_users u, phpbb_sessions_keys k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = '0556e6f2b58d5e1205dbbe5ae026f78d'

Line : 89
File : sessions.php


any thoughts?

I understand that "SQL Error : 1146 Table 'databasename.phpbb_users' doesn't exist" will not exist cos it doesnt, but i dont understand why it is reaching there. :scratch:

Whats happening?
shizimu
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Aug 08, 2006 8:01 pm

Latest Loots Block - EZPortal

Postby shizimu » Thu Oct 12, 2006 1:34 pm

Doesnt anyone know anything? This worked fine on my old site, but this time round it doesnt work at all and im doing everything i should be doing.
shizimu
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Aug 08, 2006 8:01 pm

Latest Loots Block - EZPortal

Postby shizimu » Mon Oct 16, 2006 12:42 pm

47 views and no replys
shizimu
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Aug 08, 2006 8:01 pm

Re: Latest Loots Block - EZPortal

Postby shizimu » Wed Oct 18, 2006 2:02 pm

thanks for the replys :evil:
shizimu
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Aug 08, 2006 8:01 pm

Latest Loots Block - EZPortal

Postby joehail » Thu Oct 19, 2006 1:28 am

BEGIN RANT
You Know Shizimu, you come in to the PHPBB section asking about an EZPortal issue.
You wait 2 days for someone to find a post that is in the wrong place.
Then you insult everyone here by asking
Doesnt anyone know anything?


I am sorry, to be honest due to 1. the mis-post of the thread, and 2. your complete and utter lack of respect. I doubt if your question will be answered anytime soon.

I look at every post on these forums to see if I can help someone. I do not post any "Sorry, I have no clue" posts, it just bloats up the database. But this I I couldn't leave go. You wait 2 days and then tell everyone here that we are stupid. Then 4 more days and count page views. NOT COOL.

If you look at the rest of the PHPbb section, which is NOT EZPortal by the way, you would have realized that it is the least visited part of the site.
/rant
Image
User avatar
joehail
WR.net Journeyman
WR.net Journeyman
 
Posts: 103
Joined: Tue Jul 04, 2006 4:54 pm
Location: Cincinnati, Ohio USA

Latest Loots Block - EZPortal

Postby shizimu » Thu Oct 19, 2006 12:33 pm

I see no indication of my posts calling anyone stupid. Im sorry if it sounded that way, but it was a question not a statment

Many forums i visit across the internet, You can normally find atleast someone willing to even forward you to another site of reference or something. The fact i recieve upteen views and other posts replied i was a little shocked that no one could help me, even if they forwarded me to a forum or something that could help.

I downloaded the php guide from this site and (appart from another thread i posted in the wrong forum) I posted it in what i thought was the relivant forum but where should i be posting it.

However,

You wait 2 days for someone to find a post that is in the wrong place.


Clearly I was wrong, but rather than being ignored maybe it would have been better to instruct me in the relivant place for software supplied on your site. That in mind, if you visit this link

http://wowroster.net/Downloads/c=11.html

The header CLEARLY stats

Downloads › Integration › phpBB

Which funny enough is also the heading for this forum

Forum Index › Integration › phpBB

I put 2 and 2 together.

The fact I waited 8 days, which is along time for forum activity and i had nothing which would help me other than a error message i dont understand would you not have been slightly frustrated with this silence?

Again, im sorry if it appears that im calling you stupid, but i am not. Im just shocked that NOONE could help me at all.
shizimu
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Aug 08, 2006 8:01 pm

Latest Loots Block - EZPortal

Postby zanix » Thu Oct 19, 2006 2:41 pm

I would have replied but I didn't know how to help
An working on Roster takes a lot of my time here

I downloaded this mod and tried to figure it out (as I don't use phpbb)

Did you read the readme file?
Code: Select all
1. Edit latestloot.php with the database info to your eqdkp installation.

latestloot.php
Code: Select all
$eqdkp_prefix "eqdkp_";
require_once(
'itemstats/itemstats.php');
require_once(
'itemstats/includes/itemcache.php');
//connect to the sql server
$link mysql_connect("localhost""username""password");
if (!
$link) {
   die(
'Not connected : ' mysql_error());
}
// select the database
$db_selected mysql_select_db("database"$link);
if (!
$db_selected) {
   die (
'Can\'t select the database : ' mysql_error());
}  
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Latest Loots Block - EZPortal

Postby shizimu » Thu Oct 19, 2006 3:14 pm

Yeah, I followed the latestloot addon line for line, but to no avail.

The problem i believe lays where

databasename.phpbb_users

Doesnt not exist if i can manage to change that reference in some way to read lets say

databasename.shizimu_users

it might change. But I have no idea how or where.... The stangest thing is that it worked fine on my old hosting company and i have writen code that can pull the required data to a fashion out of the database, but its nowhere near what this addon does.

None the less, i thank you for your response.
Last edited by shizimu on Thu Oct 19, 2006 3:16 pm, edited 2 times in total.
shizimu
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Aug 08, 2006 8:01 pm

Latest Loots Block - EZPortal

Postby zanix » Thu Oct 19, 2006 3:21 pm

So does phpbb have a 'phpbb_users' table?
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Latest Loots Block - EZPortal

Postby shizimu » Thu Oct 19, 2006 4:14 pm

well the error message reports that it cannot find the table in my eqdkp table.

which doesnt have it.

In my phpbb database there is a phpbb_users but thats not where the database for the items this addon reaches from is kept.
shizimu
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Aug 08, 2006 8:01 pm

Re: Latest Loots Block - EZPortal

Postby Carissma » Fri Nov 03, 2006 11:13 pm

I am having a similiar problem.

This worked perfectly on my old site: http://www.vitalisoflothar.com/forum/portal.php

But now on my new site, http://www.risenoflothar.com/phpBB2/portal.php

I am getting this error message right after I add the line:
Code: Select all
include($phpbb_root_path . 'latestloot.'.$phpEx);

in the portal.php page

Code: Select all
phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1146 Table 'risen_dkp.phpbb_sessions' doesn't exist

SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = 'fff49a1fa6bd0f98d3dd0e0bc758257d' AND u.user_id = s.session_user_id

Line : 315
File : sessions.php


There is no phpbb_sessions table in my dkp database, but there is the table - eqdkp_sessions.

Why is this not working for me this time when I had no trouble with it before?

Thanks for you help
Carissma
WR.net Apprentice
WR.net Apprentice
 
Posts: 23
Joined: Tue Jul 11, 2006 9:03 pm

Latest Loots Block - EZPortal

Postby shizimu » Mon Nov 06, 2006 2:53 pm

im glad im not the only one!!!. Any fix for this at all?
shizimu
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Aug 08, 2006 8:01 pm

Latest Loots Block - EZPortal

Postby SesshoumaruSama » Sun Oct 21, 2007 1:03 am

I know its been a while but there is a simple solution to the prob.

FIND
Code: Select all
return $item_html;
}


ADD AFTER
Code: Select all
$link = mysql_connect("localhost", "username", "password");
if (!$link) {
   die('Not connected : ' . mysql_error());
}
// select the database
$db_selected = mysql_select_db("database", $link);
if (!$db_selected) {
   die ('Can\'t select the database : ' . mysql_error());
}


Where the database above here should be your phpBB database.

Worked like a charm for me. Rest of the install is the same as stated in the readme.
SesshoumaruSama
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Fri Oct 19, 2007 6:18 am


Return to phpBB

Who is online

Users browsing this forum: No registered users and 0 guests

cron