So im new...

DDevil · October 25, 2023

So im pretty new to the CO private server scene and im trying to get started on making one. i was wondering if there were any halfway decent tutorials for a pretty dumb newbie? i tried the Comet stuff but couldnt get any of it to work cause.. well... im pretty dumb...

Spirited · October 25, 2023

So im pretty new to the CO private server scene and im trying to get started on making one. i was wondering if there were any halfway decent tutorials for a pretty dumb newbie? i tried the Comet stuff but couldnt get any of it to work cause.. well... im pretty dumb...

Comet is a skeleton source. It doesn't do a whole lot. This forum in general still needs tutorials made for the existing sources out there, but that's slowly being worked on in GitHub. For now, I'd recommend trying Redux (it has a guide with lots of answered questions already).

DDevil · October 26, 2023

So im pretty new to the CO private server scene and im trying to get started on making one. i was wondering if there were any halfway decent tutorials for a pretty dumb newbie? i tried the Comet stuff but couldnt get any of it to work cause.. well... im pretty dumb...
Comet is a skeleton source. It doesn't do a whole lot. This forum in general still needs tutorials made for the existing sources out there, but that's slowly being worked on in GitHub. For now, I'd recommend trying Redux (it has a guide with lots of answered questions already).

Would you happen to know of anywhere else? I tried following his guide and all i get is errors when executing the SQL in navicat.

Spirited · October 26, 2023

So im pretty new to the CO private server scene and im trying to get started on making one. i was wondering if there were any halfway decent tutorials for a pretty dumb newbie? i tried the Comet stuff but couldnt get any of it to work cause.. well... im pretty dumb...
Comet is a skeleton source. It doesn't do a whole lot. This forum in general still needs tutorials made for the existing sources out there, but that's slowly being worked on in GitHub. For now, I'd recommend trying Redux (it has a guide with lots of answered questions already).
Would you happen to know of anywhere else? I tried following his guide and all i get is errors when executing the SQL in navicat.

Well, getting an error isn't the expected result... do you mind posting the error? 'Cause if you run into an error in one server and don't know how to solve it, then you're likely gonna run into it on another server.

DDevil · October 28, 2023

Comet is a skeleton source. It doesn't do a whole lot. This forum in general still needs tutorials made for the existing sources out there, but that's slowly being worked on in GitHub. For now, I'd recommend trying Redux (it has a guide with lots of answered questions already).
Would you happen to know of anywhere else? I tried following his guide and all i get is errors when executing the SQL in navicat.
Well, getting an error isn't the expected result... do you mind posting the error? 'Cause if you run into an error in one server and don't know how to solve it, then you're likely gonna run into it on another server.

I follow his instructions to the letter, make sure everything has admin privileges, all the good stuff to make sure it can run, and i get this:

 Query Nov_16_Backup start

