View Single Post
  #4  
Old 02-01-2004, 10:01 AM
Chicomalo
Sarnak
 
Join Date: Aug 2003
Location: Seattle, WA, USA
Posts: 48
Default

I have try a few ways but not sure if i didn't doit right or what. Cause the thing is that he had play with me on my server and log in from Eqemulator.net but since I change everything now is kind of different i guess for him.

If you don't mind me asking, how should I set him up? Just to see if i haven't try a different way or a better way. I know I had kind of the same problem for my self before until i fix something in the account database but kind of forgot. =/ cause I had the same kind of error before until i figure it out. However silly me I didn't write down the notes like i normaly would.

Updated 2:16pm Pacific Time.

I notice something about this, could it be that I have interent sharing with my labtop on my system? Cause I have two modem and I have internet sharing on the main modem. now also i got a few errors trying a few things from there like this one here.

Quote:
C:\eqemu>world adduser Arkilian ******* 175
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
Account Attempting to be created:Arkilian 175
Error in CreateAccount query 'INSERT INTO account SET name='Arkilian', password=
'*******', status=175, lsaccount_id=0;' #1062: Duplicate entry 'Arkilian' for ke
y 2
database.CreateAccount failed.

C:\eqemu>
Also try the other way around here;
Quote:
C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 127 to server version: 3.23.58-nt

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

mysql> use eq;
Database changed
mysql>
mysql> INSERT INTO account SET name='Arkilian', password='*******', status=175;
ERROR 1062: Duplicate entry 'Arkilian' for key 2
mysql>
and final one i try doing it this way and this is what i got;


Quote:
mysql> use eq;
Database changed
mysql> INSERT INTO account SET name='Arkilian', password='*******', status 175,l
saccount_id=0;
ERROR 1064: You have an error in your SQL syntax near '175,lsaccount_id=0' at li
ne 1
mysql>
Hmmm still trying to figure this out here.
__________________
Reply With Quote