Moderator: comraden
Zapytanie SQL:
-- -- Baza danych: `lechia` -- -- -------------------------------------------------------- -- -- Struktura tabeli dla `portal_joomleague_club` -- CREATE TABLE IF NOT EXISTS `portal_joomleague_club` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `alias` varchar(100) NOT NULL DEFAULT '', `admin` int(11) DEFAULT NULL, `address` varchar(100) NOT NULL DEFAULT '', `zipcode` varchar(10) NOT NULL DEFAULT '', `location` varchar(50) NOT NULL DEFAULT '', `state` varchar(50) NOT NULL DEFAULT '', `country` varchar(3) DEFAULT NULL, `founded` varchar(50) DEFAULT NULL, `phone` varchar(20) NOT NULL DEFAULT '', `fax` varchar(20) NOT NULL DEFAULT '', `email` varchar(255) NOT NULL DEFAULT '', `website` varchar(250) NOT NULL DEFAULT '', `president` varchar(50) NOT NULL DEFAULT '', `manager` varchar(50) NOT NULL DEFAULT '', `logo_big` varchar(255) NOT NULL DEFAULT '', `logo_middle` varchar(255) NOT NULL DEFAULT '', `logo_small` va[...]
MySQL zwrócił komunikat: Dokumentacja
#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 'TYPE=MyISAM AUTO_INCREMENT=311' at line 40
DarioB wrote:Nie wiem czy coś mieszam ale jak prawidłowo przenieść bazę danych JL z 1.6 do 2.0.
Myślałem że export/import w phpmyadmin ale coś nie mogę zaimportowaćZapytanie SQL:
-- -- Baza danych: `lechia` -- -- -------------------------------------------------------- -- -- Struktura tabeli dla `portal_joomleague_club` -- CREATE TABLE IF NOT EXISTS `portal_joomleague_club` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `alias` varchar(100) NOT NULL DEFAULT '', `admin` int(11) DEFAULT NULL, `address` varchar(100) NOT NULL DEFAULT '', `zipcode` varchar(10) NOT NULL DEFAULT '', `location` varchar(50) NOT NULL DEFAULT '', `state` varchar(50) NOT NULL DEFAULT '', `country` varchar(3) DEFAULT NULL, `founded` varchar(50) DEFAULT NULL, `phone` varchar(20) NOT NULL DEFAULT '', `fax` varchar(20) NOT NULL DEFAULT '', `email` varchar(255) NOT NULL DEFAULT '', `website` varchar(250) NOT NULL DEFAULT '', `president` varchar(50) NOT NULL DEFAULT '', `manager` varchar(50) NOT NULL DEFAULT '', `logo_big` varchar(255) NOT NULL DEFAULT '', `logo_middle` varchar(255) NOT NULL DEFAULT '', `logo_small` va[...]
MySQL zwrócił komunikat: Dokumentacja
#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 'TYPE=MyISAM AUTO_INCREMENT=311' at line 40
nie będzie widzieć tabel z przyrostkiem jos_ wyedytuj tabele joomleague i zamień przyrostek na własciwy w odpowiednim edytorze który obsługuje utf-8 i ponownie zaimportuj do nowej wersjikotek82 wrote:Witam więc jest tak w nowej joomli 2,5 mam hqau4_ natomiast w joomli 1,5 jos_ wszystko jest w nowej bazie oba prefiksy w jos_ są dane natomiast hqau4 to co zainstalowało się w joomleague 2,06
kotek82 wrote:Dzięki benio08 wszystko zmieniłem baza się wgrała z braku czasu nie odpisałem wcześniej.Mam jeszcze jedno pytanie prożbę jak zrobić żeby tabela (ranking) miałe efekt kratek tab tak jak jest na dole {Pl = Rozegrane}
Skipping handling of ALTER TABLE `#__joomleague_club` ADD `standard_playground` int(11) DEFAULT NULL
ALTER TABLE `#__joomleague_club` ADD `notes` text NOT NULL - Failed
Skipping handling of ALTER TABLE `#__joomleague_club` ADD `modified` datetime DEFAULT NULL
ALTER TABLE `#__joomleague_club` CHANGE `modified_by` `modified_by` int(10) DEFAULT NULL - Success
ALTER TABLE `#__joomleague_club` ADD `dissolved` varchar(50) DEFAULT NULL - Failed
ALTER TABLE `#__joomleague_club` ADD `asset_id` int(10) NOT NULL DEFAULT '0' - Failed
Skipping handling of ALTER TABLE `#__joomleague_division` ADD `parent_id` int(11) DEFAULT NULL
ALTER TABLE `#__joomleague_division` ADD `picture` varchar(128) NOT NULL DEFAULT '' - Failed
Code: Select all
Skipping handling of ALTER TABLE `#__joomleague_match` ADD `modified` datetime DEFAULT NULL
ALTER TABLE `#__joomleague_match` CHANGE `modified_by` `modified_by` int(10) DEFAULT NULL - Success
ALTER TABLE `#__joomleague_match` ADD `asset_id` int(10) NOT NULL DEFAULT '0' - Failed
ALTER TABLE `#__joomleague_match` ADD `alias` varchar(255) NOT NULL DEFAULT '' - Failed
Code: Select all
Skipping handling of ALTER TABLE `#__joomleague_person` ADD `id` int(11) NOT NULL AUTO_INCREMENT
ALTER TABLE `#__joomleague_person` ADD `contact_id` int(11) DEFAULT NULL - Failed
Code: Select all
Skipping handling of ALTER TABLE `#__joomleague_project` ADD `extension` varchar(80) DEFAULT NULL
ALTER TABLE `#__joomleague_project` ADD `timezone` varchar(50) NOT NULL DEFAULT 'Europe/Amsterdam' - Failed
ALTER TABLE `#__joomleague_project` CHANGE `project_type` `project_type` enum('SIMPLE_LEAGUE','DIVISIONS_LEAGUE','TOURNAMENT_MODE','FRIENDLY_MATCHES') NOT NULL DEFAULT 'SIMPLE_LEAGUE' - Success
Code: Select all
Skipping handling of ALTER TABLE `#__joomleague_project` ADD `modified` datetime DEFAULT NULL
ALTER TABLE `#__joomleague_project` CHANGE `modified_by` `modified_by` int(10) DEFAULT NULL - Success
ALTER TABLE `#__joomleague_project` ADD `asset_id` int(10) NOT NULL DEFAULT '0' - Failed
ALTER TABLE `#__joomleague_project` ADD `is_utc_converted` tinyint(4) NOT NULL DEFAULT '0' - Failed
Code: Select all
Skipping handling of ALTER TABLE `#__joomleague_project_referee` ADD `modified` datetime DEFAULT NULL
ALTER TABLE `#__joomleague_project_referee` CHANGE `modified_by` `modified_by` int(10) DEFAULT NULL - Success
ALTER TABLE `#__joomleague_project_referee` ADD `asset_id` int(10) NOT NULL DEFAULT '0' - Failed
ALTER TABLE `#__joomleague_project_referee` ADD `alias` varchar(255) NOT NULL DEFAULT '' - Failed
Skipping handling of ALTER TABLE `#__joomleague_project_team` ADD `modified` datetime DEFAULT NULL
ALTER TABLE `#__joomleague_project_team` CHANGE `modified_by` `modified_by` int(10) DEFAULT NULL - Success
ALTER TABLE `#__joomleague_project_team` ADD `ordering` int(11) NOT NULL DEFAULT '0' - Failed
ALTER TABLE `#__joomleague_project_team` ADD `asset_id` int(10) NOT NULL DEFAULT '0' - Failed
ALTER TABLE `#__joomleague_project_team` ADD `alias` varchar(255) NOT NULL DEFAULT '' - Failed
Skipping handling of ALTER TABLE `#__joomleague_season` ADD `extended` text
ALTER TABLE `#__joomleague_season` ADD `published` tinyint(1) NOT NULL DEFAULT '0' - Failed
Skipping handling of ALTER TABLE `#__joomleague_team` ADD `modified` datetime DEFAULT NULL
ALTER TABLE `#__joomleague_team` CHANGE `modified_by` `modified_by` int(10) DEFAULT NULL - Success
ALTER TABLE `#__joomleague_team` ADD `asset_id` int(10) NOT NULL DEFAULT '0' - Failed
Skipping handling of ALTER TABLE `#__joomleague_team_player` ADD `modified` datetime DEFAULT NULL
ALTER TABLE `#__joomleague_team_player` CHANGE `modified_by` `modified_by` int(10) DEFAULT NULL - Success
ALTER TABLE `#__joomleague_team_player` ADD `asset_id` int(10) NOT NULL DEFAULT '0' - Failed
ALTER TABLE `#__joomleague_team_player` ADD `alias` varchar(255) NOT NULL DEFAULT '' - Failed
Skipping handling of ALTER TABLE `#__joomleague_team_staff` ADD `modified` datetime DEFAULT NULL
ALTER TABLE `#__joomleague_team_staff` CHANGE `modified_by` `modified_by` int(10) DEFAULT NULL - Success
ALTER TABLE `#__joomleague_team_staff` ADD `asset_id` int(10) NOT NULL DEFAULT '0' - Failed
ALTER TABLE `#__joomleague_team_staff` ADD `alias` varchar(255) NOT NULL DEFAULT '' - Failed
Template: [curve] - Name: []
Difference found for project [2008/09 Ekstraklasa] - Problems while saving config for [curve] with project-ID [1, show_sectionheader=1 show_curve=1 show_colorlegend=1 expiry_time=0 = ]!
Difference found for project [2008/09 PP] - Problems while saving config for [curve] with project-ID [2, show_sectionheader=1 show_curve=1 show_colorlegend=1 expiry_time=0 = ]!
Template: [nextmatch] - Name: [Ustawienia Frontendu - Strona Zapowiedź Meczu]
Difference found for project [2008/09 Ekstraklasa] - Problems while saving config for [nextmatch] with project-ID [1, show_sectionheader=1 show_nextmatch=1 show_details=1 show_preview=1 show_stats=1 show_history=1 show_previousx=1 nb_previous=5 show_thumbs_picture=1 name_format=3 show_chances=1 show_current_rank=1 show_match_count=1 show_match_total=1 show_match_total_home=1 show_match_total_away=1 show_match_points=1 show_match_goals=1 show_match_diff=1 show_match_highest_stats=1 show_match_highest_won=1 show_match_highest_loss=1 show_match_highest_won_away=1 show_match_highest_loss_away=1 show_time_suffix=1 show_logo=1 show_picture=team_picture team_picture_width=150 team_picture_height=150 expiry_time=0 = ]!
Difference found for project [2008/09 PP] - Problems while saving config for [nextmatch] with project-ID [2, show_sectionheader=1 show_nextmatch=1 show_details=1 show_preview=1 show_stats=1 show_history=1 show_previousx=1 nb_previous=5 show_thumbs_picture=1 name_format=3 show_chances=1 show_current_rank=1 show_match_count=1 show_match_total=1 show_match_total_home=1 show_match_total_away=1 show_match_points=1 show_match_goals=1 show_match_diff=1 show_match_highest_stats=1 show_match_highest_won=1 show_match_highest_loss=1 show_match_highest_won_away=1 show_match_highest_loss_away=1 show_time_suffix=1 show_logo=1 show_picture=logo_big team_picture_width=150 team_picture_height=150 expiry_time=0 = ]!
Code: Select all
ALTER TABLE `#__joomleague_club` ADD `notes` text NOT NULL - Failed
Users browsing this forum: No registered users and 2 guests