[DiscordArchive] Hi can i ask you when i try re run cmake i have this error i can't recompile modules
[DiscordArchive] Hi can i ask you when i try re run cmake i have this error i can't recompile modules
Original source
Hi can i ask you when i try re run cmake i have this error i can't recompile modules
Manually-specified variables were not used by the project:
MODULES
Do you know why ?
rektbyfaith
09-19-2022, 03:01 PM #1Archived author: Aka Worgen • Posted: 2022-09-19T15:01:01.869000+00:00
Original source
Hi can i ask you when i try re run cmake i have this error i can't recompile modules
Manually-specified variables were not used by the project:
MODULES
Do you know why ?
Original source
![[Image: unknown.png?ex=690c0f9e&is=690abe1e&hm=a...10c45f823&]](https://cdn.discordapp.com/attachments/284406375495368704/1021435959113416754/unknown.png?ex=690c0f9e&is=690abe1e&hm=ae30bd276fee11048b31f9c7cd63657c791ba5d774ef7731aee250a10c45f823&)
rektbyfaith
09-19-2022, 03:01 PM #2Archived author: Aka Worgen • Posted: 2022-09-19T15:01:50.112000+00:00
Original source
Original source
Hi team, trying to run the TC to AC db converter and on 4_CLEANUP_AND_CONVERT_SPELLS.sql getting an error on this
SET @cnt := 0;
SET @prevguid := 0;
DELETE s FROM character_skills s JOIN ((SELECT guid, skill FROM ((SELECT IF(@prevguid <> cs.guid, @cnt := 1, @cnt := @cnt+1) AS cnt, (@prevguid := guid) AS guid, cs.skill AS skill FROM character_skills cs JOIN __profession_skill t ON cs.skill = t.skill AND t.rank=6 ORDER BY cs.guid, cs.skill) X) WHERE cnt>2) x2) ON s.guid = x2.guid AND s.skill = x2.skill;
/* SQL Error (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 ') WHERE cnt>2) x2) ON s.guid = x2.guid AND s.skill = x2.skill' at line 1 */
rektbyfaith
09-19-2022, 03:07 PM #3Archived author: Zaph • Posted: 2022-09-19T15:07:51.366000+00:00
Original source
Hi team, trying to run the TC to AC db converter and on 4_CLEANUP_AND_CONVERT_SPELLS.sql getting an error on this
SET @cnt := 0;
SET @prevguid := 0;
DELETE s FROM character_skills s JOIN ((SELECT guid, skill FROM ((SELECT IF(@prevguid <> cs.guid, @cnt := 1, @cnt := @cnt+1) AS cnt, (@prevguid := guid) AS guid, cs.skill AS skill FROM character_skills cs JOIN __profession_skill t ON cs.skill = t.skill AND t.rank=6 ORDER BY cs.guid, cs.skill) X) WHERE cnt>2) x2) ON s.guid = x2.guid AND s.skill = x2.skill;
/* SQL Error (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 ') WHERE cnt>2) x2) ON s.guid = x2.guid AND s.skill = x2.skill' at line 1 */
Original source
It's not an error, it's a warning. Remove the variable and the warning will go away.
rektbyfaith
09-19-2022, 03:08 PM #4Archived author: Revision • Posted: 2022-09-19T15:08:37.893000+00:00
Original source
It's not an error, it's a warning. Remove the variable and the warning will go away.
Original source
What u mean exacly variable ?
rektbyfaith
09-19-2022, 03:09 PM #5Archived author: Aka Worgen • Posted: 2022-09-19T15:09:41.250000+00:00
Original source
What u mean exacly variable ?
Original source
I assume you have -DMODULES set
rektbyfaith
09-19-2022, 03:09 PM #6Archived author: Revision • Posted: 2022-09-19T15:09:52.515000+00:00
Original source
I assume you have -DMODULES set
Original source
I would guess `WHERE cnt>2) x2) ON s.guid = x2.guid AND s.skill = x2.skill;` is missing `AS x2` to begin with.
rektbyfaith
09-19-2022, 03:11 PM #7Archived author: Revision • Posted: 2022-09-19T15:11:18.072000+00:00
Original source
I would guess `WHERE cnt>2) x2) ON s.guid = x2.guid AND s.skill = x2.skill;` is missing `AS x2` to begin with.
Original source
Wait, no that's a brainfart. The whole mess of code confuses me.
rektbyfaith
09-19-2022, 03:11 PM #8Archived author: Revision • Posted: 2022-09-19T15:11:48.808000+00:00
Original source
Wait, no that's a brainfart. The whole mess of code confuses me.
Original source
yeah, it's heavily nested
rektbyfaith
09-19-2022, 03:13 PM #9Archived author: Zaph • Posted: 2022-09-19T15:13:26.496000+00:00
Original source
yeah, it's heavily nested
Original source
everything else was OK just that area - wondered if a SQL guru could help troubleshoot
rektbyfaith
09-19-2022, 03:13 PM #10Archived author: Zaph • Posted: 2022-09-19T15:13:38.977000+00:00
Original source
everything else was OK just that area - wondered if a SQL guru could help troubleshoot
1 Guest(s)
1 Guest(s)