[ronald]

Ritesh wrote on Nov 10 2005, 11:33 AM:

Bug confirmed. Will be fixed in v5.01.

[post=”7874″]<{POST_SNAPBACK}>[/post]

Sweet — I'm still forced to use 4.0 BETA 5, which doesn't have this bug, nor this bug: http://www.webyog.com/forums/index.php?showtopic=1532

If you could hook a brother up with a fix for both of these in 5.01 I'd gladly finally register!

[ronald]

Ritesh wrote on Jul 8 2005, 04:29 PM:

I will look into it tomorrow. Maybe we will implement it in v4.1.

[post=”6365″]<{POST_SNAPBACK}>[/post]

sad to see its not fixed in 5.0 🙁 All that would need to be done is for the table data to show up in text when the “Show Results In Text” option is specified.

[ronald]

Ritesh wrote on Jul 13 2005, 01:47 PM:

Thanks for the info.

I have forwarded it to my development team and they are working on it.

BTW, which version of MS SQL Server are you using?

Cool, thanks for looking into it —

I am using Sql Server Developer Edition 8.00.194

[ronald]

Ritesh wrote on Jul 13 2005, 08:27 AM:

We have been working on your issue. We can successfully import tables having 100 columns and 1000 rows. While working on it we came across this issue at http://bugs.mysql.com/bug.php?id=10035 that looks similar to yours.

Though in our case, SJA displayed the error and the application exited gracefully.

Can you tell us the table structure with a rough idea of what kind of data it contains?

The number of rows doesn't seem to matter — it can be reproduced with the one-row case below. The client machine is a Pentium 4 3.4ghz with 512 megs of ram. The server is running mysql 4.1.10a.

I had a look at that MySQL bug report, and apparently it is an InnoDB-only bug. So, I tried choosing “MyISAM” as the table type in the Import Wizard's “Target Table Type”, and got the same crash.

Interestingly, if I choose only the first 62 fields of the following table to be imported, I get the Buffer Overflow error message. If I choose 63 or more, no error message pops up, but Sqlyog hangs indefinately on “Importing table data: Company2…”

Here is the sql to create and populate the table in sql server:

