MYSQL :: How To Read Phpbb

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?

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.

A Seprate Database For PHPBB Or Merge The Tables With The Site?
I have a databse for the main website that will contain ~15 tables. Are there advantages/disadvantages to merging the phpBB tables with the one from the site or seprating the tables sets in 2 different databases?

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:

Read-only Tables
Is there a way to mark a table as read-only (after inserting some initial data, of course)?
I'd like to do it for optimization reasons - hoping that mysql could take advantage of the knowledge it's read-only, for caching, etc.

Read From MySQL
I installed appache server and php and work great..

But i cant read data from my sql .

I use this code to connect to connect to mySQL
server:localHost
username:root
password: ****

// Connect to the database server
$dbcnx = @mysql_connect('localhost', 'root', 'password');
if (!$dbcnx) {
die( '<p>Unable to connect to the ' .
'database server at this time.</p>' );
}
...
......
Should i create another account in mySQL? .or the php can not communicate with mySQL ?''

How Do I Read The Log-bin File?
Does anyone know how to read the binary log from a client workstation?

The log is named hostname-bin.001 and when I open the file it is unreadable (obviously because it is in binary). So making a shortcut to that file will not do the trick.

How can I open the file via a mysql command prompt on a client PC?

How To Lock A Max ID From Being Read
Basically what I want to do is read the maximum id_B from some table with id_A = 5 and insert a new row with a new id_B. While I do this I don't want anyone else to be able to insert a new row with id_A = 5.

If I do this:

SET AUTOCOMMIT=0;
SELECT MAX(id_B) FROM table WHERE id_A = '5' LOCK IN SHARE MODE;
// do php code here to increment MAX(id_B) by 1 and save it to $new_id_B
INSERT INTO table (id_A, id_B) VALUES ('5', '$new_id_B')
COMMIT;

Would this prevent other users from inserting a new record with id_A = 5, while I'm adding a new record with id_A = 5.

Read Default Value
I have table with simple data. all of fields have default value

how to read this default value, using php

How To Read Log Files
I running on Win2K3 and need to know the basics of mySql system health logs (their location, their expected contents and format) and any other logs that might help track down problems when mySql crashes. I've seen that it will log EventViewer events and that within the C:Program FilesMySQLMySQL Server 5.0data directory there are some logs.

I've been able to read the .err log since it's text but the other logs are binary. Do I have to use a cmdline app within the mySql distriubtion to read the binary files? Or, is this a well documented format and there are several 3rd party utilities out there that will parse/display these logs.

In general, where does mySql maintain its log files, does it generate separate log files per database and what are some common applications that I need to get familiar with to view the contents of these files?

Table Is Read Only
I've upgraded a server from RHEL4 to RHEL5, and in the process gone from 4.1 to 5.0. I copied over all of the database files, adjusted permissions, and ran mysql_upgrade. It's a very simple application that needs no security, so it's running without passwords.

The application works fine reading, but will not write to the table:

[root@chekov etc]# ip_age_off_autoblock
iptables: Bad rule (does a matching rule exist in that chain?)
iptables: Bad rule (does a matching rule exist in that chain?)
DBD::mysql::st execute failed: Table 'addresses' is read only at /usr/local/scri
pts/ip_age_off_autoblock line 47.
Unable to execute at /usr/local/scripts/ip_age_off_autoblock line 47.

I've tried granting privleges to anonymous users:

mysql> grant select,insert,update,delete,create,drop,references,index,alter on *.* to '';

to no avail. Absolutely nothing shows up in the log file.

Read Out An AUTO_INCREMENT-ed Value
The first column of my table is AUTO_INCREMENT. I fill my table with 5 records with a blanco value in their first field. The first column of my table will then hold the values 1,2,3,4,5 (top>down).

Then I erase those 5. Then I add a new record with a blanco first value. It will get number 6.

My problem in this scenario:

I want to read out this number 6 before I will insert that record. Is that possible?

Table Is Read Only
i transfer my mysql database in windows into linux by copy and paste it.when i want to update table record,it promt an error msg:

Error Code : 1036
Table 'ardi02' is read only
(2 ms taken).

Read Only Tables
I log on as a user who has select, insert, update, delete privilegies but when i'm trying to for example insert row in my table myadmin reports me that the table is read only. where can I as a root change this and what are the options?

Read The .err File
Working on installation in Mac OSX 10.4. Need to read the .err file, but don't know how to find it. If you can help, please show the path from from the 'top' i.e. /usr/local/mysql/ and the rest of the path.

Table Is Read Only
I backed up my tables, formated my computer, and reinstalled. Then I reinstalled mysql and capied the files back in. Now every time I try to do any table operations. I get "Table is read only". So I tired palying with the file permissions.. They are rw for user and group.. and they are all owned by mysql and the mysql group.

MySqlDataReader.Read()
Then you ask the Mysql .Net Connector Reader to Read forward is it moving a server side cursor forward?
Or is it just moving forward in a cache of the query result that is already on the client?
I assume(hope) it is the latter but just asking.

Can't Read Dir Of './mysql/'
I am currently using MySQL under Mandrake Linux 10.1 and have an error (see the title).
I have an error message when I want to see All the databases into my Server. I am using PHPMyAdmin.

Read In A .sql File
I have a large SQL file that contains a bunch of create table statements.How do I get mysql to read in this file and process the sql. =20.I am not thinking load data infile because it isn't text

