Guest twelves Posted October 5, 2003 Posted October 5, 2003 (edited) HI. I want to start the first hand edited approved small Guitar Tab search engine and data base. Not 50 thousand crappy tabs… A few hundred approved and tested guitar tabs. Quality tabs only. I am very new to a more difficult configuration of this script. Although I have it ½ way installed. The Admin section is not working. It gets in to things I know nothing about. If you want to download the scripts and install the Variables…. It is however a very easy PHP script for those that live the Php lifestyle. I do not. I am lost. The script is not working. Below are the variables to my data base and user info. (password is Blanked out, I am not sure its ok to post that in public) Below is the path to my install directory, working script. (1/2 way) And path to directories. You can also download the Script in the file www.12string.net/tabfu/tabfu.tar And thanks! I can’t get it at all. Like I said. SQL Tables and data base is already finished. Added the user stringn_jay to the database stringn_tabfu. "/home/stringn/public_html/Tabs/") I have the data base installed. I have user installed with access. I populated the tables. www.12string.net/tabfu/tabfu.tar http://www.12string.net/tabfu/tabfu.php How to install Tab-Fu: First, create a database named tabfu in mysql. Create a user and give him select/insert/update/delete privileges. Reload mysql. Now, import the database structure from tabfu.sql into mysql, like so: mysql -u <user> -p tabfu < tabfu.sql Make sure that your tabs directory doesn't have any extraneous directories inside it. The base directory should contain nothing but single-character directories. All subdirectories should contain artist or band names. For consistency, all artists are represented as lastname_first, and bands as band_name. This doesn't affect Tab-Fu at all, but it would be good for any users who browse the archive manually. Next, run tabfu_createdb to populate the database for the first time. Run it like this: tabfu_createdb <hostname> <dbname> <username> <password> <basedir> The basedir is the directory that the single-letter subdirectories are in. Make sure that you include a trailing slash! This will populate the database. To access it with the PHP interface, you'll need to do the following steps: In your document root directory, make a symlink to your tabs directory. Call it tabs/ or tabfu/ or some such name. Go into it. Make a symlink to tabfu.php, wherever it is. Call it index.php. Make sure that your web server recognizes "index.php" as a valid index file. Also make a symlink to tabfu_inc.php. Leave the name as it is. That should be it... connect to your web page in your browser and point it to /tabfu/ or whatever you called that. There it is. Enjoy. Edited October 6, 2003 by cerealkeeler Quote
vendlus Posted October 10, 2003 Posted October 10, 2003 I'm a little confused, but I'll try and help you out (extra coding/php experience is always a good thing). Your basic problem is that there are simply no results found, correct?? From the link you gave, I didn't get any errors, just no results to anything. Are there other issues that you're having with it?? I'm going to try and set it up as a test here and see what I can come up with. - vendlus Quote
vendlus Posted October 10, 2003 Posted October 10, 2003 You said your tables are populated, correct?? In that case, I'm not sure what the problem is with your being able to see nothing. I went in and manually put an entry into my table (since I know nothing about running perl scripts, which is what I think that tabfu_createdb file is). Anywhat, I got my artist name to come up when I click the correct letter. >http://bohicagaming.com/testing/tab/tabfu.php?showdir=a Click the name then shows the correct file in there. The problem then is that the script is written for the folder to be named 'tabs' and to be off of the home directory. I can fix that easily enough, but it doesn't seem that you can even see the names yet, so there's no use in doing that yet. Give me an example of one of your table fields for the song and artist fields. Mine is like this... artistartistid= 1 name= ataris artistdir= a/ataris song songid= 1 artistid= 1 title= boxcar ext= htm path= /a/ataris I'm honestly not even sure what the artistdir field does since the page does a query to get the song list. If it becomes important, I'll go in and look at the code. So give me an example so that I can compare what we've got going on here and I'll see what I can come up with for you. ---------------------------------------- btw, mods.... Is this thread ok, or should we take this to pm's (assuming he hasn't resolved this a couple of days ago)?? I was putting it out here in case the problem is something people could learn from. - Vendlus ...... another thing... the guy who wrote that script blows at giving instructions. Quote
Guest twelves Posted October 10, 2003 Posted October 10, 2003 When I said the tables are populated, I am refering to the MySql Data Tables that set up the data in the Script. That part has nothing to do with the Songs. Just the Operation of the script. I did not get the CGI Perl paths correct or configured yet… The Admin section is not working at all on my end. I think the admin gives you the option to load in the Tabs in a user friendly fashion. It’s not with Mysql after the admin is running…. I am very bad at Perl. I love PHP though,… Hmmm… I’m totally frozen on this script… And my users are dying for a way to submit tabs.. I had almost given up on this. But I need a tab data base. This is an OLGA Clone and should be user friendly… I am stumped…Darn stuck in the mud. Any advice is grateful. I can create a topic on my forum if this is breaking the rules of the board… My email is one @ 12string dot net if you want to contact me of list. And Grateful for the advice! woooot Quote
TCH-Don Posted October 10, 2003 Posted October 10, 2003 Family helping family is great! In case you haven't noticed, this post is getting a lot of views (as in interest), and what you discover may help others. Quote
Guest twelves Posted October 10, 2003 Posted October 10, 2003 One thing I forgot to mention: In the file "tabfu_createdb" after I get the data filled out, am I supposed to rename it CGI? Or PHP? Also in the line below, am I needing to fill out this info also? Or is that for the script? # argument array contains # @ARGV = ("hostname", "database", "user", "pass", "basedir") @ARGV or die "\nUsage: tabfu_createdb <hostname> <dbname> <user> <password> <basedir> \n \n"; This is a link to a working Tab Fu Data Base: http://www.thudspace.net/tabs/index.php?showartist=53 This is the Tab Fu Main page on Source Forge: http://sourceforge.net/projects/tabfu/ Im sticking my brain on this all day. Will keep folks posted. Main Download is in the Source Forge Page. Down! You Pesky Perl Scripts~! This is where is all falls apart for me: This will populate the database. To access it with the PHP interface, you'll need to do the following steps: In your document root directory, make a symlink to your tabs directory. Call it tabs/ or tabfu/ or some such name. Go into it. Make a symlink to tabfu.php, wherever it is. Call it index.php. Make sure that your web server recognizes "index.php" as a valid index file. Also make a symlink to tabfu_inc.php. Leave the name as it is. That should be it... connect to your web page in your browser and point it to /tabfu/ or whatever you called that. There it is. Enjoy. Quote
vendlus Posted October 14, 2003 Posted October 14, 2003 Sorry I haven't gotten back to you on this. It's been a hectic few days and now I'm sitting at home sick. I'm hoping to figure out what the deal is tonight though. I should have time to look into it. Quote
Guest twelves Posted October 14, 2003 Posted October 14, 2003 Its all done. www.12string.net is the page you can see it at. Problem is the admin for removing or adding scripts is perl run from SSH. Another problem is that there is no way to edit the sql data unless you run the batch script. (Or Myphp sql interface) I do have a script (PERL) that will add single tabs in. But not remove. I want to remove all the bogus tabs in there and start editing with my page members the ones that are good. 20 thousand junk tabs is bad! We want a thousand good ones! Time will tell. If you want this script. PM me and I can post the URL. Im going to keep this and make it better! Time will tell! Thanks! If there was a way to make the Perl scripts into a PHP script! That would rule! Quote
vendlus Posted October 14, 2003 Posted October 14, 2003 ok, good. my cgi-bin folder is being evil. well... actually, I just don't enough about what I'm doing with it to get it to work. I can get a test script to work, but not that createdb one. Oh well. What all do you want it to do if rewritten in php?? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.