MYSQL :: A Seprate Database For PHPBB Or Merge The Tables With The Site?

Pull Data From 2 Database Tables Into 1 Table On My Site.
I got 2 tables: a dev_tasks and a task_history table. The task table has to record information about the task I am working on AND the history table is for the task history logs. I am trying to display info from both tables into 1 table on my site.

Most of the info will come from the dev_tasks table BUT i want to dedicate on column of the displayed info for the latest log made to the task_history table.

The common column to both tables is the 'taskid' column.

What would the query look like to pull the info from both tables, knowing that the taskid is common to both and that I want to display the last log per tasks from the task_history table?

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.

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)

Should I Merge Those Tables?
I'm in a bit of dilemma right now. I have a mysql table called `cars` and one called `maintenance`.
The table `maintenance` is related to `cars`. Now I want that in the table `maintenance` are always the same rows as in the table `cars`. Not exactly the same rows, but 1 column of `maintenance` is related to 1 column of `cars`.

I could also merge those tables, but then the table `cars` would have so many columns. So I thought two separated tables would be more synoptic. What should I do?

I already tried to relate those columns with FK-relations with InnoDB, but I don't think that's really the best way.

Correct Use Of MERGE Tables?
I have seen general MERGE table usage for logging where a table is created for a fixed period of time, e.g. a month.

I am looking to do something different. I currently have a very large table, let's call it emails. There are say a million rows in here. The problem is queries running against this can be slow especially any queries against rows that are not indexed (not all of them can be).

What I am thus thinking is to use MERGE tables. Any email that has not been opened in the last year would be moved into an acrhive table. Then what is now the emails table would be renamed so I have emails_archive and emails_current and create the MERGE table emails.

Then, any searches would be run on emails_current unless a checkbox was clicked to run on *all* emails.

Is this a correct way to use MERGE tables? Is moving rows from emails_current to emails_archive going to be a problem with indexes and unique keys? I believe I can insert rows into the MERGE table and they will by phyiscally put inside emails_current but will check the unique indexes on both the tables.

Merge Tables With Where Clause?
I was wondering if there is a way to create a merge table using where
clauses for the underlying tables. I have a date column in all tables
and would like to have it so that I could just inset say the last weeks
worth of data into the merge or would that be pointless.

Changing MERGE Tables
If I have a merge table that is made up of a set of tables and I want
to change the structure of the underlying tables, how do I do it? Will
I be allowed to change each table one at a time even though the
structure must remain the same among all tables?

Also, if primary keys cannot be enforced, does that mean when I do an
insert I must name the actual table I want to insert into?

Changing MERGE Tables
If I have a merge table that is made up of a set of tables and I want
to change the structure of the underlying tables, how do I do it? Will
I be allowed to change each table one at a time even though the
structure must remain the same among all tables?
Also, if primary keys cannot be enforced, does that mean when I do an
insert I must name the actual table I want to insert into?

Merge Tables And Indexes
if anyone knows if you can index a merge table? Or Will indexing the tables that are members of the merge table improve efficienccy. I actually can make the the indexes on the merge tables, but i'm not sure if tha tis really going to make the indexes and improve performance?

Merge Tables Identical Column 1
I have three tables in one database with potential identical rows but different columns (exported from excel, thats the reason). Is it possible to do the following:

1) create a new table with the column headers from each of the three tables automatically (a lot of columns, and a lot of tables in total, to do it by hand would take too long)
2) import the columns from each of the tables into the new table, thereby
comparing row1/col1 in table1 with row1/col1 in table2 and, if the are identical, append the data from table 2?

Further explanation (to clarify it, hopefully):
tab1, tab2 and tab3 should have the same values in their respective row1 (lets call them IDs). only the rest of the columns are different. i want to create a merged table, just appending the columns of table2 to the columns of table1 after checking the ID (the identical values in each table).

How To Stack Tables (maybe Join Maybe Merge)ï¼Ÿï¼Ÿï¼Ÿ
I have thousands of similar tables which I want to stack one on another. The variables in different tables are almost identical, but not exactly. For example, I have table1 with variables state, month, household id, income where state==1. Also table2 with variables state, month, household id, income where state==2.

In addition table2 also has consumption. I want to put table1 and table2 together into one table with variables state, month, household id, income and consumption. Of course for all observations in table1, they get missing values for consumption.

I have looked at the command JOIN, but feel it's not what I want. Maybe I misunderstand something. I don't quite understand MERGE, but I really want to get one simple table standing alone.

One Database For Site And Forum?
I have a site and a forum and I want to use one database for them, so when somebody registers in the site - to be registered automatically in the forum.
Is this possible and if it is - how?

Merge Sort-of Similar Data From 2 Tables In Query
A bit of background. I'm not a web person, and I know enough about databases to scrape by. Most of my SQL is generated using templates or handy things (like PHPMyAdmin etc). I'm also not a PHP coder. I am a C/C++ coder so I've found I can hack some PHP together, and I've got roped into helping a friend with a problem

Here's the issue. I have a MySQL database with 2 tables of interest. Let's call these tables categorydata and itemdata. Both of these tables contain records that describe individual items - the item name, its ID in the system, the date it was added, some free text about it etc.

