MysQL problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MysQL problem (/showthread.php?tid=578045)

---

MysQL problem - Pro_Drifter - 16.06.2015

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

---

Re: MysQL problem - Pro_Drifter - 16.06.2015

Someone

---

Re: MysQL problem - Pro_Drifter - 16.06.2015

NOONE?

---

Re: MysQL problem - mamorunl - 16.06.2015

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.

---

Re: MysQL problem - Pro_Drifter - 16.06.2015

And how to do that?

---

Re: MysQL problem - mamorunl - 16.06.2015

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.

---

Re: MysQL problem - Pro_Drifter - 16.06.2015

I can't understand shit

---

Re: MysQL problem - Pro_Drifter - 16.06.2015

I need someone to do it , using teamviewer

---

Re: MysQL problem - Pro_Drifter - 16.06.2015

Someone?

---

Re: MysQL problem - Matess - 16.06.2015

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

---