i did everything in the post to do and i got his error too
when i did source the Source items-0.6.0-DR2-0.6.1-DR1-convert.sql;

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Brandon>cd\ c:\mysql\bin
The filename, directory name, or volume label syntax is incorrect.

C:\Documents and Settings\Brandon>cd c:\mysql\bin

C:\Mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 4.0.23-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq;
Database changed
mysql> source items-0.6.0-DR2-0.6.1-DR1-convert.sql;
ERROR 1054: Unknown column 'unknown021' in 'items'
ERROR 1054: Unknown column 'unknown022' in 'items'
ERROR 1054: Unknown column 'unknown023' in 'items'
ERROR 1054: Unknown column 'unknown064' in 'items'
ERROR 1054: Unknown column 'unknown070' in 'items'
ERROR 1054: Unknown column 'unknown072' in 'items'
ERROR 1054: Unknown column 'combatskill' in 'items'
ERROR 1054: Unknown column 'combatskilldmg' in 'items'
ERROR 1054: Unknown column 'booktype' in 'items'
ERROR 1054: Unknown column 'unknown108' in 'items'
ERROR 1054: Unknown column 'banedmgamt2' in 'items'
ERROR 1054: Unknown column 'augmentrestriction' in 'items'
ERROR 1054: Unknown column 'tribute' in 'items'
ERROR 1054: Unknown column 'attackbonus' in 'items'
ERROR 1054: Unknown column 'hpregen' in 'items'
ERROR 1054: Unknown column 'hastepercent' in 'items'
ERROR 1054: Unknown column 'unknown125' in 'items'
ERROR 1054: Unknown column 'unknown126' in 'items'
ERROR 1054: Unknown column 'unknown127' in 'items'
ERROR 1054: Unknown column 'distiller' in 'items'
ERROR 1054: Unknown column 'unknown129' in 'items'
ERROR 1054: Unknown column 'unknown130' in 'items'
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1054: Unknown column 'unknown131' in 'items'
ERROR 1054: Unknown column 'unknown132' in 'items'
ERROR 1060: Duplicate column name 'UNK121'
ERROR 1060: Duplicate column name 'pointtype'
ERROR 1060: Duplicate column name 'potionbelt'
ERROR 1060: Duplicate column name 'UNK124'
ERROR 1060: Duplicate column name 'stacksize'
ERROR 1054: Unknown column 'hasteproclvl' in 'items'
ERROR 1054: Unknown column 'spellid' in 'items'
ERROR 1054: Unknown column 'focusid' in 'items'
ERROR 1054: Unknown column 'effecttype' in 'items'
ERROR 1054: Unknown column 'level' in 'items'
ERROR 1060: Duplicate column name 'UNK129'
ERROR 1060: Duplicate column name 'proceffect'
ERROR 1060: Duplicate column name 'proctype'
ERROR 1060: Duplicate column name 'proclevel'
ERROR 1060: Duplicate column name 'UNK133'
ERROR 1060: Duplicate column name 'worneffect'
ERROR 1060: Duplicate column name 'worntype'
ERROR 1060: Duplicate column name 'wornlevel'
ERROR 1060: Duplicate column name 'UNK137'
ERROR 1060: Duplicate column name 'focustype'
ERROR 1060: Duplicate column name 'focuslevel'
ERROR 1060: Duplicate column name 'UNK141'
ERROR 1060: Duplicate column name 'scrolleffect'
ERROR 1060: Duplicate column name 'scrolltype'
ERROR 1060: Duplicate column name 'scrolllevel'
ERROR 1060: Duplicate column name 'UNK145'
ERROR 1054: Unknown column 'cost' in 'items'
ERROR 1054: Unknown column 'casttime2' in 'items'
ERROR 1054: Unknown column 'proc_rate_mod' in 'items'
ERROR 1054: Unknown column 'charmformula' in 'items'
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1054: Unknown column 'ldonpointtheme' in 'items'
ERROR 1054: Unknown column 'ldonpointcost' in 'items'
ERROR 1054: Unknown column 'gmflag' in 'items'
ERROR 1060: Duplicate column name 'serialized'
ERROR 1060: Duplicate column name 'verified'
ERROR 1060: Duplicate column name 'serialization'
ERROR 1060: Duplicate column name 'source'
ERROR 1060: Duplicate column name 'UNK033'
ERROR 1091: Can't DROP 'charges'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown001'. Check that column/key exists
ERROR 1091: Can't DROP 'collected_slot_id'. Check that column/key exists
ERROR 1091: Can't DROP 'merchantprice'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown004'. Check that column/key exists
ERROR 1091: Can't DROP 'collected_inst_id'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown006'. Check that column/key exists
ERROR 1091: Can't DROP 'spellcharges'. Check that column/key exists
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

