PS: I have now noticed that apparently no tables have been created in the database. In the installation instructions it says:
D. Click on the Dashboard link to make sure the plugin is activated
– “Dashboard link” simply means /wp-admin/index.php in the backend? Or anywhere else?
Hi,
I wish I got auto notified somehow of forum posts. I don’t troll often and it pains me you were waiting. So sorry about that.
I’m here now:)
Check the bp-chat/config directory. It should have 2 files in it. If it doesn’t then chmod them 777 and then click on the dashboard link when logged in as admin to populate them.
Another possibility, but odd one is you have a funny named database. One with a dollar sign in it perhaps? If so just let me know.
Thanks,
Dave
Hi,
I think it could have been the $ issue so I just uploaded a new patch for this. Please let me know if you have any issues.
Thanks,
Dave
Hi Dave,
Thank you for your reply and no problem about waiting. I’m glad you’re here.
I made now a complete re-installation with version 1.3.4. and opened the Dashboard. Permissions are 777, bp-chat-config.php and bp-chat-config-style.php are visible. Error messages still return.
The database name has a “-” in it, otherwise all standard.
I have noticed that the installation has not created any tables in MySQL. Hope that’s OK.
thanks
Christoph
Hi,
Any way I can get in there and see what’s up so I could fix it?
Did it make the bp-chat/config files? Did it make the right choices inside for the db, user, password stuff?
Hi Dave,
I managed now to get it running but it is not entirely clear to me why.
As for your questions:
- It’s not my private installation so I’m unfortunately not eligible to give permissions.
- The config files are there and the information is correct.
1. The reason for the tables not being installed was a problem here where the entry bp-chat-db-version in the database still remained from earlier attempts. So when I uninstalled and reinstalled the plugin, it apparently did not create the tables (which I have dropped or renamed with prefix, I don’t remember) as it should since the version corresponded to the last update and the routine wrongly assumed that all is correctly in place.
2. The function bp_chat_install() in bp-chat.php does not seem to use $bp_chat_config_db_table_prefix. That’s not a problem on my installation, but it might be if you mix two installations into one database (e.g. if your provider offers only one database and you have to use one for all of your software – these things happen with extremely low budget 😉 )
3. Now for the solution: I read about problems with “-” in database names. So I put the value in bp-chat-config.php for $bp_chat_config_db in backticks. As a result most of the error messages disappeared, only one about an alleged permission problem appeared.
After some hours of searching I discovered that the error is triggered in AJAXChatMySQLiDataBase.php (line 40) by select_db. Here I inserted again my database name without backticks: …->select_db(“my-database-name-with-dash”)
Don’t ask me why, but it is working now. It appears to need backticks everywhere, only not, however, for select_db.
Maybe it would be interesting to see how the other WP and BP code is handling that problem with dashes without resorting to backticks. I never ran there into similar problems.
BTW my provider requests for some strange reason that database names be chosen with a dash. So maybe there is more people with a similar problem.
Hope this information is helpful for similar cases. Thanks again!
I have the same problem, too! I done 1-2 from camthor’s direction. I now i get this massage:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/CustomAJAXChat.php on line 216
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/CustomAJAXChat.php on line 240
Error-Report: Access denied for user ‘dbuxxxxxx’@’localhost’ to database ‘dbxxxxxx`aranea’ Error-Code: 1044
Without this changes, I mean after a new installation I got this massage:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/CustomAJAXChat.php on line 216
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/CustomAJAXChat.php on line 240
Warning: Cannot modify header information – headers already sent by (output started at /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/CustomAJAXChat.php:216) in /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/AJAXChatHTTPHeader.php on line 36
Warning: Cannot modify header information – headers already sent by (output started at /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/CustomAJAXChat.php:216) in /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/AJAXChatHTTPHeader.php on line 37
Warning: Cannot modify header information – headers already sent by (output started at /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/CustomAJAXChat.php:216) in /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/AJAXChatHTTPHeader.php on line 41
You’re currently logged out.
Notice: Only variable references should be returned by reference in /is/htdocs/wp10588615_5KO8HE3A5V/www/wp-content/plugins/buddypress-ajax-chat/bp-chat/chat/lib/class/CustomAJAXChat.php on line 193
Can u help me?
Did you chmod 777 bp-chat/config?
