Help Upgrading Indexscript SQL Query Problem

Discussion in 'MySQL' started by cldnails, Apr 4, 2006.

0
  1. #1
    Ok, maybe because I don't know I shouldn't be doing it, but is an SQL Query the same thing as running an SQL Statement?

    When trying to run the following statement in PHPMyAdmin query for the right database I'm getting an error.


    ALTER TABLE 'dir_settings' ADD 'seo_urls' CHAR(1) NOT NULL DEFAULT '' AFTER 'admin_email' ;

    This is the 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 ''dir_settings' ADD 'seo_urls' CHAR(1) NOT NULL DEFAULT '' AFTER 'admin_email'' at line 1

    Any help ASAP is appreciated tons! :)
     
    cldnails, Apr 4, 2006 IP
  2. sacx13

    sacx13 Active Member

    Messages:
    438
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #2
    try without commas:

    Regards
     
    sacx13, Apr 5, 2006 IP
  3. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #3
    cldnails... yes, run the statement without the quotes... that should work fine. if it doesn't contact me at the support forum over at www.indexscript.com - i'll personally help you out.
     
    daboss, Apr 5, 2006 IP
  4. cldnails

    cldnails Well-Known Member

    Messages:
    1,529
    Likes Received:
    50
    Best Answers:
    0
    Trophy Points:
    120
    #4
    Thanks so much guys, it is appreciated, as noted I am new to this. Basically I just figured out what the statement was doing, lol, then added the table manually. So no fuss no muss, all is in good order now.

    Basically, it's just a matter of remodifying the script the way I want it again. Also, thanks for the offer daboss.
     
    cldnails, Apr 5, 2006 IP