Fedora :: ERROR 1064 (42000): You Have An Error In Your SQL Syntax; Check The Manual That Corresponds To Your MySQL
Jul 20, 2010
i ,musing mysql5 at fedora12 i have just installed it but i ,m using mysqladmin -p root password mypassword it says ERROR 1064 (42000): 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 'mysqladmin -uroot password 123456' at line 1
While trying to provide schema to a database in mysql, I am getting this error: ERROR 1064 (42000) at line 15: 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 'FUNCTION 'upd_radgroups()' RETURNS trigger AS'.I am not getting that where the problem is. ANd below is the script which i want to use to provide schema to my database in my Centos system:-
Quote: select * from s_transaction Where between UNIX_TIMESTAMP('2010-06-28 15:40:00') and UNIX_TIMESTAMP('2010-06-28 16:00:00') and user_id = '15545941';
Is this the syntax correct to retrieve a particular user transaction between given time period? because "its return error check the syntax near the between"
I have an ubuntu 10.10 server and want to run a script on it to check if a process is running. If it is not running, it will start the process and also write into a log file.
When running the script i get the following error message:
I am facing some strange problem of mysql replication with ssl, my replications which working fine from more than 6 months currently stopped working after i upgrade mysql in to newver version mysql-5.1.41-2, i create new ssl self singed certs but still no sucess, when client try to connect the master using ssl its gives error SSL connection error ERROR 2026 (HY000), with out ssl its working f9.
I can seeking the problem on net, and i found the below bugzilla url related to that.
[url]
I read it but not get , either new version support x509 ssl certs or not or either new version support ssl replication or not, here below my server configuration for ssl serts
And for client
Both server and clients certs are signed with same ca but still its currently not working after the mysql upgrade first 5.1.41 and then 5.1.41-2
Either as above bugzilla url, currently mysql support ssl replication or not, or either some need to do special for working with ssl. or i wait for newver version of mysql to fix if its bug or not.
I am trying a release of Ubuntu has have run into a problem that does not make much sense. I am receiving the following error: Syntax error on line 20 of /etc/apache2/sites-enabled/portal: Invalid command 'ProxyHTMLEnable', perhaps misspelled or defined by a module not included in the server configuration fail! I believe the modules required for this is apt-get install libapache2-mod-proxy-html and it shows under the available modules and it was enabled with a2enmod proxy-html.
The line from the config is ProxyHTMLEnable On. The release is the latest download with updates from, 32bit.
The following problem occurs to me, I'm creating a distribution (as a class project) for my school (I'm studying telecommunications and computer systems). I am following, in order to create the distribution, the manual that you can find on this page: [URL] But when I get to write:
Parse error: syntax error, unexpected '@' in C:xampphtdocsminippromail.php on line 8 .......its not recognizing the '@' symbol. heres the code im working with
<?php $receiver = myfriend@ourmail.co.in; $subject = wish; $content = Hi! My dear friend how are you.; $sender = myself@ ourmail.co.in ; $headers = From: $sender; mail($receiver,$subject, $content,$headers); echo Mail has been sent successfully.; ?>
My brother has Tri boot Ubuntu ,7 and Vista ..GRUB2 is the bootloader..The problem : At boot after the Lenovo splash disappears , there appears some 4 to 5 lines of error , error:syntax error GRUB or similar..This is visible only for a fraction of a second before the GRUB2 menu pops up...
The OS es load properly on selection in the menu so no loss of functionality One another problem is there is no OS highlighted by default and the timeout message "Automatic Boot in 10 Secs" does not appear Reinstalling GRUB does not solve the issue
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
not solved the correct way, reloaded using the backup i had the foresight to make i separated / into 3 partitions (/, /tmp, and /var) and after a lot of work (and hair pulling) i can now boot and login but i am getting these 2 errors during bootup
There was an error mounting /var/run Press S to skip M for manual recovery There was an error mounting /var/lock Press S to skip M for manual recovery
When I want to change my docroot in /home/Vincent/www or /home/Vincent/www/ it gaves me an. :Syntax error on line 278 of /etc/httpd/conf/httpd.conf: DocumentRoot must be a directory
I googled it already and they sad that you have to type in: chcon -R -h -t httpd_sys_content_t /home/Vincent/www << doesn't work so I tried also chcon -R -h -t httpd_sys_content_t /home/Vincent/www/ But nothing seems to work?
I am a Novell (now defunct) CNE tring to learn Linux and am having a lot of trouble finding out where the WB 6-6 is wrong in the syntax for adding local4... the the syslog-ng config file. In the instructions there are discrepancies between commas and simi-comma, they are both in the statements in no particular order. there is no pattern to them. Here is what the book shows:
filter f_local4debug { level(debug) and facility(local4); };
When I try to input this in the Gnome terminal window to try and find out where it goes wrong I get the following: -bash: syntax error near unexpected token "(" If I can get the correct syntax I belive I can use the info to get past the rest of this portion of the lesson. I am desperate to learn Linux as the only jobs out there for a Novell CNE are migrations to MS, which really sucks, since MS really really sucks.
I am not ready to upgrade my Fedora 13 to 14 yet, but I wanted to test some things in 14. So, using the live CD, I installed Fedora 14 under Virtualbox. But some things are not working and the Virtualbox Help files aren't helping. I have added my Fedora 13 /home/jjj/ folder as a shared folder with the name Home_jjj. The instructions say that in Fedora 14 I must mount it with "mount -t vboxsf share mount_point." So (as root in Fedora 14). I used the command "mount -t ext3 vboxsf Home_jjj /media" but I got an error message. I tried varying the command different ways, but haven't hit on the secret mount syntax. I would really just like to add it to Fedora 14's fstab file to make it auto-mount. I have an external monitor, which Fedora 13 sees, but Fedora 14 cannot see it. The main display for Fedora 13 is 1680x1050. Fedora 14 installed itself with 1024x768 as the max. I tried changing it with xrandr -s, but the only resolutions xrandr will take are 1024x788, 800x600 and 640x480. How can I make it at least, say, 1400x1050?
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code: the-matrix:~ # mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or Code: the-matrix:~ # rcmysql start Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
I have suse10 64bit and I was setting up SVN server on it. After all required setup while reloading apache2,its giving the error:
Code:
httpd2-prefork: Syntax error on line 113 of /etc/apache2/httpd.conf: Syntax error on line 31 of /etc/apache2/sysconfig.d/loadmodule.conf: Cannot load /usr/lib64/apache2/mod_dav_svn.so into server: /usr/lib64/libsvn_subr-1.so.0: undefined symbol: apr_memcache_add_server
I'm trying to get this script working, it's supposed to give me options of typing B to backup a folder, typing R to restore the backup, and typing E to exit.
[Code]....
When I attempt to run the script, I get my echos prompting me to type B, R or E and press enter. When I type B and press Enter, I get this:
Code: line 18: syntax error near unexpected token 'then' line 18: 'then'
I upgraded a system from 10.3 to 11.4 and I get the following error when trying to run mysql:
Will update MySQL now, if you encounter any problems, please read following file: /usr/share/doc/packages/mysql-community-server/README.SuSE Log files inconsistency, please merge following files manually: /var/lib/mysql/mysqld.log /var/log/mysqld.log
How can I correct this? Mysql will not start so I can not run any of the utilities.
Whenever I boot my laptop, I get the following three lines:Code:error: syntax error.error:Incorrect command.error: syntax error.Right after I see the error messages for a couple seconds, the boot screen shows up and the rest of the boot progresses as normal. I'm on a Wubi 10.10 ubuntu install and I'm pretty sure this error has something to do with the GRUB_TIMEOUT line on 'etc/default/grub' file.I was experiencing some weird glitches with the boot splash screen (it was in the wrong resolution and would not display some times) so I edited that file to make it work. Here is the file:
Code: # If you change this file, run 'update-grub' afterwards to update # /boot/grub/grub.cfg.
I am a newbie in unix shell script programming . After I have tried to execute this code , I found the problem said that "syntax error near unexpected token done" . I don't know that where is the mistake in my code . Could anyone help me out this problem ?, PS* : I executed it in Redhat Enterprise Linux 4 and this is my code :
#!/bin/ksh # Purge Script # Input: # 1. path (absolute path) # 2. filename (does not apply to empty folder name) # 3. retention policy (in day)
how to use create a ssh tunnel for vnc. I have fought with this explanation for some days, and hopeless trial and error finally worked. Here is the explanationEach time you want to connect to your PC, follow these steps:
Find your PC's public name or IP address. Unless your PC has been assigned a memorable name, the easiest way to do this is to go to whatismyip.com from your PC. You can assign your PC a name by getting one from a dynamic DNS provider.Start the SSH client on the computer you'll log in from.Tell the SSH client to use local port-forwarding to connect port 5,900 on your desktop to port 5,900 on localhost.Via the SSH client, run the command x11vnc -safer -localhost -nopw -once -display :0 on the computer whose desktop you will view.where someone suggests to create a local port forward. The person who asks in this thread, has apparently read the same manual as I. The suggestion works, but I am not entirely certain that I have created a secure connection by "locally" forwarding port 5900 on the phone to localhost:5900. Can someone confirm this?Am I correct in assuming that the line "Tell the SSH client to use local port-forwarding to connect port 5,900 on your desktop to port 5,900 on localhost." in the explanation should read "on your remote laptop"?
It has been working until this. I shouldn't think that I need both the 586 and the 64 versions, but it won't let me get rid of the 586 version. Trying to do that results in:
Code:
Is trying to remove kdelibs-6:4.4.1-1.fc11.i586 what I should be doing? Or am I being dense?