To be absolutely clear, the purpose of the categorydata table is for a record to define a category (think "puzzles", "board games", "vegetables", whatever), but the record row also includes data on the FIRST item in the category ("banana", "cluedo" etc) along with all its data. The purpose of the itemdata table is to list all the OTHER items in the category ("grapes", "twister" etc). Here's an example record in the categorydata table:

categoryname vegetables
categoryid 1234
categorycreated 10th Jan 2000
categoryowner Bob
firstitemid 4567
firstitemname cucumber
firstitemcreated 12th Jan 2000
firstitemdesc It's long and green
Here's an example record in the itemdata table:

itemid 4568
itemname orange
itemcreated 13th Jan 2000
itemdesc It's round and, er, yeah.

This seems really bad design to me but what do I know.

Here's what I need to do. I need to know how to merge the data in these 2 tables in a single query, ordered by the itemid and firstitemid fields.

In other words, I need the query to merge the data, ordering it so that regardless of the table the record came from the itemids are all in correct numerical order. I need to do this so that I can retrieve each item's data in order.

itemid in the itemsdata table and firstitemid in the categorydata table are unique, so when merged there won't be any colliding ids.

I need to put this in a PHP script (in a loop that dumps out all the items in order), but if someone can just help me with the SQL query syntax I'd appreciate it, I can do the rest.

I think this has something to do with inner joins but I really don't understand how to make it work, or how to retrieve and merge data from 2 tables at once bearing in mind the fields (columns? what do you call them) have different names even though they have the same purpose (ie: firstitemid -v- itemid, firstitemname -v- itemname etc).

Building My First Database Driven Site.
Before I begin, can I just state I have never installed anything on Linux server, so I am very new to this...

Okay at the mo I have and using MYSQL version 3.23.58 on my Linux Sever, incase this is important, heres the details of my server: WEB SERVEUR
Platform : Small - Fedora Core 3
Control panel : Plesk 100
Config : AMEN 2400 - AMD Athlon XP 2400+ Disk: 80 Gb - Memory: 512 Mb

OK, I need to upgrade to the latest MYSQL version. So far, I have downloaded "mysql-standard-5.0.24a-linux-i686.tar" and unpacked the file uner /usr/local

This is where I am stuck, I have no idea what to do next.. I need help for someone never done this before, preferbally a guide like... STEP by STEP, type this,

Linking Site To MySql Database
I have bought the PHP and Database book and have created a database [windows](saved under the default directory under Program FilesMySql...) and I have created a server. How do I link the website (localhost - same PC as one with MySQL) with the database or is it done automatically?

Create Php Site From Existing Database
I have been contacted by one of my clients to construct a knowledge bank based on their ms access database. I have successfully converted the ms access database to MySQL using the GUI conversion tools supplied by MySQL.com . I am wondering, and I don't know whether this is the right site to do this, if I can easily create a php site based on the database tables that have been converted.

Database Design For Ecommerce Site
I am looking to design an ecommerce site with categorised products.
Once built, I want my client to be able to add additional categories and be abel to add their products into their chosen category.Would I be best displaying this dynamnically after creating a table with the products category names in it or doing it static?
Also, if I wanted to show a different header / meta tags for weach category how would I best tie this in?

UBBThreads MySQL Database Merge
I have a UBBThreads forum that uses MySQL for the database. Recently a user's posts were accidentally deleted. We have a backup of the database but unfortunately it's quite old. We urgently need someone who is versed in MySQL operations and preferably is also familiar with UBBThreads to either try to undelete the user's posts (probably unlikely), and if not figure out a way to merge all of the user's posts from the database backup into the currently running database without overwriting any of the other information. If you are capable of doing this please email me at bmcgahan@internetworkexpert.com immediately to start work on this recovery process.

Site User To A Paid Member? Database Design HELP
I am currently working on a website where there are 2 types of users. The regular site user and a paid member. I am trying to figure out the best way to design the database (mysql) without redundancy issues.

The site user can eventually become a paid member but a member does not necessarily have to be a regular site user (in terms of category). Information stored on a site user - first name, last name, address etc. The userID being the primary key. The member pretty much the same thing but new info will be memberID, join date, expiry date, status (pending, active, expired).

I thought the easiest way to do this was to have separate tables. Do you think the best way?

My thoughts are: When the regular site user becomes a member then store the userID in the members table.

The issue I am faced with is how to store the other pieces of information. The address is not mandatory for the site user but is mandatory for the member. So, if the site user has an address then store it in the member table? that's redundancy there. Then a member do not necessarily have to be a site user in the sense of storing the info in that table.

Design issues to think about
- activation of membership once a confirmed payment has been received - Client is using Paypal.
-What if the user clicks on membership and the user is also a site user?
-What if the user is logged in as a site user and clicks membership?

I would greatly appreciate your design recommendations.

