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.

Whats happening?

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.

47 views and no replys

thanks for the replys

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

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.

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());
}  

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.

So does phpbb have a 'phpbb_users' table?

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.

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

im glad im not the only one!!!. Any fix for this at all?

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.