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', )
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;