473,289 Members | 1,917 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

new Error 1146 error and behavior with mysqlcc + mysql-5.0.15

I have just switched from mysql-4.1.14 on a FreeBSD-4.11 box to
mysql-5.0.15 on a FreeBSD-6.0 box. In both environments I use mysqlcc
to select, insert and update tables. On the 4.1.14 machine, using
mysqlcc, I could double click in a field and change its value; only if
I had selected all the fields. I couls not do this if I had selected a
subset of the fields. The number of rows returned didn't matter, as
long as I did "select * from..." I could directly edit a field value in
mysqlcc.

Now, under mysql-5.0.15, I cannot edit fields at all, whether I "select
* from..." or not. And every select I do gives me this error in
mysqlcc's explain pane:

[mymachine] ERROR 1146: Table 'tablename.1' doesn't exist

Well it certainly does exist, and I can edit its values using the mysql
client or phpmyadmin (ugh, clumsy). There are lots of posts on the net
about error 1146 and various apps and various versions of mysql and
even mysqlcc. mysqlcc had this problem with an earlier version of mysql
than 5.x but this supposedly was fixed with release 0.94.

Can anyone give me some insight on what's going on here, or a
workaround? Or another gui client that works as well as mysqlcc?
thanks,

r

Nov 23 '05 #1
0 1623

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jackson Miller | last post by:
mysqlcc has a limit of 1000 on all queries I run. I can understand this for SELECT queries, but it makes no sense for INSERT... SELECT queries. Is there a way to override this limit? -Jackson...
0
by: Carl B. Constantine | last post by:
I'm trying to move a database from one machine to another. I dumped the database and successfully loaded it on one machine, but I can't do it on another machine. I have the database set up. I...
2
by: Bruce W...1 | last post by:
I've got MySQL running as a service on my Windows 2000 box. And I can work with it using a command window (DOS box). I used the default install of MySQL and here's what status says: mysql>...
4
by: willjay | last post by:
Trying to connect with mysqlcc and i get the following message dialog. (Application popup: mysqlcc.exe - Application Error : The instruction at "0x39ee1141" referenced memory at "0x656e6e6f". The...
0
by: Adnaan | last post by:
Hi, This is the first time i am working with MySQL and i need some help. I created a table "roles" in "test" db. Everytime i right click on the table and do "Open Table", i get the following...
4
by: Robert Rae | last post by:
OS XP Pro SP2 MYSQL Ver: 5.0.0-alpha nt Whenever I view a table or run a query in the Control Center (0.9.4-beta) I get the following error: ERROR 1146: Table 'shipnet.1' doesn't exist ...
0
by: Vittorio Zuccalà | last post by:
Hello, sorry for my english :-) I've a db named "controlloscatole" on my PC which has IP: 192.168.50.195 I've created a user which hasn't generic privileges but he has only SELECT privilege to...
0
by: a0je-2w31 | last post by:
What Linux directory ought the mysql-administrator and mysqlcc executables be installed? Granted, they'll run from anywhere but is there a common path used by most Linux distributions? Signed,...
1
by: FYYF | last post by:
Hi, This is the first time i am working with MySQL and i need some help. I created a table "admin" in "testing" db. Everytime i right click on the table and do "Open Table", i get the...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.