Jump to content


S1.2 Install Script Bug


  • You cannot reply to this topic
1 reply to this topic

#1 visiblesoul

  • Administrators
  • 551 posts
  • Location:Earth
  • Texas

Posted 10 September 2005 - 02:33 AM

There is a bug in the mk_install.php file for S1.2. The mkp_links table does not install.

Try running this query to install the mkp_links table. Then the links manager should work.

CREATE TABLE `mkp_links` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL default '',
  `image` varchar(20) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `groups` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
)



Please note that I offer free support on this forum in my free time. Depending on how much work I have backlogged it may take me a week or more to answer questions. I am not ignoring you. I answer everyone but please be patient. Thanks.

Disclaimer: All forum posts, including code examples, on this forum are offered for free in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Use code examples at your own risk.

"If at first you don't succeed, keep on suckin' til you do succeed." -Curly Howard

#2 visiblesoul

  • Administrators
  • 551 posts
  • Location:Earth
  • Texas

Posted 10 September 2005 - 02:34 AM

If you have not yet run the S1.2 installer you can make this edit to repair the bug before running the installer. Then the installer will correctly install all tables.

FIND in mk_install.php
$query106="

CREATE TABLE `{$tblprefix}links` (

 `id` int(10) NOT NULL auto_increment,

 `name` varchar(60) NOT NULL default '',

 `image` varchar(20) NOT NULL default '',

 `url` varchar(255) NOT NULL default '',

 `groups` varchar(255) NOT NULL default '',

 PRIMARY KEY (`id`)

)";





$DB->query($query107);



$query106="

CREATE TABLE IF NOT EXISTS `{$tblprefix}rss` (

 `id` int(10) NOT NULL auto_increment,

 `name` varchar(40) NOT NULL default '',

 `url` varchar(255) NOT NULL default '',

 `position` int(3)  1,

 `active` tinyint(1),

 PRIMARY KEY (`id`)

)";





$DB->query($query107);

REPLACE WITH:
$query106="

CREATE TABLE `{$tblprefix}links` (

 `id` int(10) NOT NULL auto_increment,

 `name` varchar(60) NOT NULL default '',

 `image` varchar(20) NOT NULL default '',

 `url` varchar(255) NOT NULL default '',

 `groups` varchar(255) NOT NULL default '',

 PRIMARY KEY (`id`)

)";





$DB->query($query106);



$query107="

CREATE TABLE IF NOT EXISTS `{$tblprefix}rss` (

 `id` int(10) NOT NULL auto_increment,

 `name` varchar(40) NOT NULL default '',

 `url` varchar(255) NOT NULL default '',

 `position` int(3)  1,

 `active` tinyint(1),

 PRIMARY KEY (`id`)

)";





$DB->query($query107);



Please note that I offer free support on this forum in my free time. Depending on how much work I have backlogged it may take me a week or more to answer questions. I am not ignoring you. I answer everyone but please be patient. Thanks.

Disclaimer: All forum posts, including code examples, on this forum are offered for free in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Use code examples at your own risk.

"If at first you don't succeed, keep on suckin' til you do succeed." -Curly Howard





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users