[HELP]MySQL
#1

Hello there I have just recently changed my [GM] to QBase with MySQL and when I run my server and I join the server shuts down and close's. And when I go into the server.log this is what I get.

Код:
[11:04:18] Error in mysql_query: Table 'samp.players' doesn't exist
[11:04:18] Error in mysql_store_result: Table 'samp.players' doesn't exist


Please help me.
Reply
#2

Quote:
Originally Posted by Jake Canfield
Hello there I have just recently changed my [GM] to QBase with MySQL and when I run my server and I join the server shuts down and close's. And when I go into the server.log this is what I get.

Код:
[11:04:18] Error in mysql_query: Table 'samp.players' doesn't exist
[11:04:18] Error in mysql_store_result: Table 'samp.players' doesn't exist


Please help me.
You didnt create your tables. In the database
Reply
#3

Quote:
Originally Posted by Compton's Eazy E
Quote:
Originally Posted by Jake Canfield
Hello there I have just recently changed my [GM] to QBase with MySQL and when I run my server and I join the server shuts down and close's. And when I go into the server.log this is what I get.

Код:
[11:04:18] Error in mysql_query: Table 'samp.players' doesn't exist
[11:04:18] Error in mysql_store_result: Table 'samp.players' doesn't exist


Please help me.
You didnt create your tables. In the database
On the xampp.com thing?
Reply
#4

Quote:
Originally Posted by Jake Canfield
Quote:
Originally Posted by Compton's Eazy E
Quote:
Originally Posted by Jake Canfield
Hello there I have just recently changed my [GM] to QBase with MySQL and when I run my server and I join the server shuts down and close's. And when I go into the server.log this is what I get.

Код:
[11:04:18] Error in mysql_query: Table 'samp.players' doesn't exist
[11:04:18] Error in mysql_store_result: Table 'samp.players' doesn't exist


Please help me.
You didnt create your tables. In the database
On the xampp.com thing?
I use Wamp so I don't know much about xampp. You should create the tables in the Phpmyadmin
Reply
#5

Quote:
Originally Posted by Compton's Eazy E
Quote:
Originally Posted by Jake Canfield
Quote:
Originally Posted by Compton's Eazy E
Quote:
Originally Posted by Jake Canfield
Hello there I have just recently changed my [GM] to QBase with MySQL and when I run my server and I join the server shuts down and close's. And when I go into the server.log this is what I get.

Код:
[11:04:18] Error in mysql_query: Table 'samp.players' doesn't exist
[11:04:18] Error in mysql_store_result: Table 'samp.players' doesn't exist


Please help me.
You didnt create your tables. In the database
On the xampp.com thing?
I use Wamp so I don't know much about xampp. You should create the tables in the Phpmyadmin
So in my database samp i create a table mysql_query and mysql_store_result then add samp.players in there?
Reply
#6

No you need to learn how to code MYSQL, ex: Makeing Tables and making player files etc...
Reply
#7

Quote:
Originally Posted by Compton's Eazy E
No you need to learn how to code MYSQL, ex: Makeing Tables and making player files etc...
Ermm how exactly can I do that to figure out how to? This is very complicated for me. It's making me mad
Reply
#8

Quote:
Originally Posted by Jake Canfield
Quote:
Originally Posted by Compton's Eazy E
No you need to learn how to code MYSQL, ex: Makeing Tables and making player files etc...
Ermm how exactly can I do that to figure out how to? This is very complicated for me. It's making me mad
lol so much angry faces :P. Look through a mysql database and learn from the code, like I did.
Reply
#9

Quote:
Originally Posted by Compton's Eazy E
Quote:
Originally Posted by Jake Canfield
Quote:
Originally Posted by Compton's Eazy E
No you need to learn how to code MYSQL, ex: Makeing Tables and making player files etc...
Ermm how exactly can I do that to figure out how to? This is very complicated for me. It's making me mad
lol so much angry faces :P. Look through a mysql database and learn from the code, like I did.
Alright man thanks for the help!
Reply
#10

Quote:
Originally Posted by Jake Canfield
Quote:
Originally Posted by Compton's Eazy E
Quote:
Originally Posted by Jake Canfield
Quote:
Originally Posted by Compton's Eazy E
No you need to learn how to code MYSQL, ex: Makeing Tables and making player files etc...
Ermm how exactly can I do that to figure out how to? This is very complicated for me. It's making me mad
lol so much angry faces :P. Look through a mysql database and learn from the code, like I did.
Alright man thanks for the help!
Here learn from this code I made for my old DM server.

Код:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows).
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;# MySQL returned an empty result set (i.e. zero rows).
/*!40103 SET TIME_ZONE='+00:00' */;# MySQL returned an empty result set (i.e. zero rows).
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;# MySQL returned an empty result set (i.e. zero rows).
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;# MySQL returned an empty result set (i.e. zero rows).
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;# MySQL returned an empty result set (i.e. zero rows).
DROP TABLE IF EXISTS `players`;# MySQL returned an empty result set (i.e. zero rows).

SET @saved_cs_client   = @@character_set_client;# MySQL returned an empty result set (i.e. zero rows).

SET character_set_client = utf8;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE `players` (
 `id` int(11) NOT NULL auto_increment,
 `Name` varchar(50) collate latin1_general_ci NOT NULL,
 `Password` varchar(50) character set latin1 collate latin1_bin NOT NULL,
 `Level` int(11) NOT NULL default '1',
 `AdminLevel` int(11) NOT NULL default '0',
 `Moderator` int(11) NOT NULL default '0',
 `Cash` bigint(20) NOT NULL default '5000',
 `Muted` int(11) NOT NULL default '0',
 `VIP` int(11) NOT NULL default '0',
`Exp` int(11) NOT NULL default '0',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;# MySQL returned an empty result set (i.e. zero rows).

SET character_set_client = @saved_cs_client;# MySQL returned an empty result set (i.e. zero rows).


/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;# MySQL returned an empty result set (i.e. zero rows).


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;# MySQL returned an empty result set (i.e. zero rows).

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;# MySQL returned an empty result set (i.e. zero rows).

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;# MySQL returned an empty result set (i.e. zero rows).
Lol it looks like a bunch a letters I know but just try your best to learn from that like I did :P
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)