Not Allowing To Read Files
I have program with data accessed by MySQL. In my assume, I copy program and its data files to my friends, and they run program with pleased faces. And now, the first friend wants to delete all program related data files and copy program related data files from second friend(or he can also get any program formatted data files) and save them into data folder. My problem: the first friend can run program with only my data files; he can get any data files from anywhere and save them into data folder, but program won't be allowed to read these data. Does everyone have some good ideads?

Read Size Of Field
Given a table like this, where X can be any size:

table {
name int(X)
}

Is it possible to get the value of X?

MySql Write Vs Read
Essentially I am faced with a design choice;

have an oft run (modifiable) query run every time any user wants to
run it, comparing criteria againt each and every user in the table and
delviering list OR saving that list (user/user/) so the next time all
that needs to be queried is the existence of a record in the table.

The basic tradeoff; version 1 there are many simultaneous queries of
the user db on complex search criteria; version 2 there are fewer but
their are as many far more simple queries to a much larger table, not
to mention many writes to same to keep the table current.

I know this is pretty vague, but I was wondering if in general there
is an area that mysql excels in vis a vis complex query smaller tables
simple query larger tables.

Question 2 is there anyway to guestiate the search/write times of a
user log in to both query and update? #Records, fields, etc? I'd like
to keep log in to < 10 seconds max.

Coding A Forum To Read On A CD
I have a fairly large ubb that I would like made available on CD. Is it possible to do this?

Creating Read Only User
When looking over the instructions for phpMyAdmin they want a read-only user. What GRANT permissions do I need to assign so a user has just read-only rights?

Write Once Read Many Field
I am designing a database and one of the requirements my client has is that once data is entered into certain fields it cannot, under any circumstances, be changed. Is it possible to create a write once read many (WORM) field in MySQL directly?

Read-only TIMESTAMP Field
I need a table with TIMESTAMP field which must be always set to a CREATE server time (so the == CURRENT_TIMESTAMP).

How do I make it read only? I.e. make user unable to override the default value (CURRENT_TIMESTAMP) on CREATE and UPDATE. Is it the Q of user permissions? If yes, how to set 'em correctly to allow create/update but allow only to read timestamp?

First Field Isn't Read Using SELECT
I am trying to gather information from a dbase, displaying it as I go. The script works fine except the first field that matches the criteria isn't read or displayed.

For example:

On this page I check to see if a session variable 'tripNumb' is set. If it isn't, it goes to the dbase and gets the last trip number and adds one to it. The problem is that if there is only one field in the dbase it doesn't read it. Code:

Can SQL Read From A File Or List
I'd like to do a select statement that would substitute variables from a file containing a list of strings, or a list of strings right on the command line. Here's my pseudo code:

SELECT {some value from my list, table or whatever} FROM {some list of tables in a file or other table etc}..

Read Ibdata1 Or Ib_logfile1
Is there a way to read the ibdata1 or ib_logfile1 files? I'm looking for some information. It doesn't have to be complete but wanted to take a look. It's all binary right now and wondered how to convert to .txt or something that i can read.

Read Primary Key While Entering A New Row
I have a website with a form on it.  Upon pressing submit, the information gets entered into the database on a new row.  Each row is numbered with auto_increment (it's the Primary key).  The auto_incremented field is called the ID.

When the user submits his information, I would like an automatic email to get sent to his email with his unique ID number and a recap of this information.  How can I do this?

Basically it seems to me that all I need to know is the command to be able to read information off of the row that you're currently putting information on.  The only way I can think of to do this is to have the form input all the information, then close that connection and start a new one in which it searches for the row that contains all that information and that way I can get it to read the ID then.  Is there a shorter way?

Read Or Convert 5.0 Database To 4.0 Or 3.0
using 5.0 - is there a way to attach remotely to 5.0 databases with a 4.0 or 3.0 client - or is there a way to convert 5.0 databases to 4.0 or 3.0 format?

Table Is Read Only Error
We recently started using MySql as the db behind some java and cold fusion applications. A couple times we've gotten an error that says the table is read only. Stopping services and closing all open sessions does not correct the problem.

We use Mysql Control Center as our GUI, and the repair functions there also give us the same error. The only thing that seems to work is rebooting the server. Anyone run across this before?

How To Read A File Into Mysql
i have created a output file from oracle which contains insert statements like

insert into tms.tms_rem_exclusion_list values (3337)
insert into tms.tms_rem_exclusion_list values (4175)
insert into tms.tms_rem_exclusion_list values (4227)

iam new to mysql and someone told me that if i create such a file
i can import this data into the mysql table at the mysql prompt

like
mysql> tms_rem_exclusion_list < test.sql; (name of the above file)

but iam getting this:

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'tms_rem_excl
usion_list < test.sql' at line 1

first of all i am not sure where to keep the test.sql file ie in which directory
so i kept it under the scripts folder.

Creating A Queue Read-out.
I am trying to create *what should be* a simple result of where a person is in line, but I am having a lot of trouble. I have spent hours searching, and for one thing I don't even know what to search for. So here's what I am trying to do...

Let's say I have rows 1-10 in a database and rows 2,5,6,9, & 10 are all marked with '0' and the others with '1'.

If my $ID is '6', then my code would print out < 3 of 5 >.

Here is the code that I do have...

$num_in_line = (I don't know what query to put here.)

$of_total = mysql_result(mysql_query("SELECT COUNT(ID) FROM all_programs WHERE list = '0'"),0);

echo $num_in_line.' of '.$of_total;

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.