Error: Class 'sql_db' not found

Use phpBB to authenticate users in Roster

Moderator: Munazz

Error: Class 'sql_db' not found

Postby Munazz » Thu Jun 19, 2008 1:10 am

Durvien wrote:got a problem installing this. I put in my path /oggyhouse.com/html/phpBB3/ and contacted the web hosting which said it was simply /phpBB3. Completely uninstalled, reinstalled but I keep getting this error:

Fatal error: Class 'sql_db' not found in /chroot/home/oggyhous/oggyhouse.com/html/roster/addons/phpBB_login/inc/login.php on line 114


Line 114 is:
if (! $this->database = new sql_db($dbhost, $dbuser, $dbpasswd, $dbname, false) )

Do I need to set something to writeable or is there a way to change that to put my actual db in there since it can't seem to find it?


I'm not sure if this is because you are using phpBB 3 or if this is just a path error. I tested and developed this addon using phpBB 2 and the function calls from their files.

What do you have in roster/addons/phpBB_login/inc/login.php on line 30?

Looking at your error, I think it should be /chroot/home/oggyhous/oggyhouse.com/html/phpbb3

Try that and let me know if you still get the error.
Image
User avatar
Munazz
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 36
Joined: Mon Jul 31, 2006 7:50 am
Location: Fairfax, VA

Re: Error: Class 'sql_db' not found

Postby Durvien » Sat Jun 21, 2008 6:39 am

Same error:

Fatal error: Class 'sql_db' not found in /chroot/home/oggyhous/oggyhouse.com/html/roster/addons/phpBB_login/inc/login.php on line 114

any way to manually put it in on that line 114?

btw to make sure I am uninstalling this thing correctly I have to delete it out of the addon directory to be able to get back to my config menu,,, I then make sure it's on roster auth and save settings,, re-upload it to the addon directory then click the deactivate and uninstall buttons.
Last edited by Durvien on Sat Jun 21, 2008 6:44 am, edited 1 time in total.
Image
User avatar
Durvien
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Wed Jun 11, 2008 8:29 am

Re: Error: Class 'sql_db' not found

Postby Munazz » Tue Jul 15, 2008 8:46 pm

That specific line of code allows for the flexibility in phpBB2 for support of different database types. It is phpBB's way of using your configuration settings to access the database.

If phpBB3 has a different way of creating database connections, this could mess things up a little bit and I'm not sure that there is an easy fix.

I will have to take a look the way that phpBB3 works. Unless someone else out there familiar with phpBB3 and PHP can give me some insight.
Image
User avatar
Munazz
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 36
Joined: Mon Jul 31, 2006 7:50 am
Location: Fairfax, VA

Re: Error: Class 'sql_db' not found

Postby Howmag » Fri Jul 18, 2008 6:55 am

Munazz wrote:I will have to take a look the way that phpBB3 works. Unless someone else out there familiar with phpBB3 and PHP can give me some insight.


I've noticed that DKPlus is using a crm-bride to link the login and passwords of the Bulletin Boards.
Could something like that help?
User avatar
Howmag
WR.net Apprentice
WR.net Apprentice
 
Posts: 9
Joined: Thu Jul 13, 2006 2:34 am
Location: Belgium

Error: Class 'sql_db' not found

Postby sagron » Sun Aug 10, 2008 7:16 am

Replacing Lines 114/115:
Code: Select all

        
if (! $this->database = new sql_db($dbhost$dbuser$dbpasswd$dbnamefalse) )
            
die_quietly("Could not connect to the database"'Roster Auth'__FILE__,__LINE__);
 


with:

Code: Select all

        $this
->database = new dbal_mysql();
        if (! 
$this->database->sql_connect($dbhost$dbuser$dbpasswd$dbname) )
            
die_quietly("Could not connect to the database"'Roster Auth'__FILE__,__LINE__);
 


seems to work for me.
sagron
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Nov 27, 2006 2:42 am

Error: Class 'sql_db' not found

Postby sagron » Sun Aug 10, 2008 7:20 am

Nevermind... broke shortly after :p

Ok, here's what I have so far which lets me see the page at least but throws a roster error.
Attachments
login.php.txt
(27.43 KiB) Downloaded 482 times
Last edited by sagron on Sun Aug 10, 2008 7:26 am, edited 2 times in total.
sagron
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Nov 27, 2006 2:42 am

Re: Error: Class 'sql_db' not found

Postby akiko » Sun Jan 11, 2009 9:09 am

This is the error i get from using your txt file.

Could not query PHPBB Config information
SQL:
SELECT * FROM phpbb_config
File: addons/phpBB_login/inc/login.php
Line: 129

Dont understand yet why it gives this error... Hope to figure it out soon.. And hope more ppl wil help to fix the php login link between phpbb3 and roster 2 ....

EDIT:
After a few hours of getting all the errors out of script i get the 2 line login and a working roster. But the problem now is that now matter which login account i use it just doesnt wanna login and will keep returning to the normal first page without a login. I have included the file where i got until now.

Hope someone sees where i missed the problem.

This is tested on phpbb3 with roster 2.0.2
Attachments
login.php.txt
(27.05 KiB) Downloaded 427 times
Last edited by akiko on Sun Jan 11, 2009 9:05 pm, edited 2 times in total.
akiko
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Wed Jul 11, 2007 10:07 pm

Re: Error: Class 'sql_db' not found

Postby oomkoen.nl » Tue Jan 20, 2009 6:27 am

akiko wrote:This is tested on phpbb3 with roster 2.0.2


PHP3.0.3 and Roster 2.0 i get the error line:
Fatal error: Class 'dbal_mysql' not found in C:\xampp\htdocs\dd\roster\addons\phpBB_login\inc\login.php on line 116

That line is:
if (! $this->database = new dbal_mysql($dbhost, $dbuser, $dbpasswd, $dbname) )
oomkoen.nl
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Thu Jan 15, 2009 4:31 am

Re: Error: Class 'sql_db' not found

Postby Legacystar » Thu Feb 12, 2009 3:30 am

I am also getting this error:

Fatal error: Class 'sql_db' not found in /home/www/wowrejects.freehostia.com/roster/addons/phpBB_login/inc/login.php on line 114

I am using phpBB2 and the WoWRoster 2.0.2

This is my actual path:
/wowrejects.freehostia.com/phpbb2

I have tried that path that I just listed above, tried /phpBB2, and also tried /home/www/wowrejects.freehostia.com/phpBB2.

Getting the same error for all of em. Not sure what to do next. Any help is greatly appreciated, thank you
Legacystar
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Thu Feb 12, 2009 3:25 am

Re: Error: Class 'sql_db' not found

Postby Nutella » Thu Mar 26, 2009 4:42 pm

I tried a little bit and now my login works. There is only a problem with the session. If you click a link you will be logged out.

Tested with phpBB 3.0.4 and Roster 2.0.2

So here is what if done so far. (sry my english)
Attachments
login.php.txt
(27.7 KiB) Downloaded 463 times
Last edited by Nutella on Thu Mar 26, 2009 4:44 pm, edited 2 times in total.
Nutella
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Thu Feb 26, 2009 12:17 pm


Return to phpBB Login

Who is online

Users browsing this forum: No registered users and 0 guests

cron