Loading...
Index Recent Changes Preferences Editing Tips

Ask A Question

'Note: Helpers do not check this page very often. You may get a better response by asking on the site's messageboards.''



Q: Various reports of trouble viewing lists.
A: See ViewingTips


Q: I am trying to add a new and I get this message:
Database error: Invalid SQL: SELECT shows_key, showdate, venue FROM shows WHERE ref_artist = AND showdate = '12/10/02'
MySQL? Error: 1064 (You have an error in your SQL syntax. Check the manual that corresponds to your MySQL? server version for the right syntax to use near 'AND showdate = '12/10/02'' at line 1)
Session halted.
What do I do? I added previous shows with no problems.
SweetSugarLips?
LMParker523@aol.com
A: This is a new bug as of ~1/2005, possibly due to some recent site changes. Your update really does go to the admin queue for review as usual, it just shows you that dumb error. Sorry!


Q:I am not able to view my comments. I can view others, but not my own. I just get a blank white page. [Here] is the page I'm trying to view. My username is disilluzion. If anyone can help that would be wonderful. In addition to replying here, if the person with the answer could email me [here] that would be great. Thanks!


Q: When I am trying to enter 2 shows by the same artist on the same day at different venues, why does it not let me? Is there anything I can do to make it work? Thanks.

A: There are a couple things that could be happening based on what method you are trying and what error or tip message you could be receiving. For more help, please give more details on what urls you click and what you see as a result.



Verifying Email Address

Q:My question is: When i go to add a show, it gived me this message
db.etree.org now requires you to verify your real email address. Your real email address is NOT the email address displayed on your list and is not listed publicly. To verify your real email address, go here: http://db.etree.org/change_email.php.

I do have my e-mail address on there, and its a verified real e-mail address. This only happens on my computer at home. my login name is northernsong. The system lets me log in, edit all shows at one, but not add a show. Please help!!

A: The part about it "NOT" being the stuff you already put in just means that this is a separate email confirmation step you're being asked to do, apart from other stuff. Do follow the verify directions once for your userid.

Q: im trying to add a new show and i sent in my email to the posted link but when i went to the confirmation link and tried again to add a new show it still asks me to put in my email (user rodpud)

A: This is a caching problem with your browser. Try flushing the cache in options settings, also hitting ctrl-F5, reload, whatever combo works. See the DbNews page for a tips link about cachiing. Once it's fixed you shouldn't see this re-asking again.

Q: I am having the same problem as described above. I have tried your suggestions. I cleaned out my caches, deleted my history, deleted my cookies. I shut down my computer and restarted and keep getting the same error message as described below. What else can I do? I put a lot into my list. My user name is Joe Momma. Please help! I have ton more shows I would like to add.

A: Specific to your problem, Joe Momma, you have not verified your email address as requested. You will continue to be asked to verify your email until you follow the steps in the email sent to your real email address. I looked into this personally and I know this is your problem - Tom

Q: I can't look up my account info with my email address. "Email address is not valid for any user: mingram@vt.edu", even though http://db.etree.org/LucidStash is my page, and on it is my email address, so I know that it exists in the database.

A: Lookups are only done against verified email addresses. If you used a different email address when verifying your real email, that is the address you should use for having your password sent to you.


New Shows, New Wants, New Traders, Old Traders etc, don't appear

Q: I have shows in my want list (http://db.etree.org/public_wantlist.php?userid=mdecerbo )
but I don't show up when you click "users who want this" on the individual show pages. Am I doing something wrong?
Q: My list doesn't appear in the listing of traders.

A: Various pages are cached for ~24 hr to decrease load significantly on the db. If you add something and do not see it appear in a listing somewhere, wait about a day and a half and look again. (I see this user's wants now, days later.)

Also, traders with 3 or fewer shows on their lists will not appear in the alphabetical listing. The solution to that is to add more shows.

Also, anybody that hasn't updated their list within the last year isn't listed in the alpha listing. Same solution applies.

Finding "Special" Traders

Q: Is it possible to query the database and find by artist that user x has 100 shows, y has 50 etc, in case you are interested in mass trading of one band ? Right now I have to check the users who have each show and see on their list if they have a lot of each artist. I'm a computer programmer so if you don't want to do it and it's not possible I can take a crack at it from your source. Let me know. Thanks again for creating this site.

A: No, no direct way. Background discussion at [1], [2]

Q: Non-US people ask: How to filter to find traders in their geographic area(s)?

A: After hitting the top left link on the main page, [List users of this site and number of shows for each], go to bottom and look at the Filter options. Select the last itme on the State pulldown (Other). You will see many countries represented. It's not broken down further, but as of 10/2004 the entire "Other" listing is manageable to scan.

The filter section can also be used to find just people who trade DVDs, etc.


General Troubleshooting

Q: The database stopped recognizing my login a little while ago. It doesn't even recognize my email address as a user to send me my username and password, so I know I'm not just trying the wrong thing. I had to create a new user to even post this here. What can I do about this? Do I have to just abandon the old one and put my list on my new one, or can someone fix this problem?
thanks.

QWhere did it go ? Page comes up blank when i go to where i thought i left my list that i was in the process of creating ???

? could some one have edited me out of my list ?
-or-
did i actually put somewhere else ?
Can the list be made UN-Edit-ABLE ?
TIA

Q I've been trying to get a skin for my list, when I try to view it a screen comes up that says

Template Error: Loadfile: artist is not a valid handle. Halted.
can this be fixed?

A: When people don't specify relevant information (userid or at very least user name, or skin name, etc) with list-related questions, it is often impossible to troubleshoot.

Q: I got a cd with gaps between tracks. I have been using Digital Mixmaster to try and get rid of them by copying and reburning the music. I just got my burner a couple weeks ago, so I'm pretty new at this, but still kind of frustrated. Any ideas?

A: Check out http://forums.etree.org for topics like this, especially the Help on the Way and Technobabble sections. The http://wiki.etree.org site covers lots of technical topics, too.


Q: How can I change my login name to maintain the info contained therein -- I'm able to change the list name but would like the list name to reflect my user name.

i.e, db.etree.org/oldname still exists. Have changed the name once I login. I would like it to be reflected by db.etree.org/newname.

Thanks!


A: (from an unofficial / non-accredited helper) - One workaround for this is to register a new account under newname, then log in to oldname and export your list (via the export link on the main db.etree.org page, found under collect ) to a CSV file. Remember where you saved it, then log out of oldname and log in to newname. Select import (right next to export) and find the CSV file you created.


Q: I've noticed that sometime within the last two months, possibly when switching the character encoding, any attempts to use a quotation mark (") will end up as a question mark (?).

I'm using OpenOffice? Calc for the creation of my CSV files, then importing straight to ETree.

I also note stray ?s coming up all over the place now - like in this very edit - please tell me I'm not insane and that other people see these too.

My current browser is the latest release version of FireFox?.



A: Incomplete help for you: ETree doesn't really seem to mention which character encoding set they use (or, if they do, it's buried in the forums somewhere). So when it comes to characters like ß, ò, etc, I have no help. However, the problem with double quotes can be fixed from within OpenOffice? - tools > autocorrect > options, choose the "custom quotes" tab, and make sure both "replace" boxes are left unchecked.