Configuring Zen To Work With Phpbb

[DrByte]

Originally posted by mandelism@Apr 2 2006, 03:46 AM
SQL Error : 1054 Unknown column 's.session_id' in 'where clause'

SELECT u.*, s.* FROM shop_sessions s, shop_users u WHERE s.session_id = '5b27a720c5b5aa918b5c36981f87931f' AND u.user_id = s.session_user_id

Line : 267
File : sessions.php

the problem only existed at phpbb index,only wen i once installed zencart into the DB, using the same DB n same prefix, meaning both phpBB n ZenCart havin " zen_ " prefix.. [/quote]
You can't have Zen Cart AND phpBB using the SAME "prefix". But they "can" be in the same database.

Try re-installing using 'zen_' for the Zen Cart table-prefix
and
using 'phpbb_' for the phpBB table-prefix.


When you used the same prefix, you likely caused the system to overwrite some tables.

[DrByte]

Originally posted by jandlack@Apr 3 2006, 05:31 PM
CONFIG.PHP--> $dbhost = 'localhost';
CONFIG.PHP--> $dbname = 'NUNYA';
CONFIG.PHP--> $dbuser = 'NUNYA';
CONFIG.PHP--> $dbpasswd = 'NUNYA';
CONFIG.PHP--> $table_prefix = 'phpbb_';

prefix=
dbname=
dbuser=
dbhost=
dbpasswd=

these 2 groups should reflect similar information.
Since they don't, it suggests that some manual edits to the config.php file for phpBB have been done, and thus Zen Cart couldn't parse the file for needed information.

One thing to check: make sure the lines starting with a $ do not have any spaces in front of them.

[jandlack]

Thanks for the suggestion. I have only changed the configure.php to show the path to config.php. As far as the spaces go, there are spaces, but none between the '' If it will help, I can send you the config file?

Thanks,
Jacki

[zenohrocks]

I have a question about zen-cart + phpBB2 integration.

When user newly register into zen-cart, the integration of zen with phpBB2 would register the user in zencart as well as forums database during the same registration process, right? Ok, at least it appears I got the account creation part working. Account is created, in zen-cart, account name is email address, and in forums, user id is the nickname he picks during the registration process. The same password works for login in zencart and for login into forums.

But, this appears to be a problem: when a user login to zen-cart, the user is NOT automatically login him/her in forums. He must go to login again in Forums and do another separate login process. Is this the way it supposed to be, or something wrong with my integration configuration?

I have configured Zen Cart 1.3 + phpBB2 version 2.0.19.
I tested with user login to zen-cart first, then go to forums, go to profiles, forum ask login again. Then I tested first login to forums, then go back to buy some products under zen-cart, when check out, the same problem, logged into forums does not mean logged in zen-cart.

I wonder if I have something wrong with my configuration, or this is the way it supposed to be?

Thanks.

[Ripper]

That's the way it's supposed to be.

Unfortunately, it hasn't been working that way for alot of us. I will try again now that I see you have it working.

[Ripper]

OK,
I just did a fresh install of Zen Cart 1.3.0 and PHPBB 2.0.19 (I can't get any of the 2.0.20 downloads to work, they all say the ZIP file is corrupted, but that's not related to this issue, yet) on a brand new website setup strictly for testing, on the same server where all of this worked previously (before ZC 1.2.6d and PHPBB 2.0.19).

I cannot get the Forum Nickname box (yes, I know it's the forum ID) to show up and the forum link in the sidebox won't show up either. I have all of the paths correct and I have changed nothing on either "vanilla" install. The linkage is set to "TRUE" in the ZC admin section. I am about to dig into it...

[zenohrocks]

If I were you, I'd check those two places,

1) check the file
includes/configure.php, you have a line says:
define('DIR_WS_PHPBB', '/var/www/html/your_phpBB2_directory/');

replace the exact name of your phpBB2 directory.


2) check file
includes/languages/your_customs_template/english.php: make sure you have a line: define('ENTRY_NICK_TEXT', '');
if you are not using customs template, then check the file
languages/english.php

[Ripper]

Like I said, the path is correct in configure.php (I also tried every possible variation, with the absolute path, without it, with the domain name, without it, with the slashes, without them, just to be sure) The language file is also correct. Still no forum link in the sidebox or text box for Forum Nick Name on the login page.

I have an old cart on a closed testing site on the same server and it all works fine there. I have installed PHPBB 2.0.19 on that site and it still works (changing only the path in configure.php to test each version of the forum). I had it working on 3 different "live" sites until the upgrade to 1.2.7, then they all stopped working. One site had all of the PHPBB registrations directed through the ZC login page, so no one was getting registered for the forum at all. That is the one site where I care if I get this working again. The rest are fine as is, with 2 separate processes.

This is just one of those head scratchers, since it seems other people are able to make it work using the same exact settings (relative to their site, of course).

[Ripper]

Correction, the problems started with 1.2.6d, not 1.2.7

Also, how do you run the sniffer in 1.3.0? There's no debug=true or debug=false in there as far as I can see.....

[DrByte]

Originally posted by Ripper@Apr 9 2006, 10:52 AM
how do you run the sniffer in 1.3.0? There's no debug=true or debug=false in there as far as I can see.....

includes/classes/class.phpBB.php

  function phpBB() {
   $this->debug=false;

set to true instead of false