Talk:How to move deposits between users

From EPrints Documentation
Revision as of 05:16, 6 May 2007 by Jutta (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

I'm not sure if this is a difference between EPrints version 2.x and 3.0 or just a typo in the HowTo: When I used

SELECT userid FROM users WHERE username='USERNAME_GOES_HERE';

I got an error:

ERROR 1146 (42S02): Table 'test1.users' doesn't exist

so I did SHOW tables; and tried then:

SELECT userid FROM user WHERE username='USERNAME_GOES_HERE';

which showed me what I expected to see:

+--------+
| userid |
+--------+
|      2 |
+--------+
1 row in set (0.00 sec)

--jutta 06:16, 6 May 2007 (BST)