MYSQL :: PhpBB Slow Loading

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)

Slow Loading Times
It takes more than 30 seconds to load the phpmyadmin page. On a localhost server.
It says
Fatal error: Maximum execution time of 30 seconds exceeded in c:appservwwwphpmyadminlibrariesmysql_wrappers.lib.php on line 101

This sometimes also happens when loading my local website that uses MySQL.
I've tried reinstalling, but it doesnt help.

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

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

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:

Loading A New DB
I'm trying to populate a new copy of my database from the dump script taken from an overnight backup. It starts out OK but then errors with: ERROR 1060 (42S21) at line nnn: Duplicate column name 'id'.
Taking a look at the script I can see that the previous couple of tables have loaded without problem but the offending CREATE TABLE looks like this:

CREATE TABLE xxx (id int(11) NOT NULL auto_increment, <other columns...> ,PRIMARY KEY (id,id)) ...

The id column is only defined once but is duplicated in the PRIMARY KEY definition - strange! Looking through the script I see this is the case on some of the other CREATE TABLE statements also

Loading Data
in my data file i have ten of these in same format how would i load all in
my database from the text file. what would the mysql command be or should i
add something to separate each actor or what? ......

Loading Blobs
does anyone have a perl example of loading blobs from either a bin file
or an input stream?

Loading Csv Data
If you made a table to collect daily stock price in what order would your data be added to the table? Would it be ascending with the recent date towards the top or would it be descending with the recent date towards the bottom?

Also would it be wish to use the date as a key?

Loading A Database
I try to load a new database like this:

mysql> mysql < databasenamedb_2006-06-29.Thursday.sql

but then I get:
mysql> mysql < databasenamedb_2006-06-29.Thursday.sql
---> ...........

so a prompt. What is that prompt wanting? A username or a password?
What should I enter.

And in order to create a new database like this, should I do something else first? Like adding the database with "create databasenamedb;"?

Databases Are Not Loading
I am using Mysql 4.0.18. I load my database (tele) in "data" directory at c:mysql. The first time, I opened WinMySQLadmin and 3 databases appeared: test,mysql and tele. It was Ok. Then I restarted my computer and I went to WinMySQLadmin again and didn't appear mysql and tele database. What I am doing wrong or what is the problem?

Loading Data
how to load data into the tables

Load_file() Not Loading
I'm trying to load a picture into an image database. On my old server it worked fine and on this new one it returns null all the time. Let's say I try:

UPDATE tbl_1 SET blob_col=LOAD_FILE("/tmp/picture.jpg") WHERE id=1;

I get a null even though I should have permissions, the file exists, and the max_allowed_packet is set high enough. The file is on the server and I'm typing into the MySQL command line but nothing. All other UPDATE statements work fine. Just the load_file doesn't work. What am I doing wrong?

Loading Schema
I've been importing a database from a MSSQL server - not massive, 146 tables, about innodb_buffer_size 20GB total data and everything is fine with running queries - performance is good considering it's on a dev box at the moment.

Problem I have though is when you are using phpmyadmin or the mysql administrator it takes an age to load table data (in mysql admin it says 'Fetching schema table status').

These are innodb tables (I'm concerned myisam won't cope with us - lots of small updates and big slow queries) and if I convert the tables to myisam the problem goes away - loads fast as you like.

Is this a problem inherent to innodb or is there a configuration to get around it?

I'm running with default my.ini atm with the exception of innodb_buffer_pool_size=500M.

Loading A Database
I am running MySQL 3.23.46 on my laptop (Win XP), and wondered how I go about loading a database schema?Can this be done from the command prompt for instance, or is it easier to do so using PHP? I have PHP 4 loaded.

Loading Data
To log onto mysql client server I entered
mysql -h linuxproj -u myusername -p --local-infile=1

I was able to get into mysql with no problem after entering my password. Then to load the data from a .txt file stored on my computer I entered

LOAD DATA LOCAL INFILE 'C:/Program Files......../file.txt INTO TABLE Tablename FIELDS TERMINATED BY ',' LINES TERMINATED BY '
';

I got the error 'C:/Program Files....../file.txt'- Error 2 is not found. I dont know why.

Loading Many Files
Say i have a database that has 3 varchar fields and then a blob field. I can easily fill the first 3 fields with a tab delimited file. However how can i load multiple files into the blob field. Say i have 700 records- i can't do it by typing out the command over and over again. Is there a way to write a file specifying all the files that need to be loaded and then feed it mysql like i can do with a tab delimited file? Or is there another way?

Loading Data
how should my data format look like to load it to MySQL table?
Where should field name stand and where the records, what are deviders, which format

Loading Rate
I'm working on a project where we need to load several 10s of
thousands of rows per second (roughly 50 bytes/row) into MySQL tables.
We're using LOAD DATA INFILE, which works fine. The problem is, that
we have to write this data from our application into ASCII files so
load data infile can read them. The bottleneck is the writing of the
data. We were thinking that if we could write the data in binary
format, the writing might be quicker. Is there a way to load binary
data into mysql tables with something akin to load data infile?

Loading Text
a tab delimited file like this:

name is varchar (60)
bio is TEXT data type

name<tab>bio
Jack<tab>name: My name is Jack
car: I have a chevy car
pet: My pet's named Fido

Jane<tab>name: My name's Jane
car: I have a VW car
pet: I don't have a pet

How do I LOAD that into MYSQL ?I want name field and the a text bio field but how do I get it in a table assuming I have line breaks...I'm willing to globally edit the file if needed

