Jump to content


Issue information

  • #000029

  • Issue

  • 0 - None Assigned

  • UNFILED

  • 3.0.1

  • -


Issue Confirmations

  • Yes (0)No (0)
Photo

Problem with installation

Posted by SeeYou on 19 September 2011 - 07:33 AM

I greet, when I want to install portal show on mass of different error 3.1.4 me IPB 

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/nataniel/public_html/strony/blackshot.eu/ips_kernel/classDbMysqliClient.php on line 465
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/nataniel/public_html/strony/blackshot.eu/ips_kernel/classDbMysqliClient.php on line 465
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/nataniel/public_html/strony/blackshot.eu/ips_kernel/classDbMysqliClient.php on line 465
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/nataniel/public_html/strony/blackshot.eu/ips_kernel/classDbMysqliClient.php on line 465
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/nataniel/public_html/strony/blackshot.eu/ips_kernel/classDbMysqliClient.php on line 465
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/nataniel/public_html/strony/blackshot.eu/ips_kernel/classDbMysqliClient.php on line 465
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/nataniel/public_html/strony/blackshot.eu/ips_kernel/classDbMysqliClient.php on line 465




· CREATE TABLE bs_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 bs_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 bs_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 bs_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 bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('loginbox', 'Login Box', 'left', '0', 1);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('stats', 'Statistics', 'left', '0', 2);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('new_members', 'New Members', 'left', '0', 3);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('top_posters', 'Top Posters', 'left', '0', 4);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('calendar', 'Calendar', 'left', '0', 5);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('custom_content', 'Custom Content', 'left', '0', 6);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('welcomepanel', 'Welcome Panel', 'middle', '0', 7);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('latest_posts_big', 'Latest Posts (Big)', 'middle', '0', 8);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('new_posts_big', 'New Posts (Big)', 'middle', '0', 9);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('latest_news', 'Latest News', 'middle', '0', 10);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('news', 'News', 'middle', '0', 11);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('poll', 'Poll', 'right', '0', 12);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('old_news', 'Old News', 'right', '0', 13);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('latest_posts', 'Latest Posts', 'right', '0', 14);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('top_forums', 'Top Forums', 'right', '0', 15);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('site_search', 'Site Search', 'right', '0', 16);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('websearch', 'Web Search', 'right', '0', 17);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_unrealportal (`name` , `title` , `align`, `show`, `order2` ) VALUES ('jokes', 'Jokes', 'right', '0', 18);
Table 'nataniel_blackshot1.bs_unrealportal' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('activemembers', '1');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('calendar_events', '1');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('post_stats', '1');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('poll', '0');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('left', '25%');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('leftcustom', '25%');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('middle', '50%');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('middlecustom', '50%');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('right', '25%');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('rightcustom', '25%');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('num_top_forums', '5');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('num_newposts', '5');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('num_latestposts_big', '5');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('num_newmembers', '5');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('num_topposters', '5');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('num_latestposts', '5');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('newsforum', '2');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('newsforum_expert', '');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('newsforum_height', '0');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('newsforum_height_limit', '200px');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('newsforum_width', '0');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('newsposts', '5');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('num_old_news', '5');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('tease_news', '0');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('tease_length', '');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist
· INSERT INTO bs_up_settings (`name`, `value`) VALUES ('num_latest_news', '5');
Table 'nataniel_blackshot1.bs_up_settings' doesn't exist

http://www.imagebana...m/code/qwe7uzjn

Please, < ask > about fast assistance


MIXOH
Pip
Oct 13 2011 05:01 AM
TYPE keyword is no more used with MySQL latest (5.5.8) versions. This has been posted as a bug here http://bugs.mysql.com/bug.php?id=59288 but they claim that it is not the bug. The keyword ‘TYPE’ was introduced as deprecated since ENGINE was added in MySQL 4.0.18. And it is clearly mentioned in the CREATE TABLE structure manaul page (http://dev.mysql.com...eate-table.html) that the TYPE keyword will be removed in future versions.

So if your version of MySQL latest (5.5.8) version? you should be replaced keyword TYPE by keyword ENGINE in file \admin\applications_addon\other\uportal\setup\versions\install\sql\uportal_mysql_tables.php

$TABLE[] = "CREATE TABLE up_settings (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `value` longtext NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;";
$TABLE[] = "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)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;";
$TABLE[] = "CREATE TABLE up_custblocks (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `html` text NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;";
$TABLE[] = "CREATE TABLE up_custcontent (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `html` text NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;";


Back to Unreal Portal


1 user(s) are reading this issue

0 members, 1 guests, 0 anonymous users

  1. Unreal Solutions
  2. > Tracker
  3. > Unreal Portal
  4. > Status UNFILED
  5. > Version 3.0.1