[Landon]

Good day SAMP'ers,

I am now having a script, but when I try to host the .sql I get the following error:

Код:

SQL-query:

-- ----------------------------
-- Table structure for baseproducts
-- ----------------------------
CREATE TABLE `baseproducts` Roxt(
`prodid` int( 11 ) NOT NULL ,
`name` varchar( 15 ) COLLATE latin1_general_ci NOT NULL ,
`typeid` int( 11 ) NOT NULL ,
`typeid2` int( 11 ) NOT NULL ,
`baseprice` int( 11 ) NOT NULL ,
`unitquantity` int( 11 ) NOT NULL ,
`maxallowedshop` int( 11 ) NOT NULL ,
`currentprice` int( 11 ) NOT NULL ,
`priceflex` int( 11 ) NOT NULL ,
`available` int( 11 ) NOT NULL ,
`genpertick` int( 11 ) NOT NULL ,
`maxfactory` int( 11 ) NOT NULL ,
`maxallowedtruck` int( 11 ) NOT NULL ,
PRIMARY KEY ( `prodid` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci;

MySQL retourneerde: Documentatie
#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 'Roxt (
 `prodid` int(11) NOT NULL,
 `name` varchar(15) collate latin1_genera' at line 1

Does anyone know how to fix this? I am prepaired to pay the one who know how to fix this.

Thanks.

[Peter_Corneile]

As far as i am concerned , i dont even know the 'M' of MySQL ..

[brett7]

SQL is the standard the "My" bit is just a trade mark ^

[Peter_Corneile]

I have seen many people using MySQL but i never thought of or did use it .. I just want to stick with PAWNO

[Silent314]

Remove the "Roxt" from " CREATE TABLE `baseproducts` Roxt( " and try, so it's:

Код:

CREATE TABLE `baseproducts` (

[dougbrowne]

Quote:

Originally Posted by ►►►Peter Corneile◄◄◄ I have seen many people using MySQL but i never thought of or did use it .. I just want to stick with PAWNO

PAWNO is a programming language, MySQL is a database software. PAWNO = The gamemode code, MYSQL = Where the gamemode would store it's data. MySQL is very good for servers which require a lot of dynamic data to be stored like some RP scripts.

[Peter_Corneile]

Quote:

Originally Posted by dougbrowne Quote: Originally Posted by ►►►Peter Corneile◄◄◄ I have seen many people using MySQL but i never thought of or did use it .. I just want to stick with PAWNO PAWNO is a programming language, MySQL is a database software. PAWNO = The gamemode code, MYSQL = Where the gamemode would store it's data. MySQL is very good for servers which require a lot of dynamic data to be stored like some RP scripts.

Ahh kk .. But still i dont know anything about it xD

[Landon]

Quote:

Originally Posted by Gabe Remove the "Roxt" from " CREATE TABLE `baseproducts` Roxt( " and try, so it's: Код: CREATE TABLE `baseproducts` (

When I do that I get the next message:

Код:

SQL-query:

INSERT INTO `groups_permissions`
VALUES (
'3', '1', '3'sdad2241
);

MySQL retourneerde: Documentatie
#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 'sdad2241)' at line 1

[Silent314]

It looks like you have a bunch of text that just shouldn't be there. Remove "sdad2241" from that line.