AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   Input line is too long[Compile error] (https://forums.alliedmods.net/showthread.php?t=118279)

xbatista 02-09-2010 13:57

Input line is too long[Compile error]
 
PHP Code:

new const szTables[][] =  

    
"CREATE TABLE IF NOT EXISTS `d2_data` ( `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `player_data` varchar(4096) NOT NULL default '', `player_data2` varchar(4096) NOT NULL default '', `player_data3` varchar(4096) NOT NULL default '', PRIMARY KEY  (`player_name`, `player_ip`, `player_steamid`), KEY `player_data` (`player_data`), KEY `player_data2` (`player_data2`), KEY `player_data3` (`player_data3`) ) TYPE=MyISAM;"


I've try press 'enter' after ',' , no success "possibly non-terminated string"

ConnorMcLeod 02-09-2010 13:59

Re: Input line is too long[Compile error]
 
Use \

PHP Code:

new const szTables[][] =  

    
"CREATE TABLE IF NOT EXISTS `d2_data` ( `player_steamid` varchar(25) NOT NULL default '', \
    `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', \
    `player_data` varchar(4096) NOT NULL default '', `player_data2` varchar(4096) NOT NULL default '', \
    `player_data3` varchar(4096) NOT NULL default '', PRIMARY KEY  (`player_name`, `player_ip`, `player_steamid`), \
    KEY `player_data` (`player_data`), KEY `player_data2` (`player_data2`), KEY `player_data3` (`player_data3`) ) TYPE=MyISAM;"




But [][] tells that a 2 dimensions array follow, and you only put a 1 dimension array, so be carefull.

xbatista 02-09-2010 14:01

Re: Input line is too long[Compile error]
 
PHP Code:

new const szTables[][] =  

    
"CREATE TABLE IF NOT EXISTS `d2_data` ( `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `player_data` varchar(4096) NOT NULL default '', \
    `player_data2` varchar(4096) NOT NULL default '', `player_data3` varchar(4096) NOT NULL default '', PRIMARY KEY  (`player_name`, `player_ip`, `player_steamid`), KEY `player_data` (`player_data`), KEY `player_data2` (`player_data2`), \
    KEY `player_data3` (`player_data3`) ) TYPE=MyISAM;" 


Error: "input line too long" wtf?

Quote:

But [][] tells that a 2 dimensions array follow, and you only put a 1 dimension array, so be carefull.
It has worked, after I put more text to this array and at all it worked fine

SnoW 02-09-2010 14:42

Re: Input line is too long[Compile error]
 
You must format the string.

xbatista 02-09-2010 14:47

Re: Input line is too long[Compile error]
 
Ohh cmon I want to use it like is, new const szTables[][]

Arkshine 02-09-2010 14:52

Re: Input line is too long[Compile error]
 
Don't know why you have to format. Anyway try this :

Code:

new const gTableCreateQuery[] =
"                                                \
    CREATE TABLE IF NOT EXISTS `d2_data`        \
    (                                                \
        `player_steamid` VARCHAR(25) NOT NULL,        \
        `player_ip` VARCHAR(20) NOT NULL,            \
        `player_name` VARCHAR(35) NOT NULL,          \
        `player_data` VARCHAR(4096) NOT NULL,        \
        `player_data2` VARCHAR(4096) NOT NULL,        \
        `player_data3` VARCHAR(4096) NOT NULL,        \
        PRIMARY KEY(`player_name`,`player_ip`,`player_steamid`),\
        KEY `player_data` (`player_data`),            \
        KEY `player_data2` (`player_data2`),          \
        KEY `player_data3` (`player_data3`)          \
    ) TYPE=MyISAM;                                \
";


xbatista 02-10-2010 09:10

Re: Input line is too long[Compile error]
 
worked fine arky :gyar:

EDIT
: Something wrong in your string :
Quote:

L 02/10/2010 - 16:29:03: [diablo2LOD.amxx] [MYSQLX] 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 'KEY `player_data` (`player_data`), KEY `player_data2` (`player_data2`), KE' at line 1

stupok 02-10-2010 10:55

Re: Input line is too long[Compile error]
 
Read the error message. It's too long. Make it shorter, or do two separate queries.

Arkshine 02-10-2010 11:06

Re: Input line is too long[Compile error]
 
Quote:

Originally Posted by xbatista (Post 1084473)
worked fine arky :gyar:

EDIT
: Something wrong in your string :

Try again, I've forgot a ',' after `player_steamid`)

xbatista 02-10-2010 12:16

Re: Input line is too long[Compile error]
 
now works, no errors and creates the table, thanks


All times are GMT -4. The time now is 07:22.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.