My Sellerdeck Account | Free Trial

Sellerdeck Community and Knowledge Base

Sellerdeck Community is now HTTPS by default. If your browser usually keeps you logged in, you may need to login again.
Go Back   Sellerdeck Community > Sellerdeck Ecommerce Software > Sellerdeck v10

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

Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 1.00 average. Display Modes
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)


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)

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 11:50 AM.

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