MYSQL :: WAMP Issue Please Help!

No Response From MySQL From PHP With WAMP On XP
I am new to PHP/MYSQL and am setting up/running Apache 2 as a development platform on my Win XP pc.

I have succeeded in running php scripts on Apache but when I attempt to connect to mySQL I don't receive any response whatsoever, not even a helpful error message.

I have attempted binding the address in my.ini to 127.0.0.1, and have moved the mysql_connect script various places within my "www" structure.

I understand that certain firewall applications on XP can be problematic. I feel that there is probably a simple fix that I'm overlooking; I'd like to find it before I start tampering with my protection software.

Here's what I'm running into. Running the following script produces only "point 3", which makes me believe that the script is bailing out around the _connect command:

Code:

WAMP Server Solution
I have been working as a LAMP Solution Developer where my technical specifications for the LAMP solutions are:

Database backend server is MY SQL running in HP-UX (Hewlett Packard UniX) where I database composed of 9GB.

My web server is running on WAMPâ€™s version of Apache HTTP Web Server and my application server is running on WAMPâ€™s PHP version and the platform running on the Web Server is Windows XP on the staging or testing environment.

References I use is the wampserver.org

The problem is when the client processes some reports from the Database by the PHP Web Page and generates reports through the Php, after 1 hour of validating it expires.

Is there a script or an accelerator where I can use to increase the speed of the Php Page without having a page expire or the mysql table itself must be reduced so it can be easily accessed by a Php?

Connecting To A Database Using WAMP
I'm currently using WAMP to work on existing website and database material. I downloaded the required website, but it didn't run without the database online, so I dumped a copy of the database to my hard drive and imported into phpMyAdmin, but the website still doesn't connect to the database with the address 'localhost'. What would I use? Where do I connect to the database I imported in phpMyAdmin. Here's the code for connecting as well as the error message.

// CODE
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"

$hostname_systemDB = "localhost";
$database_systemDB = "myDatabase";
$username_systemDB = "user";
$password_systemDB = "pass";

$systemDB = mysql_pconnect($hostname_systemDB, $username_systemDB, $password_systemDB) or trigger_error(mysql_error(),E_USER_ERROR);
?>

// ERROR MESSAGE
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'eid'@'localhost' (using password: YES)

MySQL Import On WAMP
I installed WAMP on XP to use a test server and can't figure out this silly windoze command line thing for MySQL. It seems my linux commands are Klingon to Windows.
I try this..

mysql> username -p database < c:wampwwwfile.sql

and I get a bunch of syntax errors. I tried dual slash and everything and it's not working. The file is 80MB so it has to be done at the command prompt.
Is there anyone out there? Is there anyone listening?
I've searched low and hi and there doesn't seem to be a page with how to do this. I've seen LOAD but that's just for a table.

WAMP Upgrade - Now MYSql Not Working
I have been running WAMP on my local server for sometime but I needed to upgrade so I downloaded the latest version, stopped WAMP and installed the new version. The Php is working ok but the MySQL service won't start and I even tried starting it in the Services. When I browse to MyPhpAdmin I get this error:

Error
MySQL said:

#2003 - The server is not responding

Carry Database From Wamp To Lamp
i created a database in WAMP ON WINDOWS ans now want to put it on my lamp server.but dont now how to do it.MySQL version is 5.0.x.

Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the
site performance is very slow on windows. I dont know the exact
reasons.

I have seen some benchmark details on internet. But still they are not
having concrete facts to support LAMP as a better alternative to WAMP.
Allmost all the search done on google melts down to IIS vs Apache, My
main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly
for PHP/MySQL.

SQL Issue
Had a question I can't seem to solve.

Here is the line I am having trouble with.
$query2 = mysql_query("UPDATE Users SET Totref += Ƈ' WHERE id = '$referral'") or die(mysql_error());

The exact part is the: SET Totref += Ƈ'

I think the problem is that I can not use += in that spot. How could I increase that value by 1 in a way that works?

Max(id) Issue
I have a table that is set up as follows

