Error During Install - MYSQL error

[nzjav05]

Hey,

I have searched all throughout the forum and FAQ's trying to find this problem, but I can not find anything close enough to it.



I have done a half and half install (I used the package manager), but I uploaded my index.template.php file once I fixed it up since it failed the test.


The problem I am getting now is this:

Code Select Expand

Table 'new1.smf_tp_variables' doesn't exist
File: /home/.mondale/kaze6689/animesharing.org/forum/Sources/TPortal.php
Line: 92

Which basically means none of the databases were created.


So I ran the manual database install, but got this error:

Code Select Expand

    * Upshrink table created
    * Settings table created

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.mondale/kaze6689/animesharing.org/forum/manual_tp_install.php on line 183
    * Settings table updated
          o Added 98 new setting(s)
    * Blocks table created.
          o some sample values were added to the blocks table
    * Variables table created.
          o some sample values were added to the variables table
    * Articles table created.
          o some sample values were added to the articles table
    * DL manager table created
    * Shoutbox table created

TinyPortalÃ,´s table structure is now installed/updated.
Thank you for trying out TinyPortal.


Line 183:

Code Select Expand

        if(mysql_num_rows($sjekk)<1){





Do you know what could be causing this ?

[G6Cad]

download the manual tp install DB file only and upload it to your forum root and run the file from your browser.

[nzjav05]

That Is what I did...


I downloaded:

TinyPortal 0.9.8 database install

From the downloads tab, which then gave me the file "manual_tp_install.php"



And the long list of code there is the error it gives me when I try accessing it via my browser. That is why it is so confusing. (I have read countless posts)

[G6Cad]

You must upload the file to the same folder you have the forum and TP installed to.

Another way is to download the complete manuall install package and extract and upload the files from it to your forum folder, then point the browser to manual_tp_install.php

[nzjav05]

Yep, I had it in my root folder.

SMF already installed everything that is in the manual package (the full one). But I just keep getting the same error when I try to use the manual_tp_install.php.


I have a feeling that It may have something to do with the sql coding, but if it has worked for almost everyone else then I am not too sure why it is doing this.


BTW, this is on a dreamhost server if that helps.

[Crip]

Download a new TP_zip, un-zip it and re-zip it using the same zip name..run it through package-manager..
..it works sometimes..& clean your cookies & cache..be sure to use to be using SMF Default theme.

[nzjav05]

Yep, I have always switched back to the default theme but nothing...

I tried re-zipping it, but still no luck (this is getting annoying now).



Does anyone else have any ideas ?