ยินดีต้อนรับคุณ, บุคคลทั่วไป กรุณา เข้าสู่ระบบ หรือ ลงทะเบียน

เข้าสู่ระบบด้วยชื่อผู้ใช้ รหัสผ่าน และระยะเวลาในเซสชั่น

ThaiSEOBoard.comความรู้ทั่วไปSearch Engine Optimizationลง search script ที่เฮีย ethai แจกแล้วมี เออเรอร์อ่ะครับ
หน้า: [1]   ลงล่าง
พิมพ์
ผู้เขียน หัวข้อ: ลง search script ที่เฮีย ethai แจกแล้วมี เออเรอร์อ่ะครับ  (อ่าน 5028 ครั้ง)
0 สมาชิก และ 1 บุคคลทั่วไป กำลังดูหัวข้อนี้
red_army
สมุนแก๊งเสียว
*

พลังน้ำใจ: 1
ออฟไลน์ ออฟไลน์

กระทู้: 568



ดูรายละเอียด
« เมื่อ: 20 ธันวาคม 2006, 09:45:04 »

ลงเรียบร้อย พอ install step 3 มี error
อ้างถึง
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'admin'@'localhost' (using password: YES) in /home/asia/public_html/impresssearch/adminpanel/db.php on line 2

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/asia/public_html/impresssearch/adminpanel/db.php on line 3

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/asia/public_html/impresssearch/adminpanel/db.php on line 3
Search Portal Install

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/asia/public_html/impresssearch/adminpanel/sql.php on line 9

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/asia/public_html/impresssearch/adminpanel/sql.php on line 9
DB TABLE ERROR:
Problem:
Access denied for user 'nobody'@'localhost' (using password: NO)
Remedy:
Check that table admin does not exist from a previous installation


ผมทำอาไรผิดอ่ะครับ
บันทึกการเข้า

URL=http://www.cirtexhosting.com/affiliates/idevaffiliate.php?id=408][/URL]
tosakp
หัวหน้าแก๊งเสียว
*

พลังน้ำใจ: 113
ออฟไลน์ ออฟไลน์

กระทู้: 1,960



ดูรายละเอียด
« ตอบ #1 เมื่อ: 20 ธันวาคม 2006, 09:50:38 »

น่าจะกำหนด user / password / dbname ของ MySql ผิดน่ะครับ
อ้างถึง
Problem:
Access denied for user 'nobody'@'localhost' (using password: NO)
Remedy:
Check that table admin does not exist from a previous installation
บันทึกการเข้า

red_army
สมุนแก๊งเสียว
*

พลังน้ำใจ: 1
ออฟไลน์ ออฟไลน์

กระทู้: 568



ดูรายละเอียด
« ตอบ #2 เมื่อ: 20 ธันวาคม 2006, 09:59:01 »

ใน readme มันบอกโปรแกรมมันจาสร้าง db ให้เองอ่ะครับ
อ้างถึง

Built2Go Search Portal
Copyright  2005 Built2Go.com
Version 1.0



Table Of Contents


1)   Introduction
2)   Requirements
3)   Installation
4)   Adding categories
5)   Adding links/sponsors
6)   Editing your settings
7)   Approving
Cool   Members
9)   Sponsors
10)   Payment Processors
11)   Setting up your Poll
12)   Admin









































Introduction:

Built2Go is dedicated to give you the best experience and the most promising results in selling your inventory and getting your site up and running in no time.

Built2Go is setup to accept your paypal, 2Checkout and Worldpay accounts.

Requirements:

Server Tested on Apache/1.3.12 & 2.0 (Unix/redhat)
PHP >= 4.1.2   (will not work on anything below 4.1)
Mysql (tested with 4.01.x)
   
Installation:

Once you have downloaded the package, unzip the contents to its own folder.  Once unzipped you can upload all files and folders that are in the “scripts” folder, to your website with your favorite FTP program. All files that end in php need to be uploaded in ASCII mode. And the image folder and Century.ttf need to be uploaded in Binary mode.
   Now depending on how your server is set up depends on if you need a shebang line or not. A shebang line goes into your scripts as the very first line. This line tells the server where php is located so it can run it, almost the same as a perl script. If your server is setup as a cgi module than you will need this line and chmod all files to 755. If your php is installed as an ISAPI module than you do not need this line and you shouldn’t have to chmod anything. Unless your host has it setup to where you do need the shebang line.

First we need to edit a few files. Open config.php and set install directory (and table names if you do not want default).

There are some variables you need to read first.

This is basic language file. Feel free to change the text all you want. If your language is not English and you want to change it please feel free to edit this file and please send it to me. Full credit will be given to you for the edition to another language.
$language = "eng";

The main version variable, please do not change this
        $version = "1.0";

“SetPending” is very important. If you set it to 1 everything that is uploaded or added as far as links will be LIVE on the site. If set to 2 it goes into a pending state where you can verify the payment and the quality of the links.
     /* Allows you to check over links submitted before they go live
       1 = live on submit
       2 = pending
     */
     $SetPending = '2';

