Jump to content
  • 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

  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



  • Our picks

    • Hi All,

      So I've been thinking about doing something like this for a while but I always talked myself out of it. I want to get some feedback on this idea and how many would think about using it if it was offered.

      In the past I know how hard it was for some users to get a MySQL database going and running the BFACP (since it's a bit requirement heavy in some cases). What I would be doing is offering to manage both of these for you.

      If enough interest was shown in something like this I would definitely think about doing it. Of course, I also know the risks I would be taking in something like this, but to list what I would be offering I guess is this.

      MySQL Hosting


      Daily backups of the database to a remote site & option to download it yourself.


      No limit on how big your database can be (within reason).




      BFACP Hosting (If running AdKats on your layers)


      This would run the newest version (v3.0)


      Will still be available to run on your own hardware


      Will have extra features that are not available for an open source setup (still need to think of good things )


      Able to use your own domain name with the proper DNS setup.




      Both Above



      Please let me know what you think of this idea and vote in the poll. Again not confirming anything like this will happen but if I get enough interest from the community for something like this then please let me know.

      Disclaimer: This will NOT be something affiliated with MyRCON but will be ran through it in terms of a payment processor.
      • 10 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.