[SOLVED] Sql builder & quick search bugs 9.8.002

Scriptcase 9 Bugs
#1

Using version 9.8.002 (9)
I find a bug setting a simple condition on a grid (adding a ‘where’ statement)
I checked my syntax by trying the sql builder and this ‘add on tool’ fails with the same bug on any condition you try to set, on any table.
There is also a bug when using ‘quick search’ on a grid.
Works fine with advanced search or dynamic search, but a quick search produces a similar error as the one below.

Fatal error: Uncaught Error: Call to undefined function get_magic_quotes_gpc() in
C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\compat\base.php:216 Stack trace: #0 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\compat\nm_isql.php(566): nm_escape_string(‘BS8’) #1
C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\compat\nm_isql.php(2): sg_load(‘68ABBE04C7C5024…’) #2 {main} thrown in
C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\compat\base.php on line 216

#2

Hello @Steve_Culley

Can you tell me which data bank you are using?

Also, it would be interesting for you to show us an example of the statement created by sql.

Regards

#3

Hi thank you for your reply - Mysql
This is a sql statement from previous version of script case
SELECT
tbl_aa-members.SerId,
tbl_aa-members.PrintSort,
tbl_aa-members.PcSort,
tbl_aa-members.Name,
tbl_aa-members.RotaName,
tbl_aa-members.Surname,
tbl_aa-members.PrefOfficeContact,
tbl_aa-members.HomeNumber,
tbl_aa-members.MobileNumber,
tbl_aa-members.PrefHomeContact,
tbl_aa-members.InterGroupService,
tbl_aa-members.Group Service,
tbl_aa-members.AreaCode,
tbl_aa-members.Email,
tbl_aa-members.AaEmail,
tbl_aa-members.Transport,
tbl_aa-members.Gender,
tbl_aa-members.SobrietyDate,
tbl_aa-members.ServiceRotation,
tbl_aa-members.UpdateRecord,
tbl_aa-membersinfo.InfoId,
tbl_aa-membersinfo.SerId,
tbl_aa-membersinfo.GpId,
tbl_aa-membersinfo.IgId,
tbl_aa-membersinfo.Cid,
tbl_aa-membersinfo.Uid,
tbl_aa-membersinfo.Group,
tbl_aa-membersinfo.PcSort,
tbl_aa-membersinfo.HrGroup,
tbl_aa-membersinfo.HrNotes,
tbl_aa-membersinfo.WsoNotes,
tbl_aa-membersinfo.PrimaryGroup,
tbl_aa-membersinfo.GroupRep,
tbl_aa-membersinfo.12Steppers,
tbl_aa-membersinfo.YoungPerson,
tbl_aa-membersinfo.TelephoneTrainee,
tbl_aa-membersinfo.TelephoneResponder,
tbl_aa-membersinfo.Asts,
tbl_aa-membersinfo.Region,
tbl_aa-membersinfo.InterGroup,
tbl_aa-membersinfo.CrisisOrganiser,
tbl_aa-membersinfo.Health,
tbl_aa-membersinfo.Pi,
tbl_aa-membersinfo.Hostels,
tbl_aa-membersinfo.ArmedForces,
tbl_aa-membersinfo.Empolyment,
tbl_aa-membersinfo.Prisons,
tbl_aa-membersinfo.WhereToFind,
tbl_aa-membersinfo.ActivePhoneDuty,
tbl_aa-membersinfo.Home,
tbl_aa-membersinfo.Office,
tbl_aa-membersinfo.WkEndsH,
tbl_aa-membersinfo.WkEndsO,
tbl_aa-membersinfo.DayH,
tbl_aa-membersinfo.DayO,
tbl_aa-membersinfo.AftH,
tbl_aa-membersinfo.AftO,
tbl_aa-membersinfo.EveO,
tbl_aa-membersinfo.NightH,
tbl_aa-membersinfo.FlexiList,
tbl_aa-membersinfo.Paneller,
tbl_aa-membersinfo.Sponsor,
tbl_aa-membersinfo.All,
tbl_aa-membersinfo.North,
tbl_aa-membersinfo.South,
tbl_aa-membersinfo.East,
tbl_aa-membersinfo.West,
tbl_aa-membersinfo.Central,
tbl_aa-membersinfo.Bristol,
tbl_aa-membersinfo.Somerset,
tbl_aa-membersinfo.Any,
tbl_aa-membersinfo.Day,
tbl_aa-membersinfo.Eve,
tbl_aa-membersinfo.WkEnd,
tbl_aa-membersinfo.ServicePost,
tbl_aa-membersinfo.Availability,
tbl_aa-membersinfo.AreaCovered,
tbl_aa-membersinfo.TimesAvailable,
tbl_aa-membersinfo.InfoUpdate,
tbl_aa-membersinfo.AreasCovered,
tbl_meetings.ID,
tbl_meetings.Region,
tbl_meetings.InterGroup,
tbl_meetings.MeetingName,
tbl_meetings.ShortName,
tbl_meetings.GsrLogOn,
tbl_meetings.Admin,
tbl_meetings.ZoomCode,
tbl_meetings.Format,
tbl_meetings.Live,
tbl_meetings.ZoomLink,
tbl_meetings.Time,
tbl_meetings.MeetingType,
tbl_meetings.Day,
tbl_meetings.Town,
tbl_meetings.Address,
tbl_meetings.PcSort,
tbl_meetings.PostCode,
tbl_meetings.AreaName,
tbl_meetings.AreaCode,
tbl_meetings.Comments,
tbl_meetings.GsrName,
tbl_meetings.GsrContact,
tbl_meetings.GsrEmail,
tbl_meetings.ContactOne,
tbl_meetings.ContactTwo,
tbl_meetings.Registration,
tbl_meetings.Latitude,
tbl_meetings.Longditude,
tbl_meetings.DayNumber,
tbl_meetings.FullDetails,
tbl_meetings.Picture,
tbl_meetings.WhereToFindUpdate,
tbl_meetings.GroupTwelfthStepUpdate,
tbl_meetings.NameTick,
tbl_meetings.Password,
tbl_meetings.Email,
tbl_meetings.DayTick,
tbl_meetings.DisabledFacilities,
tbl_meetings.AddressTick,
tbl_meetings.PostTick,
tbl_meetings.ComTick,
tbl_meetings.ContactOneTick,
tbl_meetings.Contact2Tick,
tbl_meetings.ContactThreeTick,
tbl_meetings.ContactTwoTick
FROM
tbl_aa-members INNER JOIN tbl_aa-membersinfo ON tbl_aa-members.SerId = tbl_aa-membersinfo.SerId
INNER JOIN tbl_meetings ON tbl_aa-membersinfo.GpId = tbl_meetings.ID
WHERE
(tbl_meetings.Admin = ‘No’)

If I try to replicate this with 9.8.002 I get the error, the other functions on the builder ie ‘sort by’ work but as soonas I try a ‘where’ condition it crashes.

#4

Dear, @Steve_Culley

The fix is ​​available in release 9.8.003. Version available for download or update.

1 Like
#5

Thank you for the fix - all ok now :grinning:

1 Like