HI
I have noted that usermames which have an apostrophe ' such as Mr O' Mordha are causing an error message below after user clicks to view a list page
Error type 256
Error description You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Mordha'' at line 1
URL germanshepherdpups.ie/gsddb1/_litters_list.php?
Error file /home/cormac/public_html/gsddb1/include/dbconnection.php
Error line 26
SQL query select litternumber, breedername, breederemail, pupsdob, sire, siredamreg, issirehipsc, isdamhipsc, siredna, damdna, issireedscreened, isdamedscreened, issirehaemoclear, hassireaworkinqqual, hasdamaworkingqual, dam, sireconformgrade, damconformgrade, siretitle, damtitle, breedertel, breedertel2, sirecoatcolours, damcoatcolours, numberofmalepups, numberoffemalepups, willsirebeavailabletosee, willdambeavailabletosee, howmanlittersdamtodate, isthisrepeatmating, timeofdaytophone, whatisearliestdateforrelease, arepupskcreged, arepupsmicrochip, arepupstattoo, willpupsbefullyorpartialvac, willadepositbereq, ificancelisdepositrefund, isapartnershiparrangement, areanyavailonbreedterms, willtherebeacontract, ifpupdefectcanigetrefund, helpmetrainmypup, helpmewithshowingpup, isbmemberofaclub, isbreedershower, isworkingclub, breederotherbreed, littersinlastyear, providereferences, dateposted, county, logedip, webadvurl, `Prices From Per Pup`, puppicid FROM `_litters`
Solution This is a general error. It occurs when thereis an error in event code or in SQL.
Send your SQL or event code along with full error message to support team.