“siteurl” is also important. Please edit it to your url or domain.

     $siteurl = "http://www.yoursite.com/searchportal/";


“upload_dir” is where the pictures of the new searchportal are stored. This folder must be set to 777 or 766 so it can be writing to. Edit “/searchportal/pictures” to reflect your directory structure. No Ending Slash
     
      $upload_dir = $_SERVER['DOCUMENT_ROOT']."/searchportal/pictures";


This is the full path to all the scripts. Edit “/searchportal” to reflect your folder structure. No Ending Slash
         
   $full_path_to_public_program = $_SERVER['DOCUMENT_ROOT']."/ searchportal";

This is the module directory, no need to change it if you do a default install.
   
$module_dir = $siteurl."/modules";

Another important edit. These are the prices that you will charge each link or sponsor submission. Please change these to your liking and these can also be changed later if need be. Do not use any currency signs.

define(PRICE,"4.95");
   define(CLICKS,"1000");


For images it is important to set a set width and height as well as the max file size. If the images are to wide or to high then it has a possibility to distort the template design. So in this case we add a max-height and a max-width. File size is up to you. The bigger the file the more room it takes up on your server/web space. Use at your discretion.

define(MAXFILE_SIZE,"100");  // the max file size you will accept     define(MAXIMAGE_W_SIZE,"500");  // max Width of the image           define(MAXIMAGE_H_SIZE,"500");  // max Height of the image


Your email address so the billings and contact info can be sent to you.

         $from_address = "info@yourdomain";

For the modules to work, these variables need to be set. Each should be setup to the specifications of each merchant. ITEM_NAME is your representation of the payment process, name it how you see fit.

         /* payment processors here PAYPAL*/
     define('FROM_PAYPAL',"paypal@paypal.com");
     define(ITEM_NAME,"SPONSORLINK");
         /* Worldpay */
     define('INSTID',"123456"); // worldpay login #
         /*2Checkout*/
     define('SERIAL_ID',"123456"); // 2checkout login #
   
How many items to show per page. No need to edit but you can.

    /* How many members do you want per page, mainly in the admin*/
       $admin_member_per_page = 25;
    /* Number of ads per each page (after you have selected sub-category) */
    $number_of_ads_per_page = 5;

















   
Mysql table names, you can leave them default or you can edit them to your liking. The script will automatically pick them up.

   
   $admintbl = "admin";
   $ads_tbl = "sites";
      $cat_tbl = "categories";
   $usr_tbl = "users";
   $secure_image = "security_images";
   $modules = "modules";
      $rating_tbl = "rating";
      $polldata = "b2gpoll_data";
      $polllist = "b2gpoll_list";
      $sess_tbl = "session";

Admin control panel login information: Either way will give you a login prompt. If you can run .htaccess file on your server it is suggested to do that, but you don’t have to.
    /*
       1=HTTP Authentication
       0 or '' = html login
       only use this if you do not have permissions to create a .htaccess/.htpasswd files.
    */
    $logintype["http"] = '';

If this variable is set to 1 the session table has a tendency to get big. This will allow the script to clear out any old information that is not needed anymore.
     
     $GLOBALS['noshutdownfunc'] = 0;

Once everything is edited and you have uploaded the changes, we need to go to the install script. This file is located in the searchportal folder and called install.php. Run this file and it will step you through making the database tables and config file. Once installed and you move onto the admin section, you need to rename the install script or delete it. I would advise to delete this file off the server.


Adding Categories:

   This seems a little tricky but it really isn’t. By default there is categories installed. You are more than welcome to change these categories to your liking. Next just add your name of the category and the icon you want to use, if you use one. Also enter description in the first description box. The description is mainly for you. It will not show up on the site. Just push the “Submit” button and it should be added.

   






So if you want a subcategory under this newly made category, just click on the category you want it to appear under and enter the information. After click on submit and you go back to add another one, you will see it was placed under the category you specified. You can enter as many categories as you need. As of now, the script is set to only go 2 levels deep. Maybe future versions will be farther.



Adding Links:

   Adding products is self-explanatory. First, fill in the information pertaining to the new link. Second, select the appropriate category. You can also make this a sponsored link. By setting a sponsor date will activate this link to be a sponsor link. Once you have the correct essentials in this form than push the “Save” button.
   


Setting your settings:

   
View Variable Files:

This section allows you to change the settings in the files we edited earlier. You do not have to do it this way. If you are comfortable editing the files with a text editor go right ahead.

View Template Files:

This section allows you to edit the templates the scripts uses. Same as above, you can edit these manually if you want.




Approving:

   This is pretty important. In this section you need to be able to judge what is true and what is false with your records from paypal or Worldpay or 2Checkout. This lists what they bought and who they are it is up to you to judged the authentication of each transaction.


Members:

   This is the place to view the member info. You can add/edit or delete members in this section. A member can be a sponsored and a regular member at the same time. Once they have sponsor links setup with the user he is automatically setup as a sponsored member.

