Merchants without Anything to sell?

[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 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>.