Loading Database From .txt File, Please Help! Thanks
I'm very new to mysql and programming in general, just learning the basics, and currently I'm trying to access a database that was formerly on a different server and compressed into a large .txt file, and I also have a version of it in .tar . So the database is on my computer, and I'm just trying to view it through mysql on my machine, windows xp. I have tried the following:
c:> "program filesmysqlinmysql.exe" -u root -ppassword < file.txt
system unable to find the file
I currently have the file in the 'database' folder I created in the mysql directory. should it be somewhere else? should I change its type through properties?
If you have any suggestions for me could you please let me know.

Error Loading Mod_auth_mysql
I am running mysql-3.23.52 on OS X (10.2.6) and I'd like to install the
mod_auth_mysql module for a job I'm working on that used it under a
different platform.

I compiled the module using:

apxs -c -D APACHE1 -L/usr/local/mysql/lib/ -I/usr/include/mysql/
-lmysqlclient -lm -lz mod_auth_mysql.c

and installed it:

sudo apxs -i mod_auth_mysql.so

both of which seemed to go fine. In the httpd.conf file I have put the two
lines:

LoadModule mysql_auth_module libexec/httpd/mod_auth_mysql.so

AddModule mod_auth_mysql.c

but when I try to do a graceful restart of apache I get the following response:

% sudo apachectl graceful
/usr/sbin/apachectl graceful: configuration broken, ignoring restart
/usr/sbin/apachectl graceful: (run 'apachectl configtest' for details)
% sudo apachectl configtest
Syntax error on line 241 of /etc/httpd/httpd.conf:
Cannot load /usr/libexec/httpd/libphp4.so into server: (reason unknown)

Is there a particular order that this had to go in the httpd.conf file? I
can't understand why it is complaining about libphp4.

Loading Binary Data
I have a large data set of binary data files and I'd like to create a database so that I can search on the data contained in these files. I'm new to database development but from what I've seen it is only possible to store & search variables in the database in text format. Is it possible to load the files as binary variables and still use MYSQL commands to search and manipulate the database?

For example, assume a file contains a variable X which is a 32-bit floating point number ranging between 0 and 10. Does the variable X have to be converted to text first (possibly using a C program), stored into another text file, which is then loaded into the database/table? Or is it possible to load the 32-bit floating point number directly from the original binary file and perform a MYSQL query looking for instances of variable X with values 1.2 and 4.8?

Loading Mysql Table
I'm trying to make a simple photog gallery, using phpmyadmin....but I need to load the table with all the image filenames. i.e.: pic001.jpg, pic002.jpg, pic003.jpg, ....... I don't want to sit there entering every single filename (if I dont have to). My question is, is there any way I can write an SQL script, to automatically load, let's say .... pic001.jpg - pic300.jpg into the mySQL database?

Loading Pictures In Mysql
I know you're going to say search the mail archives, but I have and I can't
find an answer to my simple question of is there an SQL statement to load an
image in a .jpg file into a database table?

Also, I have read in lots of places that it's probably not a good idea to
store images in mysql but just store a pointer to the file. Is this the
accepted way of doing things with mysql?

Loading Data Into A Table
I have to load some data into a table (several tables actually). I obviously don't want to/can't insert the records one-by-one. I'm running mySQL versoin 4.0.13. Apparently I can't use the 'LOAD DATA LOCAL INFILE' with this version. Surely there should be another way of doing it?

Loading Mysql On A Windows - IIS
I have a personal web server (IIS) that i am trying to install mysql with...or install mysql so that it is available through my IIS server.

I d/l it...now what? is there a GUI for mysql that i can use? a gui like access or something. if i create databases in mysql at home, how do i get them on a ISP server...

Loading A MySQL Backup
I have a problem loading a MySQL backup from one system into another system. On system A I give the following command:

mysqldump -pxxxxxx Joomla > joomla_backup.sql

On system B I have created a database Joomla and I give the following command: Code:

Set Commit When Loading Data?
I am useing MySQL 4.1 for unix. I am loading a large data file to a singular table useing this command: mysql> load data local infile 'test.txt' into table testagain;

I get an error of running out of memory when loading. So I would like to set an automatic commit to take place after it gets to 100 to 10000 records (does not matter) to avoid running out of memory. How do I do this?

Loading Text Files
Im currently having problems loading a tab seprated file into mysql database.

It loads the data but with each field only loads half the data i.e. txt file contains "hello how are you world" (for a field) SQL table contains "hello how"
Not sure whats causing this as i've opened the same file in excel and it works perfectly (renamed it from .txt to .xls)

Fail Loading Data
I have a file creted using notepad where fields are separated by tabs. I try to load it using LOAD DATA LOCAL INFILE '/../name.txt' INTO TABLE mytabke

I get the following message:

Data truncated for column 'column name' ay row 1 error 1265

and this is repeated for al columns in the windows file.

Bulk Loading Data
I want to insert massive amounts of data in near real-time into a MySQL database. The data is in a structured binary format, and I have code that parses the data into logical data structures.

Right now I can load into a MySQL database via ODBC, but I need to improve throughput. How can I bulk insert the data more efficiently?

I would prefer not to use LOAD FILE because it involves converting the binary format to text, which will have a much larger footprint. To illustrate the pain of text files in my application, a single binary file might contain up to a million rows! And I might load hundreds, if not thousands of these files in a day!

How can I load data directly into the database at a lower more direct level than LOAD FILE? What are my options to integrate my data parser with MySQL?

Loading Mysql Extension For Use With Php-cgi.exe
I used this php package to install on my system...

PHP 5.0.0 installer [2,235Kb] - 26 July 2004
(CGI only, packaged as Windows installer to install and configure PHP, and
automatically configure IIS, PWS and Xitami, with manual configuration for
other servers. N.B. no external extensions included

It