Eroare php

[Only-Games]

Salut, am luat si eu un script gen serveresamp[dot]com si l-am pus pe host. Am editat tot ce trebuie, am urcat fisierul 'database.sql" in phpMyAdmin, dar mi-a dat o eroare:
http://s4.postimg.org/oh0wy7v3h/import_ ... 091637.png

Din cauza acestei erori, nu pot adauga serverele pe site, imi apare:
http://s16.postimg.org/n4tk5tut1/eroare.png



* Cine ma poate ajuta si pe mine?

[fan_haulin]

Salut, am luat si eu un script gen serveresamp[dot]com si l-am pus pe host. Am editat tot ce trebuie, am urcat fisierul 'database.sql" in phpMyAdmin, dar mi-a dat o eroare:
http://s4.postimg.org/oh0wy7v3h/import_ ... 091637.png

Din cauza acestei erori, nu pot adauga serverele pe site, imi apare:
http://s16.postimg.org/n4tk5tut1/eroare.png



* Cine ma poate ajuta si pe mine?

Posteaza aici .sql ul ca trebuiesc sterse niste randuri.

[DRS]

pune baza de date, sunt scrise aiurea cateva linii.

[Only-Games]

| Afiseaza codul

CREATE TABLE `lgsl` (

  `id`         INT     (11)  NOT NULL auto_increment,
  `type`       VARCHAR (50)  NOT NULL DEFAULT '',
  `ip`         VARCHAR (255) NOT NULL DEFAULT '',
  `c_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
  `q_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
  `s_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
  `zone`       VARCHAR (255) NOT NULL DEFAULT '',
  `disabled`   TINYINT (1)   NOT NULL DEFAULT '0',
  `comment`    VARCHAR (255) NOT NULL DEFAULT '',
  `status`     TINYINT (1)   NOT NULL DEFAULT '0',
  `cache`      TEXT          NOT NULL,
  `cache_time` TEXT          NOT NULL,
  `rating`     int(11) NOT NULL,
  `map` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nume` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)

) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `voting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `server_id` int(10) NOT NULL,
  `vote_ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=234 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

[fan_haulin]

Code: Select all

CREATE TABLE `lgsl` (

  `id`         INT     (11)  NOT NULL auto_increment,
  `type`       VARCHAR (50)  NOT NULL DEFAULT '',
  `ip`         VARCHAR (255) NOT NULL DEFAULT '',
  `c_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
  `q_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
  `s_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
  `zone`       VARCHAR (255) NOT NULL DEFAULT '',
  `disabled`   TINYINT (1)   NOT NULL DEFAULT '0',
  `comment`    VARCHAR (255) NOT NULL DEFAULT '',
  `status`     TINYINT (1)   NOT NULL DEFAULT '0',
  `cache`      TEXT          NOT NULL,
  `cache_time` TEXT          NOT NULL,
  `rating`     int(11) NOT NULL,
  `map` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nume` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)

) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `voting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `server_id` int(10) NOT NULL,
  `vote_ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Incearca acum.

[dL.papadiEEE]

nu ai ip dedicat al webhost si probabil din cauza asta iti face figuri lgsl-ul

[Only-Games]

Code: Select all

CREATE TABLE `lgsl` (

  `id`         INT     (11)  NOT NULL auto_increment,
  `type`       VARCHAR (50)  NOT NULL DEFAULT '',
  `ip`         VARCHAR (255) NOT NULL DEFAULT '',
  `c_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
  `q_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
  `s_port`     VARCHAR (5)   NOT NULL DEFAULT '0',
  `zone`       VARCHAR (255) NOT NULL DEFAULT '',
  `disabled`   TINYINT (1)   NOT NULL DEFAULT '0',
  `comment`    VARCHAR (255) NOT NULL DEFAULT '',
  `status`     TINYINT (1)   NOT NULL DEFAULT '0',
  `cache`      TEXT          NOT NULL,
  `cache_time` TEXT          NOT NULL,
  `rating`     int(11) NOT NULL,
  `map` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nume` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)

) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `voting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `server_id` int(10) NOT NULL,
  `vote_ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Incearca acum.

Acum a importat bine baza de date, fara erori.
Dar tot imi apare: http://s16.postimg.org/n4tk5tut1/eroare.png cand vreau sa adaug un server.

[Only-Games]

Tot de la baza de date ar fi... ma poate ajuta cineva?

[fan_haulin]

Cauta un server populat si cunoscut si incearca cu el.

[Only-Games]

Nu merge cu niciun server, dar am pus scriptul pe alt host (acelasi domeniu) si a mers.
Problema era de la host, mersi mult.