Configuring Zen To Work With Phpbb

[Ripper]

On the login page, about halfway through the registration process, there should be a text box for "Forum Nickname". No matter what I do or what I change, I cannot get the nickname into the PHPBB database. At this point, I don't even recall if the text box was there anymore. I disabled it.

Sorry I'm not more help on this.

[DrByte]

Originally posted by Ripper@Mar 23 2006, 10:24 AM
Is anyone from the coding team reading this thread?

Is there something we're all doing wrong?

It seems once you update to the latest version, you lose interaction with PHPBB.

In v1.2.7 nothing was changed that should have any effect on how Zen Cart talks to a phpBB database.

The only changes related to phpBB were input filtering in
includes/modules/pages/create_account/header_php.php
where
$nick
was changed to
zen_db_input($nick)

This was done to prevent sql injection risks.

Changes to this file have no effect on whether your forum link appears in the sidebox or whether the sniffer debug output says success or failure.
Such failures are typically related to inability to log into the phpBB database, or to find the config.php for phpBB.

[Tobias]

this just wouldn't work at all for me. i enabled it in the my store menu after installing phpbb itself, entered the correct and full path into the configure.php file but it still would not display the forum nickname field in the registration form.

i then edited sniffer.php and changed the line that says phpbb enabled to 'true'. i then refreshed the login page and there it was. Forum Nick Name! woohoo! all is swell right? wrong.

i then tried to create an account to test it but it brings me a database connect error everytime so i had to undo the changes i made to sniffer.php and therefore still do not have phpbb and zen-cart integration.

any suggestions would be greatly appreciated.

[calligraphybycarol]

I read this whole topic. :)
To answer your question, Ripper, yes I successfully linked the latest version of zen cart and the latest version of phpBB using the instructions on the first page of this topic. ::tup I had already changed the admin link to phpbb to true, changed the config.php file, saved it, and it worked..the nickname box showed up and the link to forum showed up. I was able to log in to both the store and the forum.

As you found out, though, I was not able to log in to the store if I registered through the forum.::tdn I have a Photopost gallery, zen cart store and phpbb forum and want the customers to only have to register once for all three. (I was able to configure the gallery and forum registrations already.) I may have to disable the registration on the forum and gallery and make them go through the store so that they will be able to log into all three.

If anyone has a better or easier way to coordinate these, I'm all ears!

[calligraphybycarol]

Originally posted by Ripper@Mar 24 2006, 03:51 PM
On the login page, about halfway through the registration process, there should be a text box for "Forum Nickname". No matter what I do or what I change, I cannot get the nickname into the PHPBB database. At this point, I don't even recall if the text box was there anymore. I disabled it.

Sorry I'm not more help on this.

BTW, the Forum Nickname turns out to be the User Id in the forum.

I do have one other question about the Nickname. It is a required information, but it doesn't have the red star showing up next to it in the log in page. I wondered if that was something I turned off in the Admin by accident?

[DrByte]

Originally posted by calligraphybycarol@Mar 30 2006, 01:58 AM
but it doesn't have the red star showing up next to it in the log in page. I wondered if that was something I turned off in the Admin by accident?

in your create_account.php language file, you may need to add a * into the ENTRY_NICK_TEXT definition.

[calligraphybycarol]

Originally posted by DrByte@Mar 30 2006, 07:02 AM
in your create_account.php language file, you may need to add a * into the ENTRY_NICK_TEXT definition.

I looked in the catalog/includes/languages/english/create_account.php file and there is nothing there that says "ENTRY_NICK_TEXT." Can you tell me where I can edit the "*" into the Nickname text?

[calligraphybycarol]

I will answer my own question above. I found where I can edit to add the "*" in the ENTRY_NICK_TEXT definition in the english.php file. I added an english.php file to my custom folder in catalog/includes/languages/custom and then put the edited english.php file in there, like you described in this post:
http://www.zen-cart.com/modules/ipb/index....?showtopic=9912

[mandelism]

erm..i have done the installation again n again..
after all the linking problem saved, i had this new problm

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

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

wwats teh problem??
thkx in advance
(neway, is there any pre-moded files that can be used to install it in one-go )

[jandlack]

dir=/home/stumpys/public_html/forum/
files_installed
phpbb_path=/home/stumpys/public_html/forum/

