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 Link to comment https://forums.phpfreaks.com/topic/18412-cannot-delete-record/ Share on other sites More sharing options...
fenway Posted August 23, 2006 Share Posted August 23, 2006 Sounds like a permission issue. Link to comment https://forums.phpfreaks.com/topic/18412-cannot-delete-record/#findComment-79169 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. Link to comment https://forums.phpfreaks.com/topic/18412-cannot-delete-record/#findComment-79178 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? Link to comment https://forums.phpfreaks.com/topic/18412-cannot-delete-record/#findComment-79270 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? Link to comment https://forums.phpfreaks.com/topic/18412-cannot-delete-record/#findComment-79727 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? Link to comment https://forums.phpfreaks.com/topic/18412-cannot-delete-record/#findComment-79749 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. Link to comment https://forums.phpfreaks.com/topic/18412-cannot-delete-record/#findComment-81850 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.