Re: [SLE] MySQL Table Locked?
Hi Andy,
Have you tried removing the "?" from the email field
definition which per the info below reads "email?". I
know you marking whether they have one or not but
special characters are a bad practice in table names,
because other programs and tools may not escape them
correctly and you run int funny problems ;)
good luck.
George
--- Andy Choens
Sounds like a corrupt table. Run this command from
On Monday 28 March 2005 3:53 am, Brad Dameron wrote: the commandline as root:
mysqlcheck -r -A
Didn't help. Mysql seems to think it is fine. In fact, after thinking about it some more, I decided to try backing up the table and restoring it. In this schema I have 4 tables. The other 3 are working just fine. So, I made a sql back-up of the one table that's not working correctly. Then, I dropped the table. After that I resored my back-up. That went very smoothly, but the table isn't acting right. For instance, if I use konqui to edit the table, when I try to go and edit the contents of a row, I get this error:
SQL KIOSlave: An error has occured Could not execute query. Could not access adults
You might suggest my permissions aren't correct, but I can access the other tables just fine, so my permissions are fine and so is my connection between QT and mysql. I've also tried logging into mysql as root, and I get the same results.
Using mysqladministrator, I renamed the table adults to contacts, but that didn't help either, so I changed it's name back. It let me change it's name.
To see if it means anything to anybody, I've inserted the SQL that I got from the back-up. I had to not include the data itself, sorry. I can't post that on the internet!
--andy
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT; SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS; SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION; SET NAMES utf8;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `tlp`; USE `tlp`; CREATE TABLE `adults` ( `parent_number` int(11) NOT NULL auto_increment, `camper_number` int(3) NOT NULL default '0', `camper_number_2` int(3) default '0', `primary_contact` char(3) NOT NULL default '1', `mail` char(3) NOT NULL default '0', `role` varchar(11) default '', `first_name` varchar(50) default NULL, `middle_name` varchar(20) default NULL, `last_name` varchar(20) NOT NULL default '', `cellphone` varchar(20) default '', `homephone` varchar(20) NOT NULL default '', `workphone` varchar(20) default '', `address_1` varchar(50) NOT NULL default '', `address_2` varchar(20) default '', `city` varchar(20) NOT NULL default '', `state` char(2) NOT NULL default '', `zip` varchar(11) NOT NULL default '', `email` varchar(100) default '', `notes` longtext, `email?` int(11) NOT NULL default '0', PRIMARY KEY (`parent_number`) ) TYPE=MyISAM; INSERT INTO `adults` VALUES ........I had to cut this out.
I hope this helps someone help me. If it doesn't I'm going to go join a mysql list next.
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca
On Saturday 02 April 2005 10:15 am, George Stoianov wrote:
Hi Andy,
Have you tried removing the "?" from the email field definition which per the info below reads "email?". I know you marking whether they have one or not but special characters are a bad practice in table names, because other programs and tools may not escape them correctly and you run int funny problems ;)
Hey, thanks! I completely forgot about that edit to add that column. That was the problem, and now all is well with me table. Thanks! Nobody on the mysql list saw that....... --andy
The Monday 2005-04-04 at 18:31 -0400, Andy Choens wrote:
Have you tried removing the "?" from the email field definition which per the info below reads "email?". I know you marking whether they have one or not but special characters are a bad practice in table names, because other programs and tools may not escape them correctly and you run int funny problems ;)
Hey, thanks! I completely forgot about that edit to add that column. That was the problem, and now all is well with me table. Thanks!
I told you to revise field names, I had a somewhat similar problem when I named one "index". -- Cheers, Carlos Robinson
participants (3)
-
Andy Choens
-
Carlos E. R.
-
George Stoianov