SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 04/11/2016, 01:39 PM   #1
Darkers
Little Clucker
 
Join Date: Nov 2016
Posts: 17
Reputation: 0
Default MYSQL Help!

When I hosted my server via my PC with xampp, it work fine but when I host my server to be online and setup mysql as I do with xampp, it doesn't work like I want it to work.

Heres the different between XAMPP and the host mysql (every host I tried is just same)

Code:
MYSQL from XAMPP (MY PC) - http://pastebin.com/yTEpkQE3

MYSQL from Every SAMP Host - http://pastebin.com/Y5ng7WED
__________________
Unruly Roleplay
Unruly Roleplay is a Roleplay server which contains a very dynamic and unique features!
This server is also made from scratch! This server has been opened about few hours ago! Let's check it out!
Also, hiring admins, mappers and server promoters!

Server IP Address : 173.213.69.120:7777 | Website: unrulyrp.tk
Darkers is offline   Reply With Quote
Old 04/11/2016, 02:07 PM   #2
Sithis
Gangsta
 
Join Date: Mar 2013
Location: the Netherlands
Posts: 887
Reputation: 79
Default Re: MYSQL Help!

Clearly your tables don't exist, or you are connecting to the wrong database.
__________________
Developer and owner of https://trinityrpg.com
Sithis is offline   Reply With Quote
Old 04/11/2016, 02:17 PM   #3
Vince
Spam Machine
 
Vince's Avatar
 
Join Date: Sep 2007
Location: Belgium
Posts: 10,083
Reputation: 2655
Default Re: MYSQL Help!

This is the fourth topic in as many days about the exact same issue
http://forum.sa-mp.com/showthread.ph...ghlight=HQInfo
http://forum.sa-mp.com/showthread.ph...ghlight=HQInfo
http://forum.sa-mp.com/showthread.ph...57#post3791657

Go to that gamemode's topic and tell them to fix their SQL script.
__________________
Vince is offline   Reply With Quote
Old 04/11/2016, 02:38 PM   #4
Darkers
Little Clucker
 
Join Date: Nov 2016
Posts: 17
Reputation: 0
Default Re: MYSQL Help!

Quote:
Originally Posted by Sithis View Post
Clearly your tables don't exist, or you are connecting to the wrong database.
I don't think it's connected to the wrong database nor the tables doesn't exist because it work fine in my windows.

Quote:
Originally Posted by Vince View Post
Tables names may or may not be case sensitive. This is usually not a problem on a Windows machine but Linux handles things differently and importing a database dump from a Windows machine in a Linux machine may cause trouble (experienced this myself).

What you should do, if possible, is edit the .sql file so the table names in there match the table names in your script.
What do you mean by here?
__________________
Unruly Roleplay
Unruly Roleplay is a Roleplay server which contains a very dynamic and unique features!
This server is also made from scratch! This server has been opened about few hours ago! Let's check it out!
Also, hiring admins, mappers and server promoters!

Server IP Address : 173.213.69.120:7777 | Website: unrulyrp.tk
Darkers is offline   Reply With Quote
Old 05/11/2016, 06:04 AM   #5
Darkers
Little Clucker
 
Join Date: Nov 2016
Posts: 17
Reputation: 0
Default Re: MYSQL Help!

EDIT: Fixed, thanks Vince! Now I fully understand why!
__________________
Unruly Roleplay
Unruly Roleplay is a Roleplay server which contains a very dynamic and unique features!
This server is also made from scratch! This server has been opened about few hours ago! Let's check it out!
Also, hiring admins, mappers and server promoters!

Server IP Address : 173.213.69.120:7777 | Website: unrulyrp.tk

Last edited by Darkers; 05/11/2016 at 07:41 AM.
Darkers is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Plugin r39-2 Error: Can't connect to local MySQL server through socket Emre__ Scripting Help 10 30/07/2014 09:26 AM
[Tutorial] [VIDEO] MySQL ORM r38: How to pair GM with MySQL & creation of registration/connection system cArnasLT Tutorials 3 19/05/2014 03:08 PM
BlueG MySQL plugin - Failed (plugins/mysql.so: undefined symbol: _Z13stringvprintfPKcPc) linuxthefish Plugin Development 10 13/07/2013 11:56 AM
[Tool/Web/Other] MySQL DB Manager - Easily manage your MySQL databases with this remote application fiki574 Tools and Files 13 22/07/2012 10:41 AM


All times are GMT. The time now is 06:26 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.