Buglish Posted August 23, 2006 Share Posted August 23, 2006 Hi,I am using PHP5 , MySQL5, Apache 2My 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.Regards Bug Quote Link to comment Share on other sites More sharing options...
fenway Posted August 23, 2006 Share Posted August 23, 2006 Sounds like a permission issue. Quote Link to comment Share on other sites More sharing options...
Buglish Posted August 23, 2006 Author Share Posted August 23, 2006 Its the root user and it has ALL PRIVILEGES. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 23, 2006 Share Posted August 23, 2006 Then what error do you get when you try and delete? Quote Link to comment Share on other sites More sharing options...
Buglish Posted August 24, 2006 Author Share Posted August 24, 2006 None.Its just dont want to do anything.PhpmyAdmin cannot do anything with the DB except add stuff.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? Quote Link to comment Share on other sites More sharing options...
Buglish Posted August 24, 2006 Author Share Posted August 24, 2006 Please help.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 messagemport.php: Missing parameter: import_type (FAQ 2.Coolimport.php: Missing parameter: format (FAQ 2.Cooland when I try to remove the database i get thisErrorSQL query: DocumentationSELECT *FROMMySQL 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? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 28, 2006 Share Posted August 28, 2006 I don't know what wrapper class is giving you these errors. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.