id auto increment, reference varchar(20), value varchar(20)
1,passed,3
2,failed,888
3,total,10
4,failed,99
5,passed,900
6,total,3

I am looking to get the last value inserted into the table for each reference value. the result should be:

2,failed,88
4,passed,99
3,total,10

Issue With JOIN And AVG
I'm having an issue with trying to get the average of a few rows in this query.

Here's my query:

SQL
SELECT g.name, g.thumbnail, g.plays, g.id, AVG(r.amount) AS game_ratingFROM `games` g LEFT JOIN `ratings` r ON r.game_id = g.id GROUP BY r.game_id ORDER BY RAND() LIMIT 0,1

There's the `games` table that I'm initially pulling from and then there's a separate `ratings` table that holds all the ratings for games. Ultimately I'm trying to pull the averages for the game.

The problem is that when I output game_rating it outputs 鰿.9999999' regardless of what the actual average is (should be between 0-10).

Order By Issue
I am running a query that has to search through 4 different tables by taking in a list of contact ids. This list of IDs is then used to search the orders table (matching either invoicee_id or recipient_id), if there is a match I want to take the order ID from that table, then search in the order_product table. From the order_product table if there are entries for the order_id we grabbed I want to get the subject_id of the order products. This I then use to search in the subject table to grab the name of the subject.

So essentially I want to grab a list of all the subjects that a certain user has ordered products for. But what I want to have is an ordered array at the end of it, where the subjects associated to a user ID are ordered by how many products of that subject type have been ordered. So if the user has ordered 5 Art products, 3 english and 10 Maths, I want the row in the result to be Maths, Art, English.

I have written the query which succesfully grabs the subjects ordered by a list of IDs and arranges them as so:

subjects contact_id
Art, English, Maths 9
French 11
but it will have art in the list 5 times, english 3 and maths 10.. Obviously if I use a distinct it will only display them once each, but I want them ordered by frequency if possible.

Here is my query at the moment:

