Hello all...hope we are well...
I am helping a friend with his site and we have chosen ezPortal for all our needs but ran into a problem when installing it via the Admin panel. He is running SMF 1.1.7 with roughly 10+ mods so I feel like this may be the cause but wanted to see what a solution may be...here is the error message we receive...
Column 'column_width' specified twice
File: /home/www/creativegarden.us/smf/Packages/temp/EzPortalInstall.php
Line: 198
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.
here are the contents of the EzPortalInstall.php file that make ref to 'column_width':
// Layout Columns
db_query("CREATE TABLE IF NOT EXISTS {$db_prefix}ezp_columns(
id_column int(11) NOT NULL auto_increment,
column_title tinytext,
can_collapse tinyint(1) default 0,
active tinyint(1) default 0,
column_width int(5),
column_percent int(5) default 0,
column_order int(11),
visibileactions text,
visibileboards text,
visibileareascustom text,
PRIMARY KEY (id_column)) TYPE=MyISAM $UTFData", __FILE__, __LINE__);
column_width, column_order,column_width)
VALUES ('Left', 1,1,'150',1,15)", __FILE__, __LINE__);
db_query("INSERT INTO {$db_prefix}ezp_columns
(column_title, can_collapse, active, column_width, column_order,column_width)
VALUES ('Center', 1,1,'600',2,70)", __FILE__, __LINE__);
db_query("INSERT INTO {$db_prefix}ezp_columns
(column_title, can_collapse, active, column_width, column_order,column_width)
VALUES ('Right', 1,1,'150',3,15)", __FILE__, __LINE__);
}
I dont know if that will help but wanted to post it up neways...i download it direct from this site and have tried to install it a number of times with the same results....any help would be greatly appreciated
thanks
:EDIT:
I JUST RESOLVED MY OWN ISSUE...HERE IS WHAT I HAD TO DO...
The culprit is the custom_width value was entered twice as the error message states here is what it should be:
PRIMARY KEY (id_column)) TYPE=MyISAM $UTFData", __FILE__, __LINE__);
column_width, column_order,column_width *REMOVE)
VALUES ('Left', 1,1,'150',1,15*REMOVE)", __FILE__, __LINE__);
db_query("INSERT INTO {$db_prefix}ezp_columns
(column_title, can_collapse, active, column_width, column_order,column_width*REMOVE)
VALUES ('Center', 1,1,'600',2,70*REMOVE)", __FILE__, __LINE__);
db_query("INSERT INTO {$db_prefix}ezp_columns
(column_title, can_collapse, active, column_width, column_order,column_width*REMOVE)
VALUES ('Right', 1,1,'150',3,15*REMOVE)", __FILE__, __LINE__);
Extract the .zip file to anywhere on your pc, just remember where so you can locate it. Next edit the EzPortalInstall.php file making the changes as described above. The save. Once done create a new .zip file including the newly edited .php. Then upload to your server and Apply the mod and you are done!!! Hope this helps somone.....
thanks guys for making the portal...looking to get my hands wet now lol