Close

Profile: ylechasseur

Avatar

User posts

SQL Search
9 years ago

Hi Guys,

Each time I do a search into my stores, I is rare that I have the right result, either from the mail page search or the advance search.
My SQL text seach is setup as :  CONTAINS and  or with prefix_term. If I want to search in liveforsailing site the product foot block  I will get almost everthing else except that. I am wondering if I shoud twaek the full text search into the SQL server. Before doing something wrong, I prefer asking and you guys,always have the right answers
. I know it is more an american Holiday, but Happy thanks giving.

Want to let you know.. your applications and themes works fantastic .. very very stable ..it is helping so much ,,,so much stuff to worry about ..

9 years ago

Hi Guys,

The problem was the cache. In the all parameters section, look for loadallurlrecordsonstartup is a true by default and has to be changed for False. After it is working well...

Nice new themes and widgets by the way ..

have a nice day

yves

9 years ago

Thanks a lot, I'll give a try and keep you posted. I really appreciate your help...

have a nice day

Yves

9 years ago

Hi Guys,

I have a small problem with the product insertion. I did an interface to manage the products imported. In this interface, I add product specification, product pictures, text.... When I am saving, the pictures is added, mapped to the product_picture mapping, move to the FTP site and so on. When I look at the product on the web site, it is there, but when I click on it.. nothing happen. When I use the Quick Look, then no problem but then from this window, if I click on Go to Product Description, again nothing happen. I realized that I had to update the URLRecord table with the required information, but then, If I do it manually to test, I have an Error. If I open the product from the admin console and save it, then I found the entree into the able URLRecord in double and often with the same information as I did prior. I probably missing an insert in an other table, but I didn't find where.

Any idea what I could missed ?

Also, the Motion theme is great and very easy to work with as is.. very happy with my purchase...as usual with you guys.

Have a nice day

Yves
www.liveforsailing.com

10 years ago

Hi ... it was to easy .. I never look in this section.. good to know..

I was wondering so much how you did !!

For the logo over the slider, I will try again to make it nice ..

if I am not able to do it,, I will certainly need your help..

Thanks a lot ..again :-)

Yves

10 years ago

Hi again ...

One more question, on the front page slider, I rather integrated my logo on my slider image than have it over it.

If I remove the logo in the front page in the code, does it will appear on all the other pages ?

I almost done.. simple tweaking and some minor adjustment ..

thanks for all

yves

10 years ago

One more question ....

When I import a picture for a category, it reduce the picture size as a thumb. When I put the category as featured, the picture size is to small.. I am trying to find out where to put the right parameters and I didn't find it yet..

I am sure you have a pretty good idea about it :-)

Have a nice day

yves

AjaxFilters
10 years ago

God, I am rusty ... works like a charm..

sorry guys

Thanks a lot

Yves

AjaxFilters
10 years ago

Hi Guys,

I am in the middle of the migration and It is going very well. In fact, I like it so much, that I will not do any color change or customization at all. Again, as usual, a great work.

I upgraded the DB from 3.00 to 3.10 and then 3.20. I didn't have any conversion error message, but I have the feeling I miss something.

I have a bizarre problem with the ajax filter. If I am trying to apply a filter, I have this error message in all pages (including manufacturer's page). Do you think it could be a conversion problem ?

Best regards

Yves

Procedure or function ProductLoadAllPagegNopAjaxFilters has too many arguments specified.  
The details for the log entry.Full message:  System.Data.SqlClient.SqlException (0x80131904): Procedure or function ProductLoadAllPagegNopAjaxFilters has too many arguments specified. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at Nop.Data.NopObjectContext.ExecuteStoredProcedureList[TEntity](String commandText, Object[] parameters) at SevenSpikes.Nop.Plugins.AjaxFilters.Services.ProductServiceNopAjaxFilters.(IList`1 , SpecificationFilterModelDTO , AttributeFilterModelDTO , ManufacturerFilterModelDTO , VendorFilterModelDTO , Int32 , Int32 , Int32  , Int32  , Int32  , Nullable`1  , Nullable`1  , Nullable`1  , Int32  , String  , Boolean  , Boolean  , Int32  , ProductSortingEnum  , Boolean  ) at SevenSpikes.Nop.Plugins.AjaxFilters.Services.ProductServiceNopAjaxFilters.SearchProducts(IList`1 categoryIds, SpecificationFilterModelDTO specifiationFilterModelDTO, AttributeFilterModelDTO attributeFilterModelDTO, ManufacturerFilterModelDTO manufacturerFilterModelDTO, VendorFilterModelDTO vendorFilterModelDTO, Int32 pageIndex, Int32 pageSize, Int32 manufacturerId, Int32 vendorId, Int32 storeId, Nullable`1 featuredProducts, Nullable`1 priceMin, Nullable`1 priceMax, Int32 productTagId, String keywords, Boolean searchDescriptions, Boolean searchProductTags, Int32 languageId, ProductSortingEnum orderBy, Boolean showHidden) at SevenSpikes.Nop.Plugins.AjaxFilters.Controllers.Catalog7SpikesController.() at SevenSpikes.Nop.Plugins.AjaxFilters.Controllers.Catalog7SpikesController.(Int32 , Int32 , Int32 , PriceRangeFilterModel7Spikes , SpecificationFilterModel7Spikes , AttributeFilterModel7Spikes , ManufacturerFilterModel7Spikes , VendorFilterModel7Spikes  , CatalogPagingFilteringModel  , String  , Boolean  , String&  ) at SevenSpikes.Nop.Plugins.AjaxFilters.Controllers.Catalog7SpikesController.GetFilteredProducts(Int32 categoryId, Int32 manufacturerId, Int32 vendorId,

10 years ago

Hi Guys,

I have been for the week-end under several attack from Asia. With a name like usnautic, I can understand. I should name the web site libianautic !!. So, I re-image the server yesterday and change the Ip address, Fix my Cloud Flare settings and it seems to be ok. Also, the problems began when I tried to install a new web site (classifieds) done in Framework 3.5. I had to install a lot of features in IIS and I think I screw up somewhere or maybe because the yellow man was to aggressive.. who knows !!

In fact, no widget was working at all. Also, I find in the even logs about 3 logins tentative per second from China on the SA account..
So I found a script to block all asia, Russia and middle east country in Windows Firewall. I already block them with CloudFlare, but they seems to find a way true ..
http://www.sans.org/windows-security/2011/10/25/windows-firewall-script-block-addresses-network-ranges

by
Yves