Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-27-2014, 10:08 AM
Adcid
Fire Beetle
 
Join Date: Nov 2014
Location: Idaho
Posts: 23
Default

Code:
[Status] Using database 'peq' at 127.0.0.1:3306
Perl Version is 5.12.3
============================================================
           EQEmu: Automatic Database Upgrade Check
============================================================
        Operating System is: MSWin32
        (Windows) MySQL is in system path
        Path = C:\xampp\mysql\bin/mysql
============================================================
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
        Binary Database Version: (9057)
        Local Database Version: (9057)

        Database up to Date: Continuing World Bootup...
============================================================
[Error] GetInventory query 'SELECT slotid, itemid, charges, color, augslot1, aug
slot2, augslot3, augslot4, augslot5, instnodrop, custom_data FROM inventory INNE
R JOIN character_data ch ON ch.id = charid WHERE ch.name = 'Oldsong' AND ch.acco
unt_id = 2 ORDER BY slotid' #1146: Table 'peq.inventory' doesn't exist
[Error] If you got an error related to the 'instnodrop' field, run the following
 SQL Queries:
alter table inventory add instnodrop tinyint(1) unsigned default 0 not null;

Error loading inventory for Oldsong
Error in Log IP query 'INSERT INTO account_ip SET accid=2, ip='127.0.0.1' ON DUP
LICATE KEY UPDATE count=count+1, lastused=now()' #1146: Table 'peq.account_ip' d
oesn't exist
[Error] GetInventory query 'SELECT slotid, itemid, charges, color, augslot1, aug
slot2, augslot3, augslot4, augslot5, instnodrop, custom_data FROM inventory INNE
R JOIN character_data ch ON ch.id = charid WHERE ch.name = 'Oldsong' AND ch.acco
unt_id = 2 ORDER BY slotid' #1146: Table 'peq.inventory' doesn't exist
[Error] If you got an error related to the 'instnodrop' field, run the following
 SQL Queries:
alter table inventory add instnodrop tinyint(1) unsigned default 0 not null;

Error loading inventory for Oldsong
I am able to create a character, in this example a character named "Oldsong". I am not able to log into the character. I unable start i seem to be missing inventory from my database. Ive looked in everything ive downloaded and while Ive found updates and changes to an existing inventory within my database, nothing that says, "CREATE TABLE INVENTORY"
Reply With Quote
  #2  
Old 11-28-2014, 02:19 PM
Adcid
Fire Beetle
 
Join Date: Nov 2014
Location: Idaho
Posts: 23
Default

resolved my missing Inventory table in my database. Found that the most recent player_tables_2014-10-11-02_01.sql file did not contain the needed inventory tables required to finish server. I was however able to download the previous version "player_tables_2014-09-25-02_01.sql" that had the inventory tables for the server.

I hope anyone trying to start a Windows based server will read this and save themselves a bit of frustration.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 11:16 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3