Help with phpmyadmin SQL

[jav 0]

I am having trouble creating a table in SQL with phpmyadmin on my server. I installed the singlecurrency 4.0 for Dayz Overpoch and I get a error message when I enter the Sql table "banking_data". Coins will save on the player but wont save in the bank after relog or restart. I included a pic of the error message. Here is the code I am trying to enter. ANY help would be much appreciated!

 

SET FOREIGN_KEY_CHECKS=0;

 

-- ----------------------------

-- Table structure for `banking_data`

-- ----------------------------

DROP TABLE IF EXISTS `banking_data`;

CREATE TABLE `banking_data` (

  `PlayerUID` varchar(20) NOT NULL DEFAULT '0',

  `PlayerName` varchar(128) NOT NULL DEFAULT 'Null',

  `BankSaldo` bigint(24) NOT NULL DEFAULT '0',

  `LastUpdated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`PlayerUID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

-- ----------------------------

-- Table structure for `character_data`

-- ----------------------------

 

ALTER TABLE character_data ADD CashMoney int(11) NOT NULL DEFAULT 0 AFTER Infected;

[Ryan Pennington 359]

I don't see any issues with that SQL.

[Bilco 41]

I don't see any issues with that SQL.

Me either.

[jav 0]

when I enter the SQL everything is fine. But when I try to click on Tables then click on banking_data that is when the error pops up. Also when I bring down the columns in banking_data and I click on a column it brings up this error below...

 

Notice in ./libraries/tbl_columns_definition_form.inc.php#55
 Undefined variable: server

Backtrace

./libraries/structure.lib.php#2449: include(./libraries/tbl_columns_definition_form.inc.php)
./tbl_structure.php#45: PMA_displayHtmlForColumnChange(
string 'ss_10572',
string 'banking_data',
NULL,
string 'tbl_structure.php',
)

[Bilco 41]

Well I've never installed this before so I gave it a shot. I went to the website where this is which directed me to the github. Downloaded the sql in question. Went to the database details and selected import. Selected the SQL that I downloaded and got no issues. Not exactly sure what or where you went wrong. Worked fine for me. You could try doing it my way. Delete whatever you tried creating before hand.

[jav 0]

ok thanks

[Ryan Pennington 359]

Or you can create a ticket and we can take a look from there.