Yanc Subscribers Table error

Discuss the development and implementation of Joomla! components here.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
hits_p84
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Tue Jul 15, 2008 11:05 am

Yanc Subscribers Table error

Post by hits_p84 » Thu Jul 31, 2008 3:41 pm

Hi,

I need the help with the yanc newsletter component, I have installed it, configured it and got most of it working, i can subscribe to a news letter, confirm the email link and i even get a message sayin that it has been successfull, but the subscribers information is not present in the manage subscribers table, above the table i get this error:

Column \'uid\' in field list is ambiguous SQL=SELECT s.*, l.name AS letter, IF(uid > 0, u.name, s.name) AS name, IF(uid > 0, u.email, s.email) AS email FROM jos_yanc_subscribers s\n LEFT JOIN jos_yanc_letters l ON s.lid = l.id \n LEFT JOIN jos_users u ON s.uid = u.id ORDER BY IF(uid > 0, u.name, s.name) ASC LIMIT 0, 30

Any ideas how i can fix this?

Any help will be great, if i can get this table to populate then iv got the component working successfully,

other components i am using are: CB 1.1, JACL plus, AEC subscriptions.

Locked

Return to “Components”