Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > OS X > Mac OS X Server, Xserve, and Networking

Reply
 
Thread Tools Search this Thread Display Modes
Old Nov 13, 2012, 06:46 PM   #1
Tholian
macrumors member
 
Join Date: Dec 2007
MySQL question

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?

Thanks
__________________
Tholian
http://www.readthyself.com/charity
Tholian is offline   0 Reply With Quote
Old Nov 13, 2012, 07:03 PM   #2
neier
macrumors member
 
Join Date: Apr 2003
Location: Japan
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 ....
neier is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > OS X > Mac OS X Server, Xserve, and Networking

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
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

Forum Jump

All times are GMT -5. The time now is 08:23 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC