search

Sarjuuk / aowow

Database viewer for TrinityCore based on aowow by @LordJZ, based on the JS-Engine of Wowhead
204 stars 217 forks source link

Latest 'db_structure.sql' gives too much errors #431

Closed virgo77 closed 2 months ago

virgo77 commented 2 months ago

Hi! Your last updates on 'db_structure.sql' generate lots of errors and it makes the script to stop before ending... https://github.com/Sarjuuk/aowow/commit/460615c112ec5873d055d3233a37bf5964bbd604

I'm on:

Here's the log:

Query:
CREATE TABLE `aowow_profiler_completion_achievements` (
  `id` int(10) unsigned NOT NULL,
  `achievementId` smallint(5) unsigned NOT NULL,
  `date` int(10) unsigned DEFAULT NULL,
  KEY `id` (`id`),
  KEY `typeId` (`achievementId`),
  CONSTRAINT `FK_pr_completion_achievements` FOREIGN KEY (`id`) REFERENCES `aowow_profiler_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
/*!40101 SET character_set_client = @saved_cs_client */

Error occured at:2024-07-09 12:57:50
Line no.:1838
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET character_set_client = @saved_cs_client */' at line 9

Query:
CREATE TABLE `aowow_profiler_completion_quests` (
  `id` int(10) unsigned NOT NULL,
  `questId` mediumint(8) unsigned NOT NULL,
  KEY `id` (`id`),
  CONSTRAINT `FK_pr_completion_quests` FOREIGN KEY (`id`) REFERENCES `aowow_profiler_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
/*!40101 SET character_set_client = @saved_cs_client */

Error occured at:2024-07-09 12:57:50
Line no.:1853
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET character_set_client = @saved_cs_client */' at line 7

Query:
CREATE TABLE `aowow_profiler_completion_reputation` (
  `id` int(10) unsigned NOT NULL,
  `factionId` smallint(5) unsigned NOT NULL,
  `standing` mediumint(9) DEFAULT NULL,
  KEY `id` (`id`),
  CONSTRAINT `FK_pr_completion_reputation` FOREIGN KEY (`id`) REFERENCES `aowow_profiler_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
/*!40101 SET character_set_client = @saved_cs_client */

Error occured at:2024-07-09 12:57:50
Line no.:1869
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET character_set_client = @saved_cs_client */' at line 8

Query:
CREATE TABLE `aowow_profiler_completion_skills` (
  `id` int(10) unsigned NOT NULL,
  `skillId` smallint(5) unsigned NOT NULL,
  `value` smallint(5) unsigned DEFAULT NULL,
  `max` smallint(5) unsigned DEFAULT NULL,
  KEY `id` (`id`),
  KEY `typeId` (`skillId`),
  CONSTRAINT `FK_pr_completion_skills` FOREIGN KEY (`id`) REFERENCES `aowow_profiler_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
/*!40101 SET character_set_client = @saved_cs_client */

Error occured at:2024-07-09 12:57:50
Line no.:1887
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET character_set_client = @saved_cs_client */' at line 10

Query:
CREATE TABLE `aowow_profiler_completion_spells` (
  `id` int(10) unsigned NOT NULL,
  `spellId` mediumint(8) unsigned NOT NULL,
  KEY `id` (`id`),
  CONSTRAINT `FK_pr_completion_spells` FOREIGN KEY (`id`) REFERENCES `aowow_profiler_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
/*!40101 SET character_set_client = @saved_cs_client */

Error occured at:2024-07-09 12:57:50
Line no.:1902
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET character_set_client = @saved_cs_client */' at line 7

Query:
CREATE TABLE `aowow_profiler_completion_statistics` (
  `id` int(10) unsigned NOT NULL,
  `achievementId` smallint(6) NOT NULL,
  `date` int(10) unsigned DEFAULT NULL,
  `counter` smallint(5) unsigned DEFAULT NULL,
  KEY `id` (`id`),
  KEY `typeId` (`achievementId`),
  CONSTRAINT `FK_pr_completion_statistics` FOREIGN KEY (`id`) REFERENCES `aowow_profiler_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
/*!40101 SET character_set_client = @saved_cs_client */

Error occured at:2024-07-09 12:57:50
Line no.:1920
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET character_set_client = @saved_cs_client */' at line 10

Query:
CREATE TABLE `aowow_profiler_completion_titles` (
  `id` int(10) unsigned NOT NULL,
  `titleId` tinyint(3) unsigned NOT NULL,
  KEY `id` (`id`),
  CONSTRAINT `FK_pr_completion_titles` FOREIGN KEY (`id`) REFERENCES `aowow_profiler_profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
/*!40101 SET character_set_client = @saved_cs_client */

Error occured at:2024-07-09 12:57:50
Line no.:1935
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET character_set_client = @saved_cs_client */' at line 7

Your db_structure.sql is exported from the same version as mine (10.6). Is subversion important? (yours: 11 / mine: 18)

Thanks

Regards, V.