minilogin zone problem
 

ok i login create a character then it says zone unavailible i started 5 manually

[Status] Loading spawn groups...
Error2 in PopulateZoneLists query 'SELECT DISTINCT(spawngroupID), spawngroup.nam
e, spawngroup.spawn_limit FROM spawn2,spawngroup WHERE spawn2.spawngroupID=spawn
group.ID and zone='nexus'' #1146: Table 'localpeq.spawn2' doesn't exist
[Error] Starting Log: logs/eqemu_error_zone_4016.log
[Error] Loading spawn groups failed.
Zone->Init failed
[Debug] [ZONE__INIT_ERR] Zone bootup FAILED!
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch Anniversary
[Debug] [NET__IDENTIFY] Registered patch Live

is the error how do i fix this

It's basically saying it can't find the table spawn2 in the database named localpeq. In other words, there's an issue with your database. This is resulting in the zone crashing when it tries to load that information from the database (it can't find it).

First, what is the name of your database? Did you name it peq or localpeq?

localpeq is the db

If localpeq is the name of your DB in MySQL, then it indicates there was an issue when you sourced your database.

Are you able to use a utility to browse your database like Navicat, etc?

yes what do i do?

You'll need to use it to re-source your database.

the db worked for my public shard just fine all i did was copy it then added the mini login stuff to it is all both have the spawn 2 problem but i can login to my public one . i only get as far as character creation w\ mini one click enter world and i get the zone unavailible

how do i add the missing stuff to the db

Are you using a published database (PEQ, AngeloX's Classic, etc) or a custom database?

peq distro

[Status] Booting neriakc
Map header: 46138 faces, 135 nodes, 55697 facelists
Loaded map: 138414 vertices, 46138 faces
Map BB: (-1889.25 -> 14.00, -14.00 -> 1427.44, -139.94 -> 55.97)
Map ./Maps/neriakc.map loaded.
Water Map ./Maps/neriakc.wtr not found.
Path File ./Maps/neriakc.path not found.
[Debug] The next weather check for zone: neriakc will be in 13594 seconds.
Error loading NPCs from database. Bad query: #1146: Table 'localpeq.spawn2' does
n't exist
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
Error2 in PopulateZoneLists query 'SELECT DISTINCT(spawngroupID), spawngroup.nam
e, spawngroup.spawn_limit FROM spawn2,spawngroup WHERE spawn2.spawngroupID=spawn
group.ID and zone='neriakc'' #1146: Table 'localpeq.spawn2' doesn't exist
[Error] Starting Log: logs/eqemu_error_zone_1460.log
[Error] Loading spawn groups failed.
Zone->Init failed

seems to be a spawn2 error

i get this in minilogin window:
[Debug] [WORLD__CLIENT] New connection from 127.0.0.1:2119
[Debug] [NET__IDENT_TRACE] 127.0.0.1:2119: First opcode 0x4dd0 did not match exp
ected 0x2792
[Debug] [NET__IDENT_TRACE] 127.0.0.1:2119: Tried patch 6.2_world, and it did not
match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:2119: First opcode 0x4dd0 did not match exp
ected 0x2ec9
[Debug] [NET__IDENT_TRACE] 127.0.0.1:2119: Tried patch 6.2_zone, and it did not
match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:2119: First opcode matched 0x4dd0 and lengt
h matched 464
[Debug] [NET__IDENTIFY] Identified stream 127.0.0.1:2119 with signature Titanium
_world
[Debug] [WORLD__CLIENT] New client from 127.0.0.1:2119
[Debug] [WORLD__CLIENT] audio: Logged in. Mode=(CharSel)
[Debug] [WORLD__CLIENT] audio: MiniLogin Account #1
[Debug] [WORLD__CLIENT] audio: Attempting autobootup of neriakc (42)
[Debug] [WORLD__CLIENT_ERR] audio: Received unknown EQApplicationPacket
[Debug] [WORLD__CLIENT_ERR] [OpCode OP_WorldLogout (0x7718) Size=0]
[Debug] [WORLD__CLIENT] audio: Client disconnected (not active in process)