[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteCharacter`(IN _uid INT unsigned)

BEGIN

DELETE FROM characters WHERE UID=_uid;

DELETE FROM items WHERE Owner=_uid;

DELETE FROM nobility WHERE UID=_uid;

DELETE FROM proficiencies WHERE owner=_uid;

DELETE FROM skills WHERE owner=_uid;

DELETE FROM associates WHERE UID=_uid;

DELETE FROM associates WHERE AssociateID=_uid;

DELETE FROM guildattr WHERE guild_id=(SELECT id from guild where leader_id=_uid);

DELETE FROM guildattr WHERE id=_uid;

DELETE FROM guild WHERE leader_id=_uid;

DELETE FROM tasks WHERE owner=_uid;

END

[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteGuildAttr`(IN guildId INT unsigned)

BEGIN

DELETE FROM guildattr WHERE guild_id=guildId;

END

[ERR] 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 '!=guildRank LIMIT 1;

END' at line 3

[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId INT unsigned, IN guildRank SMALLINT unsigned)

BEGIN

DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1;

END

[ERR] 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 'Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOI' at line 3

[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetGuildMemberList`(IN guildId INT unsigned)

BEGIN

SELECT u.Name AS Name, g.rank AS Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOIN characters AS u ON u.UID=g.id WHERE g.guild_id=guildId && u.UID IS NOT NULL ORDER BY g.rank DESC, u.Level DESC, u.Name;

END

[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetLastItemUID`()

SELECT * FROM items ORDER BY UniqueID DESC LIMIT 1

;

[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetNobilityRank`(IN donationvalue BIGINT unsigned)

BEGIN

SELECT COUNT(*) FROM nobility WHERE Donation>donationvalue;

END

[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `NobilityPages`()

BEGIN

SELECT * FROM nobility ORDER BY Donation DESC LIMIT 50;

END

[sql] Finished with error

I scrolled through 100-some odd pages and didn't see anyone with the same error.

Spirited · October 30, 2023

Would you happen to know of anywhere else? I tried following his guide and all i get is errors when executing the SQL in navicat.
Well, getting an error isn't the expected result... do you mind posting the error? 'Cause if you run into an error in one server and don't know how to solve it, then you're likely gonna run into it on another server.
I follow his instructions to the letter, make sure everything has admin privileges, all the good stuff to make sure it can run, and i get this:
 Query Nov_16_Backup start
[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteCharacter`(IN _uid INT unsigned)
BEGIN
DELETE FROM characters WHERE UID=_uid;
DELETE FROM items WHERE Owner=_uid;
DELETE FROM nobility WHERE UID=_uid;
DELETE FROM proficiencies WHERE owner=_uid;
DELETE FROM skills WHERE owner=_uid;
DELETE FROM associates WHERE UID=_uid;
DELETE FROM associates WHERE AssociateID=_uid;
DELETE FROM guildattr WHERE guild_id=(SELECT id from guild where leader_id=_uid);
DELETE FROM guildattr WHERE id=_uid;
DELETE FROM guild WHERE leader_id=_uid;
DELETE FROM tasks WHERE owner=_uid;
END
[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteGuildAttr`(IN guildId INT unsigned)
BEGIN
DELETE FROM guildattr WHERE guild_id=guildId;
END
[ERR] 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 '!=guildRank LIMIT 1;
END' at line 3
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId INT unsigned, IN guildRank SMALLINT unsigned)
BEGIN
DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1;
END
[ERR] 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 'Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOI' at line 3
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetGuildMemberList`(IN guildId INT unsigned)
BEGIN
SELECT u.Name AS Name, g.rank AS Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOIN characters AS u ON u.UID=g.id WHERE g.guild_id=guildId && u.UID IS NOT NULL ORDER BY g.rank DESC, u.Level DESC, u.Name;
END
[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetLastItemUID`()
SELECT * FROM items ORDER BY UniqueID DESC LIMIT 1
;
[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetNobilityRank`(IN donationvalue BIGINT unsigned)
BEGIN
SELECT COUNT(*) FROM nobility WHERE Donation>donationvalue;
END
[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `NobilityPages`()
BEGIN
SELECT * FROM nobility ORDER BY Donation DESC LIMIT 50;
END
[sql] Finished with error
I scrolled through 100-some odd pages and didn't see anyone with the same error.
Not sure if this helps, but the original thread says to uncheck an option called "Run multiple queries in each execution". If that doesn't help, then can you tell us what tool you're using to import the database?

Omicron · October 30, 2023

You are most likely using MySQL that comes with wamp or whatever. Download and install the complete MySQL server and you shouldn’t have any errors anymore.

DDevil · November 3, 2023

You are most likely using MySQL that comes with wamp or whatever. Download and install the complete MySQL server and you shouldn’t have any errors anymore.

I was using the complete MySQL right from the site.

Well, getting an error isn't the expected result... do you mind posting the error? 'Cause if you run into an error in one server and don't know how to solve it, then you're likely gonna run into it on another server.
I follow his instructions to the letter, make sure everything has admin privileges, all the good stuff to make sure it can run, and i get this:
 Query Nov_16_Backup start
[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteCharacter`(IN _uid INT unsigned)
BEGIN
DELETE FROM characters WHERE UID=_uid;
DELETE FROM items WHERE Owner=_uid;
DELETE FROM nobility WHERE UID=_uid;
DELETE FROM proficiencies WHERE owner=_uid;
DELETE FROM skills WHERE owner=_uid;
DELETE FROM associates WHERE UID=_uid;
DELETE FROM associates WHERE AssociateID=_uid;
DELETE FROM guildattr WHERE guild_id=(SELECT id from guild where leader_id=_uid);
DELETE FROM guildattr WHERE id=_uid;
DELETE FROM guild WHERE leader_id=_uid;
DELETE FROM tasks WHERE owner=_uid;
END
[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteGuildAttr`(IN guildId INT unsigned)
BEGIN
DELETE FROM guildattr WHERE guild_id=guildId;
END
[ERR] 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 '!=guildRank LIMIT 1;
END' at line 3
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId INT unsigned, IN guildRank SMALLINT unsigned)
BEGIN
DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1;
END
[ERR] 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 'Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOI' at line 3
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetGuildMemberList`(IN guildId INT unsigned)
BEGIN
SELECT u.Name AS Name, g.rank AS Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOIN characters AS u ON u.UID=g.id WHERE g.guild_id=guildId && u.UID IS NOT NULL ORDER BY g.rank DESC, u.Level DESC, u.Name;
END
[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetLastItemUID`()
SELECT * FROM items ORDER BY UniqueID DESC LIMIT 1
;
[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetNobilityRank`(IN donationvalue BIGINT unsigned)
BEGIN
SELECT COUNT(*) FROM nobility WHERE Donation>donationvalue;
END
[ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `NobilityPages`()
BEGIN
SELECT * FROM nobility ORDER BY Donation DESC LIMIT 50;
END
[sql] Finished with error
I scrolled through 100-some odd pages and didn't see anyone with the same error.
Not sure if this helps, but the original thread says to uncheck an option called "Run multiple queries in each execution". If that doesn't help, then can you tell us what tool you're using to import the database?
Also, i did that and it was still throwing the errors. i was using Navicat 16. not sure if thats the problem or not.

Spirited · November 3, 2023

Also, i did that and it was still throwing the errors. i was using Navicat 16. not sure if thats the problem or not.

I'd try using the official MySQL Workbench tool.

https://dev.mysql.com/downloads/workbench/

DDevil · November 4, 2023

Also, i did that and it was still throwing the errors. i was using Navicat 16. not sure if thats the problem or not.
I'd try using the official MySQL Workbench tool.
https://dev.mysql.com/downloads/workbench/

Did as you suggested, but instructions become a little unclear because its not the same program setup as what he uses.

sam00n · November 13, 2023

I'm very newbie to this but I try my best and I don't give up. Spirited told me that I have to put some effort and looking for the answers xD.

So I'm trying now for many times Redux source and I get this error when I execute sql file in NavicatMySql. In the video he said that it should be executed without any errors. I tried all his versions of the source and I get the same error in MySql..

SQL] Query Nov_16_Backup start

[ERR] 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 '!=guildRank LIMIT 1;

END' at line 3

[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId INT unsigned, IN guildRank SMALLINT unsigned)

BEGIN

DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1;

END

[ERR] 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 'Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOI' at line 3

[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetGuildMemberList`(IN guildId INT unsigned)

BEGIN

SELECT u.Name AS Name, g.rank AS Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOIN characters AS u ON u.UID=g.id WHERE g.guild_id=guildId && u.UID IS NOT NULL ORDER BY g.rank DESC, u.Level DESC, u.Name;

END

 Finished with error

Spirited · November 13, 2023

I have no problem with MySQL Workbench importing the backup. Same goes for using MariaDB instead of MySQL as a drop-in replacement. I recommend trying MySQL Workbench and see where that gets you. If you don't know how to import something with MySQL Workbench, then there're plenty of guides online on how to use it. I really recommend just searching for it. And if you get stuck still, post where you get stuck so others can help. Good luck!

DDevil · November 14, 2023

I have no problem with MySQL Workbench importing the backup. Same goes for using MariaDB instead of MySQL as a drop-in replacement. I recommend trying MySQL Workbench and see where that gets you. If you don't know how to import something with MySQL Workbench, then there're plenty of guides online on how to use it. I really recommend just searching for it. And if you get stuck still, post where you get stuck so others can help. Good luck!

I'll try fresh installs again and see what happens but it just kept tossing errors.

Tkblackbelt · November 15, 2023

If its not too tricky, maybe post a quick screen recording showing you running the script. Probably will help in figuring out the issue.

Another thing I recommend is ChatGpt. You can past error messages in and it can help you understand them, and suggest solutions.

Sign In

So im new...

Recommended Posts

DDevil

Spirited

DDevil

Spirited

DDevil

Spirited

Omicron

DDevil

Spirited

DDevil

sam00n

Spirited

DDevil

Tkblackbelt

Join the conversation

Browse

Activity