MySQL/PHP Mystery Problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Sephirangel
Forum Commoner
Posts: 45
Joined: Tue Jul 15, 2008 1:37 pm

MySQL/PHP Mystery Problem

Post 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!
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: MySQL/PHP Mystery Problem

Post by Eran »

Did you check the error logs for apache and mysql?
Sephirangel
Forum Commoner
Posts: 45
Joined: Tue Jul 15, 2008 1:37 pm

Re: MySQL/PHP Mystery Problem

Post by Sephirangel »

No, good point. Where would i find them?
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: MySQL/PHP Mystery Problem

Post 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.
Sephirangel
Forum Commoner
Posts: 45
Joined: Tue Jul 15, 2008 1:37 pm

Re: MySQL/PHP Mystery Problem

Post 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?
Post Reply