Quote Originally Posted by snowy2007 View Post
Cheers Andrew - I have another problem if anyone can shed any light :

In the Admin/Customers/Reward Points screen I have the following two problems :

1. When I click on a letter (sorted by Last Name) it shows me 1 screen full of names but not all the names IE: If I select the letter P then the last name on the list is "Penfold" but I have lots more customers whose last name starts with P such as Pickton etc... They are not on there. SCRAP THIS ONE - I have just realised I can change the number displayed in Admin from the default of 50

2. I have set up a test customer and earned some points. When I try to click on the edit function for that customer whose surname is "Phenton" (to manually add points etc...) and I find them by entering "Phenton" in the search box I get the following error :

1064 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 '%phenton%' OR c.customers_firstname LIKE '%phenton%' OR c.customers_id LIKE '%' at line 1
You got the first one The second one was sorted in v1.25- so if you have v1.26 (the alpha release) this is covered.