Quests not working

[Mephisto_VI]

I got my server to where I could login finally (thanks again Uleat!), but on entering the tutorial zone (further testing to work out all the bugs and misconfigurations), I immediately see InvalidTaskID(22) and InvalidTaskID(23). I made sure I had followed the guide, and trying to do a checkout, it tells me they are not compatible as they are too old for my version. Tried getting a completely new copy then moving the old ones out and then the new ones in, and still gives me the invalid task ID message after rebooting the server and the client. First step to take for troubleshooting this?

[joligario]

Tasks are in the database. Sounds like yours is not complete.

[Uleat]

I think someone posted about this before..lemme see if I can dig up that thread (I don't remember the cause atm...)

---

This is not the one I was looking for..I've seen this discussion with someone in the last 6 months, or so..but, it could have been in irc...

Verify the version of perl that you installed first: http://www.eqemulator.org/forums/showthread.php?t=33867&highlight=invalid+taskid

If that is correct, re-run CMake to verify that it found the proper version and location of perl.

(In very odd or extreme cases, CMake can find 'distributed' versions of perl before finding the 'installed' version. This shouldn't happen
unless you install multiple versions or have software with a perl distro that placed it's 'path' variable before the installed one's.)

Give that a shot and see where you stand.


EDIT: Version check includes x86 vs. x64. You still need x86 (32-bit) if you are compiling 32-bit server code.

[Mephisto_VI]

How do I check to see if CMake detects my installation of Perl? I followed the guide here: http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide&frm=Main to the letter, and verified I did install the called for versions (including x86, did not install x64)

[Uleat]

I re-ran cmake and found that it doesn't report locations unless you delete the cache..configuring should suffice for this info:

Found ZLIB: C:/Users/uleat/Desktop/git-eqemusource - inv_v2/Server/dependencies/zlib_x86/lib/zdll.lib (found version "1.2.3")
Found MySQL: C:/Users/uleat/Desktop/git-eqemusource - inv_v2/Server/dependencies/mysql_x86/lib/debug/mysqlclient.lib
Found Perl: C:/Perl/bin/perl.exe (found version "5.12.3")
Found PerlLibs: C:/Perl/lib/CORE/perl512.lib (found version "5.12.3")
Configuring done

[Mephisto_VI]

Verified my perl version is correct. Joligario is possibly correct. Not finding much under tasks in the DB. No table for quests, only quest_globals. Only one (yes, one) I have under tasks is 12, "Extraordinary Rodents". Where can I find the rest of the DB tasks? I searched the peqbeta.sql file i was instructed to download and it only has the one task. It was dated June 14 2014

[Uleat]

I have an older dump..but, it's showing 162 task entries.

I did notice that mine showed ID12 "Extraordinary Rodents" as the first entry..then, the rest numerically ascending - starting with ID1.


Did your database sourcing error out on you? If so, you may be missing additional parts of it.

I'm showing ~213.4 MB for a nearly clean database..if you're smaller than that, post back and see what happens.

[Mephisto_VI]

Its smaller. Like 205 MB for initial, but my backup I made yesterday is around 244 MB with my accounts and three test characters. No errors sourcing that I recall. I may have a bad download and need to drop all of it and re-source it. Finally got to download the latest dump (6/22/14) and will try a full drop and re-source from it.

EDIT: Nope, newest dump shows the same size. Can you export the tasks table and upload it for me please? In the mean time I will see about getting ahold of Cavedude and asking them about the dumps.

[Mephisto_VI]

Messaged cavedude about the database. Waiting for a reply.

[Uleat]

I don't know what the results will be if you try this..but, here's a link to my db's copy:

http://wiki.eqemulator.org/i?Module=Pastebin&Paste=euxmTsEw


If there is external linkage to this table, it may crash your database. Dropping system and reloading it should put you back, though. (You may have to manually delete any
player task history...)

[Mephisto_VI]

Trying to save it as an sql file is giving me headaches when I try to run it, too many syntax errors it says. Will manually insert each line and then give it a go. Thank you though for posting it as it gets me much further than I was. Will post back after I get it entered.

[Mephisto_VI]

Ok, cavedude responded and says they ARE indeed in the sql files. I verified what he said. The tasks in the sql file I downloaded from the dump are in one massively long line instead of each task on its own line. Guess I will have to do a drop_system and re-source after all.

[Mephisto_VI]

Ok did a drop_system, then re-sourced the peqbeta file. Tasks now show 162 entries. One error during the whole process that I caught, and that mentioned something about a foreign key (during the drop_system query).

EDIT: Tasks now showing up. Newly created character assigned tasks 22 and 23. They completed properly. Will figure out how to add them to the characters I already made shortly. Thanks everyone for your help :D

Now I just have custom work to do, and tweak one NPC (spawns under the floor, rendering one task impossible to finish. A Vah Shir Rogue GM in their starting city, Ta-something is all I can remember)

[Nightrider84]

#spawnfix is your friend :)

[Mephisto_VI]

Will give that a try, thanks Nightrider84