Skip to content
JoomlaProdigy Forum
Welcome, Guest
Please Login or Register.
Lost Password?
language file problem solution (sql) (1 viewing)
_GEN_GOTOBOTTOM Post Reply

TOPIC: language file problem solution (sql)

#2963
singlewood (User)
Fresh Boarder
Posts: 1
graphgraph
Click here to see the profile of this user
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.
_GEN_GOTOTOP Post Reply
© Copyright 2007 Best of Joomla, Powered by FireBoardget the latest posts directly to your desktop

Buy Now

Recommended

Search

Recommended

Joomla Templates

Member Login

Refreshing page..Please wait!
                       Lost Password?    Can't Login?