MySQL and 'Table error' with manual_tp_install_0971.php

[3nd3r]

(Hope more luck posting here and deleting old post...)

I follow the instructions to manually install. When I go to this step:

http://www.pajareo.net/manual_tp_install_0971.php

I get this error page:

Code Select Expand

    * Upshrink table created
    * Settings table created

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pajareon/public_html/manual_tp_install_0971.php on line 159
    * Settings table updated
          o Added 74 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

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


If I go to my default page, http://www.pajareo.net/index.php
I get this error:

Code Select Expand

Table 'pajareon_smf.smf_tp_settings' doesn't exist

And yes, if I look to my smf database, that table doesn't exist... In fact, no new table created.

Maybe a SQL code to insert on my PHPmyAdmin should work?

[3nd3r]

No ideas? Any support?

[akulion]

try to run the SQL query to create the missing tables

http://www.tinyportal.net/index.php?action=tpmod;dl=item643

database install file

[3nd3r]

When I go to this step:

http://www.pajareo.net/manual_tp_install_0971.php

Do you mean do this? That's when the error comes up...

Or do you mean do it before all?

[akulion]

whats ur actual DB prefix?

is it smf_ ?

[akulion]

IF it is smf_

then run this query via PHP myadmin:

Code Select Expand


CREATE TABLE `smf_tp_settings` (
  `id` mediumint(9) NOT NULL auto_increment,
  `name` text NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;


[3nd3r]

Cool!  Table smf_tp_settings created!

Now? Do a manual install? From the begginning to the end?

[akulion]

yup give it a try and keep us posted

very weird though that u got a sql execution error on the manual db install

[3nd3r]

Yes... Very very weird thing... I'll try later (I'm at 'work'  ) and will tell you.

It seems that my SQL server it's a little 'possessive'... Ony I can touch it 

[akulion]

*escapes through the window before any more questions come*

lol