Hi,

Could anyone help me to solve this prob? When im trying to create a new record (using a web-based system), it says Directory Exist. FYI, I had no problem when tried to update existant record.

Tested on XAMP, it's working fine but only getting the error when im using single installation on Apache, mysql enterprise and PHP5 (running on Windows based).

Kindly advise

regards,
suerie

It's ok guys.. i've found the solution.
I've tried to create a new record for other system and this error occured.. "Data too long for column...".
So i've searched through the internet and found the solution for this error. Seems like it solved my above prob.

Below is the solution that i've referred to:

Go to my.ini and remove the highlighted part
sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

and restart the MYSQL server.


regards,
suerie