PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > Script Installation

Reply
 
Thread Tools
Old 06-17-2004, 10:27 PM   #1
Destroyer X
Green Mole
 
Join Date: Jun 2004
Location: Oklahoma, U.S.A.
Posts: 19
Need Help Installing Search Engine

Hey everyone! While I hate to ask a question that has been asked many times, I'm having problems trying to install PhpDig. Before I begin, here's my info. on my phpinfo page:

http://www.destroyerx.net/phpinfo.php

Anyway, I tried to create the database using [PHPDIG_DIR]/admin/install.php (I managed to figure out the default username and password was admin/admin), however, everytime I tried to use the install page, it gives me the following error message:

Can't create database.
Verify user's rights.

Anyway, I tried creating a table within my MySQL database using MySQL directly, and it gave me the following error message below:

mysql> create table phpdig;
ERROR 1113: A table must have at least 1 column

Anyway, I was wondering if I was doing anything wrong to try to install this search engine. I hope I was descriptive enough by adding the error messages I was given when trying to install the script and including my phpinfo page. Hopefully, between everyone who responds to this, I'll be able to finally configure PhpDig to work on my Web site.

I was using a Perl search engine called Perlfect Search 3.31 for my Web site, but since I'm running a PHP poll and can't place PHP into the HTML template pages that are necessary for the Perl search engine and Perl image gallery, I need to get rid of my Perl scripts and make way for PHP generated pages.

Anyway, thanks everyone for your help. Ciao for now!
__________________
Visit the Destroyer X Network at http://www.destroyerx.net/

Last edited by Destroyer X; 06-17-2004 at 10:44 PM.
Destroyer X is offline   Reply With Quote
Old 06-18-2004, 05:18 AM   #2
vinyl-junkie
Purple Mole
 
Join Date: Jan 2004
Posts: 694
Welcome to the forum, Destroyer X.

You'll have better luck setting up your database manually. You can do that part through your web host's control panel. Same thing for the tables, which you'll create using a file called init_db.sql, which is in the sql folder. Also, check the documentation starting here for folder permissions, customization, etc.

Hope this helps. Let us know if you have any more problems. We'll be glad to help.
vinyl-junkie is offline   Reply With Quote
Old 06-18-2004, 10:06 AM   #3
Destroyer X
Green Mole
 
Join Date: Jun 2004
Location: Oklahoma, U.S.A.
Posts: 19
While I hated to have to post this online so everyone can see the structure of my database, I'm that desperate for help that I'm going to go ahead and do it. Anyway, "destroyerx" is my database name. I can only create tables in my database and do not have permission to create additional databases. Anyway, here is my database below:

+----------------------------------+
| Tables_in_destroyerx |
+----------------------------------+
| phpbb_auth_access |
| phpbb_banlist |
| phpbb_categories |
| phpbb_config |
| phpbb_confirm |
| phpbb_disallow |
| phpbb_forum_prune |
| phpbb_forums |
| phpbb_groups |
| phpbb_posts |
| phpbb_posts_text |
| phpbb_privmsgs |
| phpbb_privmsgs_text |
| phpbb_ranks |
| phpbb_search_results |
| phpbb_search_wordlist |
| phpbb_search_wordmatch |
| phpbb_sessions |
| phpbb_smilies |
| phpbb_themes |
| phpbb_themes_name |
| phpbb_topics |
| phpbb_topics_watch |
| phpbb_user_group |
| phpbb_users |
| phpbb_vote_desc |
| phpbb_vote_results |
| phpbb_vote_voters |
| phpbb_words |
| poll_comment |
| poll_config |
| poll_data |
| poll_index |
| poll_ip |
| poll_log |
| poll_templates |
| poll_templateset |
| poll_user |
+---------------------------------+
38 rows in set (0.00 sec)

The following is what all I've tried to do to get the init_db.sql working and get some tables created:

mysql> phpdig < search/sql/init_db.sql
-> ;
ERROR 1064: You have an error in your SQL syntax near 'phpdig < search/sql/init_db.sql' at line 1
mysql> phpdig < public_html/search/sql/init_db.sql
-> ;
ERROR 1064: You have an error in your SQL syntax near 'phpdig < public_html/search/sql/init_db.sql' at line 1
mysql> phpdig < /public_html/search/sql/init_db.sql
-> ;
ERROR 1064: You have an error in your SQL syntax near 'phpdig < /public_html/search/sql/init_db.sql' at line 1

Anyway, I was wanting to know is there was something else I'm doing wrong. The answer might be simple, but so far, I'm not seeing it yet. Thank you for your time. Ciao for now!
__________________
Visit the Destroyer X Network at http://www.destroyerx.net/
Destroyer X is offline   Reply With Quote
Old 06-18-2004, 10:16 AM   #4
Destroyer X
Green Mole
 
Join Date: Jun 2004
Location: Oklahoma, U.S.A.
Posts: 19
Well, I finally managed to get PhpDig installed from the install page. Because other people may have the same problem as I did, I'll explain how I did it. What I did was put localhost as the hostname, user and password being my database username and password, destroyerx as the PhpDig database, and I set the table prefix as phpdig_. Instead of using the Create database option, I selected Create tables only. Anyway, thanks everyone for their help. Ciao for now!
__________________
Visit the Destroyer X Network at http://www.destroyerx.net/
Destroyer X is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Who will be next #1 search engine? russell IPs, SEs, & UAs 0 08-14-2006 04:59 PM
phpDig as a niche search engine? sarahk The Mole Hole 0 10-05-2005 06:48 PM
can i customize the search engine in this way? warrence How-to Forum 1 12-01-2004 03:19 AM
google like search engine sasa How-to Forum 3 09-10-2004 10:41 AM
The search engine of our dreams. JÿGius³ Feedback & News 2 11-20-2003 07:01 PM


All times are GMT -8. The time now is 12:02 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.