Configuring Zen To Work With Phpbb

mandelism:

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.

jandlack:

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.

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

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.

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.

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...

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

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).

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.....

Ripper:

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;

I keep getting "illegal access" on a blank white page.
If I remove this:

if (!defined('IS_ADMIN_FLAG')) {
 die('Illegal Access');
}

I get:
Fatal error: Class phpbb: Cannot inherit from undefined class base in /home/XXXXX/public_html/store/includes/classes/class.phpBB.php on line 13

OK, I figured that part out..... DUH!!

OK,
I finally have a solution to this. It's so easy, I should kick myself. You need to edit the PHPBB config.php file to this and nothing else:

<?php
$dbms = 'mysql';
$dbhost  = 'localhost';
$dbname  = 'XXXXX' ;
$dbuser  = 'YYYYYY';
$dbpasswd = 'ZZZZZ';
$table_prefix = 'phpbb_';
define ( 'PHPBB_INSTALLED' , TRUE );
?>

Nothing before the first <? nothing after the last ?>

Still doesn't add the user to PHPBB. Oh well.

this is pretty annoying, why is phpBB integration not supported anymore?

Tobias:

this is pretty annoying, why is phpBB integration not supported anymore?
phpBB is still supported in the code. Nothing has changed in its feature set / capabilities.

But it's not working on forums where it did work before version 1.2.6d

exactly

I hate to break up the party but I just installed the latest version of Zen Cart (1.3) with the latest version of phpBB (2.0.20) and it works fine.

I did however notice some issues if config files and the like were not in the same directory structure as the web server directory structure (in particular the Debian phpBB deb files didn't seem to work with the Zen Cart integration).

Current config:

Operating system Linux
Kernel version 2.6.9-34.ELsmp
Machine Type x86_64
Apache version 1.3.34 (Unix)
PHP version 5.1.2
MySQL version 4.1.18-standard

(hosted on A2hosting)

Now all I just have to do is disable the registration and editing of email/password by users in phpBB!

Cheers

Scott

for the majority of people using the latest versions this is not the case.

i've freshly installed both zen 1.3.0 and phpBB 2.0.20 and it simply does not integrate anymore. the nickname field is not present in the registration form in the store and i am totally clueless as to the reason behind this. over the last 5 or more pages of comments in this thread people don't seem to be addressing this properly.

it simply doesn't work like it did and to my knowledge many people i know who also use zencart have simply had to remove their fairly popular forums in order to run on the latest version of zen.

this is becoming a fairly serious problem and there doesn't seem to be any clear-cut solution to it.