Results 1 to 8 of 8

Thread: MYSQL Issue

  1. #1
    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

  2. #2
    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

  3. #3
    Join Date
    Aug 2009
    Location
    Bluesquare datacenter
    Posts
    10
    Yeah should have said i already tried that (sorry for not saying previously )

  4. #4
    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;
    This should work.
    Regards

  5. #5
    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.

  6. #6
    Join Date
    Aug 2009
    Location
    Bluesquare datacenter
    Posts
    10
    Ah

    Always the silly mistakes that get me, cheers lads

  7. #7
    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!

  8. #8
    Join Date
    Aug 2009
    Location
    Bluesquare datacenter
    Posts
    10
    Yep indeed, speaking of PHP i best get some of this coding done

Similar Threads

  1. mysql issue
    By koppan in forum Hosting Security and Technology
    Replies: 5
    Last Post: 03-16-2007, 05:41 PM
  2. PHP/mysql issue
    By 40sixty in forum Programming Discussion
    Replies: 2
    Last Post: 12-03-2006, 12:26 AM
  3. MySQL Issue
    By stooley in forum Hosting Security and Technology
    Replies: 6
    Last Post: 11-10-2006, 09:26 AM
  4. PHP/MySQL ISSUE! Help please
    By iamdave in forum Programming Discussion
    Replies: 6
    Last Post: 07-24-2005, 11:06 AM
  5. mysql issue
    By gate2vn in forum Hosting Security and Technology
    Replies: 2
    Last Post: 03-16-2004, 12:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •