Topic: problems installing attachment mod :-(
Hi, Im setting up a punbb for the first time, and am having a very hard time installing the attachment mod (2.0.1). It wants 1.2.5, and im using 1.2.12. I did all the modifications to $punbb_versions, plus fixed some path related errors that it was complaining about, but now at the point where it tries to add a new table to my db, I am stuck.
To deal with this, the documentation
(http://cms.frankh.shacknet.nu/index.php … ;Itemid=32)
suggests "Secondly, step 43 & 44 is altered. Just change the true to false after the query (and add the comment behind , so you have a mark that the attachment mod has altered that line)"
I am not really sure what that means, but the error I get when I try to run the install is this:
File: /var/www/localhost/htdocs/attachmod/install_mod.php Line: 42
PunBB reported: Unable to add table "attach_2_files" to database
Database reported: SQL logic error or missing database (Errno: 1)
here is the code for the query that is failing.
$db->query("CREATE TABLE IF NOT EXISTS `".$db->prefix."attach_2_files` (
`id` int(10) unsigned NOT NULL auto_increment,
`owner` int(10) unsigned NOT NULL default '0',
`post_id` int(10) unsigned NOT NULL default '0',
`filename` varchar(255) NOT NULL default 'error.file',
`extension` varchar(64) NOT NULL default 'error.file',
`mime` varchar(64) NOT NULL default '',
`location` text NOT NULL,
`size` int(10) unsigned NOT NULL default '0',
`downloads` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `id` (`id`))") or error('Unable to add table "attach_2_files" to database', __FILE__, __LINE__, $db->error());
Does anyone have any suggestions for how to fix this?