Error in Vodes Admin - 'credit' in field list is ambiguous

[mpausch]

Thanks for the great module. It insalled without error but in Joomla admin, in any of the Vodes admin features, I get an error at the top of the page. The error is...
DB function failed with error number 1052
Column 'credit' in field list is ambiguous SQL=SELECT c.id AS id, userid, name, username, credit FROM jos_vode_credits AS c LEFT JOIN jos_users AS u ON c.userid=u.id ORDER BY c.userid LIMIT 0, 30

Any help would be greatly appreciated.

I'm running Joomla 1.0.13
PHP 5.2.1
Joomla! Register Globals Emulation:  OFF   
Register Globals:  OFF   
Magic Quotes:  ON   
Safe Mode:  OFF 
Apache/1.3.37 (Unix)
MySQL   5.0.37 

Thank you Thank you Thank you Thank you Thank you

[Saka]

You must have installed some component that tampered with core Jooma database tables.

You can fix it by finding this query in Vodes component and adding "c.credit" instead of just "credit".

Or just install Vodes on fresh Joomla installation.

[mpausch]

Emir,

Thank you Thank you Thank you Thank you Thank you Thank you


That worked perfectly!!!

I love this component!

thanks for the help!

[extension]

Hi admin,
I got the same problem, after moving to another server and making some changes. Could you point me out (so it's a little bit clearer for me) in which file and where to make the changes.

Best regards
Boris
Denmark

[Saka]

administrator/components/com_vodes/admin.vodes.php line 70.

[extension]

Hi,

The advice helped partly.
1. The "free Vodes" i have set in a script snippet, shows up in Vodes balance module.
2. Credits menu now shows up in Admin, but no Vodes are added (Vodes are only added to the table)
Regards
Boris