1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Mysql 075 Error input line too long
Venice
Banned
Posts: 914
Threads: 118
Joined: Nov 2010
#1

29.09.2011, 22:17
( Last edited by Venice; 30/09/2011 at 08:19 AM. )
ok, i get the errors what thay mean How to fix it ?
pawn Code:
mysql_connect(mysql_host,mysql_user,mysql_database,mysql_password);
    mysql_query(
            "CREATE TABLE IF NOT EXISTS `Accounts` ("\
              "`AccID` int(10) NOT NULL AUTO_INCREMENT,"\
              "`Username` varchar(24) NOT NULL,"\
              "`Password` varchar(64) NOT NULL,"\
              "`IP` varchar(16) NULL,"\
              "`Money` int(15) NULL,"\
              "`Score` int(15) NULL,"\
              "`Kills` int(15) NULL,"\
              "`Deaths` int(15) NULL,"\
              "`Admin` int(15) NULL,"\
              "`Donator` int(15) NULL,"\
              "`Plantedbombs` int(15) NULL,"\
              "`Defusedbombs` int(15) NULL,"\
              "`Banned` int(15) NULL,"\
              "`Banneddate` varchar(16) NULL,"\
              "`BannedReason` varchar(64) NULL,"\
              "`Bannedby` varchar(24) NULL,"\
              "PRIMARY KEY (`AccID`)"\
            ") ENGINE=InnoDB DEFAULT CHARSET=latin1;");
pawn Code:
C:\Users\Robust\Documents\My Received Files\swat.pwn(4067 -- 4083) : error 075: input line too long (after substitutions)
C:\Users\Robust\Documents\My Received Files\swat.pwn(4084) : warning 215: expression has no effect
C:\Users\Robust\Documents\My Received Files\swat.pwn(4084) : error 001: expected token: ";", but found "`"
C:\Users\Robust\Documents\My Received Files\swat.pwn(4084) : error 029: invalid expression, assumed zero
C:\Users\Robust\Documents\My Received Files\swat.pwn(4084) : error 017: undefined symbol "Bannedby"
C:\Users\Robust\Documents\My Received Files\swat.pwn(4084) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664          Copyright (c) 1997-2006, ITB CompuPhase


5 Errors.
Find
Reply
Lorenc_
High-roller
*****
Posts: 3,793
Threads: 196
Joined: Jan 2010
Reputation: 0
#2

30.09.2011, 08:21
You're exceeding the limit into the string you're trying to input as a query; meaning you may need to do this manually or make a string and then copy each part bit by bit.
Find
Reply
[MWR]Blood
High-roller
*****
Posts: 2,268
Threads: 89
Joined: Apr 2009
Reputation: 0
#3

30.09.2011, 10:53
pawn Code:
format(Query,sizeof Query," mysql_query(
            "CREATE TABLE IF NOT EXISTS `Accounts` ("\
              "`AccID` int(10) NOT NULL AUTO_INCREMENT,"\
              "`Username` varchar(24) NOT NULL,"\
              "`Password` varchar(64) NOT NULL,"\
              "`IP` varchar(16) NULL,"\
              "`Money` int(15) NULL,"\
              "`Score` int(15) NULL,"\
              "`Kills` int(15) NULL,"\
              "`Deaths` int(15) NULL,"\
              "`Admin` int(15) NULL,"\
              "`Donator` int(15) NULL,"\
              "`Plantedbombs` int(15) NULL,"\
              "`Defusedbombs` int(15) NULL,"\
              "`Banned` int(15) NULL,"\
              "`Banneddate` varchar(16) NULL,"\
              "`BannedReason` varchar(64) NULL,"\
              "`Bannedby` varchar(24) NULL,"\
              "PRIMARY KEY (`AccID`)"\
            ") ENGINE=InnoDB DEFAULT CHARSET=latin1;");
mysql_query(Query);
If this doesn't work, then use strcat.
Find
Reply
Venice
Banned
Posts: 914
Threads: 118
Joined: Nov 2010
#4

30.09.2011, 12:51
Not working same errors

Example strcat ?
Find
Reply
iggy1
High-roller
*****
Posts: 2,421
Threads: 52
Joined: Mar 2009
Reputation: 0
#5

30.09.2011, 12:53
Quote:
Originally Posted by [MWR]Blood
View Post
pawn Code:
format(Query,sizeof Query," mysql_query(
            "CREATE TABLE IF NOT EXISTS `Accounts` ("\
              "`AccID` int(10) NOT NULL AUTO_INCREMENT,"\
              "`Username` varchar(24) NOT NULL,"\
              "`Password` varchar(64) NOT NULL,"\
              "`IP` varchar(16) NULL,"\
              "`Money` int(15) NULL,"\
              "`Score` int(15) NULL,"\
              "`Kills` int(15) NULL,"\
              "`Deaths` int(15) NULL,"\
              "`Admin` int(15) NULL,"\
              "`Donator` int(15) NULL,"\
              "`Plantedbombs` int(15) NULL,"\
              "`Defusedbombs` int(15) NULL,"\
              "`Banned` int(15) NULL,"\
              "`Banneddate` varchar(16) NULL,"\
              "`BannedReason` varchar(64) NULL,"\
              "`Bannedby` varchar(24) NULL,"\
              "PRIMARY KEY (`AccID`)"\
            ") ENGINE=InnoDB DEFAULT CHARSET=latin1;");
