Cannot delete Record!
Posted 23 August 2006 - 12:55 PM
I am using PHP5 , MySQL5, Apache 2
My Database was created with phpmyAdmin.
Then I inserted with script and phpmyAdmin data into the Database.
Now I am Unable to empty or delete or remove any fields out of the Database.
Neither a script ot phpmyAdmin can delete.
What has blocked the database?
I have restarted my pc, Still I am unable to remove anything.
Please help me.
Posted 24 August 2006 - 06:39 AM
Ill have to resinstall mySQL and remake the DB.But how do I know this will not happen again?
I think it might have been becaus I didnt clode the connection everytime after use.
Can that have an affect after i restart?
Posted 24 August 2006 - 07:53 AM
Now noting works.I reinstalled MySQL 5 and recreated the Database.
But not when i try to insert a table using the SQL insert block i get this message
mport.php: Missing parameter: import_type (FAQ 2.Cool
import.php: Missing parameter: format (FAQ 2.Cool
and when I try to remove the database i get this
SQL query: Documentation
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
It previously worked. What version did I install incorectly?
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users