New install error

[Skhilled]

I've decided to install another test site using rc2 and tp 0.84 because I am now with another hosting company. The problem is everytime I run tp_install I get the following error:

Install / Upgrade TinyPortal v0.8.4beta
Upshrink table created
Settings table created
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wishyou/public_html/skhilled/smf2/tp_install.php on line 120

Blocks table created.
some sample values were added to the blocks table
Variables table created.
Articles table created.
DL manager table created
TinyPortalÂÃ,´s table structure is now installed/updated.
Please restart your forum to see the changes.

Anyone have any ideas? I've set permissions on every folder to 777 on a hunch but still no joy.

Thanks...

[Skhilled]

I forgot to mention that the forum works but no tp..

[Xarcell]

I dunno, if it was me, I'd delete everything, clean out my database, and reinstall. Make sure your doing a install, not upgrade.

[Skhilled]

ok, thanks. I'll try it again.

[Xarcell]

let us know if it works.

[Skhilled]

Nope, got the same thing. Weird. I did not do a manul edit yet but still think I shouldn't get those errors. Maybe a db prob on my end. I'll look into it.

[snork13]

i got the same error while upgrade from 8.4 ->8.6. i haven't looked into it as of yet.

Code Select Expand

foreach($settings_array as $what => $val){
        $sjekk=mysql_query("SELECT * FROM {$new_prefix}settings WHERE name='$what'");
        if(mysql_num_rows($sjekk)<1){
                 mysql_query("INSERT INTO {$new_prefix}settings (name,value) VALUES ( '$what', '$val')");
        }

-snork

[crip]

Errors come and they go...

[bloc]

i got the same error while upgrade from 8.4 ->8.6. i haven't looked into it as of yet.

Code Select Expand

foreach($settings_array as $what => $val){
        $sjekk=mysql_query("SELECT * FROM {$new_prefix}settings WHERE name='$what'");
        if(mysql_num_rows($sjekk)<1){
                 mysql_query("INSERT INTO {$new_prefix}settings (name,value) VALUES ( '$what', '$val')");
        }

-snork

This is strange..it would seem the array don't hold its values. Could you post SMF version, server, PHP and MySQL version?

[Xarcell]

Have you tried uninstalling TP, delete, then installing v86?