How To "merge" Two Tables?
What keyword should i look for to get info on how to merge two tables in the same database?

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

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.

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:(

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.

InnoDB Tables And MyISAM Tables In ONE Database?
My application demands some advantages from InnoDB and some from MyISAM.

Is it attainable to have both InnoDB tables and MyISAM tables in ONE database?
Or else, getting views from two databases, one from InnoDB and the other from MyISAM?

If not possible, any other approaches will do the job?

Site Down
Need help figuring out ohow to unlock tables.
Everytime I try a repair with my Web Host Manager my whole site freezes up.
I have one table that is "in use" a sessions table.
I can use putty and get to the
>Mysql prompt but I am lost from there...
Is there a way to repair or fix this? I have tried using phpmyadmin and cpanel and neither work, they just time out....
what command should I use?

Huge Site
I wonder if MySQL should work with tables having milions of rows, e.g. you have image uploading site and you store daily around thousands of photos and regularly querying them. What are the techniques of this? Is it possible to do this with mysql? Do you know some books, articles about this? I thought about indexing or caching(of course if possible) and I want to learn something about this.

Connect To My Db From Any Site
Can I connect to my db (via php scripts, etc) FROM a client's website ??

Web Site Form
I want to have a form on my website, almost like a feedback form but not for feedback. It will be for getting info from customers. It will simply be about 30 fields that will need to post to a database. How hard is this with mysql? How would I do this on the web page? Is there a certain language I would need to use? Also is it possible to get an email everytime a record is added via the web form?

Search From Web Site
I have a simple search function. Just an input field and a submit button that should search a table in mysql.

I do some regexp stuff in mysql so i use the REGEXP syntax but you don't have to bother about that, since we'll just asume that the user have input "x y z" in the search field.

Problem 1
I have three fields in a mysql table that i want to search. The simplest way I came up with to do this was:

SELECT * FROM table WHERE CONCAT_WS(' ',field1,field2,field3) REGEXP 'x y z'

But this won't work if field1 = z, field 2 = y and field3 = x .
How can I achive this? It's quite impossible to ad an OR statement for every possible combination of x, y and z. (perhaps I will need to search more fields in a go in the future)... Can I change the regexp to be able to match words in any combination?

Problem 2
How do I set up an index in mysql for the kind of search mentioned above? Is it usable to have an index on field1, field2, field3 if you're going to do a concatenation on them anyway?

Search My Site
All my documents and archives are in mysql database.
How do i setup that i can search my website?

MySQL On A Web Site
I am working on a web page that is currently using a MySQL database to manage our product inventory on our web site.The problem is that I am not the person who developed the web page, but it is now my responsibility. I am going to continue using the existing database, but the management process of a MySQL database on a web server is a new process for me.I am going to assume that I should be using the phpMyAdmin tools to interface with the database, but the php programming is new to me, as well.

I'm a fast learner, so what I'm really looking for is a bit of direction in how I can improve or reconfigure the output for the end-user.Anyway, I don't know if I have provided enough information, but if any of you guys can point or steer me in the direction that would make me an educated contributor to these forums, I would appreciate the introductory patience.

Multilingual Site
like...should i just have a base price and calculate the rest when needed?

i use php, mysql and mod_rewrite

Connect My Site
Im trying to connect my webpages to the MySql database that i have as part of my hosting account, ive dropped a MySqldump file into the database and have been trying to connect my site to the database but im somewhat confused about how to do this, i understand ive got to use a little bit of code to make the connection but where do i place that code? and do i place it on every webpage, im trying to put together GET variables so that when someone clicks the "Buy"
link it should then make the billing popup appear, but mainly at the moment my main confusion is about actually what to insert and where, in order to make the connection between my pages and the database

Remote Site.
i jus completed my first database site and ready to upload. but need to know 2 things.
1. where exactly is the database? ive got my site in the inetpub.. is the database in here C:Program FilesMySQLMySQL Server 4.1 ?
2. how do i upload it along with the site? is there just 1 file to upload or is there lots... ?

Building A 1 Page Site?
I have a couple of review site and I'm thinking of building a new one, but along the lines of a 1 page (well, maybe 2 or 3) site. I think the database is pretty basic and the queries dead simple (okay, except for the "I'm thinking about")*, but I'm concerned about 2 things.

1 - site simplicity and fast page loads
2 - some duplicate content

The reviews will have 2 separate text fields.

One will be a description written by me .. unique text.

Another will be a review = customer comments supplied by an affiliate .. duplicate content.

Each text field (description and review) will be up to 10k in size. The database records will also have fields for : name, image link, affiliate link, and a few more .. very brief. Probably a total of 10 fields.

What Im wondering:

1 - what problems should I watch out for, if any, by adding this much text. *I'm thinking about making the first query show up to 10 or 20 items with just maybe the first 30 or 40 words of each text field plus a thumbnail; and then a link in each that would produce a single page with the full text and larger image.

2 - I'm a little concerned that I may get a duplicate content penalty. Will having it in a database help? I'm pretty sure I could put the 'echo' in an iframe and the iframe in a directory and exclude SE bots from that directory with robots.text .. does that make sense?

Finally, there are hundreds of items so I plan on breaking them into categories to keep the menus a reasonable length .. and using javascript to to show an *items* menu when the *category* menu is selected. So should I go ahead and use AJAX to query the database?

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?