<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Manuel,<br>
<br>
Of cause you can try to do the full size upload to the test
Database: SP_JInventory.<br>
<br>
But, prior to make the final upload to the real Hall-D JInventory
Database, <br>
I think, all appropriate Hall-D staff and interested in it people
should be informed<br>
about this huge upload of completely new kind of items.<br>
<br>
How about to make a presentation on some of Hall-D meetings?<br>
<br>
Best regards, Serguei P.<br>
<br>
<br>
P.S. I'm just a contractor. And decision about so huge update should
be done by<br>
responsible Hall-D staff man.<br>
<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 3/27/15 12:28 PM, Manuel Lara wrote:<br>
</div>
<blockquote
cite="mid:CAJkHkHQbfzLm_TH7QTNM1TZstXh-MXYHiwQZXQ3PcjmCx012dw@mail.gmail.com"
type="cite">
<div dir="ltr">I've showed people at IU the db and they seem
pleased with it. Early next week I will try to upload the full
2800 cell FCAL.</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Tue, Mar 24, 2015 at 5:22 PM,
Serguei Pozdniakov <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:sergpozd@jlab.org"
target="_blank">sergpozd@jlab.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Fixed.<br>
I removed symbol (') from room's short name.<br>
It is impossible to use (') here. It goes to SQL query and
ruins SQL syntax.
<div>
<div class="h5"><br>
<br>
<br>
<br>
<div>On 3/24/15 4:47 PM, Manuel Lara wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">I'm playing with the db and when I
try to change the location of a base from the
survey table to Pauls Workshop I get the following
error:
<div><br>
</div>
<div><span
style="color:rgb(0,0,0);font-family:Times;font-size:medium">Query
failed: You have an error in your SQL syntax;
check the manual that corresponds to your
MariaDB server version for the right syntax to
use near 's Worshop (1680) > Comment: Test.
Send to Paul ' , ITM_PurchaseReq = '', IT' at
line 1</span><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Tue, Mar 24, 2015 at
1:42 PM, Serguei Pozdniakov <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org"
target="_blank">sergpozd@jlab.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0
0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> I'm in
my office.
<div>
<div><br>
<br>
<div>On 3/24/15 1:39 PM, Manuel Lara
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Will you be in your
office today? I've been playing with
the db and moving bases around and
it seems to be working great. I
would like to add IU and some rooms
at IU to the db like we discussed.
<div><br>
</div>
<div>The rooms associated with IU
are be:</div>
<div>SW 262</div>
<div>Paul's Shop</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Mar
19, 2015 at 11:05 PM, Manuel Lara
<span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:manlara@umail.iu.edu"
target="_blank">manlara@umail.iu.edu</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div dir="ltr">Thanks, I fixed
fixed the BFM for the detector</div>
<div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On
Thu, Mar 19, 2015 at
9:51 PM, Serguei
Pozdniakov <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">DB
cleaned up.<br>
Could you fix BFM for
Detector. From my
point of view it
should be:<br>
IU - FCAL Detector -
N/A<br>
Regards, S.P.<span><br>
<br>
<br>
<br>
On 03/19/2015 05:00
PM, Manuel Lara
wrote:<br>
</span>
<blockquote
class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex"><span>
Could you reset
the db. I made
some duplicate
entries for the
bases that I can't
delete<br>
<br>
</span> On Thu, Mar
19, 2015 at 1:24 PM,
Serguei Pozdniakov
<<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>>><span><br>
wrote:<br>
<br>
I'm in my
office and
planning to be
here till 5 p.m.<br>
Call me 5464.<br>
Serguei P.<br>
<br>
<br>
<br>
On 03/19/2015
12:25 PM, Manuel
Lara wrote:<br>
<br>
Hi
Serguei,<br>
<br>
Will you
be around later
today or tomorrow?
I would really
like to get the
database stuff<br>
situated<br>
so people
back at IU could
start using it.<br>
<br>
On Sun,
Mar 1, 2015 at
12:53 PM, Serguei
Pozdniakov <<a
moz-do-not-send="true" href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a><br>
</span>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>>>><span><br>
wrote:<br>
<br>
Hi
Manuel,<br>
<br>
Let's
talk about FCAL
hierarchy on
Monday.<br>
We
have to modify
formats for all
yours new items.<br>
<br>
Regards, Serguei
P.<br>
<br>
<br>
<br>
<br>
<br>
On
2/27/15 8:38 AM,
Manuel Lara wrote:<br>
<br>
Hi Serguei,<br>
<br>
Here's a quick
look at the
hierarchy of the
FCAL<br>
<br>
HallD => D2
=> X_Y =>
Base or PMT,<br>
Base => Can,
Base =>
SockBoard, Base
=> TranBoard,
Base =>
CommBoard, Base
=> MultBoard<br>
<br>
I
am playing with
the database and
seeing what
happens If I move
a Base to the<br>
survey
table.<br>
What I would like
is that all the
children of Base
would also be
moved to the<br>
survey
table but<br>
when I try with<br>
</span>
<a
moz-do-not-send="true"
href="https://halldweb1.jlab.org/SP___JInventory/htdocs/editItem.__php?id=1699"
target="_blank">https://halldweb1.jlab.org/SP___JInventory/htdocs/editItem.__php?id=1699</a><span><br>
<<a
moz-do-not-send="true"
href="https://halldweb1.jlab.org/SP_JInventory/htdocs/editItem.php?id=1699"
target="_blank">https://halldweb1.jlab.org/SP_JInventory/htdocs/editItem.php?id=1699</a>><br>
I
get an error:<br>
<br>
*Location Error:
Unknown Format*<br>
*
For more
information send
mail to Serguei
Pozdniakov : <a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a><br>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>><br>
</span>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>>>*<span><br>
*<br>
*<br>
Is this because
this function is
somehow broken in
the test database?<br>
In the production
db will all the
children of Base
move with Base?<br>
<br>
On Wed, Feb 25,
2015 at 11:49 AM,
Serguei Pozdniakov
<<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a><br>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>><br>
</span><span>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>>>>
wrote:<br>
<br>
Yes, I should
be around, maybe
not all day in my
office,<br>
but just call
me 5464 before you
come in.<br>
Serguei P.<br>
<br>
<br>
<br>
<br>
<br>
On 2/25/15
11:11 AM, Manuel
Lara wrote:<br>
<br>
Will you be
available sometime
tomorrow? I can go
over what I have.<br>
<br>
On Wed, Feb
25, 2015 at 10:35
AM, Serguei
Pozdniakov <<a
moz-do-not-send="true" href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a><br>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>><br>
</span><span>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>
<mailto:<a
moz-do-not-send="true"
href="mailto:sergpozd@jlab.org" target="_blank">sergpozd@jlab.org</a>>>>
wrote:<br>
<br>
Hi
Manuel,<br>
<br>
It
seems that Marty
did a copy of our
databases before I
granted you as<br>
a
user.<br>
I gave
you access again,
but this time
without password.<br>
You can
set new password
for yourself by
typing:<br>
<br>
mysql> SET
PASSWORD =
PASSWORD('blablabla');<br>
<br>
Both
halldweb1 and
halldweb are
working now for:<br>
<br>
jlab> mysql -h
halldweb -D
SP_JInventory -u
manlara<br>
<br>
<br>
Regards, Serguei
P.<br>
<br>
P.S.
Before you will
populate all your
thousands item<br>
can you
inform me about
final structure of
FCAL items in DB?<br>
<br>
<br>
<br>
<br>
<br>
On
02/25/2015 08:51
AM, Manuel Lara
wrote:<br>
<br>
<br>
Hi
Serguei,<br>
<br>
I
am trying to log
into SP_JInventory
but I get the
following error:<br>
<br>
ifarm1401>
mysql -h halldweb1
-D SP_JInventory
-p<br>
Enter password:<br>
ERROR 1045
(28000): Access
denied for user<br>
'manlara'@'<a
moz-do-not-send="true"
href="http://ifarm1401.jlab.org" target="_blank">ifarm1401.jlab.org</a>
<<a
moz-do-not-send="true"
href="http://ifarm1401.jlab.org" target="_blank">http://ifarm1401.jlab.org</a>><br>
<<a
moz-do-not-send="true"
href="http://ifarm1401.jlab.org" target="_blank">http://ifarm1401.jlab.org</a>><br>
<<a
moz-do-not-send="true"
href="http://ifarm1401.jlab.org" target="_blank">http://ifarm1401.jlab.org</a>>'
(using password:
YES)<br>
<br>
Maybe I lost
permission to the
database after the
upgrade<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</span></blockquote>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>