Jump to content


Photo
- - - - -

Installation Error unreal portal 3.1


  • Please log in to reply
3 replies to this topic

#1 viniciusmtn

viniciusmtn

    Member

  • Members
  • PipPip
  • 10 posts
  • IP.Board Version:1.3 or earlier

Posted 03 September 2012 - 06:14 PM

Version of my IPBOARD and 3.1

of this error message:

· CREATE TABLE up_settings ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `value` longtext NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=1 ;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 6
· CREATE TABLE unrealportal ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `title` varchar(255) NOT NULL default '', `align` varchar(255) NOT NULL default '', `show` int(11) NOT NULL default '1', `order2` int(11) NOT NULL default '0', `custblock_id` int(11) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=1 ;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 10
· CREATE TABLE up_custblocks ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `html` text NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=1 ;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 6
· CREATE TABLE up_custcontent ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `html` text NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=1 ;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 6
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('loginbox', 'Login Box', 'left', '0', 1);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('stats', 'Statistics', 'left', '0', 2);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('new_members', 'New Members', 'left', '0', 3);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('top_posters', 'Top Posters', 'left', '0', 4);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('calendar', 'Calendar', 'left', '0', 5);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('custom_content', 'Custom Content', 'left', '0', 6);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('welcomepanel', 'Welcome Panel', 'middle', '0', 7);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('latest_posts_big', 'Latest Posts (Big)', 'middle', '0', 8);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('new_posts_big', 'New Posts (Big)', 'middle', '0', 9);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('latest_news', 'Latest News', 'middle', '0', 10);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('news', 'News', 'middle', '0', 11);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('poll', 'Poll', 'right', '0', 12);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('old_news', 'Old News', 'right', '0', 13);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('latest_posts', 'Latest Posts', 'right', '0', 14);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('top_forums', 'Top Forums', 'right', '0', 15);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('site_search', 'Site Search', 'right', '0', 16);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('websearch', 'Web Search', 'right', '0', 17);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('jokes', 'Jokes', 'right', '0', 18);

Table 'clubx928_ipboard.unrealportal' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('activemembers', '1');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('calendar_events', '1');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('post_stats', '1');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('poll', '0');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('left', '25%');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('leftcustom', '25%');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('middle', '50%');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('middlecustom', '50%');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('right', '25%');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('rightcustom', '25%');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('num_top_forums', '5');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('num_newposts', '5');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('num_latestposts_big', '5');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('num_newmembers', '5');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('num_topposters', '5');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('num_latestposts', '5');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('newsforum', '2');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('newsforum_expert', '');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('newsforum_height', '0');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('newsforum_height_limit', '200px');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('newsforum_width', '0');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('newsposts', '5');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('num_old_news', '5');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('tease_news', '0');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('tease_length', '');

Table 'clubx928_ipboard.up_settings' doesn't exist
· INSERT INTO up_settings (`name`, `value`) VALUES ('num_latest_news', '5');

Table 'clubx928_ipboard.up_settings' doesn't exist

and on top of that error message appears more this look here:
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/clubx928/public_html/ips_kernel/classDbMysqliClient.php on line 464

Edited by Michael, 03 September 2012 - 09:21 PM.
Moved messages out of spoiler tags


#2 NenaDice

NenaDice

    Newbie

  • Resource Authors
  • Pip
  • 8 posts
  • IP.Board Version:3.2

Posted 04 September 2012 - 11:39 AM

I do not use that potal myself but from the error messages it looks like its tables have not been added to the database.

P.s. Did you install the right portal version that is compatible with your forum version btw?

#3 viniciusmtn

viniciusmtn

    Member

  • Members
  • PipPip
  • 10 posts
  • IP.Board Version:1.3 or earlier

Posted 04 September 2012 - 01:33 PM

yes guy installed the version that is compatible with my forum

#4 Sandi

Sandi

    Active Member

  • Resource Authors
  • PipPipPipPip
  • 118 posts
  • Location:Janesille, Wisconsin, USA
  • IP.Board Version:3.1

Posted 05 September 2012 - 04:46 AM

Unreal Portal site would be the place to find help.

Posted Image





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users