Page 1 of 1

MySQL/PHP Mystery Problem

Posted: Tue Oct 14, 2008 6:06 am
by Sephirangel
Hello everyone,

I have a strange problem with my system.
I have recently developed a PHP-based stock system for a friend. After rigorous testing on my own machine, everthing was ready and after installing it on his machine, it ran very well for a few days, records being entered very smoothly (stock records and sales records). However, after a few days, some records were not being entered into the database, even though the functions i had created for doing so were being called. Some records would enter on the second time of trying, some wouldnt work at all for a day or 2 then suddenly they will be saved. Each record is of the same format so why some are entering and others arnt is confusing.
Note that all the records that didnt work on his system worked first time on mine. We have same OS (XP), run the script from the same program (WAMP server) and have exactly the same database structure. We also use the same browser to use the system in (FireFox 3.0)

This is a strange and annoying problem which I would be eternally greatful to anyone who helps solve it. Any ideas?
Let me know if there is any code you would like to see or any database schema needed.

Many thanks in advance!

Re: MySQL/PHP Mystery Problem

Posted: Tue Oct 14, 2008 6:07 am
by Eran
Did you check the error logs for apache and mysql?

Re: MySQL/PHP Mystery Problem

Posted: Tue Oct 14, 2008 7:19 am
by Sephirangel
No, good point. Where would i find them?

Re: MySQL/PHP Mystery Problem

Posted: Tue Oct 14, 2008 9:44 am
by Eran
The location of the log is usually declared in the configuration files, otherwise defaults are used. For Apache there is a subdirectory /logs under the main installation directory, and for MySQL it is usually where the data files are stored.

Re: MySQL/PHP Mystery Problem

Posted: Wed Oct 15, 2008 2:45 pm
by Sephirangel
Sorry for the long wait for me to reply!
I have looked in the log files and there are no errors in either the PHP, MYSQL or Apache error logs so at the moment im really stumped.
Anyone got any ideas?