Register A-Z im admin-customer

[jan64]

Hi,

 

I have this great contri tryed to install but i get an error and i have no idea what to do.

When i will go to a customer are all the fields blanc adn i get this message at the top of my page.

 

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 'limit 0, 12' at line 1

 

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id, c.customers_private_messages from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by limit 0, 12

 

Can someone tell me what this means? i am not really an SQL expert :blush:

 

Thanks!

 

Regards,

Jan

[FIMBLE]

which contribution is it?

Nic

[♥geoffreywalton]

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id, c.customers_private_messages from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by limit 0, 12

 

Try changing it to something like

 

order by c.customers_lastname limit 0, 12

[jan64]

which contribution is it?

Nic

 

Register A-Z im admin-customer:

http://www.oscommerce.com/community/contri...+admin-customer

[jan64]

Try changing it to something like

 

order by c.customers_lastname limit 0, 12

 

Hi thanks for your help, i'll try it out.

[jan64]

Hi thanks for your help, i'll try it out.

 

I have really no idea where i must change this.

These lines: select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id, c.customers_private_messages from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by limit 0, 12 are not a peace of code. :blink:

I can't find "limit" in customers.php