Adding a member is simple. Fill in the info in the “Add new member” page. You can also give comments per member, which the Admin is only to see.


Searching for a member: click “search for a user” will bring up a page so you can select which part to search by. You can search by name, email, userID, date joined, paying (if they paid or not) and ID. Click on find will show the results of your search.

Sponsors:

   Sponsors are the same as members but they get a bigger rating. Each member has a choice to be have their site a sponsor site. This means they get so many clicks until they are no longer a sponsor. These clicks are purchased on signup and they can purchase however many clicks they want. As with any site, you have the ability to Approve/Deny their sponsorship purchase.

Payment Processors:

By default this script will make use of Worldpay, Paypal and 2checkout. You are not required to use all three. If you want just Paypal then disable the other two in the admin. The rest of the script will not see them until you enable them.

If you have a new merchant and this script will not run them, you are more than welcome to make one. The module as to be specifically named, It has to have “module-” before it.

   module-paypal.php or module-worldpay.php etc… must also have a dash after module. If by chance you make a new script for another merchant could you please send it to me and I will credit all the work for you 

   Paypal – Worldpay – 2Checkout:
   
   These merchants will need the return URL if you use the IPN. This url is the module directory and the corresponding module.
 
http://www.yoursite.com/search...rtal/modules/module-paypal.php
http://www.yoursite.com/search...al/modules/module-worldpay.php
http://www.yoursite.com/search...l/modules/module-2checkout.php


You will need to give this URL to a text field in your merchant account on said merchants.


Setting up your Poll:

With this script also comes a poll script. To add a poll is simple. Click on “Add a new poll”. This next page is also simple. Add a unique identifier so you can reference this with the poll you create, this will only be seen by you. Next, enter the poll question. Then in the next fields, add the voting options for the user to pick.

Once done, click on “create poll” and the next page confirms what you want. To view this poll just make sure it is enabled on the “view poll” page. This page allows you to edit, delete, create, toggle or even reset. You can tell what polls you have setup and what poll is active.

To toggle a poll to off or on: just make the drop down read “toggle” and then pick the poll you wish to toggle. You can only have one poll active at a time. Make sure you deactivate the presently active poll before you activate another.

Deleting, resetting, editing is the same as toggling.



Admin:

   This option allows you to add a new admin or view admin already installed. This is to allow more than one person to access the admin side of things to checking pending or do administration stuff. Very important to remember, once you add a new member they will be allowed to delete your account and take over so to speak. So make sure you are very trusting to this member/person.


แล้ว เราต้องไปแก้ตรงไหนอ่ะฮะ เวลามันขึ้นหน้า install มา ผมก็ใส่ user/pass แล้วแต่เราจะเซตอะไรก็ได้รึป่าว ผมก็เซตตามใจผมอ่ะ ไม่รู้ผิดตรงไหน
บันทึกการเข้า

URL=http://www.cirtexhosting.com/affiliates/idevaffiliate.php?id=408][/URL]
red_army
สมุนแก๊งเสียว
*

พลังน้ำใจ: 1
ออฟไลน์ ออฟไลน์

กระทู้: 568



ดูรายละเอียด
« ตอบ #3 เมื่อ: 20 ธันวาคม 2006, 10:00:10 »

อ้างถึง
$full_path_to_public_program = $_SERVER['DOCUMENT_ROOT']."/ searchportal";
ผมเปลี่ยนเป็น
อ้างถึง
$full_path_to_public_program = $_SERVER['DOCUMENT_ROOT'] ;
ผิดป่าวฮะ
บันทึกการเข้า

URL=http://www.cirtexhosting.com/affiliates/idevaffiliate.php?id=408][/URL]
red_army
สมุนแก๊งเสียว
*

พลังน้ำใจ: 1
ออฟไลน์ ออฟไลน์

กระทู้: 568



ดูรายละเอียด
« ตอบ #4 เมื่อ: 20 ธันวาคม 2006, 10:08:26 »

อ้าได้ละ แต่มาเจออันนี้ดิคับ Search Portal Install
DB TABLE ERROR:
Problem:
No database selected
Remedy:
Check that table admin does not exist from a previous installation ต้องทำไงอ่ะ
บันทึกการเข้า

URL=http://www.cirtexhosting.com/affiliates/idevaffiliate.php?id=408][/URL]
red_army
สมุนแก๊งเสียว
*

พลังน้ำใจ: 1
ออฟไลน์ ออฟไลน์

กระทู้: 568



ดูรายละเอียด
« ตอบ #5 เมื่อ: 20 ธันวาคม 2006, 10:24:31 »

ง่าได้ละ ไปสร้าง db user + db name ก่้อนนี่เอง
บันทึกการเข้า

URL=http://www.cirtexhosting.com/affiliates/idevaffiliate.php?id=408][/URL]
หน้า: [1]   ขึ้นบน
พิมพ์