Package: mysql-server-4.1 Version: 4.1.11a-4sarge2 Severity: important Example:
mysql> CREATE TABLE table1 (s1 INT, s2 CHAR(30)); Query OK, 0 rows affected (0.01 sec) mysql> INSERT INTO table1 VALUES (1,'Row #1'); Query OK, 1 row affected (0.00 sec) mysql> CREATE VIEW v1 AS SELECT * FROM table1; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the rightsyntax to use near 'VIEW v1 AS SELECT * FROM table1' at line 1 Or just: mysql> create view v1 as select 1; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the rightsyntax to use near 'view v1 as select 1' at line 1 I should note that I purged and re-install the MySQL 4.1 packages today. I had forgotten the root password :-P After this I initially saw some strange errors in mysql-admin, now that is working just fine. But views won't work. Regards, -- Geir Helland -- System Information: Debian Release: 3.1 Architecture: i386 (i686) Kernel: Linux 2.6.12.3 Locale: LANG=no_NO, LC_CTYPE=no_NO (charmap=ISO-8859-1) Versions of packages mysql-server-4.1 depends on: ii adduser 3.63 Add and remove users and groups ii debconf 1.4.30.13 Debian configuration management sy ii libc6 2.3.2.ds1-22 GNU C Library: Shared libraries an ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu ii libgcc1 1:3.4.3-13 GCC support library ii libmysqlclient14 4.1.11a-4sarge2 mysql database client library ii libncurses5 5.4-4 Shared libraries for terminal hand ii libreadline4 4.3-11 GNU readline and history libraries ii libstdc++5 1:3.3.5-13 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra ii mailx 1:8.1.2-0.20040524cvs-4 A simple mail user agent ii mysql-client-4.1 4.1.11a-4sarge2 mysql database client binaries ii mysql-common-4.1 4.1.11a-4sarge2 mysql database common files (e.g. ii passwd 1:4.0.3-31sarge5 change and administer password and ii perl 5.8.4-8 Larry Wall's Practical Extraction ii psmisc 21.5-1 Utilities that use the proc filesy ii zlib1g 1:1.2.2-4.sarge.2 compression library - runtime -- debconf information: mysql-server-4.1/start_on_boot: true mysql-server-4.1/postrm_remove_databases: false * mysql-server-4.1/mysql_install_db_notes: mysql-server-4.1/mysql_update_hints1: mysql-server-4.1/nis_warning: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]