View previous topic :: View next topic |
Author |
Message |
chukroast -
Joined: 14 Apr 2009 Posts: 2
|
Posted: Tue Apr 14, 2009 10:45 pm Post subject: Mysql app worked on Xampp but not 100% on Abyss |
|
|
Developed application in Xampp environment, then transported to Abyss environment.
Application executes Mysql "Select" just fine, but won't perform "Update" or "Insert".
I checked and set all permissions stopped and restarted Mysql and stopped and restarted Abyss.
Everything (application) seems to be an exact duplicate between Xampp and Abyss but "Select" is only function working when accessing the DB under Abyss.
Any Ideas ?? _________________ Thanks from Ar. |
|
Back to top |
|
|
chukroast -
Joined: 14 Apr 2009 Posts: 2
|
Posted: Wed Apr 15, 2009 1:11 pm Post subject: Problem found |
|
|
Thinking the whole time it was a permissions problem, I learned more and adjusted the permission for the applications, but didn't fix the problem.
I finally added some code to my ap to give me some feedback when executing the ap and discovered the "Update" was failing because of trying to write a null to the DB where a integer should be written. This was happening when the entry was unchanged so a null was being written instead of an integer value. Fixed this code and ap works perfectly now.
The puzzle for me is why that was not a problem in the Xampp environment and was a problem in the Abyss environment????
Oh well, since it's working I guess I don't need an answer to this. _________________ Thanks from Ar. |
|
Back to top |
|
|
pkSML -
Joined: 29 May 2006 Posts: 952 Location: Michigan, USA
|
Posted: Wed Apr 15, 2009 1:57 pm Post subject: |
|
|
That has something to do with MySQL. The stict-mode setting was probably turned on, and that's why you saw the error. I just ran into this issue last week. _________________ Stephen
Need a LitlURL?
http://CodeBin.yi.org |
|
Back to top |
|
|
|