MYSQL :: Normalizing The Unknown - Multiple Sites Setup

Sharing Data Across Multiple Sites
Sorry if this has been addressed on this board, but I am getting some serious Hour glass action, when I attempt to search this board.

I am attempting to put multiple sites together that utilize one common database with common tables. I wanted to get some advise on how the table can be implemented efficiently.

The concept is I have multiple sites that share the same code and database. I will assign a site ID to distinguish between the sites. Some Article data will be shared across the sites. Example: I have a site for Bass Guitar, Lead Guitar, Keyboard, Saxophone, etc. A component of the site will be articles written about music theory, that can span all these sites. How can I implement a solution that allows One article to be placed on all these sites based on the site ID.

I was thinking of one of two ways (and ofcourse there might be an even easier way, i haven't thought about)

Option 1
Having a field in the database named after each site or siteID, and in my query having a WHERE Clause in the code based on the siteID ie: "WHERE Bass = 1" for the bass site, and on the Saxophone site the same code would be there "WHERE Sax = 1" that way on each site If the article has a 1 in the field, it would display. I don't think it is efficient and if I where to use this concept across a large number of sites, it would very quickly become a nightmare to maintain.

Option 2
Having a field that receives a comma delimited data, that can be parsed with SQL and displaying the results if the data is present. With option two I do not know how to do it with SQL any insight? Is this efficient?

View Replies !

Best Practice Normalizing DB?
Users - Zero or more User accounts
Albums - Users have zero or more albums that contain zero or more tracks
Tracks - Users have zero or more albums that may or may not belong to one album

Currently I have one table for each and they are completely normalized and there are no foreign keys to each other. I have a relationship table called rel_user_album_track that looks like this:

id : INTEGER
user_id : Foreign Key to user table id field
album_id : Foreign Key to album table id field
track_id : Foreign Key to track table id field

When I query this table I will be able to see which users own which tracks and if those tracks belong to albums, which album is it?

I'm really looking for feedback on this design... I'm not a DB designer.. I'm just a software engineer trying to think ahead for performance reasons if this makes sense.

View Replies !

Proper Table Setup For Multiple User Types
I have a table called "schedules".

I want to combine 2 types of schedules into this table(if possible) .. class schedules(class_id) .. and individual user schedules(user_id)

With DRY in mind..I don't want to have a class schedules table and user_schedules(as I will have other tables using the same idea as well), as both schedule setups will be the same.

I have heard in the past that it is improper syntax to include both a "class_id" & "user_id" field in each table, where 1 would be null(I.E. a class_id would be set, and user_id would be null).

Is there a simple logic behind this type of thing that I am just completely blind of?

View Replies !

Normalizing Large Pieces

Let's say I have a user's table that is very frequently used:
user
________________________________________
user_id(PK),user_username,user_password
-------------------------------------------------------
And a user_info table that is not so frequently used:
user_info
_____________________________________________________________
user_id(PK),user_info_fname,user_info_lname,user_info_address,
user_info_city,user_info_state,user_info_zip,user_info_email
-------------------------------------------------------------------------------------
Now what I was thinking is that the user_info table is much to large to be considered a normalized table. If so, how can I break it up efficiently?

View Replies !

Inserting Multiple Items (# Unknown) Into A Table Using Primary Id From Master Table
In my database I have a master table for products using a auto-num id column. One product may have several purchase options (items) which have to be entered into another table.

To enter a new product and items I use a form that gathers the information for the master product and one item. This information is then inserted into the database. For the items I use mysql_insert_id() to get the id into the items table.

My challenge is getting this same id for additional items. Once the user has input the initial product and first item they hit a submit button to call a form for adding any additional items, and this is repeated until all items for that product are entered.

The new items are inserted into the database okay, but always with an id of 0. The mysql_insert_id() no longer works. Is there a way to pass this id from the previous insertion to the new one by passing a variable? or echoing input type"hidden"?

Or even better yet, Im wondering if I can ask the user at the time of entering information for the product how many items that particular product has and then bring up that many form fields to enter multiple items? Can this be done using something like an incremented loop to call form fields?

View Replies !

Best MYSQL Sites
i want to know the list of best Web sites were i can get MYSQL tutorials working with PHP.

View Replies !

Large Commercial Sites
For the past few months I have been learning PHP and MySQL in my free time. I have ideas for money making entrepreneur-style websites (worth a try, right? ). I'd like to develop the sites myself but I'm struggling to find resources that offer a straight up, detailed guide to creating high traffic database driven websites.

So far all the books I have bought come across as "here's a chapter on how to make x application, but in the real world it's much more complex". In other words, workaround solutions that wouldn't be suitable for ACTUAL high traffic db driven sites. I'm understanding the material fine, it just doesn't seem thorough enough for real world.

I'm contemplating buying Sitepoint's "Build Your Own Database Driven Website Using PHP & MySQL", but since each book I've bought costed $20-40 and so far none of them have been up to what I'd consider industry standard, I'm slightly reluctant to shell out another $40 at risk of getting rehashed version of the "watered down version of real world apps" style approach the other books had. Has anyone bought this book? Would you be able to develop a site like, say, IGN using the info in it?

Alternatively, if anybody can list a few key points that I can research (i.e. security issues, relational databases etc.) I'd be more than happy to go off and locate the articles myself. It's just knowing what I need to LEARN that's the problem.

View Replies !

Database Synchronisation On Two Remote Sites
I am considering the possibility of trying to keep a user table synchronised on two different sites. This is not something i've done before so i'm looking for any tips that might help me on my way.

Basically I was thinking of:

- scheduling php script to connect to both databases via cron to update the table at regular intervals
- generating an xml feed and doing the same thing

Both methods would potentially involve storing a pointer to only read and write the new rows, although perhaps I could use DATETIME to also copy accounts that have been updated since last run.

Probably biggest concern is:
- security... operating in a way that the data is private. The most sensitive data is hashed passwords and postal addresses, I don't think it would be appropriate to not somehow protect this info during transfers. I'm not sure whether SSL is an option (should be) but possibly I was thinking of creating some kind of token system.

- bandwidth. both sites should be fine resource wise but due to my lack of experience in these matters I don't really know what the performance hit will be, and I would like to run the script very often

As far as I know alot of big sites (for example hotel booking engines) use xml in the background to share info but I really have no idea how it all works.

View Replies !

Connecting To Yahoo Webhosting MySQL Sites
1. I've signed up for yahoo webhosting because they had MySQL
2. Installed their phpadmin tools and setup the admin username / password for my db's, create one db and table
3. I downloaded and installd the MySQL GUI tools
4. Pointed MySQL admin to my domain name with un/pw default port 3306

And all I get is "Can't connect to MySQL server on domain name (10060)

View Replies !

Two Sites Using The Same Forum Database User List
I know it's possible for TWO different sites to use the same database. Let me explain.

I have siteA and it runs a forum. Through the site, users of the forum can login using their forum ID. I now create siteB on a different domain, but on the same hosting service. I want users from siteA to be able to login with their name from that site on siteB. How would I do this? I'm using myBB as my forum software.

View Replies !

Configure 2 Sites To Access One User Table
I have two databases on the same server with different domains. I would like both sites to access the same user database table. They have the same fields.

I thought that it might just be done with an mysql command, which will point one table to the other.

View Replies !

Unknown SQL Type
For some reason i get this error for queries when i run them in VB.NET. But when i run the query in MySQL Query Analyzer it works perfectly fine. Is anyone familiar with this error Unknown SQL type - 0.

View Replies !

Unknown Option -- Log-bin
Trying to use the mysql command-line client with a MySQL 5.0.21 database on Windows 2003 Server, and am getting the error message:

mysql: unknown option '--log-bin'

What does this mean and how can I get my command-line client back?

View Replies !

Unknown Column
i was using an older version of mysql on my laptop and working on a portal project,
all was going well, no problems even using php5,
i have now upgraded to mysql 5.0.18 and when i try and access the profile page of the forum i get this error....
i'll past the query first then the error i am now getting.

Quote:if ($user_result = db_fetch_array(db_query("select user.*,groups.online_template_large,session.url,session.sessionid from user,groups left join session on session.userid=user.userid where user.userid='$_REQUEST[id]' and user.groupid=groups.groupid order by session.lastactivity desc limit 1")))

View Replies !

Phpmyadmin: Size Unknown
When I import mysql data from a dump file into mysql, then phpmyadmin under structure shows sizes as unknown. I googled for this, but could not find a good answer.

How do I get the information to show in phpmyadmin?

View Replies !

MySQL Password Unknown
Unsure what to do next.

1. Apache running in task bar.
2. PHP info function brought expected results.
3. Clicking on MySQL Command Line Client brings up a DOS box that says:

Enter password:

When typing either the only password I would have used upon installing OR using nothing and pressing ENTER, the box disappears with a loud computer default beep, then nothing.

View Replies !

Unknown Column When Using SELECT X AS Y
Someone more experienced than me will probably (I hope) be able to help me with this...

Here is the query:....

View Replies !

SELECTing A Single Unknown Value
I'm trying to find the best method of determining if two people are from the same area, my setup goes as follows I have a member table, a location table and a m2l (member to location) relation table which simply has an id, a member_id, and a location_id

I would like to be able to search if, given 2 member ids, they have a location id in common, since one member may have many locations. Is there a way to SELECT * FROM location, m2l WHERE location.id=m2l.location_id AND member.id='1' OR member.id='2'

is there a way I can SELECT only 1 location id which still satisfies the member.id='1' or member.id='2'? Since I don't know if they have any locations in common, i can't explicitly specify a location id...

View Replies !

Unknown Collation Problem
#1273 - Unknown collation: 'bJxHZ6M1mX6hwAXAbRdZA-J98V3_0AdfyjflUKgmpbk.'

And every time the string 'bJxHZ..." is different.

I installed and upgraded my system but still doesn't work.

I supposed the problem was in my.cnf and realized I didn't have a collation in that file, so I added

default-character-set = latin1
character-set-server = latin1
collation-server = latin1_spanish_ci

And, it worked but after a reboot, I get the same error.

My system is openSuSE 10.2, mysql 5.0.26 and apache 2.2.3

View Replies !

Deleting Some Unknown Caracters ?
I have a lot of fields where I want to delete 4 random numbers.

So, these fields for example :

1- "Client : 5841 TX"
2- "Client : 9822 TX"
3- "Client : 0330 TX"
4- "Client : 4987 TX"

Have to be like :

1- "Client : TX"
2- "Client : TX"
3- "Client : TX"
4- "Client : TX"

Is this possible ? I tried this but it didn't make it :

UPDATE `table` SET field = REPLACE (field,'Client : % TX','Client : TX')
WHERE field LIKE '%Client%TX%'

Do you think it's possible ?

View Replies !

Unknown Column Error?
Unknown column 'ip' in 'on clause'

View Replies !

Unknown VALUES Number
I have to insert some rows in a two columns table in the form (a,b) where a is fixed and b has n different values; my query should appears like:

INSERT INTO `table` (`id_a`,`id_b`) VALUES ('1','1'),('1','2'),('1','3'),...,('1','n')

the list of values for b come from a PHP script and are listed in a comma-separated string:

1,2,3,4,...,n

how can I modify my query to insert the rows using that string?
I thought about something like:

INSERT INTO table (`id_a`, `id_b` ) VALUES ('1', IN(appendTheStringHere)) .

View Replies !

One Value, Unknown Number Of Instances
Say I want to have a DB that keeps track of how many pints (of prune juice) I drink (okay, bad example) Each pint will have a size and the amount of time it took to drink, but I don't know how many pints I will have in each instance.

Would I have a table for Pint that had pint_size and drink_time, and then a table DrinkingSession that had num_of_pints? But then how would I log the time for each pint?

Could I write a DrinkingSession table that had pint1, pint2 pint3, etc?

View Replies !

Unknown System Variable
Im trying to install a script and this is showing up:

[Unknown system variable 'NAMES']

My MySQL version is MySQL 4.0.25. Is it because the version?

View Replies !

Unknown Column In 'on Clause'
I have seen this a couple of times and what throws me for the loop is the column IS in the table.

Unknown column 'cm.state_id' in 'on clause'

select cm.*, o.userid,c.printable_name country_name, s.printable_name
state_name, email_add as owner_email from b2gcar_mst cm, b2gcountry c,
b2gowner_mst o left join b2gstate s on (cm.state_id=s.state_id) where
cm.country_id=c.country_id and cm.owner_id=o.owner_id and cm.cid=Ɔ'

View Replies !

Unknown Column XXX In 'on Clause' - :(
I use mySql 5 and i get this particular error
error: Unknown column 'p.ID' in 'on clause'
when i'm using the below statement
"select p.title, p.url, p.ID, p.category, p.submitted_user_id ,pc.cat_title ,u.username, u.ID, pc.ID as cat_id, from posts p, post_cats pc, users u left join post_votes pv on pv.post_id=p.ID left join post_comments pcom on pcom.post_id=p.ID where pc.ID=p.category and u.ID=p.submitted_user_id ";

View Replies !

Unknown Column (assigning Using AS)
SELECT
u.user_id,
u.user_name,
(
SELECT COUNT(friend_from)
FROM friends
WHERE friend_from = u.user_id
) AS friends_added,
(
SELECT COUNT(user_referered)
FROM users
WHERE user_referered = u.user_id
) AS friends_referered,
friends_added + (friends_referered * 10) AS points
FROM users u

Quote:

#1054 - Unknown column 'friends_added' in 'field list'

View Replies !

Unknown Why This Error Is Happening
unknown column 'g.id' in 'field list'
in this SQL?

CREATE TABLE teamScoresH2H
(
SELECT
t1.id as team_1_Id,
t2.id as team_2_Id,
COUNT(DISTINCT g.id) AS nbrOfGames,
SUM(IF(g.homescore > g.visitorscore, 1,0)) AS Wins,
SUM(IF(g.homescore < g.visitorscore, 1,0)) AS Losses,
SUM(IF(g.homescore = g.visitorscore, 1,0)) AS Ties,
SUM(IF(g.homescore > g.visitorscore, 3, IF(g.visitorscore = g.homescore, 1, 0))) AS Score
FROM
teams t1
INNER JOIN teams t2 ON t1.id <> t2.id
LEFT JOIN games g ON (g.homeid = t1.id AND g.visitorid = t2.id) OR (g.homeid = t2.id AND g.visitorid = t1.id)
WHERE
(t1.division='AA' OR t2.division='AA') AND
(t1.division='AA' OR t2.division='AA') AND
(g.homescore not in (999,777) or g.homescore is null)
GROUP BY
t1.id, t2.id
)

View Replies !

Unknown Column Error
I m receiving an unknown column 'foo' in 'where clause' error on the following PHP script.
Can anyone shed any light as to why, because I am stumped.

The following code creates a select box.

function ItemsbyBrand() {
print "<label>Search by Brand</label>
";
print "<form action="">
";
print "<select id="manufacturer" name="manufacturer" onChange="top.location = 'brand.php?brand='+document.getElementById('manufacturer').value;">
<option value="0">Please choose...</option>
";
$resultid = mysql_query("SELECT manufacturer FROM stock GROUP BY manufacturer");
if($resultid) {
while($row=mysql_fetch_array($resultid)) {
printf ("<option value="%s">%s</option>
", $row["manufacturer"],$row["manufacturer"]);
}
}
print "</select>
</form>
";
}
brands.php contains this

<?php BrandResults($_GET["brand"]);
and BrandResults is

function BrandResults($brand) {
$q = sprintf("SELECT stid,name,retailprice,catlist.cat FROM stock LEFT JOIN catlist ON stid = stock WHERE manufacturer=%s ORDER BY retailprice ASC", $brand);
$resultid = mysql_query ($q);
if($resultid) {
BrandResultsName($brand);
if(mysql_num_rows($resultid) > 0) {
ProductTemplateCat ($resultid);
}
else {
print "<p>The are currently no items within these search terms</p>
";
}
}
else print mysql_error();
}
function BrandResultsName($sres) {
printf ("<h2>Items by %s</h2>",$sres);
}

View Replies !

Unknown Table In Where Clause?
Why won't my mysql client recognize gallery_details?

Code:
SELECT p.photo_id, p.venue_id, p.event_id, p.views
FROM photos p
WHERE gallery_details.category = 1 ORDER BY views DESC LIMIT 100;
the error

SELECT p.photo_id, p.venue_id, p.event_id, p.views
FROM photos p
WHERE gallery_details.category =1
ORDER BY views DESC
LIMIT 100

MySQL said: Documentation
#1109 - Unknown table 'gallery_details' in where clause

View Replies !

New Db Setup
Does anyone know of a good web site that I can look at that will show me how to set up a MySQL instance?

View Replies !

DB Setup
I'm trying to figure out how I should layout a database table(s). What I would like to do is be able to keep track of how many times several pages are viewed each day.

For example, I'd like to know how many times the index.php was hit on Sept 8. and how times on Sept 9. How many times article.php was hit on the 8th and on the the 9th etc.

View Replies !

Setup.exe Xp Pro
how to sort this out everytime i try to uninstall a progarm it comes up with setup.exe has a problem and as to close,it is just on 1 program it is a ebay toolbar im trying to get rid off any help might help.

View Replies !

Setup With PHP
I've downloaded the mySQL files from the http://www.mysql.com website, and have unzipped them into my c: drive, although, i wish to be able to use this in addition in my PHP programming with my Apache Server. How would I do somthing like this?

View Replies !

Joining Tables On Unknown Table Name
I have a framework that uses dynamically created tables, named using an
incremental "attribute set ID", as follows:

attrdata_1
attrdata_2
attrdata_3
etc, etc...

I also have another table that stores data for each object within the
framework, called "object". The fields in this table are fixed so are always
known, one of which is "attrset_id" which relates to one of the
"attrdata_***" tables.

The fields in the "attrdata_***" tables are all unknown except for a fixed
"object_id" field that links objects with an entry in those tables.

The idea is that the "attrdata_***" tables can be used to extend the data
for each object so, for example:

We need to extend Object 100 to store new properties "name", "address" and
"tel", so a new "attrdata_4" table is created containing fields "object_id",
"name", "address" and "tel" and "object_id" is set to "100" (the object's
ID) and the "attrset_id" field in the "object" table is set to "4" (the
newly created attribute set's ID).

Now, when querying the DB I want to link the "object" table with the
relevant "attrdata_***" table to get the complete extended data set, so
ideally this would be....

SELECT O.*, A.* FROM object AS O
LEFT JOIN CONCAT("attrdata_", O.attrset_id) AS A ON O.id=A.object_id
WHERE O.id=100

... but that doesn't work. What I need to know is if anything along those
lines exists? I've looked, but not found so I'm now making sure :) Although
it could be done using a couple of statements, I'd prefer, if possible, a
single statement solution.

View Replies !

Unknown Variable --defaults-file
I am trying to use the --defaults-file with a compiled version of mysql on a Feodra Core 2 based on Linux-2.6.5 I type the following command :

/usr/local/mysql4src/libexec/mysqld --basedir=/usr/local/mysql4src
--datadir=/usr/local/mysql4src/data --user=mysql4
--pid-file=/usr/local/mysql4src/data/mysql.pid --socket=mysqld.sock
--defaults-file=/usr/local/mysql4src/my.cnf

041110 11:47:43 [ERROR] /usr/local/mysql4src/libexec/mysqld: unknown
variable 'defaults-file=/usr/local/mysql4src/my.cnf'

I am using mysql-4.1.7 and compiled it with the following options :
../configure
--prefix=/usr/local/mysql4src
--localstatedir=/usr/local/mysql4src/data
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock

Do I have to compile mysql with a special option or something like this?

View Replies !

Mysqldump: Unknown Variable 'quickmax_allowed_packet=16M'
I am moving from a master reseller to a VPS

Recieving this error while moving mysql:

mysqldump: unknown variable 'quickmax_allowed_packet=16M'

View Replies !

Unknown MySQL Server Error
I receive the error below when I try and add a post to my website. Any idea what is going on?

Warning: mysql_pconnect(): Unknown MySQL Server Host 'host' (0) in /home/webbport/public_html/guest.php on line 69
Unable to connect to SQL server

View Replies !

Unknown Table 'xxxx' In Where Clause
I have been looking through a few of the forum posts here and I haven't found a solution to my problem.

There error I am getting is:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-4.1.7-nt]Unknown table 'girls' in where clause

/xxx/xxx.asp, line xxx

[asp]
Dim RSGirls
Dim RSThumbs
Dim GirlSQLStmt
Dim ThumbSQLStmt

GirlSQLStmt = "SELECT Name, Height, Age, Weight, Bust, Waist, Hips, Pictures, Description "
GirlSQLStmt = GirlSQLStmt & "FROM Girls"

ThumbSQLStmt = "SELECT * FROM tourthumbs WHERE tourthumbs.id = girls.id"

Set RSThumbs = MyConn.Execute(ThumbSQLStmt)
Set RSGirls = MyConn.Execute(GirlSQLStmt)
[/asp]

There are two tables in the database, 'girls' and 'tourthumbs'. I have checked the permissions that I have set for MySQL and made sure that I can access them both. Both tables also exist and so does the id field in both tables.

View Replies !

Save A List Of Unknown Length
I'm trying to create a db that I can store recipes in.I would like to have a table for the recipes and a seperate table for the ingredients,but each recipe will have an unknown number of ingredients.i don't really want to create max-ingredients +1 fields and I would prefer not to save a string of PKs that i have to parse appart.This has got to be a common task, how is it done?

View Replies !

Unknown Column In Field List
I'm trying to update a text field upc12 in my universal table with a text field upc20 from my newtable where universal table and the newtable have the same UPC number...

UPDATE universal
SET universal.upc12 = newdata.upc20
WHERE universal.upcnumeric = newdata.upcnumeric;

SQL Error: Unknown column 'newdata.upc12' in 'field list'

I have verified that newdata.upc12 is intact.

View Replies !

Unknown MySQL Server Host
I have a production webApplication running on linux, apache; which most of the time runs fine, except once a while; I receive this warning message:

Warning: Unknown MySQL Server Host 'serverName.com' (11) in /usr/local/apache/htdocs/webApplication/db.php on line 12

...here is my db.php ...
<?PHP

function dbConn()
{
$hostname = "servername.com";
$username = "root";
$password = "the_pwd";
$dbname = "mysqldbName";

$dbLink = mysql_connect ($hostname, $username, $password) OR DIE("Unable to connect to database");
mysql_select_db ($dbname) or die("Unable to select database");
return $dbLink;
}

function dbEnd($dbLink)
{
mysql_close($dbLink);
}
?>

View Replies !

#2000 - Unknown MySQL Error
I'm using my SQL via one of SBC yahoo's packaged deals for web access.

Everything had been going along smoothly...until today.

Under PHPMYADMIN...privileges I started seeing the following msg:

Warning: Your privilege table structure seem to be older than
this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!

Whatever SQL statement I try to run (a select, alter, update etc etc) I get the #2000 - Unknown MySQL error msg. So I can't run the script mentioned in the error msg since it won't get past the very 1st alter statement.

I'm not sure what went wrong but I can't even "reload mysql" - I just keep getting the "Uknown" msg.

With the exception of the "mysql" database, all of my other databases show a dash sign instead of the number of tables (in the PhpMyAdmin drop down. I can't even click on one of them without getting the "uknown" msg.

View Replies !

Unknown Column 'p.insurance_id' In 'on Clause'
The other day we updated our live server with the latest stable release for fbsd, release 5.0.18, and we began to get 'unknown column in on clause' errors, error code #1054. At first I thought it was a problem with the installation, but I duplicated the exact errors on my personal windows xp pro pc by upgrading to release 5.0.18 from 5.0.11. On another query we get the following error: Line 258: Unknown column 'p.insurance_id' in 'on clause'.

We tried creating a new field, called insurance_id_02, in the patient table and changing the code to look for that field instead of the p.insurance_id field in the on clauses, but mysql returned the same error. Any help would be greatly appreciated. I don't know if this is a bug in the new release or a strange quirk in our db.

View Replies !

Mysql: Unknown Option '--ndbcluster'
Running into some issues while configuring my cluster....

I'm setting up a cluster with two storage nodes and one management node...
The problem I'm having is that when I try to open MySQL on one of the storage nodes I get this error...

mysql: unknown option '--ndbcluster'

but i do not get this error on the other storage node and i am able to access MySQL on it.

The my.cnf file looks like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysql_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#Options for MySQLD process
[MYSQL]
ndbcluster #run ndb engine
ndb-connectstring=x.x.x.x #location of MGM node

#Options for ndbd process
[MYSQL_CLUSTER]
ndb-connectstring=x.x.x.x #location of MGM node

If anyone can let me know what the problem is it would be greatly appreciated...
I'm running Fedora Core 4 and MySQL 5.0.19 MAX

View Replies !

Strange 'unknown Column' Error
PHP

$sql = "SELECT COUNT(*) FROM klanten WHERE username = '$_POST[newid]'";
    $result = mysql_query($sql);
    if (!$result) {
        error('A database error occurred in processing your '.
              'submission.If this error persists, please '.
              'contact xxx.' . mysql_error());

and I swear there is a column called username. Still, I get an error saying that column username is not there.

Anyone has an idea what might be wrong ?

I just added the column. Does the server need time to refresh or sth ?

View Replies !

Unknown Column 'some_value' In 'where Clause'
As I navigate through my (still built..) web site, i've created a link that directs to : /show_title?action=show&id=".title_id."
that leads to a page where I run the query:
$id = $_GET['id'];
"SELECT title_name from titles WHERE title_id = $id"
and i get:
--> Unknown column 'CDA15FD' in 'where clause'
although when I move the cursor on the link I get:
/show_title?action=show&id=CDA15FD
and CDA15FD DOES exist in my db!

View Replies !