mysql>

i know this is out of order with the steps but this is what happend when i did all the steps in synch
im doing a fresh install with no other server to be upgraded

Aradorn:
Drop the EQ Database! I linked to a page where it describes how to drop a database. You already aparently have a eq database.(and from the looks of it, one which isnt current, or is incomplete)

If you dont want to drop the databse then simply make the database name eqb or eq2 or testing, or database. And just make sure you change the db.ini file to point to your new database.

You dont need it named EQ. It looks as though you already have a eq database.

The second way you can rid yourself of the database is to navigate to your mysql/data directory and DELETE the eq folder. Then restart your computer, and start from step 1.

Either way, you missed my post about dropping teh database, you already have one there, youre trying to overwrite it.

sorry bout that i see it now thanks.... one last question im not clear on. on step 14 I dont put the bracket around username and password right

Thanks Iwantavr4, my issue is when i type username and password in EQ (after the patchme thing) it just pauses for a minute then says, make sure you are online, can't connect to server. I can't get past that when using minilogin. If i use eqemu login i can get to others servers and such, and even see mine if i start world.exe and all, Course i can't play on mine i get 1017:) so i tried getting a dns $15.00 and all kinds of other combos

Not going to give up. I have had this working, and im awesome at database work.. i populated like 12 zones with correct mob named and itemized drops. I really liked doing that and am trying to get this working so i can do it again lol. May have to wait for eqemu to catch live. Would probably be best.

No brackets around the user/password.

If youre trying to set this up with a network i cant help you... I didnt set mine up that way. I set it up to fly solo on my own PC. 127.0.0.1 is local loopback for computers.

dropping server and redoing it fixed the database prob
in world.exe it does this
[status] loading ./addon.ini'
couldn't open './addon.ini'.
[status] loading EQ time of day..
Failed to open log file: logs/emu_error_world_3044.log
[error] could not load EQTime file ./eqtime.cfg
[error] Unable to load ./egtime.cfg
and in all boot5zones it does this
[quest] loading perl commands...
[quest] Warning - commands.pl: perl runtime error: open 'commands.pl' No such file or directory at (eval 4) line 1.

other then that everything else loads fine

Okay, i was wondering if some files would be missing. Now that you mention it, there are a few other files.

The commands.pl is a file i havent been able to find and the folks at PEQ said its not neccisary. So no worries on that one. Ill update the guide in a couple hours, but for now, CHOW! :)

Edit: Cant get those extra files. For some reason i cant upload anything here. Probably has to do with the firewall. See post below, updated main guide also to reflect changes.

the file says the archive is either in unknown format or damaged

Okay i changed step 5 of the guide, it now has a link to the eqemu compile perl version from the eqemulator sourceforge site. Download that file, extract all the files within to your C:\eqemu\ then overwrite world.exe, perlzone.exe and emusharemem with the updated files from the other 6.1perl zip file.

Oh, also! I feel i should mention i tried this on my laptop, which is running windows XP with service pack 2. You need to make sure your XP Firewall is set to prompt you when you have programs trying to run servers, open ports, or connect to stuff... Otherwise this wont work. I think i had to set 3 or 4 different programs when they popped up to 'unblock'. If you are running winXP this may be why some of you arent seeing your servers. Because XP Firewall is blocking the server programs from broadcasting or recieving information!

