Phpbb
I am trying to set up PHPbb on my website using MySql 4.1 for my forums and I can't figure out how to create a new database and connect the database to the actual site and also I need to locate my:
1 database name
2 username
3 password
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Phpbb With Mysql
Im going to uss phpbb as my forums but i dont have a clue where to get started. I know i have to create a database with mysql so it can connect, but i need help on how to start the database what should i put in it etc. I think i can use phpadmin, if i'm right. My host provides me with sql database and sql. Can any please help so i can get this working.
PHPBB Forums
I have MySQL 4.0 installed on my computer. I tried to install the PHPBB forums and set it to MYSQL 4.0, but i dont know a valid host name, or database name, database username, and password. How can i figure these things out.
MySQL With PHPbb?
Is it enough to just install mySQL on the webbserver for the phpbb-forum to work? Or do I have to create my own database-files with predefined tables too?
How To Read Phpbb
php file is loaded as codes on windows, but when u upload it on web u get the codes showed as image and stuff, so my question is, when using local host (windows xp) what prog or how i can see the php files not as codes/source when opening but as image or table or whatever.
Phpbb And Firefox
I am developping a forum using phpbb 2.0.17 (the lastest version). My forum url is www.qnhl.com. The problem is the following: When you make a new post in a specific forum, this forum should show the "new post" icon instead of the "no new post" one. But it's not the case in Mozilla firefox. The "no new post" is always there. What's the problem? Anything related with cookies? Note that I don't have this problem with Internet Explorer.
Phpbb Forum
I'm experiencing some problems trying to get my phpbb forum to work with mysql. I'm running the newest version of apache, and php is installed and working, but I'm not quite sure about what I have to do with the MySQL database part to get it working. If anyone knows of any tutorials or anything I would be grateful Just for reference: I'm a newb when it comes to both php, and MySQL.
Phpbb: Username Already Taken After Deleting
I tested to delete phpbb user where user_post = 0. After deletion, the query exe as normal. But when I start to register, the phpBB immediately shows Sorry, but the username is already taken. instead of showing registeration form.
PhpBB Slow Loading
my site runs quickly except when a user hits forum (allready signed in or logging in) to login to the forums it takes 10x as long to get to the forums as it does the rest of the site, once in the forums its ok and runs as normal,is there any settings in SQL that can speed this up? or is there another problem.
PHPBB Can't Connect To Database
So i'm running Apache, PHP, and MySQL 4.x/5.x (i've attempted both) on Win2k. When i try to install phpBB2 it says it can't connect to the database Connection to database You have not established a connection to MySQL 4.x. ERROR: Access denied for user 'ODBC'@'localhost' (using password: NO) Your database was not found. ERROR: Access denied for user 'ODBC'@'localhost' (using password: NO)
MySQL Query For PhpBB
i want to display 5-10 latest phpBB2 posts on my homepage, and i know there are mods for the forum's index page that do similar thing, but i want to do it in my Perl script. I know how to connect to mySQL DB, but I don't know SQL.. could someone help me with mySQL query for X latest posts, so I would get the result containing user name, post topic, post date&time and post text?
Editing Not Working In PhpBB
After transfering my forum from one server to another, editing stopped working. You can go to phpBB's edit link, but when you try to edit the post nothing is changed. Topic titles can be edited, but nothing else can (including uploaded files with the attachment MOD). If I edit it directly from phpMyAdmin it will work fine, but editing through the forum does nothing. On the last server it worked fine, although I'm pretty sure on my last server I was running on an older version of MySQL (3.x). On my new host (globat) I'm on MySQL 4.1.Nothing was changed in phpBB's scripts since the transfer, so nothing would have taken away the ability to edit post text. If anybody knows what is stopping these things I would greatly appreciate the help, since I've been looking for a solution for quite some time now.
Seprate Database For PHPBB
I have a databse for the main website that will contain ~15 tables. Are there any advantages/disadvantages to merging and seprating and what is generally the best way to go? I'm also interested to hear about (other) situations in wich you would choose for an additional database to increase my insight in the subject.
Help Rewriting A Slow Phpbb Query
I have a "glance" or "Recent Topics" list on my forums that have become fairly complex. I modified an already feature rich glance mod to allow users to select individual forums to exclude from showing topics in the list. As well when users are members of certain forum groups, they see topics from the group forum in the list, and they are highlighted a different colour. The main SQL query to create the list often is showing up in the MySQL Slow_query log and I'm pretty sure is the main cause for the page loading slow. I am no mysql Guru, so I thought I would seek the advice of some to improve or totaly rewrite this slow query. PHP $sql = "SELECT f.forum_id, f.forum_name, t.topic_title, t.topic_id, t.topic_last_post_id, t.topic_poster, t.topic_views, t.topic_replies, t.topic_type, p2.post_time, p2.poster_id, u.username as last_username, u2.username as author_username FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u, " . USERS_TABLE . " u2 WHERE f.forum_id NOT IN (" . $forumsignore . $glance_recent_ignore . ") AND t.forum_id = f.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND t.topic_moved_id = 0 AND p2.poster_id = u.user_id AND t.topic_poster = u2.user_id ORDER BY t.topic_last_post_id DESC"; $sql .= ($glance_recent_offset) ? " LIMIT " . $glance_recent_offset . ", " . $glance_num_recent : " LIMIT " . $glance_num_recent; The "NOT IN" list varies per user, but here is an example: NOT IN (77,75,76,25,26,37,63,64,66,67,67,1,25,26,37,70,28,75,76,78)
Mysql Login Error For Phpbb.
what i am used to do, if i have to select more rows by their id's i write "SELECT * FROM table1 WHERE id IN (1,2,3,4,5)" how can i do this via Execution in adodb (http://phplens.com/adodb/) ? if i pass array, adodb starts complaining, if i implode it, it adds quotes around the string... any help? $ado -> Execute("select * from table1 where id IN (?)", array(array(1,2,3,4,5)) ) //this does not work:(
Tables Import PhpBB/phpNuke
My existing site is ok but limited and I'm now at the point where I would like to use a CMS, but I want to import all the old sites membership and comments into the new install. I HAVE A SCRIPT THAT WILL DO THIS called. phpbb_nuke_conv.tar should anyone else ask. but for this to happen the phpBB data must be in the same database where the nuke data resides, ie moving the phpBB tables over to the nuke SQL database. The prefixes are different so there no problems there, could someone please point set-by-step for this proceedure. I'm sure it only a few buttons and it would save me an ENOURMOUS amount of time reading about a subject I would rather not.
MySQL Query Linking OpenCrypt & PhpBB
I understand that this will seem very novice to you all as developers, but I really need some expert eyes on my question because frankly the other forums have offered no real assistance. I have a customer database system called OpenCrypt installed and running on my website. OpenCrypt has built in features to connect to my mySQL database as to create phpBB accounts similtaneously as general website accounts are created on my website! Now. I am new to mySQL and am working on getting the correct syntax to work with my phpBB database. The following are my current fields in question: user_id -> I need these id's to be created sequentially when new rows are added to my table, phpbb_users. user_regdate -> What date parameters does phpBB read? Thanks for your help! This is my current simple syntax used to similtaneously add phpBB rows to the table, where %variable% refers to my OpenCrypt fields: INSERT INTO kylebt_Forums.phpbb_users SET `username` = '%username', `user_password`=MD5('%password%'), `user_email`='%email%'
Help With MYSQL And PHPBB On Server 2003 Standard
Trying to get help with this situation. I have installed PHPBB, PHP (4X) and MySQL 4.1. This is how I started out. 1. Installed MYSQL - ran setup - did FULL install - and entered in new password when requested. MYSQL gave the green light when computer rebooted. Created new database with CREATE DATABASE XXX; Also installed ODBC from MYSQL site and created a "SITE DSN" for the ODBC 2. Installed PHP and verfied working and accessible 3. Installed PHPBB per the instructions on the site. Did the permissions as instructed on config.php and install.php 4. Came to the install screen. Entered the info and password that I did with MYSQL installation (Root was the username) NOW SAYS - CANNOT CONNECT TO THE DATABASE. I do not know what to do at this point.
Making Site Login Add Users To Phpbb Database Table
I have a login script for my site that I got off the net and was planning to use, but, I also wanted to make it so that when a user signed up thru the registration form it would also add them to the phpbb database's table. It wasn't discussed heavily from where i got the script but from what was mentioned the encryptions differ which results in a rejected login. Code:
|
TRACKER
