Sourcemod Webadmin (Updated 12/05/2012) - Page 65

maxolahird · 03-02-2013 , 19:06 Re: Sourcemod Webadmin (Updated 12/05/2012)

help me !

Table 'impactcs_admin.smwa_server' doesn't exist

I get that when going to 'Server'

DGnetwork · *Last edited by DGnetwork; 04-02-2013 at 20:36.*

hello im running mysql 5.5.30 and smwa 2.1 final and im getting this syntax error. i believe its due to the version of mysql but my hosting provider will not update until all flaws are fixed. hopefuly someone can tell me how to fix it for the version i have. here is the error.

Code:

Query:

CREATE TABLE smwa_server(
ID            int(11) PRIMARY KEY auto_increment,
Ip               varchar(21) NOT NULL default '',
Name_Short    varchar(24) NOT NULL default '',
rcon             varchar(255) NOT NULL default '',
ftp_ip           varchar(255) NOT NULL default '',
ftp_username     varchar(255) NOT NULL default '',
ftp_pw           varchar(255) NOT NULL default '',
ftp_path         varchar(255) NOT NULL default '',
UNIQUE KEY (Ip)
)TYPE=MyISAM;

Antwort: 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 'TYPE=MyISAM' at line 11

Mallow · 05-12-2013 , 04:12 Re: Sourcemod Webadmin (Updated 12/05/2012)

For everyone getting the below errors, notices throughout the site (editing users, adding users, etc)

Quote:

Code:

Notice: Undefined index: UserPlugincontrol in /home/xxx/inc/function.php on line 1585

Then I get this one on the profile page:

Code:

Notice: Undefined index: UserPlugincontrol in /home/xxx/public_html/smod/user.php on line 269

Code:

Antwort: Unknown column 'UserPlugincontrol' in 'field list'

Simply execute this query into your table:

Code:

ALTER TABLE  `smwa_users` ADD  `UserPlugincontrol` INT( 1 ) NULL

If you changed the prefix (smwa), you will need to adjust this accordingly. Hope this helps.

DGNetwork, you are missing a Unique Key name.

Change

Code:

UNIQUE KEY (Ip)

to

Code:

UNIQUE KEY Ip (Ip)

alexys95 · 06-05-2013 , 13:26 Re: Sourcemod Webadmin (Updated 12/05/2012)

I got a weird problem, the web interface works perfectly untill I add a server, then it just hangs. the index.php page wont load at all. Anyone got any idea how to fix this?

Tried booth 2.1 and 2.2 with fix...

Thanks!

erroler · 08-19-2013 , 18:16 Re: Sourcemod Webadmin (Updated 12/05/2012)

I get this error when trying to open the chatlogex trough sourcemod web admin:

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 '0' at line 1

Jumpman · *Last edited by Jumpman; 10-09-2013 at 14:09.*

Quote:

Originally Posted by DGnetwork

hello im running mysql 5.5.30 and smwa 2.1 final and im getting this syntax error. i believe its due to the version of mysql but my hosting provider will not update until all flaws are fixed. hopefuly someone can tell me how to fix it for the version i have. here is the error.

Code:

Query:
 
CREATE TABLE smwa_server(
ID            int(11) PRIMARY KEY auto_increment,
Ip               varchar(21) NOT NULL default '',
Name_Short    varchar(24) NOT NULL default '',
rcon             varchar(255) NOT NULL default '',
ftp_ip           varchar(255) NOT NULL default '',
ftp_username     varchar(255) NOT NULL default '',
ftp_pw           varchar(255) NOT NULL default '',
ftp_path         varchar(255) NOT NULL default '',
UNIQUE KEY (Ip)
)TYPE=MyISAM;
 
Antwort: 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 'TYPE=MyISAM' at line 11

Think you have same problem like me, maybe it's be cource of the mysql version but i change everthing i setup.php

From:
TYPE=MyISAM
To
ENGINE=MyISAM

This Works for me

maxolahird · 12-05-2013 , 11:08 Re: Sourcemod Webadmin (Updated 12/05/2012)

There is a problem with this... if someone (In this case, me) has different databases for each plugin... 3rd party plugins won't work at all as the table MUST be in the same database as Sourcemod Webadmin is.... can you make us able to choose which database the table of the plugin is?

OddworldCrash · 01-16-2014 , 07:32 Re: Sourcemod Webadmin (Updated 12/05/2012)

[QUOTE=alexys95;1965170]I got a weird problem, the web interface works perfectly untill I add a server, then it just hangs. the index.php page wont load at all. Anyone got any idea how to fix this?
[QUOTE]

^ I have the same problem.

excalibur · 01-16-2014 , 08:01 Re: Sourcemod Webadmin (Updated 12/05/2012)

check you webserver logs, you might get your answer there

amirdiya · 01-22-2014 , 06:14 Re: Sourcemod Webadmin (Updated 12/05/2012)

For install i don,t know any things of
1. Create a new mysql database. Ex:admin
2. Import "create_admins" from "addons/sourcemod/configs/sql-init-scripts/mysql" to the database
3. Edit "databases.cfg" in "addons/sourcemod/configs" on your gameserver.
4. Upload all files to your web server to a folder of your choice.
5. Open the file "../inc/config.php" and change the data to your MySQL Database.
6. Run the "../setup.php" in your Web browser.
7. Set the "../temp" directory to "Chmod 777".
8. Set the "../inc/pics/games" directory to "Chmod 777".
9. Delete the file "../setup.php" on your web server!
10. Open the Web interface "../index.php" on your Web browser.
11. Login with...
Username: admin
Password: 123456

please make a video and see all thing to me