Compile/Running server problems

[Acheronx]

Running into a few problems. I'll explain what I did or doing at the time of the errors.

  LoadLibraryEx(C:\dev\planeshift\dbmysql.dll) error 998: Invalid access to memory location.
SCF_WARNING: factory returned a null instance for planeshift.database.mysql if error messages are not self explanatory, recompile CS with CS_DEBUG
WARNING: could not load plugin 'planeshift.database.mysql'

-- Some LOG stuff, if needed, I could post that, otherwise I'm sure it's not important? --

planeshift.application.server:
  No iDataConnection plugin!
    7701 <c:\dev\planeshift\src\server\psserver.cpp:250 psServer::Initialize>
    7703 Could not create database or connect to it:
    7703 error while initializing server!

That error pops up when I try to run psserver.exe. The file dbmysql.dll is located in the same directory as the psserver.exe, and I'm pretty sure it's not corrupted.I did compile the plgdbmysql and it was successful (aside from a warning that it couldn't find dbmysql.lib). Also the database is running at the time, proper tables, user account works, version 5.x CE (as directed in the guides)

Any help to figure what I might have done wrong or whatever it may be will be greatly appreciated.

Side note: I did as the guide said, downloaded and compiled the files required. So I'm at a loss to what's wrong. :x

Thanks in advance.
-Ach

[ThomPhoenix]

Did you point dbgmysql to your mysql folder and did you install the mysql dev package?

[Acheronx]

As it explained in the guide that everyone keeps telling me to read, it says Community Edition, and yes, I downloaded that. No where does it say a dev version of mysql, or where to download it. So if Dev isn't the same as CE, then I'll have to say no.

[ThomPhoenix]

If it has an include folder, you'll be alright.
Now, check your psserver.cfg and look if it has the right settings for your database after line 66.

[Acheronx]

The data in there is correct as well.

localhost//database//user//pass all work (I've been able to connect and see the tables using SQLyog).

[ThomPhoenix]

What about a clear all and complete rebuild in MSVC?
You can also visit #planeshift-build on the Freenode network (IRC) for more support.
If you find the issue, please post the solution here.

[Acheronx]

Been to the irc channel, no one could help (no one knew MSVC too)

I think I found out what the issue was. On the guide it never says which version MySQL I need, only to get the Community Edition. Was told to get 5.0.37, so I'll try that out.

[ThomPhoenix]

On the MySQL page you automatically get the latest one, why did you take an older version?

[Acheronx]

Because 5.0.37 works?

Finally got a reply and there is a known issue with the 5.0.41 version of MySQL, so that's why the downgrade worked.

[ThomPhoenix]

Oh no, I thought you downloaded an even older version of MySQL and that .37 was the current stable one. I should've looked first. Good to know that .41 is bugged.

[Acheronx]

Running into another problem with "spawn". It might be something that I forgot, seems to be a libpng libjpeg issue from not compiling with CS, also crashes after loading the kernel32.dll. Do I need those dlls in the PS directory?

I'll try to sort it out, if I can't figure it out, back to forums I go.

[ThomPhoenix]

You don't need kernel32.dll in the Planeshift dir.
And please post the error you get here. If spawning goes wrong it might be the database. Is the database created without warnings? You hear warnings as beeps.

[Acheronx]

All the tables were created successfully. =/

<bunch of calc spam> Calculated maxSize to be 750.00  221701
<c:\dev\planeshift\src\server\gem.cpp:806 gemObject::InitMesh>
  221703 Could not create Item because could not load  file into mesh.
  221704 <c:\dev\planeshift\src\server\gem.cpp:692 gemObject::gemObject>

  221704 Could not create gemObject because mesh could not be Init'd.
  221704 <c:\dev\planeshift\src\server\gem.cpp:693 gemObject::gemObject>

  221704 Name: Fist Factory:  File: /planeshift/.spr
  221704
  221705 Object  was not created.
Assertion failed: obj->GetEntity() != 0
Location:         c:\dev\planeshift\src\server\entitymanager.cpp:900
Call stack:
[0x0067abbd] (psserver.exe)EntityManager::CreateItem+0x67d @c:\dev\planeshift\src\server\entitymanager.cpp:900 ()
[0x00712d2b] (psserver.exe)SpawnManager::RepopulateItems+0xdb @c:\dev\planeshift\src\server\spawnmanager.cpp:548 ()
[0x0065e3f0] (psserver.exe)com_spawn+0x60 @c:\dev\planeshift\src\server\command.cpp:496 ()
[0x008d16b2] (psserver.exe)execute_line+0x232 @c:\dev\planeshift\src\common\util\serverconsole.cpp:149 ()
[0x008d203f] (psserver.exe)psServerConsoleCommand::Trigger+0x1f @c:\dev\planeshift\src\common\util\serverconsole.h:139 ()
[0x008bf648] (psserver.exe)EventManager::ProcessEventQueue+0xe8 @c:\dev\planeshift\src\common\util\eventmanager.cpp:97 ()
[0x008bfb9d] (psserver.exe)EventManager::Run+0x2ad @c:\dev\planeshift\src\common\util\eventmanager.cpp:207 ()
[0x00765bf6] (psserver.exe)CS::Threading::Implementation::`anonymous namespace':
:proxyFunc+0x36 @c:\dev\cs\libs\csutil\threading\win32_thread.cpp:117 ()

[0x102047c1] (MSVCR80D.dll)beginthreadex+0x221
[0x10204767] (MSVCR80D.dll)beginthreadex+0x1c7
[0x7c80b50b] (kernel32.dll)GetModuleFileNameA+0x1b4

Hopefully that'll help figure more of what's going wrong. I'm at a loss.

[ThomPhoenix]

Ah, I knew how to fix that.
But I forgot.
Someone in #planeshift-build knows, because they told me.

[Acheronx]

Have been trying in there, no luck so far.

I might just switch to linux anyways. Too many problems and not much support for Windows. Thanks for the assistance though, Thom.