|Nov 13, 2012, 06:46 PM||#1|
I'm running several wordpress sites off of Mountain Lion Server and all has gone well. Now I am trying to add a fourth site and have run into some trouble. When trying to add a new table to MySQL via SQL Buddy front end I get the following error:
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 ) CHARSET latin1 at line 1
It does not matter what name I put in for the table, I always get the error message so I don't think it is really a syntax error.
After a great deal of research I have not come up with a solution. I was hoping that someone has seen this and solved it already. I know thier are a lot of variables but someplace to start would be helpful.
BTW, does anyone know of a good tutorial for working with SQL Buddy and Wordpress?
|Nov 13, 2012, 07:03 PM||#2|
No experience with SQL Buddy or wordpress, but, that's just an SQL syntax error. You need an equal sign between CHARSET and latin1
create table `TableName` ( .... ) DEFAULT CHARSET=latin1 ....
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|PHP & MySQL help please.||Stocktrader||Web Design and Development||1||Mar 9, 2014 06:04 AM|
|php mysql = NSString||IDMah||iPhone/iPad Programming||9||Dec 20, 2013 01:35 PM|
|MySQL Question Re: Complicated Comparisons||scem0||Mac Programming||16||Aug 21, 2013 10:48 PM|
|PHP, MySQL help please please please||Stocktrader||Web Design and Development||7||Jun 5, 2013 01:29 PM|
|MySQL||saberahul||Mac Programming||1||Mar 17, 2013 11:47 PM|
All times are GMT -5. The time now is 02:06 PM.