At this step

16) Then source the following databases into the database by typing the following commands(In this order)
Code:

Source load_system.sql; Source load_empty_users.sql; Source items-0.6.0-DR2-0.6.1-DR1-convert.sql; Source 0.6.1-upgrade.sql; Source ZONECFG.SQL; Source altadv_vars-contents.sql;

i am getting this error

mysql> source load_system.sql;
ERROR:
Failed to open file 'load_system.sql', error: 2
mysql>

I'm sure that i'm doing something totally noobish, and that this error is easily fixed. If anyone could help me i'd really appreciate it 8) thanks.

did you make sure all those files are in c:\mysql\bin folder. make sure there are no folders inside the bin

iwantavr4 do you have EQVercheck if you do can u post your version i want to make sure mine matches i didnt patch on 5/11 but i did patch up to 5/11 and i want to make sure my version matchs befor i continue

I think that's the problem, those first two files don't exist.

Source load_system.sql;
Source load_empty_users.sql;

I didn't see anywhere in the tut where it says to download them.

those files are in the peq-velious-beta1.zip

sql files not missing
 

Velious beta Database from PEQ
http://prdownloads.sourceforge.net/p...ious-beta1.zip

then extract them in step:

8) Extract the following database files to C:\Mysql\bin
8a) peq-velious-beta1.zip

:)

Used this tutorial and everthing works execpt the merchants :)
i did get 2 beeps on the Source load_system.sql but it scrolled by so fast i wasnt able to find out what caused the beeping...

[edit] Aradorn types faster than me

Thanks 8). I noticed when i extraced the velious db that there was a directory in the zip file, and the tut didn't mention anything about not leaving it there so i just extracted the directory. I really appreciate the help.

this is my eq version pre 5/11 just wondering if this is the right one to work with the 6.1dr1
SHORT VERSION: SEQ8A667
LONG VERSION: EQ10F6C5D8579C384AAACC9FA61E2727A6B8291587

same here
 

thats the same eq version i have that works with this tutorial

ok i guess im gonna have to redo the tutorial ... one thing i found wierd tho when i installed winmysqladmin it didnt ask me to put in a username\pass but when i go to my.ini setup it has the username\pass in there...


i did have this program before i did the tutorial, but i went to control panel and add\remove software and installed the winmysql i downloaded.


anyways i use the user/pass off of winmysql when i do the sourceing i hope this is correct also

yep, use the username and pass you made when starting the winmsqladmin

GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;

change the username to the username your using, likely root, then set the password to what ever you want the pass to be

this changes the permissions to allow the user to use any database, if you wanted to just do one database for example, change the *.* to dbname.* (database name . and * for all tables etc in that database)

execute this command using the mysql -u [username] -p[passsword]
just with the -p and it will prompt for the password if one is set

forexample:
c:\mysql\bin\mysql -u root -ppassword
(notice no space between the -p and the password)

dont forget to change databases before sourcing, example:
use eq;

:) hope that helps some

Anyone wanna add onto this explaining how to get it to go public?

Alright, i got through the whole tutorial with only one error this time, when i try running world.exe i get this

Failed to open log file: logs/eqemu_world_2744.log
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1
[Status] Loading opcodes..
[Error] Load Shared Library 'EMuShareMem' failed. Error=Error #14001
Unable to laod EMuShareMem for opcodes.
Failed to open log file: logs/eqemu_error_world_2744.log
[Error] Loading opcodes failed. I can't live like this!

Anyone know what's wrong?

Failed to open log file: logs/eqemu_world_0196.log 1st line on world.exe

this below is the last thing in world.exe everything inbetween loads perfectly now
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1170: 127.0.0.1:8782
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1169: 127.0.0.1:878088166 New TCP connection: 127.0.0.1:16777343New zoneserver: #3 127.0.0.1:1173
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1173: 127.0.0.1:878490169 New TCP connection: 127.0.0.1:16777343New zoneserver: #4 127.0.0.1:1172
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1172: 127.0.0.1:878192172 New TCP connection: 127.0.0.1:16777343New zoneserver: #5 127.0.0.1:1171
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1171: 127.0.0.1:8783

