Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] Banner Manager


Mookie_Jam

Recommended Posts

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]

Link to comment
Share on other sites

  • 4 months later...
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

Link to comment
Share on other sites

  • 4 months later...
  • 7 months later...
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!

Link to comment
Share on other sites

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!

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

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!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...