TinyPortal

Development => Support => Installation => Topic started by: Jacobryan on March 23, 2007, 08:57:54 PM

Title: Error when installing TP_983
Post by: Jacobryan on March 23, 2007, 08:57:54 PM
QuoteUpshrink table created
Settings table created2: mysql_num_rows(): supplied argument is not a valid MySQL result resource
File: /home/content/j/a/c/jacobryan82/html/smf/Packages/temp/tp_install.php
Line: 169

I'm having the same problem where everything seem to be installing then in goes to a blank screen and nothing happens I check my packages and it still says apply mod.  But I only get the error above after I first upload the file after that I get the blank window??

???
Title: Re: Error when installing TP_983
Post by: Resident Geek on March 23, 2007, 09:21:24 PM
That error says mysql_num_rows()
usually it's something like smf_num_rows()
Are you sure that you have the correct information in for your DB?
Title: Re: Error when installing TP_983
Post by: Jacobryan on March 23, 2007, 09:29:55 PM
I have not changed anything in my database. I had TP 9.7 working fine then I did the upgrade and now I cant get TP back on my site to save my life!!  :'(
Title: Re: Error when installing TP_983
Post by: Resident Geek on March 23, 2007, 09:34:06 PM
Hmm. That's strange. I did a search through my own database to see were the num_rows was stored, and it's not anywhere in my database.
I'd try redownloading the file, and reuploading it. My guess would be that you've got a corrupt file.
Unless you've happened to have been messing with SSI.php before you uploaded. I hear it'll cause you a lot of grief if you've been messing with it, when you try to update TP.
Title: Re: Error when installing TP_983
Post by: Jacobryan on March 23, 2007, 09:38:46 PM
I have touched nothing!!

The only thing I have done with my database is back it up.  I dont know enough about php to mess with any files!!

Also I have downloaded the file again uploaded it and still I get the same problem.  I even tried uploading the old 9.7 file and it does nothing!! 
Title: Re: Error when installing TP_983
Post by: Resident Geek on March 23, 2007, 09:40:25 PM
What mods do You have installed?
Also, do you have any blocks with script coding in them. They tend to cause problems at inconvenient times.
Title: Re: Error when installing TP_983
Post by: Jacobryan on March 23, 2007, 09:47:46 PM
The only mod applied is:

SMF 1.1.2 Update Package
Title: Re: Error when installing TP_983
Post by: Resident Geek on March 23, 2007, 09:49:09 PM
What about code block snippets? Do you have any code in a script block?
Title: Re: Error when installing TP_983
Post by: G6Cad on March 23, 2007, 09:56:41 PM
Download the big upgrade package from SMF, extract the package on your local machine and then take out the upgrade.php and the 2 sql update files.
Upload them to your forum root and point the browser to the upgrade.php file.
Let it update the database, then try and install TP again.
Title: Re: Error when installing TP_983
Post by: Resident Geek on March 23, 2007, 09:59:29 PM
You may want to check to see what tp_install.php is trying to do on line 169. May give you/us a clue as to what it's trying to do.

EDIT: Never mind. Listen to G6. She knows a lot more about this than I do. I just hack code.  >:D
Title: Re: Error when installing TP_983
Post by: Jacobryan on March 23, 2007, 10:01:30 PM
Quote from: G6â„¢ on March 23, 2007, 09:56:41 PM
Download the big upgrade package from SMF, extract the package on your local machine and then take out the upgrade.php and the 2 sql update files.
Upload them to your forum root and point the browser to the upgrade.php file.
Let it update the database, then try and install TP again.

I have already done that the first time I had trouble and it did not fix the problem. Should I try it again??
Title: Re: Error when installing TP_983
Post by: Jacobryan on March 23, 2007, 10:05:09 PM
What are the names of the 2 sql update files?
Title: Re: Error when installing TP_983
Post by: G6Cad on March 23, 2007, 10:08:05 PM
Uppgrade 1-1.sql
Uppgrade 1-0.sql

What SQL version do you have ?
Title: Re: Error when installing TP_983
Post by: Jacobryan on March 23, 2007, 10:16:13 PM
4 I believe
Title: Re: Error when installing TP_983
Post by: Jacobryan on March 23, 2007, 10:17:08 PM
upload those 3 file and run the upgrade correct?
Title: Re: Error when installing TP_983
Post by: G6Cad on March 23, 2007, 10:39:33 PM
Yes
Title: Re: Error when installing TP_983
Post by: Jacobryan on March 24, 2007, 02:38:57 AM
Did it and it still gave me the same error!
Title: Re: Error when installing TP_983
Post by: bloc on March 24, 2007, 08:38:10 AM
Quote from: Resident Geek on March 23, 2007, 09:59:29 PM
You may want to check to see what tp_install.php is trying to do on line 169. May give you/us a clue as to what it's trying to do.

EDIT: Never mind. Listen to G6. She knows a lot more about this than I do. I just hack code.  >:D

Then I suggest get your facts straight first. Its not helpful when you don't know what you are talking about. "mysql_num_rows" is a php function and it fails if the sql table it tries to read doesn't exist or doesn't have any entries.


Jacobryan,

..From the error it seems to not be able to read the tp_settings table and be able to update a few items there. But I am bit uncertain how you did the upgrade for TP. Did you import the entire zip package and just pressed "apply mod"?
Title: Re: Error when installing TP_983
Post by: Jacobryan on March 24, 2007, 11:14:32 AM
Mr. Bloc I have done so much in the past couple of days I'm not sure what I did!!  :-\

When I installed TP 983 I got an error I was then told to run smf Big Update.  After that I was told to try the upload the TP 983 and it should work but it still gave me the same error.   No matter what I do now I keep getting the same error mess.  I've got to run to work but I will check back when I get off.  I might have missed a simple step but I have totally confused myself now!   ???
Title: Re: Error when installing TP_983
Post by: bloc on March 24, 2007, 11:24:12 AM
If you can make other mods install and work, then its something with TP. If you can't, then its the server setup somehow.
Title: Re: Error when installing TP_983
Post by: Jacobryan on March 24, 2007, 11:27:33 AM
Its a godaddy server. If that helps you out.  They set up everything for ya.
Title: Re: Error when installing TP_983
Post by: bloc on March 24, 2007, 11:42:56 AM
Hm. I am not sure if it does, but others have reported trouble with Godaddy before, especially when you want to do something more than using the default forum.

It would seem the server makes it hard to update TP the normal way. Have you tried the manual approach?
Title: Re: Error when installing TP_983
Post by: Jacobryan on April 05, 2007, 11:38:55 PM
I've tried a million ways over the past week.  I guess I am left to go with the manual install, though it will prolly be my downfall.  But I'll give manual install a shot!  8)
Title: Re: Error when installing TP_983
Post by: Shadow on April 06, 2007, 06:39:26 AM
I ask someone about Manual installing of TP.  And that person told me it's easly to do.  But backup the file's