Jump to content

Archived

This topic is now archived and is closed to further replies.

  • 0
B1untSpecialist

Adkats SQL Script Errors

Question

Hi, I'm new to setting up adkats, and am trying to setup my clan's new DB with the adkats script, but am not exactly sure if I am doing this right. Maybe I've screwed up, not sure. 

This is what I 've done so far. I made sure that I had the stat logger runing, and the DB was fresh and clean before i did so. I saw the tables in the left pan in my php admin interface. I then couldn't figure out where to paste and run the script that is provided, and read somewhere that you can just upload the .sql file to your DB. So I selected my DB name in the left pane, then selected import tab, and browsed to adkats.sql, and selected it, and hit go. I then got this error:
 

Error

SQL query:

 

REPLACE INTO `adkats_commands` VALUES(144, 'Invisible', 'player_challenge_complete', 'Log', 'Player Completed Challenge', 'challengecomplete', TRUE, 'Any')

DROP TABLE IF EXISTS `adkats_infractions_global`

 

I'm not sure what i did wrong, or what to do to fix it. Please help, I got a whole clan of buttholes asking whats taking me so long LMFAO..

 

MySQL said: dot.gif

#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 'DROP TABLE IF EXISTS `adkats_infractions_global`' at line 3

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

Solved in BF4DB discord. An outdated Adkats.sql file in the zip.

 

https://raw.githubusercontent.com/AdKats/AdKats/master/adkats.sql


The developer of the Battlefield Admin Control Panel (BFACP)

For BFACP support please post in the BFACP topic linked above.

Do not contact me via PM on the forums for help with procon. Please make a topic for it. Only PM's I will accept will revolve around any website issues.

Air VPN - The air to breathe the real Internet

Share this post


Link to post
Share on other sites

Also, in the import tab, before I uploaded anything I got this error/warning, but disregarded it, and just tried to upload the .sql file.

Warning in ./libraries/plugin_interface.lib.php#551
dot.gif count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/display_import.lib.php#371: PMA_pluginGetOptions(
string 'Import',
array,
)
./libraries/display_import.lib.php#456: PMA_getHtmlForImportOptionsFormat(array)
./libraries/display_import.lib.php#691: PMA_getHtmlForImport(
string '5d2389b065989',
string 'table',
string '526612_clientdb',
string 'tbl_currentplayers',
integer 2097152,
array,
NULL,
NULL,
string '',
)
./tbl_import.php#36: PMA_getImportDisplay(
string 'table',
string '526612_clientdb',
string 'tbl_currentplayers',
integer 2097152,
)

Share this post


Link to post
Share on other sites



  • Our picks

    • I wanted I let you know that I am starting to build out the foundation for the hosting services that I talked about here. The pricing model I was originally going for wasn't going to be suitable for how I want to build it. So instead I decided to offer each service as it's own product instead of a package deal. In the future, hopefully, I will be able to do this and offer discounts to those that choose it.

      Here is how the pricing is laid out for each service as well as information about each. This is as of 7/12/2020.

      Single MySQL database (up to 30 GB) is $10 USD per month.



      If you go over the 30 GB usage for the database then each additional gigabyte is charged at $0.10 USD each billing cycle. If you're under 30GB you don't need to worry about this.


      Databases are replicated across 3 zones (regions) for redundancy. One (1) on the east coast of the USA, One (1) in Frankfurt, and One (1) in Singapore. Depending on the demand, this would grow to more regions.


      Databases will also be backed up daily and retained for 7 days.




      Procon Layer will be $2 USD per month.


      Each layer will only allow one (1) game server connection. The reason behind this is for performance.


      Each layer will also come with all available plugins installed by default. This is to help facilitate faster deployments and get you up and running quickly.


      Each layer will automatically restart if Procon crashes. 


      Each layer will also automatically restart daily at midnight to make sure it stays in tip-top shape.


      Custom plugins can be installed by submitting a support ticket.




      Battlefield Admin Control Panel (BFACP) will be $5 USD per month


      As I am still working on building version 3 of the software, I will be installing the last version I did. Once I complete version 3 it will automatically be upgraded for you.





      All these services will be managed by me so you don't have to worry about the technical side of things to get up and going.

      If you would like to see how much it would cost for the services, I made a calculator that you can use. It can be found here https://ezrcon.com/calculator.html

       
      • 10 replies
    • I have pushed out a new minor release which updates the geodata pull (flags in the playerlisting). This should be way more accurate now. As always, please let me know if any problems show up.

       
      • 9 replies
×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.