 |
|
 |
|
Next: WHERE (06/06/1978 < 06/06/1979) returns false ..
|
| Author |
Message |
External

Since: Jan 09, 2008 Posts: 5
|
(Msg. 1) Posted: Wed Jan 09, 2008 3:33 am
Post subject: Mysql query cache? Archived from groups: alt>php>sql (more info?)
|
|
|
Hello.
I have a strange problem with my website at work. There is a database
with some product data. Data is registered thru php - website, and
once a week a raport is generated from this data. If a mistake was
made, the data of current week can be corrected in the same way as it
is input. Also there is a part which draws graphs showing registered
data on time based graph.
The problem is, since 2 days something happened and the report
generated shows invalid data - from the current week, not the most
recently corrected. I don't keep corrected data. It's no longer in
database. But it appears in the report. In the graph showing part the
problem doesn't exists. The most recent data is shown there. And
still it uses the same data table.
The problem never happened before (the website exists for many
months).
I'm looking for some advice what could have happened? After rebooting
the computer-server the most recent data was loaded into the report,
and the problem continued if any new corrections were made after the
reboot.
It looks to me that it is some kind of a buffer which holds the
queries...?
I even have screen-printed the query and - following - the results. If
I executed the screen-printed version in SQL-yog - a SQL managing
program - the result was correct. But still in the application - the
data was not up-to-date.
The screen -printed query is:
"select
columns_wr.nazwa2,weekly_sales.value,weekly_sales.week,weekly_sales.week,columns_wr.event2,columns_wr.product_id
from report.columns_wr,report.weekly_sales
where columns_wr.product_id=weekly_sales.product_id
and columns_wr.product_id=65
and date>='2007-12-10' and date<='2008-01-13' order by date" >> Stay informed about: Mysql query cache? |
|
| Back to top |
|
 |  |
External

Since: Jan 09, 2008 Posts: 5
|
(Msg. 2) Posted: Wed Jan 09, 2008 3:56 am
Post subject: Re: Mysql query cache? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
 |  |
External

Since: Jan 14, 2008 Posts: 245
|
(Msg. 3) Posted: Wed Jan 09, 2008 4:54 am
Post subject: Re: Mysql query cache? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
On 9 Jan, 11:56, michalk... RemoveThis @o2.pl wrote:
> Maybe it helps:
> The MySQL version is 5.0.37 and the table has six columns (one of
> which contains texts about 20-30 chars long) and about 27000 rows.
I'm not sure where php comes into this.
Maybe you'd be better off asking in comp.databases.mysql >> Stay informed about: Mysql query cache? |
|
| Back to top |
|
 |  |
External

Since: Jan 09, 2008 Posts: 5
|
(Msg. 4) Posted: Wed Jan 09, 2008 7:58 am
Post subject: Re: Mysql query cache? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
On 9 Sty, 13:54, Captain Paralytic wrote:
> On 9 Jan, 11:56, michalk... RemoveThis @o2.pl wrote:
>
> > Maybe it helps:
> > The MySQL version is 5.0.37 and the table has six columns (one of
> > which contains texts about 20-30 chars long) and about 27000 rows.
>
> I'm not sure wherephpcomes into this.
>
> Maybe you'd be better off asking in comp.databases.mysql
This problem is definitely connected with php. If I edit/search data
through mysql-interface everything works perfect. It only happens if I
enter and read data through php web page. >> Stay informed about: Mysql query cache? |
|
| Back to top |
|
 |  |
External

Since: Jan 09, 2008 Posts: 5
|
(Msg. 5) Posted: Wed Jan 09, 2008 8:51 am
Post subject: Re: Mysql query cache? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
|
|
|
On 9 Sty, 16:58, michalk....RemoveThis@o2.pl wrote:
> On 9 Sty, 13:54, Captain Paralytic wrote:
>
> > On 9 Jan, 11:56, michalk....RemoveThis@o2.pl wrote:
>
> > > Maybe it helps:
> > > The MySQL version is 5.0.37 and the table has six columns (one of
> > > which contains texts about 20-30 chars long) and about 27000 rows.
>
> > I'm not sure wherephpcomes into this.
>
> > Maybe you'd be better off asking in comp.databases.mysql
>
> This problem is definitely connected with php. If I edit/search data
> through mysql-interface everything works perfect. It only happens if I
> enter and read data through php web page.
please check out my next post for more info on this problem >> Stay informed about: Mysql query cache? |
|
| Back to top |
|
 |  |
| Related Topics: | php + MySQL problems - I'm trying to get php + MySQL running on my web server. I tested the setup on an old RH8 server install that I was going to upgrade; everything worked fine. So I wiped out the old RedHat, installed Fedora Core 2, and repeated the installation. No dice...
Accounts in Mysql - Hello, Learning about Mysql Accounts, there is something I like to ask for. I have made some database tests as root mysql with [gastonv@telenetPC ~]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL....
php and mySql - I get an error message while trying to follow these procedures: http://www.howtoforge.com/intrusion-...on-ubuntu-7.10 Here is the error: Fatal error: Call to undefined function mysql_connect() in /var/www/adodb5/drivers/adodb-mysql.inc.php on line 363..
[MySQL] hierachy problem ... - Hello, I have a table which have these fields: - id - idParent - label I would like to display each field and his children but each parent may have no child. Example: A AA AB AC B C CA CB .... I can't write the request, could you help me?....
simple question I think...about PHP/mySQL - I want to make a website that starts with letters A thru Z . Click on the letter A you get a list of surnames beginning with A.... Click on surname A..... you get a table with all the information from a mySQL on the people with that surnames. My simpl... |
|
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|
|
 |
|
|