Updated Solo Server Package

[Pallos]

I got a bunch of errors when I sourced the SQL using Heidi, 16 to be exact and I just installed the server today so I believe the schema should be up to date..


/* Loading file "F:\EQserver\solo_server.sql" (827.7 KiB) into query tab #1 ... */
/* SQL Error (1062): Duplicate entry '800023' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800020' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800020-800020' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800020-1' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800015' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800015' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800015-800015' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800087' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800087' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800087-800087' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800088' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800088' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800088-800088' for key 'PRIMARY' */
/* SQL Error (1062): Duplicate entry '800000' for key 'PRIMARY' */
/* SQL Error (1265): Data truncated for column 'y' at row 4 */
/* SQL Error (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 'UNLOCK TABLES' at line 3 */

[djeryv]

I don't know what your issue is...other than I go into the console and import stuff manually. I don't use Heidi or any 3rd party program so I don't know if that is the issue you are having. All I do know is that I did a fresh install of everything and sourced my file without incident less than a week ago. It almost looks like you are importing it twice hence the duplicate ID error.

EDIT: I just downloaded the files and sourced them with a fresh PEQ database without any errors, just to be sure. I have to assume Heidi is doing something wrong with the SQL file.

[djeryv]

I added something fun today for my server and included it as a separate SQL file in my solo server package. If you import it, it will change your townsfolk and guards to use the newer character models so you don't have the classic models of guards and merchants (for examples) looking "classic" when you have the better graphics turned on. I also ran to the different cities with the graphics turned to the classic models and they all look great. The NPC appearances get randomized so everyone has a different look and outfit. It really diversifies the cities instead of most people looking identical.

[bigwhitebuddha]

Pallos,

I was receiving a similar error when using Heidi. I investigated, and discovered that there was a mistake in one of the locations for the Witches of the Velvet Order. If you load up Heidi, and go to the "Witches of the Velvet Order" section you will find the location for each witch. Find the one with the following location:

('800005', 'nektulos', '-977.896', '1564.54.54', '26.9251', '300', '1'),

If you look at this line, you will see that '1564.54.54' is incorrect. I changed it to '1564.54'. After that, it worked perfectly! Hopefully you find this helpful!

[djeryv]

Originally Posted by bigwhitebuddha

Pallos,

I was receiving a similar error when using Heidi. I investigated, and discovered that there was a mistake in one of the locations for the Witches of the Velvet Order. If you load up Heidi, and go to the "Witches of the Velvet Order" section you will find the location for each witch. Find the one with the following location:

('800005', 'nektulos', '-977.896', '1564.54.54', '26.9251', '300', '1'),

If you look at this line, you will see that '1564.54.54' is incorrect. I changed it to '1564.54'. After that, it worked perfectly! Hopefully you find this helpful!

Thanks! I fixed the download package with this.

[bigwhitebuddha]

I have also run into an issue I could use help with. Currently, everything is looking good, but I am unable to speak with any of the witches (Except for the one in POK). I can see their character models, and can also hail them, but receive no dialog in response. This is not the case with any of the other custom added characters. Can anyone help with this?

[djeryv]

Originally Posted by bigwhitebuddha

I have also run into an issue I could use help with. Currently, everything is looking good, but I am unable to speak with any of the witches (Except for the one in POK). I can see their character models, and can also hail them, but receive no dialog in response. This is not the case with any of the other custom added characters. Can anyone help with this?

Try standing on top of them and then hail them. If that works it is because I just realized (this morning) that the aggroradius plays a part in this and the solo_server.sql processes in an order that caused the witches to have a 15 instead of a 55 aggroradius. I fixed the main download zip package to fix this, but if this is truly your issue just run the query below to make it better.

UPDATE npc_types SET aggroradius=55 WHERE ( id>=800000 AND id<=800100 );

...and this to give the rest of the world a bit more reach to notice you...

UPDATE npc_types SET aggroradius=35 WHERE aggroradius>35;

[bigwhitebuddha]

Originally Posted by djeryv

Try standing on top of them and then hail them. If that works it is because I just realized (this morning) that the aggroradius plays a part in this and the solo_server.sql processes in an order that caused the witches to have a 15 instead of a 55 aggroradius. I fixed the main download zip package to fix this, but if this is truly your issue just run the query below to make it better.

UPDATE npc_types SET aggroradius=55 WHERE ( id>=800000 AND id<=800100 );

...and this to give the rest of the world a bit more reach to notice you...

UPDATE npc_types SET aggroradius=35 WHERE aggroradius>35;

Unfortunately, this did not fix the issue. It seems like the NPC's are aware of my "Hail". However, they give no response dialog after said "Hail".

[djeryv]

Originally Posted by bigwhitebuddha

Unfortunately, this did not fix the issue. It seems like the NPC's are aware of my "Hail". However, they give no response dialog after said "Hail".

Which NPCs specifically?

[bigwhitebuddha]

Originally Posted by djeryv

Which NPCs specifically?

These are the following NPC's:

Sister Talsir, Shokar, Greska, Bresta, Frakla, Peshir, Annabe, Martal, Nebris, Ruskal, Ortizk, Evalla, Xeryth, Catala

[djeryv]

I just talked to Frakla with no issue. Do you have the perl scripts in your quests/global folder?

[bigwhitebuddha]

Originally Posted by djeryv

I just talked to Frakla with no issue. Do you have the perl scripts in your quests/global folder?

Yes, I do. I downloaded the scripts again, and placed them into my global folder, just in case. I am still encountering the same issue.

[djeryv]

Can you talk to any of the artisans or arcanums in town? Do they show you any items you can buy from them?

[bigwhitebuddha]

Originally Posted by djeryv

Can you talk to any of the artisans or arcanums in town? Do they show you any items you can buy from them?

I am able to speak to the Emerald Eye Sage, but I cannot buy from the artisan or the arcanum. I can speak to them though

[djeryv]

Then I would guess that you don't have Perl installed with the Perl DBI (Database Integration) so plugin::LoadMysql(); works correctly. Can you verify that is installed? I am now also guessing you are running a Windows server?