Jump to content


Photo

Cannot delete Record!


  • Please log in to reply
6 replies to this topic

#1 Buglish

Buglish
  • New Members
  • Pip
  • Newbie
  • 7 posts
  • LocationSouth Africa

Posted 23 August 2006 - 12:55 PM

Hi,
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.
Regards Bug

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 23 August 2006 - 01:17 PM

Sounds like a permission issue.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 Buglish

Buglish
  • New Members
  • Pip
  • Newbie
  • 7 posts
  • LocationSouth Africa

Posted 23 August 2006 - 01:44 PM

Its the root user and it has ALL PRIVILEGES.

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 23 August 2006 - 03:39 PM

Then what error do you get when you try and delete?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 Buglish

Buglish
  • New Members
  • Pip
  • Newbie
  • 7 posts
  • LocationSouth Africa

Posted 24 August 2006 - 06:39 AM

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?

#6 Buglish

Buglish
  • New Members
  • Pip
  • Newbie
  • 7 posts
  • LocationSouth Africa

Posted 24 August 2006 - 07:53 AM

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 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
Error

SQL query: Documentation

SELECT *
FROM

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?

#7 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 28 August 2006 - 09:56 PM

I don't know what wrapper class is giving you these errors.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users