Author Topic: Error in Vodes Admin - 'credit' in field list is ambiguous  (Read 13257 times)

mpausch

  • Newbie
  • *
  • Posts: 2
    • View Profile
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
« Last Edit: 11 October 2007, 16:23 by mpausch »

Saka

  • Administrator
  • Hero Member
  • *****
  • Posts: 2,500
    • View Profile
    • Sakic.Net
Re: Error in Vodes Admin - 'credit' in field list is ambiguous
« Reply #1 on: 11 October 2007, 17:01 »
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.
« Last Edit: 11 October 2007, 17:05 by Saka »

mpausch

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: Error in Vodes Admin - 'credit' in field list is ambiguous
« Reply #2 on: 11 October 2007, 18:39 »
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

  • Newbie
  • *
  • Posts: 2
    • View Profile
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
  • Hero Member
  • *****
  • Posts: 2,500
    • View Profile
    • Sakic.Net
administrator/components/com_vodes/admin.vodes.php line 70.

extension

  • Newbie
  • *
  • Posts: 2
    • View Profile
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