Kyle F Posted May 14, 2017 Posted May 14, 2017 Hey guys. It's been a while since I've posted at IPS.. I have a question. Does anyone (at all) here still use IP.Board 2.3.x (that could include a demo board) at all? I know and understand that 2.3.x was discontinued for support and downloads years ago, but I still have it/use it. I have a new board I installed a few weeks ago as I wanted to bring back an old clan and I'm just trying to sort things out on it. I've done my own security updates/patches and fixed some bugs in the version I'm using and have modded it to my liking. The Admin CP is or will be modded when I've finished with it. (at the moment I've got a local installation with the modded ACP) - I still have quite a few of the old versions that I had backups of from when they were the latest updates on a hard disk. The products I've still got from when they were the latest are: IP.Board 2.0.0 IP.Board 2.2.2 IP.Board 2.3.3 IP.Board 2.3.6 IP.Blog 1.3.2 (13005) IP.Downloads 1.2.0 Matt These are the current versions and products I have as well as a few for IP.Board 3.3 and 3.4.x (Like IP.Downloads and IP.Content for 3.4) If anyone would offer some help with installing the IDM 1.2.0 that'd be wonderful because on a backup I had I restored the files and SQL database for an old forum running 2.3.6, IDM works fine. But when I transferred the files over to my currently running installation and run "/forums/idm_setup/" I get this: 1000 queries run (up to 1000 total queries run so far).... Error in upgrade 1.2.0 (12005) 17 errors found CREATE TABLE ibf_downloads_categories ( cid int(10) NOT NULL auto_increment, cparent int(10) NOT NULL default '0', cname varchar(255) NOT NULL default '', cdesc mediumtext NULL, copen tinyint(1) NOT NULL default '0', cposition int(10) NOT NULL default '0', cperms text NULL, coptions text NULL, ccfields text NULL, cfileinfo text NULL, cdisclaimer mediumtext NULL, PRIMARY KEY (cid), KEY cparent (cparent), KEY cposition (cposition) ); Table 'ibf_downloads_categories' already exists CREATE TABLE ibf_downloads_ccontent ( file_id mediumint(8) NOT NULL default '0', updated int(10) default '0', PRIMARY KEY (file_id) ); Table 'ibf_downloads_ccontent' already exists CREATE TABLE ibf_downloads_cfields ( cf_id smallint(5) NOT NULL auto_increment, cf_title varchar(250) NOT NULL default '', cf_desc varchar(250) NOT NULL default '', cf_content text NULL, cf_type varchar(250) NOT NULL default '', cf_not_null tinyint(1) NOT NULL default '0', cf_max_input smallint(6) NOT NULL default '0', cf_input_format text NULL, cf_file_format mediumtext NULL, cf_position smallint(6) NOT NULL default '0', cf_topic TINYINT( 1 ) NOT NULL DEFAULT '0', cf_search TINYINT( 1 ) NOT NULL DEFAULT '0', PRIMARY KEY (cf_id), KEY cf_position (cf_position) ); Table 'ibf_downloads_cfields' already exists CREATE TABLE ibf_downloads_comments ( comment_id int(10) NOT NULL auto_increment, comment_fid int(10) NOT NULL default '0', comment_mid mediumint(8) NOT NULL default '0', comment_date varchar(13) NOT NULL default '0', comment_open tinyint(1) NOT NULL default '0', comment_text mediumtext NULL, comment_append_edit TINYINT( 1 ) NOT NULL DEFAULT '0', comment_edit_time VARCHAR( 11 ) NOT NULL DEFAULT '0', comment_edit_name VARCHAR( 255 ) NULL , ip_address VARCHAR( 32 ) NULL , use_sig TINYINT( 1 ) NOT NULL DEFAULT '1', use_emo TINYINT( 1 ) NOT NULL DEFAULT '1', PRIMARY KEY (comment_id), KEY comment_fid (comment_fid) ); Table 'ibf_downloads_comments' already exists CREATE TABLE ibf_downloads_downloads ( did int(10) NOT NULL auto_increment, dfid int(10) NOT NULL default '0', dtime varchar(13) NOT NULL default '0', dip varchar(55) NOT NULL default '0', dmid mediumint(8) NOT NULL default '0', dsize int(10) NOT NULL default '0', dua varchar(255) default NULL, dbrowsers varchar(25) NOT NULL default '', dos varchar(25) NOT NULL default '', dcountry varchar(7) NOT NULL default '', PRIMARY KEY (did), KEY dfid (dfid,dsize) ); Table 'ibf_downloads_downloads' already exists CREATE TABLE ibf_downloads_favorites ( fid int(10) NOT NULL auto_increment, fmid mediumint(8) NOT NULL default '0', ffid int(10) NOT NULL default '0', fupdated varchar(13) NOT NULL default '0', PRIMARY KEY (fid), KEY ffid (ffid) ); Table 'ibf_downloads_favorites' already exists CREATE TABLE ibf_downloads_files ( file_id int(10) NOT NULL auto_increment, file_name varchar(255) NOT NULL default '0', file_cat mediumint(8) NOT NULL default '0', file_open tinyint(1) NOT NULL default '0', file_broken tinyint(1) NOT NULL default '0', file_broken_reason text NULL, file_broken_info VARCHAR( 255 ) NULL, file_filename varchar(255) NOT NULL default '0', file_ssname varchar(255) NOT NULL default '0', file_thumb varchar(255) NOT NULL default '0', file_views int(10) NOT NULL default '0', file_downloads int(10) NOT NULL default '0', file_submitted varchar(13) NOT NULL default '0', file_updated varchar(13) NOT NULL default '0', file_desc text NULL, file_size int(10) NOT NULL default '0', file_mime mediumint(8) NOT NULL default '0', file_ssmime mediumint(8) NOT NULL default '0', file_submitter mediumint(8) NOT NULL default '0', file_approver mediumint(8) NOT NULL default '0', file_approvedon varchar(13) NOT NULL default '0', file_topicid int(10) NOT NULL default '0', file_pendcomments smallint(4) NOT NULL default '0', file_ipaddress varchar(50) NOT NULL default '0', file_storagetype enum('web','nonweb','ftp','db') NOT NULL default 'web', file_sub_mems mediumtext NULL, file_votes text NULL, file_rating smallint(5) NOT NULL default '0', file_meta text NULL, file_new tinyint( 1 )NOT NULL default '0', file_placeholder tinyint(1) NOT NULL default '0', file_url TINYTEXT NULL, file_ssurl TINYTEXT NULL, file_realname VARCHAR( 255 ) NULL, PRIMARY KEY (file_id), KEY file_views (file_views), KEY file_downloads (file_downloads), KEY file_cat (file_cat), KEY file_submitter (file_submitter), KEY file_broken (file_broken), KEY file_open (file_open), KEY file_rating (file_rating) ) TYPE=MyISAM 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' at line 44 CREATE TABLE ibf_downloads_filestorage ( storage_id int(10) NOT NULL default '0', storage_file blob, storage_ss blob, storage_thumb blob, UNIQUE KEY storage_id (storage_id) ); Table 'ibf_downloads_filestorage' already exists CREATE TABLE ibf_downloads_fileviews ( view_id mediumint(10) NOT NULL auto_increment, view_fid int(10) NOT NULL default '0', PRIMARY KEY (view_id) ); Table 'ibf_downloads_fileviews' already exists CREATE TABLE ibf_downloads_ip2ext ( ip int(11) unsigned NOT NULL default '0', country char(2) NOT NULL default '', KEY ip (ip) ); Table 'ibf_downloads_ip2ext' already exists CREATE TABLE ibf_downloads_mime ( mime_id int(10) NOT NULL auto_increment, mime_extension varchar(18) NOT NULL default '', mime_mimetype varchar(255) NOT NULL default '', mime_file text NULL, mime_screenshot text NULL, mime_inline text NULL, mime_img text NULL, PRIMARY KEY (mime_id) ); Table 'ibf_downloads_mime' already exists CREATE TABLE ibf_downloads_mimemask ( mime_maskid int(10) NOT NULL auto_increment, mime_masktitle varchar(255) NOT NULL default '0', PRIMARY KEY (mime_maskid) ); Table 'ibf_downloads_mimemask' already exists CREATE TABLE ibf_downloads_mods ( modid mediumint(8) NOT NULL auto_increment, modtype tinyint(1) NOT NULL default '0', modgmid varchar(255) NOT NULL default '0', modcanedit tinyint(1) NOT NULL default '0', modcandel tinyint(1) NOT NULL default '0', modcanapp tinyint(1) NOT NULL default '0', modcanbrok tinyint(1) NOT NULL default '0', modcancomments tinyint(1) NOT NULL default '0', modcats mediumtext NULL, PRIMARY KEY (modid) ); Table 'ibf_downloads_mods' already exists CREATE TABLE ibf_downloads_upgrade_history ( idm_upgrade_id int(10) NOT NULL auto_increment, idm_version_id int(10) NOT NULL default '0', idm_version_human varchar(200) NOT NULL default '', idm_upgrade_date int(10) NOT NULL default '0', idm_upgrade_mid int(10) NOT NULL default '0', idm_upgrade_notes text NULL, PRIMARY KEY (idm_upgrade_id) ); Table 'ibf_downloads_upgrade_history' already exists CREATE TABLE ibf_downloads_filebackup ( b_id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , b_fileid INT( 10 ) NOT NULL DEFAULT '0', b_filetitle VARCHAR( 255 ) NOT NULL DEFAULT '0', b_filedesc TEXT NULL , b_filename VARCHAR( 255 ) NOT NULL DEFAULT '0', b_ssname VARCHAR( 255 ) NOT NULL DEFAULT '0', b_thumbname VARCHAR( 255 ) NOT NULL DEFAULT '0', b_filemime MEDIUMINT( 8 ) NOT NULL DEFAULT '0', b_ssmime MEDIUMINT( 8 ) NOT NULL DEFAULT '0', b_filemeta TEXT NULL , b_storage VARCHAR( 10 ) NOT NULL DEFAULT 'web', b_hidden TINYINT( 1 ) NOT NULL DEFAULT '0', b_backup VARCHAR( 13 ) NOT NULL DEFAULT '0', b_updated VARCHAR( 13 ) NOT NULL DEFAULT '0', b_fileurl TINYTEXT NULL , b_ssurl TINYTEXT NULL , b_filereal VARCHAR( 255 ) NOT NULL DEFAULT '0', INDEX ( b_fileid ) ); Table 'ibf_downloads_filebackup' already exists ALTER TABLE ibf_groups ADD idm_restrictions TEXT NULL; Duplicate column name 'idm_restrictions' CREATE TABLE ibf_downloads_sessions ( dsess_id VARCHAR( 32 ) NOT NULL , dsess_mid INT( 10 ) NOT NULL DEFAULT '0', dsess_ip VARCHAR( 32 ) NULL , dsess_file INT( 10 ) NOT NULL DEFAULT '0', dsess_start VARCHAR( 13 ) NOT NULL DEFAULT '0', dsess_end VARCHAR( 13 ) NOT NULL DEFAULT '0', PRIMARY KEY ( dsess_id ) , INDEX ( dsess_mid , dsess_ip ) ) ENGINE = MYISAM ; Table 'ibf_downloads_sessions' already exists I know the tables already exist as I emptied them from the SQL backup tables for these. But if I DROP the tables from my current installation database and run the installer it fails to create these tables. As for "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' at line 44" I don't know what I need to check to try and sort this out. The MySQL DB version on Hostgator (screenshot below) I'd really appreciate if someone could help with the witchcraft that which the IDM installer is throwing at me. This one is from my local installation and the IDM works fine: This one is my new installation (it doesn't work): Thank you.
Dean_ Posted May 14, 2017 Posted May 14, 2017 GREAT SCOTT! Quick Marty - Back to the time machine!!!! 2.3.x - What was that 2007? I wish I could be of more help
Faqole Posted May 14, 2017 Posted May 14, 2017 That seems to be a very old version. May I ask as to why are you not upgrading to the latest version? It has a lot of benefits, like a lot of new features, not to mention the security patches and the bug fixes. That being said, I do not know what you are trying to install, but looking at the errors that you posted, the tables of that script already exist in your database. You will have to remove them and give the installation another go. However, it will be better to backup them first before you delete them. Hope it helps a little. 5 minutes ago, Dean_ said: GREAT SCOTT! Quick Marty - Back to the time machine!!!! 2.3.x - What was that 2007? I wish I could be of more help Even Doc was surprised by this one LOL
Pete T Posted May 14, 2017 Posted May 14, 2017 30 minutes ago, NSanityHD said: Hey guys. It's been a while since I've posted at IPS.. I have a question. Does anyone (at all) here still use IP.Board 2.3.x (that could include a demo board) at all? I know and understand that 2.3.x was discontinued for support and downloads years ago, but I still have it/use it. I have a new board I installed a few weeks ago as I wanted to bring back an old clan and I'm just trying to sort things out on it. I've done my own security updates/patches and fixed some bugs in the version I'm using and have modded it to my liking. The Admin CP is or will be modded when I've finished with it. (at the moment I've got a local installation with the modded ACP) - I still have quite a few of the old versions that I had backups of from when they were the latest updates on a hard disk. The products I've still got from when they were the latest are: IP.Board 2.0.0 IP.Board 2.2.2 IP.Board 2.3.3 IP.Board 2.3.6 IP.Blog 1.3.2 (13005) IP.Downloads 1.2.0 Matt These are the current versions and products I have as well as a few for IP.Board 3.3 and 3.4.x (Like IP.Downloads and IP.Content for 3.4) If anyone would offer some help with installing the IDM 1.2.0 that'd be wonderful because on a backup I had I restored the files and SQL database for an old forum running 2.3.6, IDM works fine. But when I transferred the files over to my currently running installation and run "/forums/idm_setup/" I get this: 1000 queries run (up to 1000 total queries run so far).... Error in upgrade 1.2.0 (12005) 17 errors found CREATE TABLE ibf_downloads_categories ( cid int(10) NOT NULL auto_increment, cparent int(10) NOT NULL default '0', cname varchar(255) NOT NULL default '', cdesc mediumtext NULL, copen tinyint(1) NOT NULL default '0', cposition int(10) NOT NULL default '0', cperms text NULL, coptions text NULL, ccfields text NULL, cfileinfo text NULL, cdisclaimer mediumtext NULL, PRIMARY KEY (cid), KEY cparent (cparent), KEY cposition (cposition) ); Table 'ibf_downloads_categories' already exists CREATE TABLE ibf_downloads_ccontent ( file_id mediumint(8) NOT NULL default '0', updated int(10) default '0', PRIMARY KEY (file_id) ); Table 'ibf_downloads_ccontent' already exists CREATE TABLE ibf_downloads_cfields ( cf_id smallint(5) NOT NULL auto_increment, cf_title varchar(250) NOT NULL default '', cf_desc varchar(250) NOT NULL default '', cf_content text NULL, cf_type varchar(250) NOT NULL default '', cf_not_null tinyint(1) NOT NULL default '0', cf_max_input smallint(6) NOT NULL default '0', cf_input_format text NULL, cf_file_format mediumtext NULL, cf_position smallint(6) NOT NULL default '0', cf_topic TINYINT( 1 ) NOT NULL DEFAULT '0', cf_search TINYINT( 1 ) NOT NULL DEFAULT '0', PRIMARY KEY (cf_id), KEY cf_position (cf_position) ); Table 'ibf_downloads_cfields' already exists CREATE TABLE ibf_downloads_comments ( comment_id int(10) NOT NULL auto_increment, comment_fid int(10) NOT NULL default '0', comment_mid mediumint(8) NOT NULL default '0', comment_date varchar(13) NOT NULL default '0', comment_open tinyint(1) NOT NULL default '0', comment_text mediumtext NULL, comment_append_edit TINYINT( 1 ) NOT NULL DEFAULT '0', comment_edit_time VARCHAR( 11 ) NOT NULL DEFAULT '0', comment_edit_name VARCHAR( 255 ) NULL , ip_address VARCHAR( 32 ) NULL , use_sig TINYINT( 1 ) NOT NULL DEFAULT '1', use_emo TINYINT( 1 ) NOT NULL DEFAULT '1', PRIMARY KEY (comment_id), KEY comment_fid (comment_fid) ); Table 'ibf_downloads_comments' already exists CREATE TABLE ibf_downloads_downloads ( did int(10) NOT NULL auto_increment, dfid int(10) NOT NULL default '0', dtime varchar(13) NOT NULL default '0', dip varchar(55) NOT NULL default '0', dmid mediumint(8) NOT NULL default '0', dsize int(10) NOT NULL default '0', dua varchar(255) default NULL, dbrowsers varchar(25) NOT NULL default '', dos varchar(25) NOT NULL default '', dcountry varchar(7) NOT NULL default '', PRIMARY KEY (did), KEY dfid (dfid,dsize) ); Table 'ibf_downloads_downloads' already exists CREATE TABLE ibf_downloads_favorites ( fid int(10) NOT NULL auto_increment, fmid mediumint(8) NOT NULL default '0', ffid int(10) NOT NULL default '0', fupdated varchar(13) NOT NULL default '0', PRIMARY KEY (fid), KEY ffid (ffid) ); Table 'ibf_downloads_favorites' already exists CREATE TABLE ibf_downloads_files ( file_id int(10) NOT NULL auto_increment, file_name varchar(255) NOT NULL default '0', file_cat mediumint(8) NOT NULL default '0', file_open tinyint(1) NOT NULL default '0', file_broken tinyint(1) NOT NULL default '0', file_broken_reason text NULL, file_broken_info VARCHAR( 255 ) NULL, file_filename varchar(255) NOT NULL default '0', file_ssname varchar(255) NOT NULL default '0', file_thumb varchar(255) NOT NULL default '0', file_views int(10) NOT NULL default '0', file_downloads int(10) NOT NULL default '0', file_submitted varchar(13) NOT NULL default '0', file_updated varchar(13) NOT NULL default '0', file_desc text NULL, file_size int(10) NOT NULL default '0', file_mime mediumint(8) NOT NULL default '0', file_ssmime mediumint(8) NOT NULL default '0', file_submitter mediumint(8) NOT NULL default '0', file_approver mediumint(8) NOT NULL default '0', file_approvedon varchar(13) NOT NULL default '0', file_topicid int(10) NOT NULL default '0', file_pendcomments smallint(4) NOT NULL default '0', file_ipaddress varchar(50) NOT NULL default '0', file_storagetype enum('web','nonweb','ftp','db') NOT NULL default 'web', file_sub_mems mediumtext NULL, file_votes text NULL, file_rating smallint(5) NOT NULL default '0', file_meta text NULL, file_new tinyint( 1 )NOT NULL default '0', file_placeholder tinyint(1) NOT NULL default '0', file_url TINYTEXT NULL, file_ssurl TINYTEXT NULL, file_realname VARCHAR( 255 ) NULL, PRIMARY KEY (file_id), KEY file_views (file_views), KEY file_downloads (file_downloads), KEY file_cat (file_cat), KEY file_submitter (file_submitter), KEY file_broken (file_broken), KEY file_open (file_open), KEY file_rating (file_rating) ) TYPE=MyISAM 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' at line 44 CREATE TABLE ibf_downloads_filestorage ( storage_id int(10) NOT NULL default '0', storage_file blob, storage_ss blob, storage_thumb blob, UNIQUE KEY storage_id (storage_id) ); Table 'ibf_downloads_filestorage' already exists CREATE TABLE ibf_downloads_fileviews ( view_id mediumint(10) NOT NULL auto_increment, view_fid int(10) NOT NULL default '0', PRIMARY KEY (view_id) ); Table 'ibf_downloads_fileviews' already exists CREATE TABLE ibf_downloads_ip2ext ( ip int(11) unsigned NOT NULL default '0', country char(2) NOT NULL default '', KEY ip (ip) ); Table 'ibf_downloads_ip2ext' already exists CREATE TABLE ibf_downloads_mime ( mime_id int(10) NOT NULL auto_increment, mime_extension varchar(18) NOT NULL default '', mime_mimetype varchar(255) NOT NULL default '', mime_file text NULL, mime_screenshot text NULL, mime_inline text NULL, mime_img text NULL, PRIMARY KEY (mime_id) ); Table 'ibf_downloads_mime' already exists CREATE TABLE ibf_downloads_mimemask ( mime_maskid int(10) NOT NULL auto_increment, mime_masktitle varchar(255) NOT NULL default '0', PRIMARY KEY (mime_maskid) ); Table 'ibf_downloads_mimemask' already exists CREATE TABLE ibf_downloads_mods ( modid mediumint(8) NOT NULL auto_increment, modtype tinyint(1) NOT NULL default '0', modgmid varchar(255) NOT NULL default '0', modcanedit tinyint(1) NOT NULL default '0', modcandel tinyint(1) NOT NULL default '0', modcanapp tinyint(1) NOT NULL default '0', modcanbrok tinyint(1) NOT NULL default '0', modcancomments tinyint(1) NOT NULL default '0', modcats mediumtext NULL, PRIMARY KEY (modid) ); Table 'ibf_downloads_mods' already exists CREATE TABLE ibf_downloads_upgrade_history ( idm_upgrade_id int(10) NOT NULL auto_increment, idm_version_id int(10) NOT NULL default '0', idm_version_human varchar(200) NOT NULL default '', idm_upgrade_date int(10) NOT NULL default '0', idm_upgrade_mid int(10) NOT NULL default '0', idm_upgrade_notes text NULL, PRIMARY KEY (idm_upgrade_id) ); Table 'ibf_downloads_upgrade_history' already exists CREATE TABLE ibf_downloads_filebackup ( b_id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , b_fileid INT( 10 ) NOT NULL DEFAULT '0', b_filetitle VARCHAR( 255 ) NOT NULL DEFAULT '0', b_filedesc TEXT NULL , b_filename VARCHAR( 255 ) NOT NULL DEFAULT '0', b_ssname VARCHAR( 255 ) NOT NULL DEFAULT '0', b_thumbname VARCHAR( 255 ) NOT NULL DEFAULT '0', b_filemime MEDIUMINT( 8 ) NOT NULL DEFAULT '0', b_ssmime MEDIUMINT( 8 ) NOT NULL DEFAULT '0', b_filemeta TEXT NULL , b_storage VARCHAR( 10 ) NOT NULL DEFAULT 'web', b_hidden TINYINT( 1 ) NOT NULL DEFAULT '0', b_backup VARCHAR( 13 ) NOT NULL DEFAULT '0', b_updated VARCHAR( 13 ) NOT NULL DEFAULT '0', b_fileurl TINYTEXT NULL , b_ssurl TINYTEXT NULL , b_filereal VARCHAR( 255 ) NOT NULL DEFAULT '0', INDEX ( b_fileid ) ); Table 'ibf_downloads_filebackup' already exists ALTER TABLE ibf_groups ADD idm_restrictions TEXT NULL; Duplicate column name 'idm_restrictions' CREATE TABLE ibf_downloads_sessions ( dsess_id VARCHAR( 32 ) NOT NULL , dsess_mid INT( 10 ) NOT NULL DEFAULT '0', dsess_ip VARCHAR( 32 ) NULL , dsess_file INT( 10 ) NOT NULL DEFAULT '0', dsess_start VARCHAR( 13 ) NOT NULL DEFAULT '0', dsess_end VARCHAR( 13 ) NOT NULL DEFAULT '0', PRIMARY KEY ( dsess_id ) , INDEX ( dsess_mid , dsess_ip ) ) ENGINE = MYISAM ; Table 'ibf_downloads_sessions' already exists I know the tables already exist as I emptied them from the SQL backup tables for these. But if I DROP the tables from my current installation database and run the installer it fails to create these tables. As for "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' at line 44" I don't know what I need to check to try and sort this out. The MySQL DB version on Hostgator (screenshot below) I'd really appreciate if someone could help with the witchcraft that which the IDM installer is throwing at me. This one is from my local installation and the IDM works fine: This one is my new installation (it doesn't work): Thank you. can ask using same database on different setups ? is that correct when mean that one local and one server based ? and server based one having problem correct
Kyle F Posted May 14, 2017 Author Posted May 14, 2017 18 minutes ago, Dean_ said: GREAT SCOTT! Quick Marty - Back to the time machine!!!! 2.3.x - What was that 2007? I wish I could be of more help Yes. 13 minutes ago, Faqole said: That seems to be a very old version. May I ask as to why are you not upgrading to the latest version? It has a lot of benefits, like a lot of new features, not to mention the security patches and the bug fixes. That being said, I do not know what you are trying to install, but looking at the errors that you posted, the tables of that script already exist in your database. You will have to remove them and give the installation another go. However, it will be better to backup them first before you delete them. Hope it helps a little. Even Doc was surprised by this one LOL I did say I know it's an old version. I do have 3.4.5 board files but I want to use 2.3.x because of my own custom skin and because the things I wanted were already used from my old clan board which this installation was backed up from. I had to install a new install though because I had a certain modification that I can't find online anymore and so it messed something up. I know the newer versions have more features and I know there's more benefits on it. But the point is, I don't like IPS4 and I like 2.3.x better. Call it a taste of good old fashion nostalgia. 10 minutes ago, Theme Tent UK said: can ask using same database on different setups ? is that correct when mean that one local and one server based ? and server based one having problem correct I did think about it but then it'd take more time. The other installation (my local one that I restored a backup) is somewhat broken. IP.Blog installed and works fine on my actual installation but IDM (Invision Download Manager) does not.
Pete T Posted May 14, 2017 Posted May 14, 2017 1 minute ago, NSanityHD said: Yes. I did say I know it's an old version. I do have 3.4.5 board files but I want to use 2.3.x because of my own custom skin and because the things I wanted were already used from my old clan board which this installation was backed up from. I had to install a new install though because I had a certain modification that I can't find online anymore and so it messed something up. I know the newer versions have more features and I know there's more benefits on it. But the point is, I don't like IPS4 and I like 2.3.x better. Call it a taste of good old fashion nostalgia. I did think about it but then it'd take more time. The other installation (my local one that I restored a backup) is somewhat broken. IP.Blog installed and works fine on my actual installation but IDM (Invision Download Manager) does not. Well i can see why like 2.3.x was good software when come out and one that enjoy working with the most, so when remove all IDM tables will not allow you install IDM again because bring new error ? i trying build a picture up what the problem is so i can help many people would say unsure or update it but i understand why like keep it 2.3.x (i would do the same but my hard drive killed my version ) so don't have any 2.3.x backups
Faqole Posted May 14, 2017 Posted May 14, 2017 7 minutes ago, NSanityHD said: I did think about it but then it'd take more time. The other installation (my local one that I restored a backup) is somewhat broken. IP.Blog installed and works fine on my actual installation but IDM (Invision Download Manager) does not. Did you check the database and remove the tables for that script? Because from the error message you posted, it appears that its tables are still in the database.
Kyle F Posted May 14, 2017 Author Posted May 14, 2017 1 minute ago, Faqole said: Did you check the database and remove the tables for that script? Because from the error message you posted, it appears that its tables are still in the database. Please read my posts carefully. I did explain that if I "DROP" the tables from the DB and run the installer, it fails to create two of the required or needed tables. The following tables fail to insert into the DB: ibf_downloads_upgrade_history ibf_downloads_files
Morrigan Posted May 14, 2017 Posted May 14, 2017 I remember STARTING on 2.3.4 I had the f-ing coolest profiles back then. I mean back when they weren't as cool as they are now. I'll be honest I don't know (other than you having stuff already) what the advantage is to you installing that specific version. For your install problem are you installing the stock version before adding in your changes/upgrades or are you uploading those stock? Most likely it's a problem with the specific modifications that you are talking about interfering with the upgrade.
Kyle F Posted May 14, 2017 Author Posted May 14, 2017 8 minutes ago, Morrigan said: I remember STARTING on 2.3.4 I had the f-ing coolest profiles back then. I mean back when they weren't as cool as they are now. I'll be honest I don't know (other than you having stuff already) what the advantage is to you installing that specific version. For your install problem are you installing the stock version before adding in your changes/upgrades or are you uploading those stock? Most likely it's a problem with the specific modifications that you are talking about interfering with the upgrade. The following mods are installed on the board at the moment which don't interfere at all with the installation of IDM. (Adriano) Secondary Groups Indicator (FSY23) Auto PM New Members (iNV23)Unoffical Warning (FSY22) Group Name Indicator (FSY22) Members Online Today [BoT] File Editor Adsense Bot System D22-Board Panel I choose this version because I can't upgrade my skin to work with 3.4 and I don't like IPS4.
Adlago Posted May 14, 2017 Posted May 14, 2017 Try installing before IDM-> Universal Mod Installer (FSY23)
Kyle F Posted May 14, 2017 Author Posted May 14, 2017 5 minutes ago, Adlago said: Try installing before IDM-> Universal Mod Installer (FSY23) I have UMI installed. UMI does not interfere with the installation of IDM. IDM isn't a third party mod, it's (was) an official IPS application.
Morrigan Posted May 15, 2017 Posted May 15, 2017 Regardless I recommend installing just the IPS products and see if it still happens. I also recommend that you not alienate those that are trying to help. You are being extremely curt and dismissive to those attempting to help you with your dilemma which makes us less inclined to provide you with such assistance (I'm referring to your comment toward @Faqole and @Theme Tent UK) Obviously there shouldn't be a problem with installing the IPS apps by default. They were working when it was released. It means that something specifically is not functioning. This is why I recommend that you install just the IPS apps, no plugins, and after you have installed them and verified that they are working then install your plugins. This could be a version of PHP or MySQL that is causing the issue which would require that things be changed in the script completely.
Kyle F Posted May 15, 2017 Author Posted May 15, 2017 36 minutes ago, Morrigan said: Regardless I recommend installing just the IPS products and see if it still happens. I also recommend that you not alienate those that are trying to help. You are being extremely curt and dismissive to those attempting to help you with your dilemma which makes us less inclined to provide you with such assistance (I'm referring to your comment toward @Faqole and @Theme Tent UK) Obviously there shouldn't be a problem with installing the IPS apps by default. They were working when it was released. It means that something specifically is not functioning. This is why I recommend that you install just the IPS apps, no plugins, and after you have installed them and verified that they are working then install your plugins. This could be a version of PHP or MySQL that is causing the issue which would require that things be changed in the script completely. I meant no disrespect and I apologise if it sounded like I was. I've tried uninstalling the mods and then attempted reinstalling IDM but I got the same errors. It's giving an error when creating the two tables mentioned and is crying about the "ENGINE TYPE". I'm unsure where I'd change the engine or SQL type for IDMs script though.
Morrigan Posted May 15, 2017 Posted May 15, 2017 This may be your issue. It's an old script so it's completely possible that this may have been a thing: https://www.devside.net/wamp-server/php-and-mysql-error-type-myisam-with-failure-to-install-php-script
Faqole Posted May 15, 2017 Posted May 15, 2017 11 hours ago, NSanityHD said: Please read my posts carefully. I did explain that if I "DROP" the tables from the DB and run the installer, it fails to create two of the required or needed tables. The following tables fail to insert into the DB: ibf_downloads_upgrade_history ibf_downloads_files You can recreate those tables manually in the database. You can take their structure from that script 's installer file. It is worth a try. With regard to the other error, the link posted by @Morrigan above should help. You can change the engine type of a table in the database as well.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.