lisense
Read the full previous answer on the forum, as I editted a bit.
Hi Paul and I'm sorry for the troubles. I mentioned you should read the included FAQ, the answer was there, read below: Excerpt from Plus FAQ.txt: 22Q. I'm getting all kind of strange mysql errors, especially: MySQL error: 1366 (Incorrect integer value: '' for column 'latin1' at row 1) Session halted. 22A. Sounds like you are running MySQL 5.0 with SQL strict mode enabled. To disable strict mode open your my.cnf (or my.ini) in an editor and remove/comment out the following line: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"...
Hi and I'm sorry for the troubles. I mentioned you should read the included FAQ, the answer was there, read below: Excerpt from Plus FAQ.txt: 22Q. I'm getting all kind of strange mysql errors, especially: MySQL error: 1366 (Incorrect integer value: '' for column 'latin1' at row 1) Session halted. 22A. Sounds like you are running MySQL 5.0 with SQL strict mode enabled. To disable strict mode open your my.cnf (or my.ini) in an editor and remove/comment out the following line: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"...
Hi Paul and I'm sorry for the troubles. I mentioned you should read the included FAQ, the answer was there, read below: Excerpt from Plus FAQ.txt: 22Q. I'm getting all kind of strange mysql errors, especially: MySQL error: 1366 (Incorrect integer value: '' for column 'latin1' at row 1) Session halted. 22A. Sounds like you are running MySQL 5.0 with SQL strict mode enabled. To disable strict mode open your my.cnf (or my.ini) in an editor and remove/comment out the following line: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"...
Click on the username and you will see a big blue button that says Send Message No pm buttons anywhere in sourceforge that I could find.
No pm buttons anywhere in sourceforge that I could find. Click on the username and you will see a big blue button that says Send Message
Sorry Ciprian, for using the reply form but you said you wanted me to pm you and that was the only way I could find to do that. No pm buttons anywhere in sourceforge that I could find. As for the installation after manually inserting data into the users_reg table I was able to get the chat page to show but couldn't login or register without errors. I could also get into the admin area but there was limited things I could do and sometimes when I clicked on a link nothing happened. I've decided to...
You're running MySQL 5 (5.7 as you told me). In the install/manual/installation/database/ are two zips, for older mysql versions, but not sure it will help with your error. For now, just put '0' instead of null in those 3 "insert" lines: INSERT INTO c_reg_users VALUES ('0', instead of INSERT INTO c_reg_users VALUES ('', Then read the Q&A in docs/plus_docs/Plus FAQ.txt, there might be an answer for your case. PS: I cannot use the reply form on this support forum from my phone, that's why I would have...
Okay solved that error by changing lines 179 & 260 to current date and time but now I am trying to solve the next error: INSERT INTO c_reg_users VALUES ('', '1', 'admin', '0', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '', '', '', 0, 1, '', '', 'https://sourceforge.net/projects/phpmychat', 'http://ciprianmp.com/plus', '', 'red', 'images/avatars/def_avatar.gif', '0', '', '', '', '', '', '', '', '', '', '', '') MySQL said: Documentation 1366 - Incorrect integer value: '' for...
Okay tried that and got this: CREATE TABLE c_config ( ID tinyint(1) NOT NULL default '0', MSG_DEL tinyint(1) NOT NULL default '96', USR_DEL tinyint(1) NOT NULL default '10', REG_DEL tinyint(1) NOT NULL default '0', LANGUAGE varchar(40) NOT NULL default 'english', MULTI_LANG enum('0','1') NOT NULL default '1', REQUIRE_REGISTER enum('0','1') NOT NULL default '0', REQUIRE_NAMES enum('0','1') NOT NULL default '0', EMAIL_PASWD enum('0','1') NOT NULL default '0', PASS_LENGTH tinyint(1) NOT NULL default...
Okay tried that and got this: CREATE TABLE c_config ( ID tinyint(1) NOT NULL default '0', MSG_DEL tinyint(1) NOT NULL default '96', USR_DEL tinyint(1) NOT NULL default '10', REG_DEL tinyint(1) NOT NULL default '0', LANGUAGE varchar(40) NOT NULL default 'english', MULTI_LANG enum('0','1') NOT NULL default '1', REQUIRE_REGISTER enum('0','1') NOT NULL default '0', REQUIRE_NAMES enum('0','1') NOT NULL default '0', EMAIL_PASWD enum('0','1') NOT NULL default '0', PASS_LENGTH tinyint(1) NOT NULL default...
Yes, the other user just had the same issue and fixed it together .Go to phpmyadmin and select those 6 existing tables in the chat db and drop them. Then go to install/manual installation/databases/mysql_new_install.txt, open, copy content, go back to phmyadmin and paste it in the SQL windows (second top menu link. That should load all the tables. There is no need to load the chat in the root, it should be in it's own subfolder, under the root (under public_html).
I deleted everything and started over this time installing inside a directory named chat. ie: root/chat/ The reason I can't install inside root is because there is a wordpress installation there for the original website for which I want this chat to work with. I proceeded to follow the prompts in the install script windows and got all the way to the end where I clicked the login to admin link and got this error again: Database error: Invalid SQL: SELECT password,perms,email FROM c_reg_users WHERE...
also, can I get a link to your chat folder to have a look? Send pm if you don't want to publish it here.
Hi, Two levels down might be too much and some relative paths within the files might be wrong (../ not ../../). If your main chat folder contains just phpmychat, then you should put your plus folder content directly in that chat folder (index.php to be one level down from chat root). Easiest, just upload the plus folder directly in the root of your site, and run from there. If it works, rename "plus" to "chat" or whatever you like it to be called. If still unsuccessful, let's try a teamviewer. C...
Hi Ciprian, I have deleted everything and started over with a new install on a different domain but on the same server. I unzipped the plus1.98 zip into a chat directory which is two levels down from the root ie: root/dating/chat/. I was able to run the install with no errors however when I tried to view the chat I got a 404 error. I checked and the install/install.php file was removed but I decided to remove the whole install folder in case but got the same results. What am I missing?
Thanks lesmond for the response. Yes, i replaced the db name, user and password with the ones in my db. They correspond. Am i missing something else?
The settings in the config/config.lib.php file were not set right to correspond with my database settings make sure these 3 lines are the same has your database name/user and password replace cpanelname_chatdb, cpanelname_chatuser and chatuser_password with the ones in the database. // Database settings define("C_DB_NAME", 'cpanelname_chatdb'); // Logical database name on that server (most common like: cpanelusername_databasename) define("C_DB_USER", 'cpanelname_chatuser'); // Database username (most...
The settings in the config/config.lib.php file were not set right to correspond with my database settings make sure these 3 lines are the same has your database name/user and password // Database settings define("C_DB_NAME", 'cpanelname_chatdb'); // Logical database name on that server (most common like: cpanelusername_databasename) define("C_DB_USER", 'cpanelname_chatuser'); // Database username (most common like: cpanelusername_username) define("C_DB_PASS", 'chatuser_password'); // Database user's...
I am unable to install too. Tried a manual install but still gives a blank page. Changed the htaccess file too but the same thing. Lesmond, please what setting did you change in your config file?
All fixed, it seems I had the wrong setting in the config file, many thanks to Ciprian for stepping in to fix it for me
All fixed, it seems I had the wrong setting in the config file, many thanks to Ciprian for stepping in to fix it for me
All fixed, it seems I had the wrong setting in the config file, many thanks to Ciprian for stepping in to fix it for me :)
Tried that, even removed them, still nothing. One thing I have noticed the site is saying not secure, even though I know it is. We are friends on FB (Les) you can dm me there if you wish.
Might be the .htaccess file causing this. Rename that file (in the plus folder) and test again. If needed, contact me privately and we can go for a TeamViewer session together. Ciprian
Might be the .htaccess file causing this. rename that file (in the plus folder) and test again. If needed, contact me privately and we can go for a TeamViewer session together. Ciprian
I went ahead and tried a manual install, but still have the same problem with a blank page For info I run php7.3 on my server
I went ahead and tried a manual install, but still have the same problem with a blank page For info I run php7.3 on my server
I went ahead and tried a manual install, but still have the same problem with a blank page For info I run php7.3 on my server
I have tried several times to install the chat with no success, when I click next it goes to a blank page as shown in the image ... I have filled in the details here .. I did create a mysql database on my server. anyone have an idea what I have done wrong?
I am sorry for your troubles. There seemed to be a problem with not finding the database datingac_chatroom (or the table names could've been different). If it suits you, we can try a TeamViewer session so I can attempt to do it for you remotely. V/R, Ciprian
I am sorry for your troubles. There seemed to be a problem with not finding the databse datingac_chatroom (or the table names could've been different). If it suits you, we can try a TeamViewer session so I can attempt to do it for you remotely. V/R, Ciprian
Tried to install the chat 4 times now and still no go. The closest I came was a successful install and then not being able to access the admin. Got this error message: Database error: Invalid SQL: SELECT password,perms,email FROM c_reg_users WHERE username='ChatManager' LIMIT 1 MySQLi error: 1146 (Table 'datingac_chatroom.c_reg_users' doesn't exist) Session halted. Tried to drop all tables in database and paste manual install database from msql_new_install.txt but got an sql error which I forgot...
1.98 - fixed some reported cross-scripting holes
1.98 - fixed a beeping issue in users_popup
1.98 - fixed a bug that caused Safari users to be kicked off the rooms
1.98 - more german/localized.chat.php corrections
1.98 - fixed the birthday empty field error in latest MySQL db (Fixes readme.txt updated)
1.98 - fixed the birthday empty field error in latest MySQL db
1.98 - typo fix german/localized.chat.php
Hello, I am currently attempting to install phpMyChat on my website. However, the installation process is a bit unclear when it comes to databases, and I'm not sure what I should do. I am sort of a noob with this sort of stuff, help would be greatly appreciated. I would like to know what I must set as the database name, username, and password, and if there is any additional setup required after that. I have already completed the automatic setup. If there is anything extra I must do, please let me...
1.98 - added php 7.4.0 compatibility
1.97 - fix the configuration tab error (install date field mysql error).
Hi Rehan, It seems it's related to your DNS settings (may be something wrong in your file etc/hosts): https://stackoverflow.com/questions/6275535/php-error-php-network-getaddresses-getaddrinfo-failed-while-getting-informat
It installed successfully but when I try to access it I get this error: Error: Could Not Connect: " php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution http://www.chatga.ga/chat/ However if you access the main site it works fine. chatga.ga
1.97 - adding extrainfo to mods
1.97 - fixes for X-Origin cross-domain (fixes youtube/video posting and fb like button)
1.97 - fixes for X-Origin cross-domain (fixes youtube/video posting and fb like button)
Honestly, I don't know what could be wrong. Try the manual installation mode, it's safer. Instructions provided in the install/manual installation folder.
1.97 - improved bot tables and function getthat(), incl. installer
1.97 - fix admin/config update check
1.97 - installer utf8mb4 update fix
1.97 - pdo utf8mb4 fix
1.97 - first release
1.97-beta1 - fix admin/config when on https
Hi, I'm sorry you encounter issues. Can I please have a link to your chat so I can investigate and replicate the error?
1.97-beta1 - Archive pages now hide any error_log saved in the logs folders
1.96 error 404
1.97-beta1 - current version updated
1.97-beta1 - converted db to utf8mb4 and added full emoji support
1.97-beta1 - fix admin/config when on https
1.97-beta1 - fix in users list + geoIP update 05.12
I have a Problem on Setup page 4. Following message: "Could not open "config/config.lib.php" for writing!" It's Chmod to 666 and on Page 3 It's all green "The file "config/config.lib.php" is writeable. Please fill out this form and the values will be stored directly in the file." What happens?
1.97-beta1 - small code fixes for admin panel
1.97-beta1 - fixed a permission error on saving logs
1.97-beta1 - fixed a forgotten while each loop
1.97-beta1 - first release (brings php 7.2 compatibility)
1.96 - owner.php spelling correction in comments
1.96 - geoip6 db updated to October 2018
In your Admin panel/Configuration menu, under Bot settings, you have a link.
run the botloader<<< where's the botloader?
1.96 - geoip db updated to April 2018
1.96 - geoip updated
1.96 - geoip updated
1.96 - Date.format calendar plugin updated
1.96 - geoip updated
Hi Claire and sorry for the late response. I have seen this behaviour on another server just recently. I am still trying to figure out which setting of your MySQL server is causing this - I suppose it's a "stict_mode" enabled issue, but I want to go deeper into how to overcome this. If you wanna help me hunt down this bug/error, would you be so kind to send me a private email with a link to your chat, at ciprianmp at yahoo dot com? Thank you! Ciprian
I have just installed rev 1.96 of phpmychat-plus on a Fedora 26 system. After about 30 minutes of activity on the site, I suddenly got the error: Database error: Invalid SQL: SELECT type FROM c_messages WHERE room = 'Open Chat Room' ORDER BY m_time DESC LIMIT 1 MySQL error: () Session halted. I deleted the install and database, did it over again, started a chat session and got the same error after just a few posts. Using phpMyAdmin I can give the error causing select command and, other than being...
1.96 - fixed the blank page that was throwing warnings + dutch statistics traslation
1.96 - curr_version file included for manual installations
1.96 - 2 forgotten files to be pushed to svn
Happy New Year Erich! Indeed, it is hard to reverse the coding as of current version to accomplish what you're looking for, but I am putting this on my to do list for the next version, which I am working on already. Make sure you subscribe to our newsletter and keep an eye on my next code pushes. All the best!
Happy New Year Erich Indeed, it is hard to reverse the coding as of current version to accomplish what you're looking for, but I ampputting this on my to do list for the next version, which I am working on already. Make sure you subscribe to our newsletter and keep an eye on my next code pushes. All the best
I want to really dumb down login and eliminate registration. I don't want emails, secret questions, profile information or even passwords - nothing. Just for people to type in a username and chat. I understand I'd be completely unprotected from bot harassment or dealing with offensive users. This is fine. So preferably my main page would have 2 fields: Username: "Joe Blow" Room: "default" And a button that says "CHAT" Would this be easy to accomplish without getting into too much database stuff?...
1.96 - log format but fix again (%%) (table header was missing)
1.96 - geoip updated