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

16 years 5 months ago - 16 years 5 months ago #1493 by 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

Please Log in or Create an account to join the conversation.

16 years 5 months ago - 16 years 5 months ago #1495 by 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.

Emir Sakic
www.sakic.net

Please Log in or Create an account to join the conversation.

16 years 5 months ago #1497 by 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!

Please Log in or Create an account to join the conversation.

15 years 10 months ago #2720 by 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

Please Log in or Create an account to join the conversation.

15 years 10 months ago #2721 by Saka
administrator/components/com_vodes/admin.vodes.php line 70.

Emir Sakic
www.sakic.net

Please Log in or Create an account to join the conversation.

15 years 10 months ago #2722 by 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

Please Log in or Create an account to join the conversation.

About us

We provide high quality Joomla components created by a co-founder and original core developer of Joomla. For over a decade, our products have been used by more than 20.000 webmasters around the world.

Stay in touch