phpfreechat current version is 1.2
On the joomla backend for utChat on the configuration display I get the warning
Invalid argument supplied for foreach() in
... /administrator/components/com_utchat/admin.utchat.html.php on line 182
On the front end I get this error
Invalid argument supplied for foreach() in
... /components/com_utchat/utchat.php on line 26
phpFreeChat cannot be initialized, please correct these errors:
* 'serverid' parameter is mandatory by default use 'md5(__FILE__)' value
My first guess is that the pfc bundled with the component does use mysql container, the table should be created in the joomla db, and something didn't get created or possibly needs to be seeded ... (?)
Looks like my first guess is right:
JDatabaseMySQL::query: 1146 - Table 'database_name.jos_utchat' doesn't exist SQL=SELECT * FROM jos_utchat
Solution:
I got into phpMyAdmin for my joomla! database, and ran
SELECT VERSION( ) ;
to determine I am running mysql version 4.0.27-max-log
After editing line 17 in /com_utchat_1.0/install.utchat.php to read
- Code: Select all
) ENGINE=MyISAM CHARSET=utf8;
and replacing all instances of "#_utchat" with "jos_utchat"
the sql file was able to create the jos_utchat table (using phpMyAdmin)
Seems between upon whatever mysql version utChat was developed, and version 4.0.27 there is a syntax option unavailable to earlier versions (line 17 edit) and the install failed silently.
So now I'm stuck about where Problem loading... by wenfi
describes, but it feels so great to have caught up!
I guess we're on our own now: