language file problem solution (sql) 2008/04/14 13:17
Karma: 0  
There are some threads in this forum talking about the language file issues. I had encountered the same problem. The error message looks like this:
Warning: main(/www/users/china.cn/components/com_jpsubmissionary//language/) [function.main]: failed to open stream: No such device in /www/users/china.cn/administrator/components/com_jpsubmissionary/admin.jpsubmissionary.php on line 80
Finally I find that it's the problem of SQL script.
#Line 77 $query = "SELECT H_language FROM #__JoomlaProdigy_jpsubmissionary_configuration WHERE id = 0";
In some version of MySql, table name: #__JoomlaProdigy_jpsubmissionary_configuration is converted to lowercase.
so the SQL script should be : $query = "SELECT H_language FROM #__joomlaprodigy_jpsubmissionary_configuration WHERE id = 0"; Otherwise the component cannot get any data from database.
Replace all "JoomlaProdigy" to "joomlaprodigy", the problem goes away. Hope it helps..
Post edited by: singlewood, at: 2008/04/14 13:18
The administrator has disabled public write access.