My SellerDeck Account | Newsletter | Free Trial

Community and Knowledge Base

Go Back   SellerDeck Community > SellerDeck Ecommerce Software > SellerDeck v10

Search powered by Google
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 1.00 average. Display Modes
  #1  
Old 01-Mar-2012, 10:18 PM
bambeebumble bambeebumble is offline
Registered User
Join Date: Mar 2012
Full Name: David Jones
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
Smile Buffer Overun Error when uploading Search: Solution

The Error:

A Buffer Overun error is displayed when uploading due to the Full Product Descriptions being ticked in the search options & some of those full descriptions are containing more than 2048 characters which causes an error on upload & blocks full descriptions in the search results.

Our Solution

Follow these instructions to create a Query in Access to find all "rogue" long product descriptions. It will tell you which products have more than 2048 characters. You can then adjust them accordingly and get your full descriptions back into the search results-

1. Open Access and open Actiniccatalog.mdb
2. Click 'Queries' on the left and click 'New query'
3. Click 'Design view' and click OK
4. Top left there is a square dropdown box- choose the 'SQL' option
5. Put exactly the line below into the text entry screen, replacing anything already there (note the different types of brackets - very important)

SELECT * FROM [PRODUCT] WHERE LEN([FULL DESCRIPTION]) >2048

6. Click the exclamation mark in the toolbar to run the query


Hope this helps some people with the same Buffer Overun problem.
Reply With Quote
The Following User Says Thank You to bambeebumble For This Useful Post:
Krithika (02-Mar-2012)
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 03:31 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.