CREATE TABLE [dbo].[Company2] (

[ID] [int] IDENTITY (1, 1) NOT NULL ,

[NAFILL] [int] NULL ,

[TicklerID] [int] NULL ,

[MenuID] [int] NULL ,

[MinimumLunch] [int] NULL ,

[MinimumDinner] [int] NULL ,

[ExtraRestaurantFee] [int] NULL ,

[Tip] [int] NULL ,

[TipThreshold] [int] NULL ,

[FreeDeliveryThreshold] [int] NULL ,

[CashSurcharge] [int] NULL ,

[CheckSurcharge] [int] NULL ,

[CardSurcharge] [int] NULL ,

[HouseSurcharge] [int] NULL ,

[ICVerifyCompany] [int] NULL ,

[CandidateAddressID] [int] NULL ,

[Authorization1] [int] NULL ,

[Authorization2] [int] NULL ,

[CheckAuthorizationType] [int] NULL ,

[CardAuthorization] [int] NULL ,

[SalesTaxOnDeliveryFee] [int] NULL ,

[SalesTaxOnCompanyTip] [int] NULL ,

[SalesTaxOnMiscFee] [int] NULL ,

[Active] [int] NULL ,

[PrintAllOrders] [int] NULL ,

[OnLine] [int] NULL ,

[CardRequired] [int] NULL ,

[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[OrderMessage] [varchar] (750) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[RestaurantMessage] [varchar] (750) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[AccountMessage] [varchar] (750) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ZoneMessage] [varchar] (750) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Phone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CandidateDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CandidatePhone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[AcceptedCards] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[StateCodeDefault] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CandidateAddress1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CandidateAddress2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CandidateAddress3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Address1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Address2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Address3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[UseMembership] [int] NULL ,

[MemberDiscount] [int] NULL ,

[MemberLimit] [int] NULL ,

[MemberFreeDelivery] [int] NULL ,

[Overhead] [int] NULL ,

[FreezeConvFee] [int] NULL ,

[ShowCommissionRate] [int] NULL ,

[QB_Restaurants] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[QB_Checking] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[QB_DueRestaurant] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[QB_SalesTax] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[QB_RestaurantCharges] [varchar] (750) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[QB_FoodCosts] [varchar] (750) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[QB_CompanyFile] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[QB_Days_Restaurant] [int] NULL ,

[QB_Integrate_Restaurant] [int] NULL ,

[DelFee_Minimum] [int] NULL ,

[DelFee_Maximum] [int] NULL ,

[DelFee_Percent] [int] NULL ,

[UserList1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[UserList2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[UserList3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[UserList4] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[UserList5] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[UserList6] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[MinimumDinnerList] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[MinimumLunchList] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[MinimumTipList] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[MinimumMessageList] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[MinimumTitleList] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[UserListRequired] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[BusinessListRequired] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[LunchBegins] [datetime] NULL ,

[DinnerBegins] [datetime] NULL ,

[Text_DeliveryFee] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Text_ConvFee] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Text_DriverTip] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[RestrictHouseOnCheckOut] [int] NULL ,

[RequireApprovalToCheckOut] [int] NULL ,

[CateringMenu] [int] NULL ,

[CateringFee] [int] NULL ,

[RequireEmail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[PayDriversByDelivery] [int] NULL ,

[ReimburseDrivers] [int] NULL ,

[TemplateID] [int] NULL ,

[TipImpoundCategoryID] [int] NULL ,

[AccountingPhone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[MaxInternetLevel] [int] NULL ,

[AllowAdjustmentChangeDate] [int] NULL ,

[AuthorizeExtra] [int] NULL ,

[MailingListOptOut] [int] NULL ,

[Reservations_Use] [int] NULL ,

[Reservations_AutoCancel] [int] NULL ,

[Website] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[EmailAddress] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[TipCalculation] [int] NULL ,

[DefaultHouseRestriction] [int] NULL ,

[WebAuthMerchant] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ReturnDriversToRestaurant] [int] NULL ,

[TodayNotAdvanced] [int] NULL ,

[UseRestaurantTaxRates] [int] NULL ,

[UseZoneTaxRates] [int] NULL ,

[UseCustomerTipRate] [int] NULL ,

[WelcomeMessage] [int] NULL ,

[UseClassification] [int] NULL ,

[NoMultipleOrders] [int] NULL ,

[NegativeBalanceAdjustmentID] [int] NULL ,

[RestaurantBillAdjustmentID] [int] NULL ,

[SettlementPeriodEnds] [int] NULL ,

[CustomCateringOnWeb] [int] NULL ,

[AuthValue] [int] NULL ,

[WEB_ShowUtensils] [int] NULL ,

[UseRadios] [int] NULL ,

[Nextel_PickupTime] [int] NULL ,

[Nextel_DeliveryTime] [int] NULL ,

[AllowCheck_Individual] [int] NULL ,

[AllowCheck_Business] [int] NULL ,

[AllowCheck_Hotel] [int] NULL ,

[ConvFeeCalc] [int] NULL ,

[AboutUsID] [int] NULL ,

[ContactUsID] [int] NULL ,

[AllowCourier] [int] NULL ,

[CanadaTax] [int] NULL ,

[PayCCToRestaurant] [int] NULL ,

[CAAMediaAccountNumber] [int] NULL ,

[SalesTaxOnOperatorTip] [int] NULL ,

[Message_21_ID] [int] NULL ,

[Message_21_AutoSend] [int] NULL ,

[Message_22_ID] [int] NULL ,

[Message_22_AutoSend] [int] NULL ,

[Message_23_ID] [int] NULL ,

[Message_23_AutoSend] [int] NULL ,

[Message_24_ID] [int] NULL ,

[Message_24_AutoSend] [int] NULL ,

[Message_25_ID] [int] NULL ,

[Message_25_AutoSend] [int] NULL ,

[HoursOfOperation] [varchar] (112) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[HideRestaurantAddress] [int] NULL ,

[Template_Print_Auto] [int] NULL ,

[Template_Print_Manual] [int] NULL ,

[Template_Fax_Restaurant] [int] NULL ,

[Template_Fax_Customer] [int] NULL ,

[Template_Email] [int] NULL ,

[Template_View] [int] NULL ,

[Internet_ShowAllRestaurants] [int] NULL ,

[UsePostalCodes] [int] NULL ,

[Internet_ForceStreetMap] [int] NULL ,

[ClosedForVacation] [int] NULL ,

[Authorization3] [int] NULL ,

[InternalWebsite] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Template_TakeOut] [int] NULL ,

[RequireTaxIDNumber] [int] NULL ,

[Group_Minutes] [int] NULL ,

[Integration_ReadySetFood_Account] [int] NULL ,

[Integration_IamCity_Account] [int] NULL ,

[ShowFullCCNumber] [int] NULL ,

[StripLeading] [int] NULL ,

[StripTrailing] [int] NULL ,

[RestrictAuthLength] [int] NULL ,

[MerchantType] [int] NULL ,

[UpdateETA] [int] NULL

) ON [PRIMARY]

GO

INSERT INTO dbo.Company2

(NAFILL,TicklerID,MenuID,MinimumLunch,MinimumDinner,ExtraRestaurantFee,Tip,TipTh

eshold,FreeDeliveryThreshold,CashSurcharge,CheckSurcharge,CardSurcharge,HouseSur

harge,ICVerifyCompany,CandidateAddressID,Authorization1,Authorization2,CheckAuth

rizationType,CardAuthorization,SalesTaxOnDeliveryFee,SalesTaxOnCompanyTip,SalesT

xOnMiscFee,Active,PrintAllOrders,OnLine,CardRequired,Description,OrderMessage,Re

taurantMessage,AccountMessage,ZoneMessage,Phone,CandidateDescription,CandidatePh

ne,AcceptedCards,StateCodeDefault,CandidateAddress1,CandidateAddress2,CandidateA

dress3,Address1,Address2,Address3,UseMembership,MemberDiscount,MemberLimit,Membe

FreeDelivery,Overhead,FreezeConvFee,ShowCommissionRate,QB_Restaurants,QB_Checkin

,QB_DueRestaurant,QB_SalesTax,QB_RestaurantCharges,QB_FoodCosts,QB_CompanyFile,Q

_Days_Restaurant,QB_Integrate_Restaurant,DelFee_Minimum,DelFee_Maximum,DelFee_Pe

cent,UserList1,UserList2,UserList3,UserList4,UserList5,UserList6,MinimumDinnerLi

t,MinimumLunchList,MinimumTipList,MinimumMessageList,MinimumTitleList,UserListRe

uired,BusinessListRequired,LunchBegins,DinnerBegins,Text_DeliveryFee,Text_ConvFe

,Text_DriverTip,RestrictHouseOnCheckOut,RequireApprovalToCheckOut,CateringMenu,C

teringFee,RequireEmail,PayDriversByDelivery,ReimburseDrivers,TemplateID,TipImpou

dCategoryID,AccountingPhone,MaxInternetLevel,AllowAdjustmentChangeDate,Authorize

xtra,MailingListOptOut,Reservations_Use,Reservations_AutoCancel,Website,EmailAdd

ess,TipCalculation,DefaultHouseRestriction,WebAuthMerchant,ReturnDriversToRestau

ant,TodayNotAdvanced,UseRestaurantTaxRates,UseZoneTaxRates,UseCustomerTipRate,We

comeMessage,UseClassification,NoMultipleOrders,NegativeBalanceAdjustmentID,Resta

rantBillAdjustmentID,SettlementPeriodEnds,CustomCateringOnWeb,AuthValue,WEB_Show

tensils,UseRadios,Nextel_PickupTime,Nextel_DeliveryTime,AllowCheck_Individual,Al

owCheck_Business,AllowCheck_Hotel,ConvFeeCalc,AboutUsID,ContactUsID,AllowCourier

CanadaTax,PayCCToRestaurant,CAAMediaAccountNumber,SalesTaxOnOperatorTip,Message_

1_ID,Message_21_AutoSend,Message_22_ID,Message_22_AutoSend,Message_23_ID,Message

23_AutoSend,Message_24_ID,Message_24_AutoSend,Message_25_ID,Message_25_AutoSend,

oursOfOperation,HideRestaurantAddress,Template_Print_Auto,Template_Print_Manual,

emplate_Fax_Restaurant,Template_Fax_Customer,Template_Email,Template_View,Intern

t_ShowAllRestaurants,UsePostalCodes,Internet_ForceStreetMap,ClosedForVacation,Au

horization3,InternalWebsite,Template_TakeOut,RequireTaxIDNumber,Group_Minutes,In

egration_ReadySetFood_Account,Integration_IamCity_Account,ShowFullCCNumber,Strip

eading,StripTrailing,RestrictAuthLength,MerchantType,UpdateETA)

VALUES (NULL,NULL,1,NULL,NULL,450,NULL,5000,50000,0,0,0,20000,0,NULL,273728576,20144716

,0,-1,0,0,0,-1,0,-1,-1,'Sample Company','We appreciate your patronage, and all feedback you provide to help us improve our services to you! ***Delivery Rewards … Every 10 points receive One Free Delivery !! ***','Thank You from The Staff at Our Company','We appreciate your patronage and all feedback you provide to help us improve our services to you!','','(555) 555-5555','','','NYYYNN','0','','','','555 Main Street','Suite A','Yourtown US 55555',0,495,0,NULL,400000,0,0,'-1','Commerce Bank','','','','','',NULL,NULL,0,0,0,'','','','','','','','','','','0006800007710006690003800006810003140000000000000','NNNNNNNNNY','NNNNNNNNNN','1899-12-30 11:00:00','1899-12-30 14:30:00','','','',0,0,0,1995,'YNYNN',0,0,2,1,'2013212345',1,-1,0,-1,0,20,'www.samplecompany.com','[email protected]',1,1,'',0,0,-1,0,0,1,0,0,2,2,6,0,NULL,0,1,-1,-1,2,2,-1,0,23,NULL,0,0,0,0,0,1,-1,2,-1,3,-1,4,-1,5,-1,'1100110011001100110000000000143014301430143014300000000016301630163016301630

63016002100210021002100211521151945',0,2,2,2,3,3,2,-1,0,NULL,NULL,167912345,'www.samplecompany.com',NULL,0,90,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL)

GO

[ronald]

peterlaursen wrote on Jul 8 2005, 04:01 PM:

Quote:

Not for me, this is a bug.

Show results in text only has effect on result-tab not data-tab!

I disagre with you! Nothing should be changed back here! it's a major improvement!

Data-tab always show ALL data in table, result-tab the result of laset SELECT-query.

You could do a “select * from …” , choose “show result in text” and it works from resultpane as you want.

But I would not mind an option like “show table data in text” – though I would probably never use it myself.

Wrong, data tab will only show all data up to the row limit specified in SQLyog's preferences. How is it an improvement to have “Insert/Update Data For The Table” and “View Data” do the EXACT SAME THING? Why not just delete the “View Data” option entirely if it doesnt serve any different purpose than “Insert/Update Data For The Table”? A user like you who wants the grid, and wants to be able to delete or update the data, should choose “Insert/Update Data For The Table”. In previous versions, if you chose “View Data”, and had text mode enabled, the table rows would be displayed as text. Now something is broken, and choosing “View Data” while in text mode has the exact same effect as choosing “Insert/Update Data For The Table”.

I dont know about you, but over the span of a week id have to be typing “select *” thousands of times! On another slower machine I have 4.0 BETA 5, which behaved correctly, I wish I had the install file for that version.

[ronald]

peterlaursen wrote on Jul 8 2005, 03:09 PM:

from menu: edit .. show results in text .. works here.

You did not simply overlook that option ??

But the option is not saved to .ini-file when closing SQLyog.

The grid view is implemented to make it possible to delete or update data from RESULT.

The new DATA and RESULT-pane as of 4.0 is a major improvement in my opinion!

So, it works if you do “edit .. show results in text”, and then right-click a table and choose “View Data”? Not for me, this is a bug. You will notice, now right-clicking and choosing “Insert/Update Data For The Table” and choosing “View Data” does the EXACT SAME THING, even with the text option specified. in previous versios, you'd only get the grid with “Insert/Update Data For The Table”

[Author]

Posts