Phpmyadmin Install Error 1064
Contents |
very strange error. error 1064 (42000): you have an error in your sql syntax; During the installation the following error was thrown: populating 1064 mysql database via sql… error encountered populating database: mysql said: ERROR 1064 (42000) at
Mysql Error 1064 (42000)
line 72: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for
Error Code 1064 In Mysql
the right syntax to use near ‘(14) NOT NULL, `sqlquery` text NOT NULL, PRIMARY KEY (`id`), KEY `usernam' at line 6 Google to the rescue! Apparently, the timestamp format in MySQL does not allow(?) for a value with the "timestamp". I had to abort #1064 - you have an error in your sql syntax the installation and then manually edit dbconfig: In "/usr/share/dbconfig-common/data/phpmyadmin/install/mysql" replace "timestamp(14)" with "timestamp". After editing this, you have to uninstall phpMyAdmin (but not purge it): apt-get remove phpmyadmin When the installer (or uninstaller in this case) asks you to unregister phpMyAdmin from dbconfig, answer no, so your changes in the file are not undone. Now reinstall phpMyAdmin again and answer yes if it asks for you to use dbconfig. apt-get install phpmyadmin Props to Krevindiou over at ServerFault for this one. Author Dietbrand TollenaerePosted on November 1, 2012May 5, 2014Categories TechTags debian, error, mysql, php, phpmyadmin Post navigation Previous Previous post: Review: Velbon Sherpa 803RNext Next post: Fix for "postdrop: warning: unable to look up public/pickup: No such file or directory" Tech Vancouver Photography dietbrand.eu Proudly powered by WordPress
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn
You Have An Error In Your Sql Syntax Check The Manual That Corresponds To Your Mysql Server Version
more about Stack Overflow the company Business Learn more about hiring developers or posting error 1064 mysql 42000 mysqldump ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site error 1064 mysql 42000 create table for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise https://dietbrand.eu/fixing-a-phpmyadmin-installation-error/ to the top Setting up phpmyadmin, got a MySQL syntax error up vote 3 down vote favorite 3 I tried installing phpmyadmin on Debian Squeeze with a nginx and mysql-server installed. I ran sudo apt-get install phpmyadmin, and all appeared to be going well until setup threw me this: An error occurred while installing the database: mysql said: ERROR 1064 (42000) at line 72: You have an error in http://serverfault.com/questions/341116/setting-up-phpmyadmin-got-a-mysql-syntax-error your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, `sqlquery` text NOT NULL, PRIMARY KEY (`id`), KEY `usernam' at line 6 ...what do? mysql php debian nginx share|improve this question asked Dec 15 '11 at 3:55 jibcage 3114 Please show us the full output or at least some infos before that? –quanta Dec 15 '11 at 6:28 @quanta what do you want me to show? It asks me whether I want to do dbconfig_common, I say yes, it asks for the root password, and then it gives me that error. –jibcage Dec 15 '11 at 6:54 What is your sources.list? Paste it. Chances are your mixing repositories. –user104294 Dec 15 '11 at 22:39 The error is quite strange. apt-get clean and try again. If if didn't work, you can download the phpmyadmin source code and extract to Apache document root. –quanta Dec 16 '11 at 4:16 add a comment| 2 Answers 2 active oldest votes up vote 10 down vote Replace "timestamp(14)" by "timestamp" in /usr/share/dbconfig-common/data/phpmyadmin/install/mysql (pma_history section). Then reinstall phpmyadmin. share|improve this answer answered Jan 5 '12 at 13:21 Krevindiou 1012
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the http://stackoverflow.com/questions/31369927/phpmyadmin-error-1064 workings and policies of this site About Us Learn more about Stack https://premium.wpmudev.org/forums/topic/does-anyone-know-the-solution-to-error-1064-for-phpmyadmin Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; error 1064 it only takes a minute: Sign up phpMyAdmin error #1064 up vote -1 down vote favorite Trying to import stored procedures created in my local machine into a web server (iPage hosting) by using phpMyAdmin. Due to errors in the process of importing the procedures I decided to manually enter the stored procedures using scripts into the server, like you have an the following example: CREATE PROCEDURE upvote(IN _message_id int, IN _user_id int) BEGIN DECLARE qty_upvotes INT; INSERT IGNORE INTO upvotes SET message_id = _message_id,user_id = _user_id; SET qty_upvotes = (SELECT COUNT(*) FROM upvotes WHERE message_id = _message_id); UPDATE message_stats SET upvotes = qty_upvotes WHERE message_id = _message_id; END Then I get the error below. 1064 - 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 '' at line 3 I looked for it everywhere since 2 days now and I cannot find a solution. Any clue? phpmyadmin mysql-error-1064 share|improve this question edited Jul 12 '15 at 16:24 Anil Natha 2,34451835 asked Jul 12 '15 at 16:20 Omar Melendrez 11 Did you try to wrap all the properties and values with ` such as `message_id` = `_message_id`,`user_id` = `_user_id`? –5ervant Jul 12 '15 at 16:31 Answer posted below –Omar Melendrez Jul 13 '15 at 6:11 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote
Contact Work with us The Hub Log In Become a member New to the community? Start here Home Support Support Forums General wordpress Decura The Bug Hunter 468 pts 773 pts LEVEL 7 Does anyone know the solution to error #1064 for phpMyAdmin? I was just trying to upload a restore through the phpMyAdmin for a site and got this error: #1064 - 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 'example_com_db.sql' at line 1 The backup was made with backWPup as a .tar.gz file. I've tried finding a solution to this but came up empty handed after several attempts. All General WordPress Plugins & Themes Multisite Features & Feedback Comments 15 Jack Kitterhing Code Norris 13,192 pts 20,412 pts LEVEL 30 Hi there @Decura I hope you are well today and thanks for your question. Are you using myisam, InddoDB, something else? Is it set as UTF8? Or for some reason has that changed? Have you got something like this in your DB backup http://stackoverflow.com/questions/4679080/phpmyadmin-error-1064 Please advise. Is this a single site install or a multisite install? Thank you! Kind Regards Jack. Decura The Bug Hunter 468 pts 773 pts LEVEL 7 @Jack Kitterhing backWPup has an option called DB Optimize that was selected. The selected table types to optimize is MyISAM and InnoDB tables. Other than that I don't use it. I do not know if this is set to UTF8 and there is nothing like the code from the link in the backup. Decura The Bug Hunter 468 pts 773 pts LEVEL 7 @Jack Kitterhing The hosting provider offers a 30-day manual restore for a fee so there is a plan b backup solution. However, several of my sites are using the same setup so I'm worried that this is a general error that might affect all of them. Decura The Bug Hunter 468 pts 773 pts LEVEL 7 @Jack Kittering The cause seems to be a version mismatch due to reserved words. No need to look further. I will opt in for plan b and try to figure something out after the restore. lol Site Builder, Child of Zeus 471 pts 248 pts LEVEL 4 Hi Decura, If it's a syntax error it should be possible to correct the db. If you want I can have a look to your backup and try to repair it. It's generaly not a good idea to restore a db with another program than this with which the backup was done. Laurent. Decura The Bug Hunter 468 pts 773 pts LEVEL 7 @lol Thank you for the offer but the order has already been sent. Do you have any recommendations to a backup program? Perhaps I will switch to another solution. l