mysql_query(Query);
If this doesn't work, then use strcat.
That doesn't work all that does is carry the string to the next line (but its the same line really and wont remove the error). You will need to use strcat/format or do several queries.
Find
Reply
Raimis_R
Huge Clucker
****
Posts: 398
Threads: 11
Joined: Nov 2010
Reputation: 0
#6

30.09.2011, 12:57
Something like:

pawn Code:
new Query[ Size ];

strcat(Query, "mysql_query(CREATE TABLE IF NOT EXISTS `Accounts` (\
                `AccID` int(10) NOT NULL AUTO_INCREMENT,\
                `Username` varchar(24) NOT NULL,\
                `Password` varchar(64) NOT NULL,\
                `IP` varchar(16) NULL,\
                `Money` int(15) NULL,\
                `Score` int(15) NULL,\
                `Kills` int(15) NULL,\");
              
strcat(Query, "`Deaths` int(15) NULL,\
              `Admin` int(15) NULL,\
              `Donator` int(15) NULL,\
              `Plantedbombs` int(15) NULL,\
              `Defusedbombs` int(15) NULL,\
              `Banned` int(15) NULL,\
              `Banneddate` varchar(16) NULL,\
              `BannedReason` varchar(64) NULL,\
              `Bannedby` varchar(24) NULL,\
              PRIMARY KEY (`AccID`)\
            ) ENGINE=InnoDB DEFAULT CHARSET=latin1;");
            
mysql_query(Query);
Find
Reply
Venice
Banned
Posts: 914
Threads: 118
Joined: Nov 2010
#7

30.09.2011, 12:59
errors

Code:
C:\Users\Robust\Documents\My Received Files\swat.pwn(4068) : error 037: invalid string (possibly non-terminated string)
C:\Users\Robust\Documents\My Received Files\swat.pwn(4068 -- 4076) : error 001: expected token: "-string end-", but found "-identifier-"
C:\Users\Robust\Documents\My Received Files\swat.pwn(4076) : warning 215: expression has no effect
C:\Users\Robust\Documents\My Received Files\swat.pwn(4076) : error 001: expected token: ";", but found ")"
C:\Users\Robust\Documents\My Received Files\swat.pwn(4076) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


4 Errors.
Find
Reply
Raimis_R
Huge Clucker
****
Posts: 398
Threads: 11
Joined: Nov 2010
Reputation: 0
#8

30.09.2011, 13:01
Mmm

pawn Code:
new Query[ Size ];

strcat(Query, "mysql_query(CREATE TABLE IF NOT EXISTS `Accounts` (\
                `AccID` int(10) NOT NULL AUTO_INCREMENT,\
                `Username` varchar(24) NOT NULL,\
                `Password` varchar(64) NOT NULL,\
                `IP` varchar(16) NULL,\
                `Money` int(15) NULL,\
                `Score` int(15) NULL,\
                `Kills` int(15) NULL");
              
strcat(Query, ",\`Deaths` int(15) NULL,\
              `Admin` int(15) NULL,\
              `Donator` int(15) NULL,\
              `Plantedbombs` int(15) NULL,\
              `Defusedbombs` int(15) NULL,\
              `Banned` int(15) NULL,\
              `Banneddate` varchar(16) NULL,\
              `BannedReason` varchar(64) NULL,\
              `Bannedby` varchar(24) NULL,\
              PRIMARY KEY (`AccID`)\
            ) ENGINE=InnoDB DEFAULT CHARSET=latin1;");
            
mysql_query(Query);
Find
Reply
Venice
Banned
Posts: 914
Threads: 118
Joined: Nov 2010
#9

30.09.2011, 13:11
Code:
C:\Users\Robust\Documents\My Received Files\swat.pwn(4087) : error 027: invalid character constant
C:\Users\Robust\Documents\My Received Files\swat.pwn(4087) : error 027: invalid character constant
C:\Users\Robust\Documents\My Received Files\swat.pwn(295) : warning 204: symbol is assigned a value that is never used: "Killit"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


2 Errors.
in this line

Code:
) ENGINE=InnoDB DEFAULT CHARSET=latin1;");
Find
Reply
Raimis_R
Huge Clucker
****
Posts: 398
Threads: 11
Joined: Nov 2010
Reputation: 0
#10

30.09.2011, 13:15
pawn Code:
new Query[ size ];

        strcat(Query, "mysql_query(CREATE TABLE IF NOT EXISTS `Accounts` (\
                        `AccID` int(10) NOT NULL AUTO_INCREMENT,\
                        `Username` varchar(24) NOT NULL,\
                        `Password` varchar(64) NOT NULL,\
                        `IP` varchar(16) NULL,\
                        `Money` int(15) NULL,\
                        `Score` int(15) NULL,\
                        `Kills` int(15) NULL,");

        strcat(Query, "`Deaths` int(15) NULL,\
                      `Admin` int(15) NULL,\
                      `Donator` int(15) NULL,\
                      `Plantedbombs` int(15) NULL,\
                      `Defusedbombs` int(15) NULL,\
                      `Banned` int(15) NULL,\
                      `Banneddate` varchar(16) NULL,\
                      `BannedReason` varchar(64) NULL,\
                      `Bannedby` varchar(24) NULL,\
                      PRIMARY KEY (`AccID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;");

        mysql_query(Query);
Find
Reply
Venice
Banned
Posts: 914
Threads: 118
Joined: Nov 2010
#11

30.09.2011, 13:19
work thanks +Rep
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help