2011-12-09, 11:31 AM
(2011-12-08, 11:39 PM)pavemen Wrote: sorry about that. I have not done a fresh install in a while and did not catch that with the latest update (in which I changed the type of that field).
Simply edit the file in /inc/plugins/myshowcase/myshowcase_plugins.php and cahnge line 119 from
`comment` text NOT NULL default '',
to
`comment`,
and then attempt the install again
new error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - 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 ' `dateline` bigint(30) NOT NULL, PRIMARY KEY (`cid`,`gid`) ) ENGINE' at line 7
Query:
CREATE TABLE `mybb_myshowcase_comments` ( `id` int(3) NOT NULL default '1', `cid` int(10) NOT NULL auto_increment, `gid` int(10) NOT NULL, `uid` int(10) NOT NULL, `ipaddress` varchar(30) NOT NULL default '0.0.0.0', `comment`, `dateline` bigint(30) NOT NULL, PRIMARY KEY (`cid`,`gid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;