Error on table sugarcrm.songs_cstm

[Tavares]

Hello.
After installing the songs module its appearing the following error:

"Retrieving record by id songs: found Query Failed:SELECT songs.* , songs_cstm.* FROM songs LEFT JOIN songs_cstm ON songs.id = songs_cstm.id_c WHERE songs.id = '' LIMIT 0,1::MySQL error 1146: Table 'sugarcrm.songs_cstm' doesn't exist"

The installation of the module returned no errors, only when i remove it returns the following errors and warnings:

ERROR: rmdir_recursive(): argument cache/upload/upgrades/module/Songs_Example_Module-4.0.1-restore is not a file or a dir.
Warning: unlink(cache/dynamic_fields//Users/fields.php): Permission denied in /var/www/html/crm/include/dir_inc.php on line 73

Warning: rmdir(cache/dynamic_fields//Users): Directory not empty in /var/www/html/crm/include/dir_inc.php on line 90

Warning: rmdir(cache/dynamic_fields/): Directory not empty in /var/www/html/crm/include/dir_inc.php on line 90

Module Uninstall Successful

How can i fix this?Do i have to create the table myself, and wich fields should i create with it?

[Tavares]

Does anybody knows why this appens??
Its a module made to work...and it isn't working correctly!!

I would apreciatte some help!

Tanks!

[pblag]

Hi Tavares!

In your situation it is possible that you have some problems with files permission.
You have to chmod all files to 777 and uninstall module again. After that install this module if you still have this problem you can create new table with id_c field but i am not sure that it will help you.

Regards,
Petro Blagodir
pblag@blagodir.com
http://www.blagodir.com

[Tavares]

Hello!
I had to create both tables manualy...and the problem seems like its solved!Now i have another problem when saving to the database...it says that i have an MySql error when inserting, butt it don't says wich file should i correct it...so i was wondering if anybody nows where to see the SQL statement when inserting into the database.

Tanks!

[pblag]

Hi Tavares!

i think that for checking sql query you have to try file
data/SugarBean.php

Regards,
Petro Blagodir
pblag@blagodir.com
Blagodir Software