paengski13

Anyone knows how to solve this? This problem happen again, the request was received 1 seconds after the auction closed, and 2 users bid at the last 1 second (00:00:01) . So the delay is around 2-3 seconds before the system received the request. Does anyone know what to configure or to check for this kind of problem? This only happen once or twice a day, I am not sure what can trigger this event. Thanks in advance

Yes we do have a staff who manage our server, but normally I or him does not have enough knowledge on this issues. I think less than 5 - 10 minutes per minute? What I am thinking is to add a 1-2 seconds delay before the auction close, so just in case the this scenario happen. But I still want to know how to solve this if it is really possible to solve. Thank you!

Hi, I am not familiar with our server configuration, we are using Windows, and I think our server is high enough to handle all the process. But I am not sure what configuration needed. May I know what to look at so I can check the server setting I think there are less thank 30 users in every auction, since this was launch last May only.

Hi, I have this auction website, where sometimes (happen once or twice a day) the client request is delay for 2-3 seconds before the server received that request. take a look at this scenario: - auction time 00:00:01 - someone make a bid Normally the system detects that someone make a bid, so the auction time will extend up to 20 seconds. However, at a random time, the bid request was received 2 seconds after the auction closed. I have this condition when the auction closed no one can bid anymore, so I am sure that this bid was a valid bid. I have created a log from the start of the process so that I know what time the request from the server was received. user auction id time when server received the request (PHP) ABCDE 1887 2012-07-10 22:35:52 auction id auction closed 1887 2012-07-10 22:35:50 As you can see the auction closed at 22:35:50 but the request was received at 22:35:52. My question is, what are the reasons why sometimes the request is delayed? Thanks in advance!

Hi Kicken, I tried to run it using different browser but the problem is still the same, I tried to run the report query "Show processlist" command in mysql and found out that all other request are waiting for the report query to be finished. It means that the table are lock for any other request until the first request is completed. I change all affected tables to InnoDB and now it is working simultaneously, I'm still testing if this will be the fix to my problem.

Hi Everyone, I have this problem when trying to run a query which will generate a report. The database hang depending on how many seconds the query will be processed. Let say the query will take 5 seconds, during this time, when I try to access a page, it will just keeps on loading until the report I generated on the admin side is done. I am not sure what configuration I need to set. I changed engine type from MyIsam to InnoDb, although it is much faster now, but still my database still hang until the query has finished the execution. Any advise? Thanks in advance!

Hi everyone, I'm new to CakePHP and I have this problem. I need to update a div every X seconds to display the newly registered records from the database. I already try and successfully created this using procedural php approach, but since I'm currently using a cakePHP its kinda different. Thank you in advance!

Hi, Does anyone know where can I get a good article or ready made script library for facebook's "mention" feature? e.g. Wallpost: @Rafael Torres is asking for help. Thank you in advance!

Ops I think I already found the answer, all I need to do is add NULL to the other table so that the number of columns will matched. (SELECT column1, column2 FROM School_A_Tbl) UNION ALL (SELECT column1, NULL FROM School_B_Tbl) Thanks again!

Just 1 more question, is it possible to used UNION with different number of columns. I got this error stating "[Err] 1222 - The used SELECT statements have a different number of columns" Is there any other option for this?

Thanks a lot! I guess UNION is the best way to solve this problem.

Hi all! Is it possible to join the 2 mysql_query results before doing the mysql_fetch_assoc. Here is the scenario. Table: School_A_Tbl student_id student_name date_enrolled A00 Anna March 20 A01 Ben March 22 A02 Carla March 24 Table: School_B_Tbl student_id student_name date_enrolled B00 Dan March 21 B01 Erl March 23 B02 Fox March 25 Since there is no relationship with the 2 tables I want to combine them order by the date_enrolled $resultA = mysql_query("SELECT * FROM School_A_Tbl"); $resultB = mysql_query("SELECT * FROM School_B_Tbl"); What I want to do is combine this data according to date_enrolled. It should be something like this. student_id student_name date_enrolled A00 Anna March 20 B00 Dan March 21 A01 Ben March 22 B01 Erl March 23 A02 Carla March 24 B02 Fox March 25 It would be a better help if $resultA and $resultB will be merged before I iterate it using mysql_fetch_assoc. Thanks in advance.

Yes, that's correct I want to reload the 1st parent (the one who called the 2nd parent) using the second parent. But the problem is, since they are both in the difference instance(new tab), Is it possible to reload the 1st parent window using 2nd parent window?

First parent is the List page. Second parent/New tab is the record I had selected in the First parent (List page). When I update the second parent, the List page should reload. Note: Using a child window is not an option based on the specs.

Hi! Just want to ask is it possible to refresh or call a parent window by another parent window?