this is the only 2 errors i see on world.exe now

was i supposed to put username\pass in LoginServer.ini

5) Extract Compiled-Perl-Win32.zip to C:\EQEmu\, then extract EQEmu-0.6.1-DR1-Perl.zip to the same directory and ensure you *OVERWRITE* world.exe, zoneperl.exe, and emusharemem.dll
did you unzipp both those into c:\eqemu

I'm pretty sure i did, but i'm completely redoing the tut now..

if you redo make sure you go to control panel and add/remove mysql and perl.. then delete the perl mysql and eqemu folder or you will still get problems

Thanks, i tried redoing it once, and didn't completely remove mysql and i ran into problems when i tried making the eq db

Arrrggghhhh
 

I just redid the entire tutorial without error until i got to where i lauch world.exe, and it gave me this same error again

Failed to open log file: logs/eqemu_world_2744.log
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1
[Status] Loading opcodes..
[Error] Load Shared Library 'EMuShareMem' failed. Error=Error #14001
Unable to laod EMuShareMem for opcodes.
Failed to open log file: logs/eqemu_error_world_2744.log
[Error] Loading opcodes failed. I can't live like this!

I'm stumped... Anyone have any advice please?

iwantavr4 i got a question... finnaly gotinto eq but when im in wfreeport i get a pet error or something then after a few min it dropps me has this happend to you

ok here is the error
Debug Error!

Program: C:\eqemu\zoneperl.exe
modul:c:\eqemu\zoneperl.exe
file:

Run-time check failuer #3- the variable 'petstruct' is being used with being defined.
(press retry to debug the application)

its a microsoft visual c++ debug library

Aradorn,
import these in to your database, its originally from cavedudes database, but i changed the server name in my set up :)

you might already have the minilogin one thats if your useing it, i dont know what they all do but the error is mainly related to

might actually change the pass too though, here are the rest of the vars i have set currently

:)

drognir,
might try making a log dir in your eqemu dir, not sure otherwize :)

I had the pet construct error, but its late and i'm not remembering what i did to fix it..... hummm

I dont know how you got your version number... The one i have was created/modified on this date:
Sunday, April 17, 2005, 10:13:30 PM

And has the following MD5 Hash:
40B0DA1CCB3C3C07947261B016201328

that log thing u jsut mentioned do you just make a folder called log? i also updated post above about the error

yes, logs actually ;)

version tool
http://www.eqemulator.net/forums/showthread.php?t=17992

thats what i used to determin which version i am running, though it doesnt list my version, but its working - at lease at the moment

pet construct error, actually still have this error

I think it is related to the perl compile version of zone, i just started messing with it today, i dont know of a fix. there is a non-perl version that does work, but no quests with it as far as i know...

i'll look up the link....
http://www.eqemulator.net/forums/showthread.php?t=18675

try one of the no perl versions listed there, have to beg the others here to find out more about the pet construct error

When i get that problem, i hit ignore, otherwise it crashes the zone. Not sure how to fix it. If you hit retry or abort it will usually make you LD. Ignore just lets it continue. I dont know how to fix it...

For that you just need to create a c:\eqemu\logs directory.

Im adding these extra steps and the sourced in stuff you put here also.. Thanks vRandom.

Okay, before you redo everything. First create a logs directory in your C:\EQEmu folder (C:\EQEmu\logs).

Then, try re-unzipping the EQEmu-0.6.1-DR1-Perl.zip again to your eqemu directory, make sure you overwrite the three files zone, world, and emusharemem.

I think im going to add some troubleshooting steps to the bottom of my minilogin post...

Also:
If you feel the urge to REDO the database, you dont have to reinstall everything. Type the following code to delete the eq database:
You can then redo your database.