SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard Zaggs's Avatar
    Join Date
    Feb 2005
    Posts
    1,045
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Alter table problem

    Hi!

    I am trying to add a number of new fields on an existing table. Here is the sql query I am using:

    PHP Code:
    alter table fi_raters add (
    cell_c39 smallint(6),
    cell_c40 smallint(6),
    cell_c41 smallint(6),
    cell_c42 smallint(6),
    cell_c43 smallint(6),
    cell_c44 smallint(6),
    cell_c45 smallint(6),
    cell_c46 smallint(6),
    cell_c48 smallint(6),
    cell_c49 smallint(6),
    cell_c50 smallint(6),
    cell_c51 smallint(6),
    cell_d39 smallint(6),
    cell_d40 smallint(6),
    cell_d41 smallint(6),
    cell_d42 smallint(6),
    cell_d43 smallint(6),
    cell_d44 smallint(6),
    cell_d45 smallint(6),
    cell_d46 smallint(6),
    cell_d48 smallint(6),
    cell_d49 smallint(6),
    cell_d50 smallint(6),
    cell_d51 smallint(6),
    cell_g39 smallint(6),
    cell_g40 smallint(6),
    cell_g41 smallint(6),
    cell_g42 smallint(6),
    cell_g43 smallint(6),
    cell_g44 smallint(6),
    cell_g45 smallint(6),
    cell_g46 smallint(6),
    cell_g48 smallint(6),
    cell_g49 smallint(6),
    cell_g50 smallint(6),
    cell_g51 smallint(6),
    cell_h47 decimal(9,2),
    cell_i39 smallint(6),
    cell_i40 smallint(6),
    cell_i41 smallint(6),
    cell_i42 smallint(6),
    cell_i43 smallint(6),
    cell_i44 smallint(6),
    cell_i45 smallint(6),
    cell_i46 smallint(6),
    cell_m47 decimal(9,2),
    cell_i48 smallint(6),
    cell_i49 smallint(6),
    cell_i50 smallint(6),
    cell_i51 smallint(6),
    cell_g53 decimal(9,1),
    cell_g54 smallint(6),
    cell_g55 smallint(6),
    cell_i58 smallint(6),
    cell_i59 smallint(6),
    cell_n59 smallint(6),
    cell_n60 smallint(6),
    cell_n61 smallint(6),
    cell_n62 smallint(6),
    cell_n63 smallint(6),
    cell_n64 smallint(6),
    cell_n65 smallint(6),
    cell_n66 smallint(6),
    cell_n67 smallint(6),
    cell_n68 varchar(100),
    cell_n69 smallint(6),
    cell_b73 int(11),
    cell_g73 smallint(6),
    cell_g74 smallint(6),
    cell_h73 smallint(6),
    cell_i73 smallint(6),
    cell_i74 smallint(6),
    cell_m73 smallint(6),
    cell_n73 smallint(6),
    cell_n74 smallint(6),
    cell_o73 smallint(6),
    cell_g76 smallint(6),
    cell_i76 smallint(6),
    cell_n76 smallint(6),
    cell_g77 smallint(6),
    cell_i77 smallint(6),
    cell_n77 smallint(6),
    cell_g78 decimal(9,2),
    cell_i78 decimal(9,2),
    cell_n78 decimal(9,2),
    cell_g79 decimal(9,2),
    cell_i79 decimal(9,2),
    cell_n79 decimal(9,2),
    cell_g80 smallint(6),
    cell_i80 smallint(6),
    cell_n80 smallint(6),
    cell_g81 smallint(6),
    cell_i81 smallint(6),
    cell_n81 smallint(6),
    cell_g82 smallint(6),
    cell_i82 smallint(6),
    cell_n82 smallint(6),
    cell_g83 smallint(6),
    cell_i83 smallint(6),
    cell_n83 smallint(6),
    cell_g84 decimal(9,2),
    cell_i84 decimal(9,2),
    cell_n84 decimal(9,2),
    cell_b80 decimal(9,2),
    cell_b81 decimal(9,2),
    cell_b82 decimal(9,2),
    cell_b83 decimal(9,2),
    cell_b84 decimal(9,2),
    cell_b85 decimal(9,2),
    cell_b86 decimal(9,2),
    cell_b91 smallint(6),
    cell_b92 smallint(6),
    cell_b93 smallint(6),
    cell_e90 smallint(6),
    cell_e91 smallint(6),
    cell_e92 smallint(6),
    cell_e93 smallint(6),
    cell_e95 smallint(6),
    cell_e96 smallint(6),
    cell_e97 smallint(6),
    cell_f95 smallint(6),
    cell_f96 smallint(6),
    cell_f97 smallint(6),
    cell_i90 smallint(6),
    cell_i91 smallint(6),
    cell_i92 smallint(6),
    cell_i93 smallint(6),
    cell_i94 smallint(6),
    cell_c104 decimal(9,1),
    cell_c105 decimal(9,1),
    cell_c106 decimal(9,1),
    cell_c107 decimal(9,1),
    cell_c108 decimal(9,1),
    cell_c109 decimal(9,1),
    cell_d104 decimal(9,4),
    cell_d105 decimal(9,4),
    cell_d106 decimal(9,4),
    cell_d107 decimal(9,4),
    cell_d108 decimal(9,4),
    cell_d109 decimal(9,4),
    cell_e104 smallint(6),
    cell_e105 smallint(6),
    cell_e106 smallint(6),
    cell_e107 smallint(6),
    cell_e108 smallint(6),
    cell_e109 smallint(6),
    cell_f104 smallint(6),
    cell_f105 smallint(6),
    cell_f106 smallint(6),
    cell_f107 smallint(6),
    cell_f108 smallint(6),
    cell_f109 smallint(6),
    cell_g104 decimal(9,1),
    cell_g105 decimal(9,1),
    cell_g106 decimal(9,1),
    cell_g107 decimal(9,1),
    cell_g108 decimal(9,1),
    cell_g109 decimal(9,1),
    cell_h104 smallint(6),
    cell_h105 smallint(6),
    cell_h106 smallint(6),
    cell_h107 smallint(6),
    cell_h108 smallint(6),
    cell_h109 smallint(6),
    cell_i104 decimal(9,2),
    cell_i105 decimal(9,2),
    cell_i106 decimal(9,2),
    cell_i107 decimal(9,2),
    cell_i108 decimal(9,2),
    cell_i109 decimal(9,2),
    cell_m104 smallint(6),
    cell_m105 smallint(6),
    cell_m106 smallint(6),
    cell_m107 smallint(6),
    cell_m108 smallint(6),
    cell_m109 smallint(6),
    cell_n104 decimal(9,1),
    cell_n105 decimal(9,1),
    cell_n106 decimal(9,1),
    cell_n107 decimal(9,1),
    cell_n108 decimal(9,1),
    cell_n109 decimal(9,1),
    cell_o104 decimal(9,1),
    cell_o105 decimal(9,1),
    cell_o106 decimal(9,1),
    cell_o107 decimal(9,1),
    cell_o108 decimal(9,1),
    cell_o109 decimal(9,1),
    cell_c119 decimal(9,1),
    cell_c120 decimal(9,1),
    cell_c121 decimal(9,1),
    cell_c122 decimal(9,1),
    cell_c123 decimal(9,1),
    cell_c124 decimal(9,1),
    cell_d119 decimal(9,4),
    cell_d120 decimal(9,4),
    cell_d121 decimal(9,4),
    cell_d122 decimal(9,4),
    cell_d123 decimal(9,4),
    cell_d124 decimal(9,4),
    cell_e119 smallint(6),
    cell_e120 smallint(6),
    cell_e121 smallint(6),
    cell_e122 smallint(6),
    cell_e123 smallint(6),
    cell_e124 smallint(6),
    cell_f119 smallint(6),
    cell_f120 smallint(6),
    cell_f121 smallint(6),
    cell_f122 smallint(6),
    cell_f123 smallint(6),
    cell_f124 smallint(6),
    cell_g119 decimal(9,1),
    cell_g120 decimal(9,1),
    cell_g121 decimal(9,1),
    cell_g122 decimal(9,1),
    cell_g123 decimal(9,1),
    cell_g124 decimal(9,1),
    cell_h119 smallint(6),
    cell_h120 smallint(6),
    cell_h121 smallint(6),
    cell_h122 smallint(6),
    cell_h123 smallint(6),
    cell_h124 smallint(6),
    cell_i119 decimal(9,2),
    cell_i120 decimal(9,2),
    cell_i121 decimal(9,2),
    cell_i122 decimal(9,2),
    cell_i123 decimal(9,2),
    cell_i124 decimal(9,2),
    cell_m119 smallint(6),
    cell_m120 smallint(6),
    cell_m121 smallint(6),
    cell_m122 smallint(6),
    cell_m123 smallint(6),
    cell_m124 smallint(6),
    cell_n119 decimal(9,1),
    cell_n120 decimal(9,1),
    cell_n121 decimal(9,1),
    cell_n122 decimal(9,1),
    cell_n123 decimal(9,1),
    cell_n124 decimal(9,1),
    cell_o119 decimal(9,1),
    cell_o120 decimal(9,1),
    cell_o121 decimal(9,1),
    cell_o122 decimal(9,1),
    cell_o123 decimal(9,1),
    cell_o124 decimal(9,1),
    cell_c533 decimal(9,1),
    cell_c534 decimal(9,1),
    cell_c535 decimal(9,1),
    cell_c536 decimal(9,1),
    cell_c537 decimal(9,1),
    cell_c538 decimal(9,1),
    cell_d533 decimal(9,4),
    cell_d534 decimal(9,4),
    cell_d535 decimal(9,4),
    cell_d536 decimal(9,4),
    cell_d537 decimal(9,4),
    cell_d538 decimal(9,4),
    cell_e533 smallint(6),
    cell_e534 smallint(6),
    cell_e535 smallint(6),
    cell_e536 smallint(6),
    cell_e537 smallint(6),
    cell_e538 smallint(6),
    cell_f533 smallint(6),
    cell_f534 smallint(6),
    cell_f535 smallint(6),
    cell_f536 smallint(6),
    cell_f537 smallint(6),
    cell_f538 smallint(6),
    cell_g533 decimal(9,1),
    cell_g534 decimal(9,1),
    cell_g535 decimal(9,1),
    cell_g536 decimal(9,1),
    cell_g537 decimal(9,1),
    cell_g538 decimal(9,1),
    cell_h533 smallint(6),
    cell_h534 smallint(6),
    cell_h535 smallint(6),
    cell_h536 smallint(6),
    cell_h537 smallint(6),
    cell_h538 smallint(6),
    cell_i533 decimal(9,2),
    cell_i534 decimal(9,2),
    cell_i535 decimal(9,2),
    cell_i536 decimal(9,2),
    cell_i537 decimal(9,2),
    cell_i538 decimal(9,2),
    cell_m533 smallint(6),
    cell_m534 smallint(6),
    cell_m535 smallint(6),
    cell_m536 smallint(6),
    cell_m537 smallint(6),
    cell_m538 smallint(6),
    cell_n533 decimal(9,1),
    cell_n534 decimal(9,1),
    cell_n535 decimal(9,1),
    cell_n536 decimal(9,1),
    cell_n537 decimal(9,1),
    cell_n538 decimal(9,1),
    cell_o533 decimal(9,1),
    cell_o534 decimal(9,1),
    cell_o535 decimal(9,1),
    cell_o536 decimal(9,1),
    cell_o537 decimal(9,1),
    cell_o538 decimal(9,1)
    ); 
    Here is the error I am receiving:

    Code:
    There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
    ----BEGIN CUT----
    eNp1lktv20YYRff8FbPIwgEUhcM31ZVhCGkA+VErTYFuDEkUZwYQh66sBMkqfz1SH7BUnLv0MfHx
    ztHlR84fH+8fZ+bGmpvMLOZ3M1OmprSmtjZNlp+O//qRJDeflzPz5mM3My9/7Z5X+5ftfroL6+mz
    f558Ndm0qE2WptX71L63tbH1LM1meWo239fj4ekwmPm3Z/Mmuf2+/G1xnD9Np0WZ/L58NPfLibn+
    ML/7NDGf58db/RGiub3/8+NicX26LHm4vZ4dxzfT4y2Sh18fTldN7penGdm0MosQv3xLFtd3H2Zm
    G999OfTvmuTve6x2h+3eHFbr3db04Wm/Ov75YlZdZ66SzXa3e9rkrXkZVrtdiIer6u0k+fEPLtJL
    /C+1SDOkOdICaYm0QtogbYmWeIqSTtHlNKFDDx166NBDhx469NChhw49dOihQw8deujQg0MPDj04
    9ODQg0MPDj049ODQg0MPDj049ODQgz8+y912E47/uGon2X84oJ6AegLqCagnoJ6AegLqCahnEMdA
    awGtBbQWuD1lfnY7+4rxZy7xHCVGKylaZFqlSC3SDGmOtEBaIq2Q1kgb83W13/jV/sqm6Sumw63r
    3JyAfZVb45NVU1iP1wZBacKA10ZBacIo8laYATUidXWNE1A5Ulc3+LAwjoxd3fKQlocgdg0+c0gj
    Utfg8kEakboGFxXSiNQ12CukEalrCpTJODJeHwUhtowzxjljccuScYW4Jf/rNkNKnrZtitQizZDy
    3BJphZSeqR4n9DihxwkBzxbwbAHPFvBsocVvUZsW9Ao78lLwSvBa8Ebwlnh3mac446XgleC14I3g
    LfHtKQ/8+Kc4iCvGNeOGMb0Je07Sc5Kek/ScpOckPSdxojNOdMaJzjjRGSc640RnPJvxbMazGc9m
    PJvxbCZcmsnOeCl4JXgteCM4vlcHNjOwmYHNDGxmYDMDm4miM1F0JorORNGZKDoTRWdGkWcUeUaR
    ZxR5RpFnFHk21gqepYJbwTPBc8EL3sO25T15keecW8EzwXPBC97DtsVdmaWMLeOMcc6YF67l9YxJ
    ek7Sc5Kek/ScxInOONEZJzrjRGec6IwTnfFsxrMZz2Y8m/FsxrOZcGnmbE9mqeBW8EzwXPCC9zCa
    GdjMwGYGNjOwmYHNRNGZKDoTRWei6EwUnYmiM6PIM4o8o8gzijyjyDOKPJsyzwVX15eCV4LXguP7
    orvMU5zxQvBS8ErwWnD8Tt6e8sCuPMVBXDKuGNeM8eOUk/ScpOckPSfpOUnPSZzojBOdcaIzTnTG
    ic440RnPZjyb8WzGsxnPZjybCZdmsjNeCF4KXgleC47fyQObGdjMwGYGNjOwmYHNRNGZKDoTRWei
    6EwUnYmiM6PIM4o8o8gzijyjyDP+P0/y9pefvbzIXg==
    ----END CUT----
    ----BEGIN RAW----
    
    ERROR: C1 C2 LEN: 50 51 7110
    STR: 
    
    CVS: $Id: sqlparser.lib.php,v 2.47 2006/01/17 17:02:30 cybot_tm Exp $
    MySQL: 5.0.45
    USR OS, AGENT, VER: Win MOZILLA 5.0
    PMA: 2.8.2.4
    PHP VER,OS: 5.2.6 Linux
    LANG: en-utf-8
    SQL: alter table fi_raters add (
    cell_c39 smallint(6),
    cell_c40 smallint(6),
    cell_c41 smallint(6),
    cell_c42 smallint(6),
    cell_c43 smallint(6),
    cell_c44 smallint(6),
    cell_c45 smallint(6),
    cell_c46 smallint(6),
    cell_c48 smallint(6),
    cell_c49 smallint(6),
    cell_c50 smallint(6),
    cell_c51 smallint(6),
    cell_d39 smallint(6),
    cell_d40 smallint(6),
    cell_d41 smallint(6),
    cell_d42 smallint(6),
    cell_d43 smallint(6),
    cell_d44 smallint(6),
    cell_d45 smallint(6),
    cell_d46 smallint(6),
    cell_d48 smallint(6),
    cell_d49 smallint(6),
    cell_d50 smallint(6),
    cell_d51 smallint(6),
    cell_g39 smallint(6),
    cell_g40 smallint(6),
    cell_g41 smallint(6),
    cell_g42 smallint(6),
    cell_g43 smallint(6),
    cell_g44 smallint(6),
    cell_g45 smallint(6),
    cell_g46 smallint(6),
    cell_g48 smallint(6),
    cell_g49 smallint(6),
    cell_g50 smallint(6),
    cell_g51 smallint(6),
    cell_h47 decimal(9,2),
    cell_i39 smallint(6),
    cell_i40 smallint(6),
    cell_i41 smallint(6),
    cell_i42 smallint(6),
    cell_i43 smallint(6),
    cell_i44 smallint(6),
    cell_i45 smallint(6),
    cell_i46 smallint(6),
    cell_m47 decimal(9,2),
    cell_i48 smallint(6),
    cell_i49 smallint(6),
    cell_i50 smallint(6),
    cell_i51 smallint(6),
    cell_g53 decimal(9,1),
    cell_g54 smallint(6),
    cell_g55 smallint(6),
    cell_i58 smallint(6),
    cell_i59 smallint(6),
    cell_n59 smallint(6),
    cell_n60 smallint(6),
    cell_n61 smallint(6),
    cell_n62 smallint(6),
    cell_n63 smallint(6),
    cell_n64 smallint(6),
    cell_n65 smallint(6),
    cell_n66 smallint(6),
    cell_n67 smallint(6),
    cell_n68 varchar(100),
    cell_n69 smallint(6),
    cell_b73 int(11),
    cell_g73 smallint(6),
    cell_g74 smallint(6),
    cell_h73 smallint(6),
    cell_i73 smallint(6),
    cell_i74 smallint(6),
    cell_m73 smallint(6),
    cell_n73 smallint(6),
    cell_n74 smallint(6),
    cell_o73 smallint(6),
    cell_g76 smallint(6),
    cell_i76 smallint(6),
    cell_n76 smallint(6),
    cell_g77 smallint(6),
    cell_i77 smallint(6),
    cell_n77 smallint(6),
    cell_g78 decimal(9,2),
    cell_i78 decimal(9,2),
    cell_n78 decimal(9,2),
    cell_g79 decimal(9,2),
    cell_i79 decimal(9,2),
    cell_n79 decimal(9,2),
    cell_g80 smallint(6),
    cell_i80 smallint(6),
    cell_n80 smallint(6),
    cell_g81 smallint(6),
    cell_i81 smallint(6),
    cell_n81 smallint(6),
    cell_g82 smallint(6),
    cell_i82 smallint(6),
    cell_n82 smallint(6),
    cell_g83 smallint(6),
    cell_i83 smallint(6),
    cell_n83 smallint(6),
    cell_g84 decimal(9,2),
    cell_i84 decimal(9,2),
    cell_n84 decimal(9,2),
    cell_b80 decimal(9,2),
    cell_b81 decimal(9,2),
    cell_b82 decimal(9,2),
    cell_b83 decimal(9,2),
    cell_b84 decimal(9,2),
    cell_b85 decimal(9,2),
    cell_b86 decimal(9,2),
    cell_b91 smallint(6),
    cell_b92 smallint(6),
    cell_b93 smallint(6),
    cell_e90 smallint(6),
    cell_e91 smallint(6),
    cell_e92 smallint(6),
    cell_e93 smallint(6),
    cell_e95 smallint(6),
    cell_e96 smallint(6),
    cell_e97 smallint(6),
    cell_f95 smallint(6),
    cell_f96 smallint(6),
    cell_f97 smallint(6),
    cell_i90 smallint(6),
    cell_i91 smallint(6),
    cell_i92 smallint(6),
    cell_i93 smallint(6),
    cell_i94 smallint(6),
    cell_c104 decimal(9,1),
    cell_c105 decimal(9,1),
    cell_c106 decimal(9,1),
    cell_c107 decimal(9,1),
    cell_c108 decimal(9,1),
    cell_c109 decimal(9,1),
    cell_d104 decimal(9,4),
    cell_d105 decimal(9,4),
    cell_d106 decimal(9,4),
    cell_d107 decimal(9,4),
    cell_d108 decimal(9,4),
    cell_d109 decimal(9,4),
    cell_e104 smallint(6),
    cell_e105 smallint(6),
    cell_e106 smallint(6),
    cell_e107 smallint(6),
    cell_e108 smallint(6),
    cell_e109 smallint(6),
    cell_f104 smallint(6),
    cell_f105 smallint(6),
    cell_f106 smallint(6),
    cell_f107 smallint(6),
    cell_f108 smallint(6),
    cell_f109 smallint(6),
    cell_g104 decimal(9,1),
    cell_g105 decimal(9,1),
    cell_g106 decimal(9,1),
    cell_g107 decimal(9,1),
    cell_g108 decimal(9,1),
    cell_g109 decimal(9,1),
    cell_h104 smallint(6),
    cell_h105 smallint(6),
    cell_h106 smallint(6),
    cell_h107 smallint(6),
    cell_h108 smallint(6),
    cell_h109 smallint(6),
    cell_i104 decimal(9,2),
    cell_i105 decimal(9,2),
    cell_i106 decimal(9,2),
    cell_i107 decimal(9,2),
    cell_i108 decimal(9,2),
    cell_i109 decimal(9,2),
    cell_m104 smallint(6),
    cell_m105 smallint(6),
    cell_m106 smallint(6),
    cell_m107 smallint(6),
    cell_m108 smallint(6),
    cell_m109 smallint(6),
    cell_n104 decimal(9,1),
    cell_n105 decimal(9,1),
    cell_n106 decimal(9,1),
    cell_n107 decimal(9,1),
    cell_n108 decimal(9,1),
    cell_n109 decimal(9,1),
    cell_o104 decimal(9,1),
    cell_o105 decimal(9,1),
    cell_o106 decimal(9,1),
    cell_o107 decimal(9,1),
    cell_o108 decimal(9,1),
    cell_o109 decimal(9,1),
    cell_c119 decimal(9,1),
    cell_c120 decimal(9,1),
    cell_c121 decimal(9,1),
    cell_c122 decimal(9,1),
    cell_c123 decimal(9,1),
    cell_c124 decimal(9,1),
    cell_d119 decimal(9,4),
    cell_d120 decimal(9,4),
    cell_d121 decimal(9,4),
    cell_d122 decimal(9,4),
    cell_d123 decimal(9,4),
    cell_d124 decimal(9,4),
    cell_e119 smallint(6),
    cell_e120 smallint(6),
    cell_e121 smallint(6),
    cell_e122 smallint(6),
    cell_e123 smallint(6),
    cell_e124 smallint(6),
    cell_f119 smallint(6),
    cell_f120 smallint(6),
    cell_f121 smallint(6),
    cell_f122 smallint(6),
    cell_f123 smallint(6),
    cell_f124 smallint(6),
    cell_g119 decimal(9,1),
    cell_g120 decimal(9,1),
    cell_g121 decimal(9,1),
    cell_g122 decimal(9,1),
    cell_g123 decimal(9,1),
    cell_g124 decimal(9,1),
    cell_h119 smallint(6),
    cell_h120 smallint(6),
    cell_h121 smallint(6),
    cell_h122 smallint(6),
    cell_h123 smallint(6),
    cell_h124 smallint(6),
    cell_i119 decimal(9,2),
    cell_i120 decimal(9,2),
    cell_i121 decimal(9,2),
    cell_i122 decimal(9,2),
    cell_i123 decimal(9,2),
    cell_i124 decimal(9,2),
    cell_m119 smallint(6),
    cell_m120 smallint(6),
    cell_m121 smallint(6),
    cell_m122 smallint(6),
    cell_m123 smallint(6),
    cell_m124 smallint(6),
    cell_n119 decimal(9,1),
    cell_n120 decimal(9,1),
    cell_n121 decimal(9,1),
    cell_n122 decimal(9,1),
    cell_n123 decimal(9,1),
    cell_n124 decimal(9,1),
    cell_o119 decimal(9,1),
    cell_o120 decimal(9,1),
    cell_o121 decimal(9,1),
    cell_o122 decimal(9,1),
    cell_o123 decimal(9,1),
    cell_o124 decimal(9,1),
    cell_c533 decimal(9,1),
    cell_c534 decimal(9,1),
    cell_c535 decimal(9,1),
    cell_c536 decimal(9,1),
    cell_c537 decimal(9,1),
    cell_c538 decimal(9,1),
    cell_d533 decimal(9,4),
    cell_d534 decimal(9,4),
    cell_d535 decimal(9,4),
    cell_d536 decimal(9,4),
    cell_d537 decimal(9,4),
    cell_d538 decimal(9,4),
    cell_e533 smallint(6),
    cell_e534 smallint(6),
    cell_e535 smallint(6),
    cell_e536 smallint(6),
    cell_e537 smallint(6),
    cell_e538 smallint(6),
    cell_f533 smallint(6),
    cell_f534 smallint(6),
    cell_f535 smallint(6),
    cell_f536 smallint(6),
    cell_f537 smallint(6),
    cell_f538 smallint(6),
    cell_g533 decimal(9,1),
    cell_g534 decimal(9,1),
    cell_g535 decimal(9,1),
    cell_g536 decimal(9,1),
    cell_g537 decimal(9,1),
    cell_g538 decimal(9,1),
    cell_h533 smallint(6),
    cell_h534 smallint(6),
    cell_h535 smallint(6),
    cell_h536 smallint(6),
    cell_h537 smallint(6),
    cell_h538 smallint(6),
    cell_i533 decimal(9,2),
    cell_i534 decimal(9,2),
    cell_i535 decimal(9,2),
    cell_i536 decimal(9,2),
    cell_i537 decimal(9,2),
    cell_i538 decimal(9,2),
    cell_m533 smallint(6),
    cell_m534 smallint(6),
    cell_m535 smallint(6),
    cell_m536 smallint(6),
    cell_m537 smallint(6),
    cell_m538 smallint(6),
    cell_n533 decimal(9,1),
    cell_n534 decimal(9,1),
    cell_n535 decimal(9,1),
    cell_n536 decimal(9,1),
    cell_n537 decimal(9,1),
    cell_n538 decimal(9,1),
    cell_o533 decimal(9,1),
    cell_o534 decimal(9,1),
    cell_o535 decimal(9,1),
    cell_o536 decimal(9,1),
    cell_o537 decimal(9,1),
    cell_o538 decimal(9,1)
    );
    
    ----END RAW----
    
    SQL query:
    
    alter table fi_raters add ( cell_c39 smallint(6), cell_c40 smallint(6), cell_c41 smallint(6), cell_c42 smallint(6), cell_c43 smallint(6), cell_c44 smallint(6), cell_c45 smallint(6), cell_c46 smallint(6), cell_c48 smallint(6), cell_c49 smallint(6), cell_c50 smallint(6), cell_c51 smallint(6), cell_d39 smallint(6), cell_d40 smallint(6), cell_d41 smallint(6), cell_d42 smallint(6), cell_d43 smallint(6), cell_d44 smallint(6), cell_d45 smallint(6), cell_d46 smallint(6), cell_d48 smallint(6), cell_d49 smallint(6), cell_d50 smallint(6), cell_d51 smallint(6), cell_g39 smallint(6), cell_g40 smallint(6), cell_g41 smallint(6), cell_g42 smallint(6), cell_g43 smallint(6), cell_g44 smallint(6), cell_g45 smallint(6), cell_g46 smallint(6), cell_g48 smallint(6), cell_g49 smallint(6), cell_g50 smallint(6), cell_g51 smallint(6), cell_h47 decimal(9,2), cell_i39 smallint(6), cell_i40 smallint(6), cell_i41 smallint(6), cell_i42 smallint(6), cell_i43 smallint(6), cell_i44 smallint(6), cell_i45 smallint(6), cell_i46 smallint(6), cell_m47 decimal(9,2), cell_i48 smallint(6), cell_i49 smallint(6), cell_i50 smallint(6), cell_i51 smallint(6), cell_g53 decimal(9,1), cell_g54 smallint(6), cell_g55 smallint(6), cell_i58 smallint(6), cell_i59 smallint(6), cell_n59 smallint(6), cell_n60 smallint(6), cell_n61 smallint(6), cell_n62 smallint(6), cell_n63 smallint(6), cell_n64 smallint(6), cell_n65 smallint(6), cell_n66 smallint(6), cell_n67 smallint(6), cell_n68 varchar(100), cell_n69 smallint(6), cell_b73 int(11), cell_g73 smallint(6), cell_g74 smallint(6), cell_h73 smallint(6), cell_i73 smallint(6), cell_i74 smallint(6), cell_m73 smallint(6), cell_n73 smallint(6), cell_n74 smallint(6), cell_o73 smallint(6), cell_g76 smallint(6), cell_i76 smallint(6), cell_n76 smallint(6), cell_g77 smallint(6), cell_i77 smallint(6), cell_n77 smallint(6), cell_g78 decimal(9,2), cell_i78 decimal(9,2), cell_n78 decimal(9,2), cell_g79 decimal(9,2), cell_i79 decimal(9,2), cell_n79 decimal(9,2), cell_g80 smallint(6), cell_i80 smallint(6), cell_n80 smallint(6), cell_g81 smallint(6), cell_i81 smallint(6), cell_n81 smallint(6), cell_g82 smallint(6), cell_i82 smallint(6), cell_n82 smallint(6), cell_g83 smallint(6), cell_i83 smallint(6), cell_n83 smallint(6), cell_g84 decimal(9,2), cell_i84 decimal(9,2), cell_n84 decimal(9,2), cell_b80 decimal(9,2), cell_b81 decimal(9,2), cell_b82 decimal(9,2), cell_b83 decimal(9,2), cell_b84 decimal(9,2), cell_b85 decimal(9,2), cell_b86 decimal(9,2), cell_b91 smallint(6), cell_b92 smallint(6), cell_b93 smallint(6), cell_e90 smallint(6), cell_e91 smallint(6), cell_e92 smallint(6), cell_e93 smallint(6), cell_e95 smallint(6), cell_e96 smallint(6), cell_e97 smallint(6), cell_f95 smallint(6), cell_f96 smallint(6), cell_f97 smallint(6), cell_i90 smallint(6), cell_i91 smallint(6), cell_i92 smallint(6), cell_i93 smallint(6), cell_i94 smallint(6), cell_c104 decimal(9,1), cell_c105 decimal(9,1), cell_c106 decimal(9,1), cell_c107 decimal(9,1), cell_c108 decimal(9,1), cell_c109 decimal(9,1), cell_d104 decimal(9,4), cell_d105 decimal(9,4), cell_d106 decimal(9,4), cell_d107 decimal(9,4), cell_d108 decimal(9,4), cell_d109 decimal(9,4), cell_e104 smallint(6), cell_e105 smallint(6), cell_e106 smallint(6), cell_e107 smallint(6), cell_e108 smallint(6), cell_e109 smallint(6), cell_f104 smallint(6), cell_f105 smallint(6), cell_f106 smallint(6), cell_f107 smallint(6), cell_f108 smallint(6), cell_f109 smallint(6), cell_g104 decimal(9,1), cell_g105 decimal(9,1), cell_g106 decimal(9,1), cell_g107 decimal(9,1), cell_g108 decimal(9,1), cell_g109 decimal(9,1), cell_h104 smallint(6), cell_h105 smallint(6), cell_h106 smallint(6), cell_h107 smallint(6), cell_h108 smallint(6), cell_h109 smallint(6), cell_i104 decimal(9,2), cell_i105 decimal(9,2), cell_i106 decimal(9,2), cell_i107 decimal(9,2), cell_i108 decimal(9,2), cell_i109 decimal(9,2), cell_m104 smallint(6), cell_m105 smallint(6), cell_m106 smallint(6), cell_m107 smallint(6), cell_m108 smallint(6), cell_m109 smallint(6), cell_n104 decimal(9,1), cell_n105 decimal(9,1), cell_n106 decimal(9,1), cell_n107 decimal(9,1), cell_n108 decimal(9,1), cell_n109 decimal(9,1), cell_o104 decimal(9,1), cell_o105 decimal(9,1), cell_o106 decimal(9,1), cell_o107 decimal(9,1), cell_o108 decimal(9,1), cell_o109 decimal(9,1), cell_c119 decimal(9,1), cell_c120 decimal(9,1), cell_c121 decimal(9,1), cell_c122 decimal(9,1), cell_c123 decimal(9,1), cell_c124 decimal(9,1), cell_d119 decimal(9,4), cell_d120 decimal(9,4), cell_d121 decimal(9,4), cell_d122 decimal(9,4), cell_d123 decimal(9,4), cell_d124 decimal(9,4), cell_e119 smallint(6), cell_e120 smallint(6), cell_e121 smallint(6), cell_e122 smallint(6), cell_e123 smallint(6), cell_e124 smallint(6), cell_f119 smallint(6), cell_f120 smallint(6), cell_f121 smallint(6), cell_f122 smallint(6), cell_f123 smallint(6), cell_f124 smallint(6), cell_g119 decimal(9,1), cell_g120 decimal(9,1), cell_g121 decimal(9,1), cell_g122 decimal(9,1), cell_g123 decimal(9,1), cell_g124 decimal(9,1), cell_h119 smallint(6), cell_h120 smallint(6), cell_h121 smallint(6), cell_h122 smallint(6), cell_h123 smallint(6), cell_h124 smallint(6), cell_i119 decimal(9,2), cell_i120 decimal(9,2), cell_i121 decimal(9,2), cell_i122 decimal(9,2), cell_i123 decimal(9,2), cell_i124 decimal(9,2), cell_m119 smallint(6), cell_m120 smallint(6), cell_m121 smallint(6), cell_m122 smallint(6), cell_m123 smallint(6), cell_m124 smallint(6), cell_n119 decimal(9,1), cell_n120 decimal(9,1), cell_n121 decimal(9,1), cell_n122 decimal(9,1), cell_n123 decimal(9,1), cell_n124 decimal(9,1), cell_o119 decimal(9,1), cell_o120 decimal(9,1), cell_o121 decimal(9,1), cell_o122 decimal(9,1), cell_o123 decimal(9,1), cell_o124 decimal(9,1), cell_c533 decimal(9,1), cell_c534 decimal(9,1), cell_c535 decimal(9,1), cell_c536 decimal(9,1), cell_c537 decimal(9,1), cell_c538 decimal(9,1), cell_d533 decimal(9,4), cell_d534 decimal(9,4), cell_d535 decimal(9,4), cell_d536 decimal(9,4), cell_d537 decimal(9,4), cell_d538 decimal(9,4), cell_e533 smallint(6), cell_e534 smallint(6), cell_e535 smallint(6), cell_e536 smallint(6), cell_e537 smallint(6), cell_e538 smallint(6), cell_f533 smallint(6), cell_f534 smallint(6), cell_f535 smallint(6), cell_f536 smallint(6), cell_f537 smallint(6), cell_f538 smallint(6), cell_g533 decimal(9,1), cell_g534 decimal(9,1), cell_g535 decimal(9,1), cell_g536 decimal(9,1), cell_g537 decimal(9,1), cell_g538 decimal(9,1), cell_h533 smallint(6), cell_h534 smallint(6), cell_h535 smallint(6), cell_h536 smallint(6), cell_h537 smallint(6), cell_h538 smallint(6), cell_i533 decimal(9,2), cell_i534 decimal(9,2), cell_i535 decimal(9,2), cell_i536 decimal(9,2), cell_i537 decimal(9,2), cell_i538 decimal(9,2), cell_m533 smallint(6), cell_m534 smallint(6), cell_m535 smallint(6), cell_m536 smallint(6), cell_m537 smallint(6), cell_m538 smallint(6), cell_n533 decimal(9,1), cell_n534 decimal(9,1), cell_n535 decimal(9,1), cell_n536 decimal(9,1), cell_n537 decimal(9,1), cell_n538 decimal(9,1), cell_o533 decimal(9,1), cell_o534 decimal(9,1), cell_o535 decimal(9,1), cell_o536 decimal(9,1), cell_o537 decimal(9,1), cell_o538 decimal(9,1) );
    
    MySQL said: Documentation
    #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 'cell_c40 smallint(6),
    cell_c41 smallint(6),
    cell_c42 smallint(6),
    cell_c43 s' at line 3
    Any ideas what could cause this?

  2. #2
    Utopia, Inc. silver trophy
    ScallioXTX's Avatar
    Join Date
    Aug 2008
    Location
    The Netherlands
    Posts
    8,897
    Mentioned
    138 Post(s)
    Tagged
    2 Thread(s)
    There is some weird character before "cell_40" (line 3).
    Rémon - Hosting Advisor

    Minimal Bookmarks Tree
    My Google Chrome extension: browsing bookmarks made easy


Bookmarks

Posting Permissions

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