Results 1 to 8 of 8
Thread: MYSQL Issue
-
08-26-2009, 02:09 PM #1Newbie
- Join Date
- Aug 2009
- Location
- Bluesquare datacenter
- Posts
- 10
MYSQL Issue
Can you notice anything wrong here?
Code:CREATE TABLE `sys_config` ( `webtitle` varchar(255) NOT NULL, `titleseperator` varchar(255) NOT NULL, `siteauthor` varchar(255) NOT NULL, `sitecopyright` varchar(255) NOT NULL, `sitedistribution` varchar(255) NOT NULL, `siterating` varchar(255) NOT NULL, `siteresource` varchar(255) NOT NULL, `sitecontent` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `site_email` varchar(255) NOT NULL, `domain_name` varchar(255) NOT NULL, `system_mail` varchar(255) NOT NULL, `htaccessban` varchar(255) NOT NULL, `banmessage` varchar(255) NOT NULL, ) ENGINE=MyISAM;
Code:#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 ') ENGINE=MyISAM' at line 16
-
08-26-2009, 02:30 PM #2Web Hosting Master
- Join Date
- Oct 2006
- Location
- /usr/src/linux/
- Posts
- 700
Try
Code:TYPE=MyISAM;
█ VPSnoc.com offers high quality Xen® OpenVZ & Windows® Virtual Private Servers at affordable prices.
█ 99.95% Uptime | 24/7/365 Support | Unmetered bandwidth.
█ Follow us: twitter.com/VPSnoc
-
08-26-2009, 02:34 PM #3Newbie
- Join Date
- Aug 2009
- Location
- Bluesquare datacenter
- Posts
- 10
Yeah should have said i already tried that (sorry for not saying previously )
-
08-26-2009, 02:45 PM #4New Member
- Join Date
- Jul 2009
- Posts
- 3
I think it's the comma before the )
Code:CREATE TABLE `sys_config` ( `webtitle` varchar(255) NOT NULL, `titleseperator` varchar(255) NOT NULL, `siteauthor` varchar(255) NOT NULL, `sitecopyright` varchar(255) NOT NULL, `sitedistribution` varchar(255) NOT NULL, `siterating` varchar(255) NOT NULL, `siteresource` varchar(255) NOT NULL, `sitecontent` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `site_email` varchar(255) NOT NULL, `domain_name` varchar(255) NOT NULL, `system_mail` varchar(255) NOT NULL, `htaccessban` varchar(255) NOT NULL, `banmessage` varchar(255) NOT NULL ) ENGINE=MyISAM;
Regards
-
08-26-2009, 02:53 PM #5Junior Guru
- Join Date
- May 2001
- Location
- Houston, TX
- Posts
- 195
Remove the last comma after "`banmessage` varchar(255) NOT NULL,".
Sorry, noticed oso96_2000 has posted resolution.
-
08-26-2009, 03:01 PM #6Newbie
- Join Date
- Aug 2009
- Location
- Bluesquare datacenter
- Posts
- 10
Ah
Always the silly mistakes that get me, cheers lads
-
08-26-2009, 04:27 PM #7Web Hosting Master
- Join Date
- Apr 2007
- Posts
- 3,531
I did something similar the other day with a PHP file constructing an mySQL query.
Drove me MAD!BotWars.io - Code the AI of your Battle Bot!
-
08-26-2009, 04:38 PM #8Newbie
- Join Date
- Aug 2009
- Location
- Bluesquare datacenter
- Posts
- 10
Yep indeed, speaking of PHP i best get some of this coding done
Similar Threads
-
mysql issue
By koppan in forum Hosting Security and TechnologyReplies: 5Last Post: 03-16-2007, 05:41 PM -
PHP/mysql issue
By 40sixty in forum Programming DiscussionReplies: 2Last Post: 12-03-2006, 12:26 AM -
MySQL Issue
By stooley in forum Hosting Security and TechnologyReplies: 6Last Post: 11-10-2006, 09:26 AM -
PHP/MySQL ISSUE! Help please
By iamdave in forum Programming DiscussionReplies: 6Last Post: 07-24-2005, 11:06 AM -
mysql issue
By gate2vn in forum Hosting Security and TechnologyReplies: 2Last Post: 03-16-2004, 12:43 PM