weird erroe upon creating new artist

pej
pej
Offline
0
Hi, i get the following error when i try to add a new artist:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pejy87/public_html/playmgmt/libraries/joomla/database/database/mysql.php on line 344

what seems to be the problem?
Responses (9)
  • Accepted Answer

    Tuesday, March 02 2010, 03:32 PM - #Permalink
    0
    mm... well... just that you should disable the Warnings, actually. :lol:

    this is not an "error" that makes the application crash: just a warning. nothing too serious.
    to disable error reporting, fo to your joomla backend->global config->server->error reporting->none
    The reply is currently minimized Show
  • Accepted Answer

    pej
    pej
    Offline
    Tuesday, March 02 2010, 05:13 PM - #Permalink
    0
    Fatal error: Call to undefined method TableArtist::getErrorMsg() in /home/pejy87/public_html/playmgmt/administrator/components/com_muscol/models/artist.php on line 93

    this is the error i get when i try to create a new artist.

    please help me with this, my client is anxiously waiting.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, March 02 2010, 05:18 PM - #Permalink
    0
    this error means that something on the artist database table creation went wrong

    first suggestion: UNINSTALL Music COllection, and, most important, MANUALLY DELETE the msuic collection database tables (those beginning by jos_muscol_). then reinstall again and see if it works.

    if it still dont works, then send me joomla admin access AND ftp access AND phpmyadmin access and I'll try to find out what's wrong.

    but TRY THE FIRST SUGGESTION FIRST.

    Germi
    The reply is currently minimized Show
  • Accepted Answer

    pej
    pej
    Offline
    Tuesday, March 02 2010, 05:42 PM - #Permalink
    0
    thanks! the problem was solved. But there is still an issue when i use the recently added artist module on the home page:

    http://ahuradesign.com/playmgmt/

    if you click alexa Divine, it brings you to a error page.

    500 - Layout "" not found

    can you give me your email? i will send you the administrator info
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, March 02 2010, 05:45 PM - #Permalink
    0
    thats not a problem: you havent SAVED your parameters yet. you need to go to the paramters on the backend, and click SAVE at least once.

    you havent done this yet..

    man, this is number 1 on installation instructions!!!!! ;)
    The reply is currently minimized Show
  • Accepted Answer

    pej
    pej
    Offline
    Tuesday, March 02 2010, 05:46 PM - #Permalink
    0
    actually i did, but i forgot to do it when i reinstalled the component.

    Thanks a bunch!
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, March 02 2010, 05:47 PM - #Permalink
    0
    no prob ;)
    The reply is currently minimized Show
  • Accepted Answer

    Martin
    Martin
    Offline
    Thursday, June 17 2010, 09:10 AM - #Permalink
    0
    Hello,

    have the same problem.
    where do i find the

    msuic collection database tables (those beginning by jos_muscol_) ?

    Thank you
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, June 17 2010, 03:03 PM - #Permalink
    0
    well you need access to the database for that... :S do you have access? (phpMyAdmin for instance)
    The reply is currently minimized Show
Your Reply