Trouble Installing

[toneranger]

host says to connect through port ???? instead, so where do i input this.

Thanks tony

[esm]

hi esm - that little script returns - Connected successfully

been in touch with host, who reports connection through socket not available

absent any other information, one of you seems to be wrong.

your host says "connection through socket not available" but the small program I had you run said "Connected successfully." Those would seem to be mutually exclusive events.

And did you try replacing line 404 in the application.php file with the same line in small test program?

mysql_connect("cogia.net", "your_db_user_name","your_db_password");

if it worked in the small test program, it should work in the application.php file.

Just out of curiosity, is register_globals turned on or off?



.

[toneranger]

hi esm, added that line to application.php - no joy

then added it to install.hp line around 253 and script intalls. Thanks so much. Now to customising look etc.

Thanks again. Toneranger

[esm]

so it is working now?

if so, that brings us back almost full circle because all that the install does with the info is write it back to the application.php file.



.

[dody]

Please create a support ticket at http://www.nicecoder.com/helpdesk/ticket_new.php or just email us at support@nicecoder.com along with your ftp and mysql account. We'll examine the installation problem.

[toneranger]

Install has been completed.

errors now are in index.php and in admin

index.php returns
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/tonwil.cogia.net/links/index.php on line 25

the line throwing the error up is


$num_rows = mysql_num_rows($result);

same when in admin mode as you try to view available categories( have created these) .

Toneranger

[esm]

INDEXU (and Lite) does not do much error checking. The error for line 25 says that it did not find any categories.

But you say you have created categories. Once again these are mutually exclusive statements. Both cannot be right.

Did you create any "parent" categories?



.

[toneranger]

looked at the db itself - all seems to be in place. categories have not been created as the script does not seem to write to db.

Globals are on

Toneranger

[esm]

same when in admin mode as you try to view available categories( have created these) .

Toneranger

categories have not been created as the script does not seem to write to db.
Toneranger

hmmm... well, I am confused.

have you created categories or not?

If you go to the Admin Control Panel, you should see an option to add categories. You need to create at least one parent category. without a parent category, a sub-category will never show even if you create a million of them.



.

[toneranger]

Hi, i did try to create categories from within admin but the process failed.

Admin opens with the following error on admin/index.php

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/tonwil.cogia.net/links/application.php on line 265

adding a category returns the cat view page empty but includes the folloing error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/tonwil.cogia.net/links/application.php on line 265

opening the site index page returns

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/tonwil.cogia.net/links/index.php on line 25

Hope that explains my problems clearer

[esm]

add a category thru phpmyadmin

set the category id equal to one and parent id equal to zero

then test the index page and the add category script

you may also want to allow the folks at Nicecoder to install the scrip for you and get it running.


.

[toneranger]

Hi esm, thanks for all your help.

this really is bugging me - perhaps time to move from free host as the script will not run properly on this test host.

went into phpmyadmin and the categories have been created in the db, but are not displayed in any of the output.

index.php still contains the errors posted earlier.

admin/index.php when adding category returns message category created.

cat view just displays the table with delete category.

have run a search from the index page - results report I have categories and links in the database but will not display them.
errors in page returned

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/tonwil.cogia.net/links/search.php on line 67

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/tonwil.cogia.net/links/search.php on line 122

Search the Directory:
Search Result

There are categories and links found for keyword rugby hospital radio


decided to delete db and start anew - install script runs but fails to create info to db.

Connected successfully Message
Configuration file has been updated.

Verifying existing Indexu Lite Edition tables:
category....failed
link....failed
rating....failed
review....failed
review_temp....failed
searchlog....failed
validate....failed


Done

Can't find any existing tables. Installation will create new tables.

category....failed
link....failed
rating....failed
review....failed
review_temp....failed
search_log....failed
validate....failed

Installation completed. Now you can go to administrator control panel to administer your portal.


toneranger

[esm]

Would it be worth deleting the db and starting again.

Well, the lite version is what first attracted me to INDEXU. The lite version has probably been installed at least a couple of hundred of times and it may very well be easily in the several hundreds.

I would estimate that about 99% of those installs have been perfect. Yours may just be one of those in the 1%. it is really just a simple install so it would not hurt to delete everything and start all over.

I would let Nicecoder install it.


.

[dody]

What php version do you have? I found some cases which is not running in php 4.3.11