Hello.
MySQL CC is not supported now, and could have some problems with a fresh
versions of MySQL. If error doesn't appear in latest MySQL Administrator
then everything is ok.
[local] ERROR 1146: Table 'llcopy.1' doesn't exist
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/cannot-find-table.html
The error was
ERROR 1054 (42S22): Unknown column 'C1' in 'field list'
Check if the sql_mode has ANSI_QUOTES enabled. See:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
Kerry Frater wrote:
Can someone point me in the right direction.
I had 4.1 running and all was well with my little program. I decided to test
the code with the newer 5.0.18. I updated my DB and then tried to access it
using the MYSQl Control Centre - 0.9.4-Beta and query browser 1.0.4 alpha.
The Administrator allows me to view table structure but not to add any
numerical columns.
Using the Control centre, If I double click on the table I wish to view data
I get two lines in the message area
Empty set (0.00) sec
[local] ERROR 1146: Table 'llcopy.1' doesn't exist
llcopy being my test database name.
These messages are got no matter what the table content is. I do note that
the error message on this app is different numerically to the previous
Also my insert program now fails to insert data. So I extracted one of the
SQL insert commands that worked with 4.1 and manually run it using the
mysql.exe command interface. This is the manual command.
INSERT INTO BanksC
(Bank,BankName,AccountNo,Balance,PMClosingBalance,EOMTempBalance,STTS)
VALUES (C1,Client
Bank,NONE,0.00,0.00,0.00,C);
The error was
ERROR 1054 (42S22): Unknown column 'C1' in 'field list'
The settings of the table are char(2), char(20), char(12),
decimal(12,2),decimal(12,2),decimal(12,2),char(1) respectively.
This is driving me crazy. I am obviously doing something stupid but I have
got so close to the problem I can't see the wood for the trees.
Kerry
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
