MySQL/PHP Mystery Problem
Posted: Tue Oct 14, 2008 6:06 am
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!
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!