Raised This Month: $261 Target: $400
 65% 

Notices

SuperHero MySQL save


Post New Thread Reply   
 
Thread Tools Display Modes
swapped
BANNED
Join Date: Mar 2014
Location: OrpheuRegisterHook
Old 05-13-2014 , 04:31   Re: SuperHero MySQL save
Reply With Quote #11

this is the spam thread or what?
swapped is offline
Krillin
Senior Member
Join Date: Jul 2004
Old 05-31-2014 , 12:52   Re: SuperHero MySQL save
Reply With Quote #12

Quote:
L 05/04/2014 - 00:21:25: [superheromodmysql.amxx] DEBUG: MySQL connect error: [2002] 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' (,,)
Looks like your MySQL host is not set up right?

Give us some information to go on here? Where is your MySQL Host and Game Server? What is Linux and or Windows? This make a very big difference in resolving your connection issues. Steps you have tried to do to resolve this issue. Etc. It is not as complicated as it sounds, but could make or break your setup. Like "sh_mysql_host "localhost"" for Linux doesn't work correctly, it needs to be "sh_mysql_host "127.0.0.1"" but the host file binds localhost to 127.0.1.1 and needs to be edited.

Best Regards,
Krillin
__________________
Krillin's World Server(s) Operator


Last edited by Krillin; 05-31-2014 at 12:58.
Krillin is offline
Send a message via Yahoo to Krillin
DOG09
Member
Join Date: Feb 2011
Old 08-28-2014 , 07:41   Re: SuperHero MySQL save
Reply With Quote #13

Quote:
Originally Posted by Krillin View Post
Looks like your MySQL host is not set up right?

Give us some information to go on here? Where is your MySQL Host and Game Server? What is Linux and or Windows? This make a very big difference in resolving your connection issues. Steps you have tried to do to resolve this issue. Etc. It is not as complicated as it sounds, but could make or break your setup. Like "sh_mysql_host "localhost"" for Linux doesn't work correctly, it needs to be "sh_mysql_host "127.0.0.1"" but the host file binds localhost to 127.0.1.1 and needs to be edited.

Best Regards,
Krillin
I'm using localhost and i get error like:
Code:
#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 '(14) NOT NULL,
    `XP` int(10) unsigned NOT NULL default '0',
    `HUDHELP` t' at line 4
I know that there is needed to update tabels but i'am newbie so i don't know what to change and superheromysql.inc needed to change too...
DOG09 is offline
Krillin
Senior Member
Join Date: Jul 2004
Old 05-21-2015 , 20:45   Re: SuperHero MySQL save
Reply With Quote #14

Check your SuperHero Database permissions for the user you used in the superheromysql.inc configuration.

Sorry we closed our SHM servers in December so I really have nothing to relate to.

Provide the information we require or this will not go anywhere.

What are you hosting the server on? Linux or Windows if Linux you cannot use LOCALHOST as the host you have to use 127.0.0.1 or 127.0.1.1 (depending if you edited the HOST file in ./etc folder).
Is the Database on the same computer?
What versions are you running?

Without this information it is pointless.

Best Regards,
Krillin
__________________
Krillin's World Server(s) Operator


Last edited by Krillin; 05-21-2015 at 20:50. Reason: Linux hint
Krillin is offline
Send a message via Yahoo to Krillin
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

Forum Jump


All times are GMT -4. The time now is 08:43.


Powered by vBulletin®
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Theme made by Freecode