Merchants without Anything to sell?

[ChUzZ84]

Hey guys,

having an issue at the moment where all merchants are empty nothing on them at all to sell. Anyone have a similar post they can direct me too? or where I can look on my server to find the issue?

[ChUzZ84]

Actually I am finding now when I use the GM command #itemsearch that there is always 0 results.

[So_1337]

Sounds like you have an empty items table. Which database are you using?

[ChUzZ84]

PEQ

tried re-installing and still nothing. Any idea?

[hayward6]

have a look at the items table in the database and see if anything is there. If its empty, you'll need to source it in again... maybe you missed a step in soursing it? Are there any errors in the log when you start up the server? it should list the number of items it loads when first started.

[ChUzZ84]

Items are there...

1000-2123 listed... seems small amount for this game.

This I noticed come up in startup

http://roarpower.net/images/error01.jpg

[cavedude]

Where are you getting the DB from? That error indicates the one you have is rather old as the items table hasn't changed in some time... You can either grab a semi-current DB from the installer:

http://www.projecteq.net/phpBB2/viewtopic.php?t=4346 updates are here: http://www.projecteq.net/phpBB2/viewtopic.php?t=4612

Or, if you feel like fiddling with CVS (not hard at all, and there are tons of tutorials about) this is where you'll always find our current DB:

http://www.projecteq.net/phpBB2/viewtopic.php?t=2258

[So_1337]

Yes, grabbing everything from CVS is the way to go. Here's a great tutorial (http://www.projecteq.net/phpBB2/viewtopic.php?t=5632) if you'd like the latest PEQ has to offer.

/plug off

[ChUzZ84]

do i need to install all the ones in this link? I only installed 1110a which might explain something.

http://www.projecteq.net/phpBB2/viewtopic.php?t=4612

[So_1337]

You need only install the most recent, I believe.

[ChUzZ84]

yeah I did download...

Database Version: 0.7.0-1110a

any newer then that?

[cavedude]

The most recent one on that page is 1129, which is far newer than 1110a. There will be another update soon, though I can't say when. You have to install the full version like you did, and then install the newest upgrade pack over it, which is 1129. That will at least get you working ;)

The CVS is now using 1129Rev82 which is current as of this morning.

[Derision]

That error is likely to be because you are using MySQL 5.1. See this thread:

http://www.eqemulator.net/forums/showthread.php?t=24079

The column name 'range' in the items table became a reserved word in MySQL 5.1. Try 5.0.<something>.

[ChUzZ84]

Ok changed to 5.0 and no longer getting the error message when I boot. Now the only issue is the World Server is not appearing in the Login Server.

[ChUzZ84]

Oh and does anyone know how to enable your server for PVP?

[ChUzZ84]

Fixed it all... working fine.