what i do wrong?

[wilson212]

So here is what i have. I have sql executed on "arsenal" database. I
also downloaded the "arenaldata.sql" for the cache_db. my database is
trinity: character database = "characters" realm db = "realmd" and
world db = "world".

in the datagrabber i have the lines like this:

$this->pvpdbconn = mysql_connect("localhost", "root", "ascent", true)
or die(get_class($this).": no connection to database.");
@mysql_select_db("realmd") or die (get_class($this).": not able to
select specified database.");

and:

$logindb = mysql_connect("localhost", "root", "ascent", true) or die
(get_class($this).": no connection to login database.");
@mysql_select_db("realmd") or die (get_class($this).": not able to
select specified database in login db.");

for the config:

$cache_db_type = 'mysql'; //one of the above types
$cache_db_host = '127.0.0.1'; //db ip or hostname (with port or
without); leave empty for i.e. sqlite
$cache_db_user = 'root'; //the username; leave empty for i.e. sqlite
$cache_db_pass = 'ascent'; //the password; leave empty for i.e.
sqlite
$cache_db_base = 'arsenal'; //the db-name; for sqlite this would be
the filepath (remember using forward-slashes in windows, too!)

$data_db_type = 'mysql'; //if you set this to mysql and have both
arsenal dbs on the same host (i.e. localhost) be sure
$data_db_host = 'localhost'; //to set one to "localhost" and one
to "127.0.0.1" for otherwise it won't open a new connection
$data_db_user = 'root'; //and this may have unforseen consequences
$data_db_pass = 'ascent';
$data_db_base = 'cache';

?>

I can see the main search page but when i search a character i get
this error:

"XML Parsing Error: junk after document element
Location: http://127.0.0.1/search.xml?searchQuery=knocturnal&searchType=all
Line Number 2, Column 1:

<b>Fatal error</b>: Uncaught exception 'ErrorException' with message
'mysql_fetch_assoc(): supplied argument is not a valid MySQL result
resource' in C:\xampp\htdocs\classes\dataGrabbers
\Trinity_PVPDataGrabber.class.php:666
^"

i have all pdosqlite and sqlite extensions enabled in php.ini. and the
armory is directly in my "htdocs" folder.

what did i do wrong?

[amras-taralom]

i wrote you a pm earlier in the trinity forums.
but there are some points here, too.

first of all: arsenaldata belongs to the data-db, not the cache. you
can put
both to the same db though, tables don't overlap.
2nd of all: the error in the grabber means it can't connect. so
something is
wrong there (user, pw or host).

by the way: why is your pass "ascent"? as of now there is no ascent
data
grabber...

Greetings, Amras.

[wilson212]

I figured out what the problem was, i needed to erase the other
datagrabber for "TrinityPVE" i only have 1 realm so i needed to change
that in the config, just 1 realm.
works great now :D

[amras-taralom]

nice to see that it works now :)
have fun with the arsenal.

[wilson212]

I will :D love it so far... Did you know though that the "live
version" isnt working?

[Amras Taralom]

yes, i know. there was a hdd at the main root of our server, it has to be
replaced. will work again soon :)

--------------------------------------------------
From: "wilson212" <wilson....@yahoo.com>
Sent: Wednesday, February 03, 2010 8:16 PM
To: "xmlarsenal-discuss" <xmlarsena...@googlegroups.com>
Subject: Re: what i do wrong?