CONFIG.PHP-->CONFIG.PHP--> $dbms = 'mysql'&#59; 
CONFIG.PHP--> $dbhost = 'localhost'&#59; 
CONFIG.PHP--> $dbname = 'NUNYA'; 
CONFIG.PHP--> $dbuser = 'NUNYA'; 
CONFIG.PHP--> $dbpasswd = 'NUNYA'&#59; 
CONFIG.PHP--> $table_prefix = 'phpbb_'&#59; 
CONFIG.PHP--> define ( 'PHPBB_INSTALLED' , TRUE )&#59; 
CONSTANTS.PHP-->define('DEBUG', 1); // Debugging off 
CONSTANTS.PHP-->define('DELETED', -1); 
CONSTANTS.PHP-->define('ANONYMOUS', -1); 
CONSTANTS.PHP-->define('USER', 0); 
CONSTANTS.PHP-->define('ADMIN', 1); 
CONSTANTS.PHP-->define('MOD', 2); 
CONSTANTS.PHP-->define('USER_ACTIVATION_NONE', 0); 
CONSTANTS.PHP-->define('USER_ACTIVATION_SELF', 1); 
CONSTANTS.PHP-->define('USER_ACTIVATION_ADMIN', 2); 
CONSTANTS.PHP-->define('USER_AVATAR_NONE', 0); 
CONSTANTS.PHP-->define('USER_AVATAR_UPLOAD', 1); 
CONSTANTS.PHP-->define('USER_AVATAR_REMOTE', 2); 
CONSTANTS.PHP-->define('USER_AVATAR_GALLERY', 3); 
CONSTANTS.PHP-->define('GROUP_OPEN', 0); 
CONSTANTS.PHP-->define('GROUP_CLOSED', 1); 
CONSTANTS.PHP-->define('GROUP_HIDDEN', 2); 
CONSTANTS.PHP-->define('FORUM_UNLOCKED', 0); 
CONSTANTS.PHP-->define('FORUM_LOCKED', 1); 
CONSTANTS.PHP-->define('TOPIC_UNLOCKED', 0); 
CONSTANTS.PHP-->define('TOPIC_LOCKED', 1); 
CONSTANTS.PHP-->define('TOPIC_MOVED', 2); 
CONSTANTS.PHP-->define('TOPIC_WATCH_NOTIFIED', 1); 
CONSTANTS.PHP-->define('TOPIC_WATCH_UN_NOTIFIED', 0); 
CONSTANTS.PHP-->define('POST_NORMAL', 0); 
CONSTANTS.PHP-->define('POST_STICKY', 1); 
CONSTANTS.PHP-->define('POST_ANNOUNCE', 2); 
CONSTANTS.PHP-->define('POST_GLOBAL_ANNOUNCE', 3); 
CONSTANTS.PHP-->define('BEGIN_TRANSACTION', 1); 
CONSTANTS.PHP-->define('END_TRANSACTION', 2); 
CONSTANTS.PHP-->define('GENERAL_MESSAGE', 200); 
CONSTANTS.PHP-->define('GENERAL_ERROR', 202); 
CONSTANTS.PHP-->define('CRITICAL_MESSAGE', 203); 
CONSTANTS.PHP-->define('CRITICAL_ERROR', 204); 
CONSTANTS.PHP-->define('PRIVMSGS_READ_MAIL', 0); 
CONSTANTS.PHP-->define('PRIVMSGS_NEW_MAIL', 1); 
CONSTANTS.PHP-->define('PRIVMSGS_SENT_MAIL', 2); 
CONSTANTS.PHP-->define('PRIVMSGS_SAVED_IN_MAIL', 3); 
CONSTANTS.PHP-->define('PRIVMSGS_SAVED_OUT_MAIL', 4); 
CONSTANTS.PHP-->define('PRIVMSGS_UNREAD_MAIL', 5); 
CONSTANTS.PHP-->define('POST_TOPIC_URL', 't'); 
CONSTANTS.PHP-->define('POST_CAT_URL', 'c'); 
CONSTANTS.PHP-->define('POST_FORUM_URL', 'f'); 
CONSTANTS.PHP-->define('POST_USERS_URL', 'u'); 
CONSTANTS.PHP-->define('POST_POST_URL', 'p'); 
CONSTANTS.PHP-->define('POST_GROUPS_URL', 'g'); 
CONSTANTS.PHP-->define('SESSION_METHOD_COOKIE', 100); 
CONSTANTS.PHP-->define('SESSION_METHOD_GET', 101); 
CONSTANTS.PHP-->define('PAGE_INDEX', 0); 
CONSTANTS.PHP-->define('PAGE_LOGIN', -1); 
CONSTANTS.PHP-->define('PAGE_SEARCH', -2); 
CONSTANTS.PHP-->define('PAGE_REGISTER', -3); 
CONSTANTS.PHP-->define('PAGE_PROFILE', -4); 
CONSTANTS.PHP-->define('PAGE_VIEWONLINE', -6); 
CONSTANTS.PHP-->define('PAGE_VIEWMEMBERS', -7); 
CONSTANTS.PHP-->define('PAGE_FAQ', -8); 
CONSTANTS.PHP-->define('PAGE_POSTING', -9); 
CONSTANTS.PHP-->define('PAGE_PRIVMSGS', -10); 
CONSTANTS.PHP-->define('PAGE_GROUPCP', -11); 
CONSTANTS.PHP-->define('PAGE_TOPIC_OFFSET', 5000); 
CONSTANTS.PHP-->define('AUTH_LIST_ALL', 0); 
CONSTANTS.PHP-->define('AUTH_ALL', 0); 
CONSTANTS.PHP-->define('AUTH_REG', 1); 
CONSTANTS.PHP-->define('AUTH_ACL', 2); 
CONSTANTS.PHP-->define('AUTH_MOD', 3); 
CONSTANTS.PHP-->define('AUTH_ADMIN', 5); 
CONSTANTS.PHP-->define('AUTH_VIEW', 1); 
CONSTANTS.PHP-->define('AUTH_READ', 2); 
CONSTANTS.PHP-->define('AUTH_POST', 3); 
CONSTANTS.PHP-->define('AUTH_REPLY', 4); 
CONSTANTS.PHP-->define('AUTH_EDIT', 5); 
CONSTANTS.PHP-->define('AUTH_DELETE', 6); 
CONSTANTS.PHP-->define('AUTH_ANNOUNCE', 7); 
CONSTANTS.PHP-->define('AUTH_STICKY', 8); 
CONSTANTS.PHP-->define('AUTH_POLLCREATE', 9); 
CONSTANTS.PHP-->define('AUTH_VOTE', 10); 
CONSTANTS.PHP-->define('AUTH_ATTACH', 11); 
CONSTANTS.PHP-->define('CONFIRM_TABLE', $table_prefix.'confirm'); 
CONSTANTS.PHP-->define('AUTH_ACCESS_TABLE', $table_prefix.'auth_access'); 
CONSTANTS.PHP-->define('BANLIST_TABLE', $table_prefix.'banlist'); 
CONSTANTS.PHP-->define('CATEGORIES_TABLE', $table_prefix.'categories'); 
CONSTANTS.PHP-->define('CONFIG_TABLE', $table_prefix.'config'); 
CONSTANTS.PHP-->define('DISALLOW_TABLE', $table_prefix.'disallow'); 
CONSTANTS.PHP-->define('FORUMS_TABLE', $table_prefix.'forums'); 
CONSTANTS.PHP-->define('GROUPS_TABLE', $table_prefix.'groups'); 
CONSTANTS.PHP-->define('POSTS_TABLE', $table_prefix.'posts'); 
CONSTANTS.PHP-->define('POSTS_TEXT_TABLE', $table_prefix.'posts_text'); 
CONSTANTS.PHP-->define('PRIVMSGS_TABLE', $table_prefix.'privmsgs'); 
CONSTANTS.PHP-->define('PRIVMSGS_TEXT_TABLE', $table_prefix.'privmsgs_text'); 
CONSTANTS.PHP-->define('PRIVMSGS_IGNORE_TABLE', $table_prefix.'privmsgs_ignore'); 
CONSTANTS.PHP-->define('PRUNE_TABLE', $table_prefix.'forum_prune'); 
CONSTANTS.PHP-->define('RANKS_TABLE', $table_prefix.'ranks'); 
CONSTANTS.PHP-->define('SEARCH_TABLE', $table_prefix.'search_results'); 
CONSTANTS.PHP-->define('SEARCH_WORD_TABLE', $table_prefix.'search_wordlist'); 
CONSTANTS.PHP-->define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch'); 
CONSTANTS.PHP-->define('SESSIONS_TABLE', $table_prefix.'sessions'); 
CONSTANTS.PHP-->define('SESSIONS_KEYS_TABLE', $table_prefix.'sessions_keys'); 
CONSTANTS.PHP-->define('SMILIES_TABLE', $table_prefix.'smilies'); 
CONSTANTS.PHP-->define('THEMES_TABLE', $table_prefix.'themes'); 
CONSTANTS.PHP-->define('THEMES_NAME_TABLE', $table_prefix.'themes_name'); 
CONSTANTS.PHP-->define('TOPICS_TABLE', $table_prefix.'topics'); 
CONSTANTS.PHP-->define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch'); 
CONSTANTS.PHP-->define('USER_GROUP_TABLE', $table_prefix.'user_group'); 
CONSTANTS.PHP-->define('USERS_TABLE', $table_prefix.'users'); 
CONSTANTS.PHP-->define('WORDS_TABLE', $table_prefix.'words'); 
CONSTANTS.PHP-->define('VOTE_DESC_TABLE', $table_prefix.'vote_desc'); 
CONSTANTS.PHP-->define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results'); 
CONSTANTS.PHP-->define('VOTE_USERS_TABLE', $table_prefix.'vote_voters'); 
prefix=
dbname=
dbuser=
dbhost=
dbpasswd=
users_table=users
user_group_table=user_group
groups_table=groups
config_table=config
link_enabled_admin_status=true
FAILURE: phpBB NOT activated


Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/stumpys/public_html/includes/classes/sniffer.php:58) in /home/stumpys/public_html/includes/functions/sessions.php on line 111

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/stumpys/public_html/includes/classes/sniffer.php:58) in /home/stumpys/public_html/includes/functions/sessions.php on line 111

I am a true newbie to Zen, and would like to have some help if possible. I have read through this post as well as many others, and in most cases have found what I needed. This time I am really stuck.

Any suggestions or help would be greatly appreciated,
Jacki
::frust