Mookie_Jam Posted December 20, 2006 Share Posted December 20, 2006 Hi, I tryed to install this contribution http://www.oscommerce.com/community/contri...,banner+manager But after the installation I get this proble, both in the catalog and the admin panel :( Catalog Problem 1054 - Unknown column 'banners_open_new_windows' in 'field list' select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows from banners where status = '1' and banners_group = '248x105' [TEP STOP] Admin Problem 1054 - Unknown column 'banners_open_new_windows' in 'field list' select banners_title, banners_url, banners_image, banners_group, banners_html_text, status, date_format(date_scheduled, '%d/%m/%Y') as date_scheduled, date_format(expires_date, '%d/%m/%Y') as expires_date, expires_impressions, date_status_change, banners_open_new_windows, banners_on_ssl from banners where banners_id = '2' [TEP STOP] Quote Link to comment Share on other sites More sharing options...
andri29 Posted May 10, 2007 Share Posted May 10, 2007 Hi, I tryed to install this contribution http://www.oscommerce.com/community/contri...,banner+manager But after the installation I get this proble, both in the catalog and the admin panel :( Catalog Problem 1054 - Unknown column 'banners_open_new_windows' in 'field list' select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows from banners where status = '1' and banners_group = '248x105' [TEP STOP] Admin Problem 1054 - Unknown column 'banners_open_new_windows' in 'field list' select banners_title, banners_url, banners_image, banners_group, banners_html_text, status, date_format(date_scheduled, '%d/%m/%Y') as date_scheduled, date_format(expires_date, '%d/%m/%Y') as expires_date, expires_impressions, date_status_change, banners_open_new_windows, banners_on_ssl from banners where banners_id = '2' [TEP STOP] I have same problem.Any HELP ??? Thx Quote Link to comment Share on other sites More sharing options...
kustomjs Posted September 13, 2007 Share Posted September 13, 2007 I get the same problem but how do I add it into my sql database? Quote Link to comment Share on other sites More sharing options...
quick Posted May 5, 2008 Share Posted May 5, 2008 Hi, I tryed to install this contribution http://www.oscommerce.com/community/contri...,banner+manager But after the installation I get this proble, both in the catalog and the admin panel :( Catalog Problem 1054 - Unknown column 'banners_open_new_windows' in 'field list' select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows from banners where status = '1' and banners_group = '248x105' [TEP STOP] Admin Problem 1054 - Unknown column 'banners_open_new_windows' in 'field list' select banners_title, banners_url, banners_image, banners_group, banners_html_text, status, date_format(date_scheduled, '%d/%m/%Y') as date_scheduled, date_format(expires_date, '%d/%m/%Y') as expires_date, expires_impressions, date_status_change, banners_open_new_windows, banners_on_ssl from banners where banners_id = '2' [TEP STOP] Unbelievedable, two years later, I have the same problem, I am doing the search about two hours, can not get solution, anybody happend to know how can i work it out? Thanks very much! Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted May 5, 2008 Share Posted May 5, 2008 Shame your search hasn't found any of the probably 10+ times I've posted this, but enjoy anyway. This assumes there is a step in the installation that say "run this sql ..." 1) Go to your ISPs admin area for your site. 2) Click on the icon for Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk. 3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box. 4) Click on "SQL" on the navigation bar. 5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts. 6) For both methods click "Go".. 7) If all goes well, your SQL query will run successfully For another explanation see:- http://www.oscommerce.com/forums/index.php?sho...dmin+mysql+code Or for a contribution to allow you to run SQL Script from Admin http://www.oscommerce.com/community/contributions,4567 Cheers! Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
quick Posted May 6, 2008 Share Posted May 6, 2008 Shame your search hasn't found any of the probably 10+ times I've posted this, but enjoy anyway. This assumes there is a step in the installation that say "run this sql ..." 1) Go to your ISPs admin area for your site. 2) Click on the icon for Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk. 3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box. 4) Click on "SQL" on the navigation bar. 5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts. 6) For both methods click "Go".. 7) If all goes well, your SQL query will run successfully For another explanation see:- http://www.oscommerce.com/forums/index.php?sho...dmin+mysql+code Or for a contribution to allow you to run SQL Script from Admin http://www.oscommerce.com/community/contributions,4567 Cheers! :blush: :blush: :blush: Thanks Geo, I am shame to my knowledage too. I even ignore the the step : Add the following fields to the banners table: Field: banners_open_new_windows tinyint(1) Default 1 Field: banners_on_ssl tinyint(1) Default 1 I don't quite understand this query, because the others allways supply ***.sql, I leaned a lot. I will try. Thank you very much! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.