SELECT
GROUP_CONCAT (s.subject_name) as subjects, c.contact_id as contact_id
FROM
orders as o
INNER JOIN
order_product as op
ON
(op.order_id = o.order_id)
INNER JOIN
product as p
ON
(p.product_id = op.product_id)
INNER JOIN
subject as s
ON
(s.subject_id = p.subject_id)
INNER JOIN
contact as c
ON
(c.contact_id = o.invoicee_id OR c.contact_id = o.recipient_id)
WHERE
find_in_set(o.invoicee_id, Ə,11')
OR
find_in_set(o.recipient_id, Ə,11')

GROUP BY
c.contact_id
note the 9,11 are just there for testing purposes, eventually I will be passing in an entire list of IDs.

AUTO_INCREMENT Issue
I am still a rather new MySQL user. The auto_increment property was learned from a tutorial and it has stuck with me ever since for generating distinctive IDs. However, I have only recently discovered that when I delete a row from the existing table, the new auto_increment will not go from the last ID left but rather keeps going from where the previous record was. For example, I delete row 5 with ID 5, the next one I create would be row 5 with ID 6 instead of ID 5 as intended. How should I go about solving this problem? Thx.

Issue With LIMIT
PHP

SELECT item.itemId, item.itemName, 2 * SUM(bans.bansForAgainst) -
COUNT(bans.bansForAgainst)
AS count, bans.bansForAgainst, bans.bansItemId
FROM item, bans
WHERE item.itemId = bans.bansItemId
GROUP BY bans.bansItemId
ORDER BY item.itemId DESC
LIMIT 0,5

But it's not limiting the output...at all.

Autonumber Issue
Once the database is incremented to 127 entries the database no longer increments. As a result I get a 127 error.

Replication Issue?
My slave has been working fine up until now. Here is the error message.

030730 11:32:28 Slave: connected to master 'repl@xxxx.xxx.org:3306',
replication started in log 'SQLServer1-bin.034' at position 77571524
ERROR: 1062 Duplicate entry '120816' for key 1
030730 11:32:28 Slave: error running query 'INSERT INTO Assignments (
..........

Key 1 is CaseID

Database changed
mysql> select CaseID from Assignments Order by CaseID DESC Limit 3;
+--------+
| CaseID |
+--------+
| 120815 |
| 120814 |
| 120813 |
+--------+
3 rows in set (0.02 sec)

mysql> DELETE FROM Assignments WHERE CaseID = 120816;
Query OK, 0 rows affected (0.04 sec)

If I try to restart the slave I get the error all over again.

Issue With GROUP_CONCAT
A table looks like:

time millisec
10:02:04 234
10:02:04 567
10:04:12 003

Both time and millisec are in order by simply select. In fact, I want to use the counter to do row operations, like different between two adjacent rows. Maybe one has better idea than adding a counter.

Date Issue
I can't understand why this query from inside phpMyAdmin doesn't return anything since it executes without errors. My setup : WinXP, IIS, MySQL 3.23.54-nt, phpMyAdmin 2.5.2-pl1.

SELECT *
FROM `reservations`
WHERE (res_start between 2004-01-01 AND 2004-09-01);

The reservations field is in date format and contains a lot of valid records.

Replication Issue
I'm having quite a fuss with my two MySQL DB servers lately. I'm trying to establish replication between a MySQL 4.0.20 server (master) and a MySQL 4.1.11 server (slave).

From what I read, replication from a 4.0.x server -> 4.1.x server will work, just not the other way around.

However, that's not really my problem. After unsuccessfully completing the configuration myself, I used ....

Speed Issue
We had version 4.1 installed on a server and a multiuser application accessing it. Over a period of a year or so, accessing queries etc. has become slower and slower, although the number of records have increased dramatically over that time.

Recently we installed 4.1 again on a new server and moved the database over and instantly there was a dramatic increase in speed. However, over the last 3 or 4 weeks it has started slowing down again.

For the moment, let us assume that it is not the application that is causing the problem. Is there anything about the way MySQL is set up that might cause it to slow up in this way? We are using both InnoDB and ISAM tables.

Replication Issue
I had mysql replication working fine for awhile until the binary logs used up all the disk space (my bad for not putting anything in place) and all our websites stop working. As a quick fix I deleted one of the first binary logs that where created but left the current binary file that was being loaded from.

Doing that of course stuffed everything up and I haven't been able to get it working since.

I've tried many times stopping/starting the slave, granting new user privilages on the master, changing the master on the slave.

I can access the database if I through the mysql prompt fine, so it shouldn't be a firewall or anything - plus it was working before.

Mysqldump Issue
i have fedora core 4 installed. i have a script that extracts data from one table to the next. now this script works fine in windows but in linux it writes the file but theirs no data in it??? Code:

UNION Issue
I'm trying to display info from 2 different tables in a table on my site. I have the structure set to 7 columns and a count of 30 rows. I can get it to work fine if I just use one select statement with desc limit from 1 table.

But what I want is for it to display info from 1 table first that has 20 rows then grab the remaining 10 rows from the other table. I've tried using UNION for this but I keep getting the column error for different column sizes. I'm running mysql 5 with php 5.2.5.

Is there a better way of doing this? From what I understood about mysql 5 you could run 2 select statements. But that doesn't seem to work.

These are the 2 individual queries that work on their own:

$sql = "SELECT * FROM tbl_user tb
INNER JOIN tbl_user_2 tbl
ON tb.user_id=tbl.user_id
WHERE tbl.status > 0 AND
tb.user_check='Y'
ORDER BY
tbl.status DESC";

$sql = "SELECT * FROM tbl_user WHERE user_check='Y' ORDER BY logged_today DESC";

C++ A Structure Issue
Have a question about codeprinciple.

What is the way you would suggest when i connect to a database and perform a query - one model would be like this:

DoQuery()
{
MYSQL *conn;
conn = mysql_init(NULL);
mysql_real_connect(conn,"*****","*****","*****","*****",0,NULL,0);
mysql_query(conn,"SELECT * FROM *****");
result = mysql_store_result(dBase);
mysql_free_result(result);
mysql_close(conn);
}

So it inits, connects, query, free's and close - that would be for every time i want to do a query.

Another approach would be to connect to the database from application start, and only close the connection at application end ?

Categorizing Issue
I’m dealing with a little problem on the architecture of my MySQL database due to its complexity and I would appreciate any tips on the following:

I’m building a database for my image bank and want to categorize the images so that they may be viewed according with a specific multiple classification. What I have now is an image that belongs to a Category A and has a sub-category A1, for example: “People” / “Health”.

But I would like to have the image to be seen on a category “Concepts” with a sub-category “Stress” or even category “Health” and sub-category “Mental Health” or all of them, according to the user’s choice. If the user clicks on the category “Concepts” he will be able to see my image IMG_5454.jpg and also he could see that same image on the “Health” category.

I now have an “image”, “category” and “subcategory” tables. What could be the best structure for use with PHP to select images that meet the multiple classification?

Connection Issue
I installed MySQL along with PHP and Apache. I also installed the MySQL admin software. I can log into that using localhost.. however, when I try to install scripts, I cannot get a connection with MySQL.

I have SQL installed in the C: and the Apache installed in C:program files is this what is wrong?

The errors I am getting are:

Can't Connect to My SQL server on localhost

A Link to the server cannot be established

my_sql_db() supplied arguement is not valid mysql-link

Sorry an error has occured please check your database info is correct and make sure your database already exsists.

Design Issue
I've tried a couple of times to design a database for some web programs I'm working on. I keep running into this issue: What if I have a table, and I want one of the data types to be a list. It seems like a table within a table is what I want. The other way I thought would be to create a seperate global table and have a variable that links to the ID of the able I want to contain the list (if that makes any sense). Here's an example:

Character
ID
Experience
Level
Strength

ItemInventory
ID
CharacterID
ItemID

But for some reason that seems really messy to me. Is that the way it's supposed to be done?

Locking Issue
I am running MySQL 4.0.20 on redhat 9.

But i frequently face a problem of that the table is being lock. i see from the process list that i am the only one trying to update the record and the rest of the connection do nothing. Below is the log file i get when i try to show the innodb status when the table is lock. Code:

Num_rows Issue
$queryfavoriteIdeas = "SELECT favoriteIdeas FROM users WHERE username='$username'";
$favoriteIdeasResult = mysql_query($queryfavoriteIdeas, $dbc);
$favoriteIdeasarray = mysql_fetch_row($favoriteIdeasResult);
$favoriteIdeas = $favoriteIdeasarray[0];
$rows = mysql_num_rows($favoriteIdeaResult);

echo "debug: $queryfavoriteIdeas = $queryfavoriteIdeas <br />";
echo "debug: $favoriteIdeas = $favoriteIdeas<br />";
echo "debug: $rows = $rows<br />";

The query is echoed correctly, the $favoriteIdeas row value is echoed correctly, but for some reason $rows comes back as "".

The strange thing is that $favoriteIdeas shows me the 1 row result that I am expecting. However, $rows does not indicate that 1 row was fetched.

Why would $rows remain null is the result contains 1 row of data?

Without the correct row count, the rest of my code doesn't really work.

Row Locking Issue
I am running a MySQL server for a department-critical function at my company. The basic setup is a MyISAM-based MySQL 5.1 installation, with one specific table to hold the work that is to be distributed among the employees. Other tables are for user settings (based out of the client, written in C++ with a wxWindows base, using libmysql as the medium for query submission and retrieval).

Overall, the most troublesome problem yet encountered is that each query -- one to locate a workable row, the next to pull the information from that row, and the last to mark that row as touched and no longer available to others (three in total, all occurring within one connected session) -- has a very undesireable tendency to collide during the initial "locate query." When this occurs, one employee ends up with their ID in the "worked by" field, but both clients have the same information given to them.

I've read up on InnoDB, and explored some of the locking mechanisms, but even when the DB type is migrated to InnoDB, the server runs inexcusably slow (sometimes taking up to nine seconds to return a query). It's row locking features seemed to accomplish very little in the way of preventing a read from occurring on the row, though UPDATE and DELETE statements where blocked.

In the end, I am simply wondering if there is a way to force the DB to block read access to a row that has already been read by another client, and move on to the next record in the DB, while being invisible to the user (and preferrably the client application). The only solution I can derive from all of this is to actually mark the first returned work record as completed, and then (somehow) locate it after it's been marked, preventing further reads from the row based solely on the client's rules of retrieval.

Reordering Issue
what query to use to transform this

CODE+----------+-----------------+----------------------------------+---------------
| table_ID | service_type_ID | service_type_name                | service_order
+----------+-----------------+----------------------------------+---------------
|        1 |            NULL | service 1                        | 1
|        2 |            NULL | service 2                        | 2
|        4 |               1 | NULL                             | 1
|        5 |               1 | NULL                             | 2
|        6 |               1 | NULL                             | 3
|        7 |               2 | NULL                             | 1
|        8 |               2 | NULL                             | 2
+----------+-----------------+----------------------------------+---------------

Issue 5.0.18 And Trigger
any issue with the version 5.0.18 of mySQL and using
triggers?Is there any troubleshooting for that kind of issue?

Mysql_fetch_fields Issue
----------------
column1|column2|
---------------
1 | 2 |
----------------

Both columns are type int(11). And here's what I do:

sprintf(initial_query, "%s %s LIMIT 1", select * from", tablename);

if ((return = mysql_query(&dbmaster, initial_query)) != 0) {
exit(1);
}
if ((master = mysql_store_result(&dbmaster)) == 0) {
exit(1);
}
if ((master_fields = mysql_fetch_fields(master)) == NULL) {
exit(1);
}
master_column = mysql_num_fields(master);
//master_column = mysql_field_count(&dbmaster);
mysql_free_result(master);

for (i=0; i<master_column; i++) {
printf ("field %d type is %d", i, master_fields[i].type);
printf ("field %d name is %s", i, master_fields[i].name);
}

This is just a snippet. Every variable is declared correctly. Here,
as expected, I get 2 as the return value for mysql_num_fields or
mysql_field_count. However, in the for loop, I get weird values for
field type and get NULL for second column name:

Field 0 type is 134557680 Field 0 name is column1
Field 1 type is 3239533 Field 1 name is (null)

WHAT IS GOING ON? I am at a loss. Could this be a bug in MySQL?

Timestamp Issue
I am programming in PHP, and I have a timestamp which is being added to the database like " 2004-11-11 16:30:20" and I need to add 3 hours to it, and format it to something more ledgable like November 11, 2004 - 4:30:20.

Connectivity Issue
I have installed ver 5.0 on a windows 2000 server.
I am accessing that machine via Terminal Services and using the host's administrator account for login. I have successfully walked through the drill of setting up an instance, setting up a connection, logging in as root, using the query browser tool to create and drop a database, and to add tables to that database.

My difficulty is that I have accomplished all of this using the localhost account.
When I attempt to connect using an IP address, I get the following message: Host '<my host>' is not allowed to connect to this MySQL server. I am able to ping the server just fine, and it is a static, public IP.

When I search the docs, I find that the error message translates to SQLState = HY000 (ER_HOST_NOT_PRIVLEGED) - but I can't find much on how to resolve this.

License Issue
planning on installing apache,php and MySQL into a company's server in order to provide a small database for the company. PLEASE,please someone help me to understand: DO I have to BUY a MySQL license (commercial) to do this?

Is MySQL free for usage? And If yes, then for who and which kinds of usage?

I read in GPL and it sais I think that except for being free to view and edit this open source product, you can distribute it for free, sell it or whatever u like.
Probably I could have misundestand. If someone is really aware of this legal part, pls answer.

thanks.

ps: 1. This will be used INTERNALLY of the company.
2. The source code will BE open and available to whoever wants it.
3. I will get payed for providing my services.
4. I have read GPL and Arjen Lentz's article "MySQL Network and you".

I have also read a LOT of the postings regarding this issue. But it's really difficult to get a clear straightforward answer.

Security Issue
I have just installed MySQL on my PC as part of Wamp5, with the idea learning about how to operate a database and intergrate it with my websites. When I open the phpMyAdmin first page there is a warning.

"Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole."
What is this referring to? and how do I "fix the hole"
Thanks. Life...It's difficult not to take it personally.

Trigger Issue
I have a trigger that I have used before that allows me to merge several tables and eliminate duplicate entries caused by duplicate instances in each of the tables that I am merging.

The table is like:

CREATE TABLE mergeTable ( ckey INT NOT NULL UNIQUE AUTO_INCREMENT,
quantity INT NOT NULL DEFAULT 0 );

The trigger is something like:

DELIMITER $$
CREATE TRIGGER mergeFoo BEFORE INSERT ON mergeTable
FOR EACH ROW
BEGIN
DECLARE element INT;

SELECT mergeTable.ckey INTO element FROM mergeTable WHERE mergeTable.ckey = new.ckey;
IF element IS NULL THEN
SET new.quantity = 1;
ELSE
UPDATE mergeTable SET mergeTable.quantity = mergeTable.quantity + 1 WHERE mergeTable.ckey = new.ckey;
-- Somehow cause the insert to fail without telling the world!
END IF;
END$$

DELIMITER ;

This trigger allows me to merge into a single table from multile similar tables with the benifit of turning inserts that would have produced a duplicate row into updates. I get the error message:

Can't update table 'mergeTable' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

Is this condition ever going to be lifted/enhanced? Other similar products treat triggers as functions that return values. If the return is null then don't complete the insert.

Security Issue
still new to mysql and this is my first post. i am using mysql on windows xp home machine, and i've noticed that i can open the mysql user table in notepad and although there is a lot of garbage text in it, the username and encrypted password are clearly within the garbage text. have i done something wrong in my admin/install, or is this the way it is supposed to work?

SELECT Issue
I am making a login function where a user enters a username and password. This is looked up and then a result is displayed if they have the password correct. I have the following code:

query = "SELECT password FROM users WHERE username = $username";
$result = mysql_query($query);

if ($result == $password) {
echo "your signed in";
}
else
{
echo "oops! wrong password";
}

But it always outputs that the password was wrong when I know it was right.

Mysqldump Issue
I have a piece of a script that writes my table data to a csv file. now the below code works fine on windows. im using linux fedora core 4. Now it writes the file but theirs nothing in it?

#!/bin/bash
/usr/bin/mysqldump -h localhost -u root --tab--fields-terminated-by=';' --lines-terminated-by="
" --no-create-info ehpadmin Referral_Authorization > Referral.txt

Auto_increment Issue
I'm trying to fix this issue :

i insert 6 lines into a database.
Then, i delete 5 lines and i insert 6 lines again : the auto_increment id will start from 7, instead of 1 ...I'd like to use the unused ids (deleted ones) instead of creating new ones.

InnoDB Issue
Can someone tell me why do I get the following error

java.sql.SQLException: Error on rename of './epis/#sql-7cc_3d' to './epis/bgroups' (errno: 121)

after running in .jsp page command ALTER TABLE `epis`.`bgroups` ENGINE = InnoDB;
...when I use mysql-administrator and set the table to innodb, I get this error:
Error executing SQL commands to update table.
MySQL Error Nr. 1025
Error on rename of './epis/#sql-7cc_20' to './epis/bgroups' (errno: 121)

IN Nesting Issue
Any idea why i get an error when I run the below code. The union works fine and results in a single value but once I add the first 2 lines, the code fails. I am using MySQL 4.1. Is there a functionality limitation in the IN operator..?

select name from persons
where name in (
(select person from plays
group by person
having count(sports) >=10)
union
(select likee from likes
group by likee
having count(liker) >=10)
)

Script Issue
I have a linux script that wirtes a csv file for my mysql database table. Now its writing the csv file even if the tbale is empty? is their a way to check to see if theirs data first, if so write the file if not kill this part of the script?

Script

[script]
select * into outfile '/tmp/file2'
FIELDS TERMINATED BY ';' LINES TERMINATED BY 'N' FROM DIRECT_REFERRAL
[/script]