MysQL problem
#1

I hosted my server. When i tried to connect , i can't see the onplayerequestclass and when i press spawn i'm getting spawned into the air ... Login / register / load statistics isn't working... but on server logs it says that everything's okay...

I have libmysql.dll usfowner (SQL file) ~> I don't know if something wrong with these or something that i don't know. I have to upload these files to the Host? or what?


+ I tried to upload these files using phpmyadmin but i get these errors

For the usfowner:

--
-- Database: `usfowner`
--
-- --------------------------------------------------------
--
-- Table structure for table `tehachievementz1351`
--
CREATE TABLE IF NOT EXISTS `tehachievementz1351` (

`Username` VARCHAR( 24 ) NOT NULL ,
`Ach1` INT( 11 ) NOT NULL ,
`Ach2` INT( 11 ) NOT NULL ,
`Ach3` INT( 11 ) NOT NULL ,
`Ach4` INT( 11 ) NOT NULL ,
`Ach5` INT( 11 ) NOT NULL ,
`Ach6` INT( 11 ) NOT NULL ,
`Ach7` INT( 11 ) NOT NULL ,
`Ach8` INT( 11 ) NOT NULL ,
`AchsCompleted` INT( 11 ) NOT NULL
) ENGINE = INNODB DEFAULT CHARSET = latin1;

Η MySQL returned this message:

------------------------------------
And for the libmysql.dll i get this message:

Wrong
Command SQL:

[...]

MySQL returned this message:

#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 'MZ?' at line 1

#1046 - No database selected





Please help me , i don't know anything about MySQL
Reply
#2

Someone
Reply
#3

NOONE?
Reply
#4

The SQL file should be imported using your database administration script. A script as adminer or phpMyAdmin.

The error you are getting is that you haven't specified a database to connect to in your script.
Reply
#5

And how to do that?
Reply
#6

I suggest reading through the plugin api here: https://sampwiki.blast.hk/wiki/MySQL/R33

Also, the specific command is here: https://sampwiki.blast.hk/wiki/MySQL/R33#mysql_connect

At the top of the page is a link to a tutorial. You might want to read that as well.
Reply
#7

I can't understand shit
Reply
#8

I need someone to do it , using teamviewer
Reply
#9

Someone?
Reply
#10

Where did you get your GM if you don't know nothing about MySQL?
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)