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 to write down. I have since deleted all files/folders from server and dropped tables from database until I can find the time to try again.
Any ideas on why the original error message came up?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
Last edit: Ciprian Murariu 2020-08-19
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
Ciprian.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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 username='findinga_chatro' LIMIT 1
MySQLi error: 1146 (Table 'findinga_chatroom.c_reg_users' doesn't exist)
Session halted.
I went into phpmyadmin and there is only 6 databases showing there:
bot_bot
bot_bots
bot_conversationlog
bot_dstore
bot_gmcache
The other tables that were mentioned during the install like c_reg_users isn't there. Somehow the installation script isn't installing all the tables correctly. Is there a sql querie that I can use to add them?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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 '6',
ADMIN_NOTIFY enum('0','1') NOT NULL default '1',
ADMIN_NAME varchar(35) NOT NULL default 'Your name/chat name here',
ADMIN_EMAIL varchar(35) NOT NULL default 'Your email address here',
CHAT_URL varchar(100) NOT NULL default 'Your server/chat URL here',
SHOW_ADMIN enum('0','1') NOT NULL default '1',
SHOW_DEL_PROF enum('0','1') NOT NULL default '1',
VERSION enum('0','1','2') NOT NULL default '2',
BANISH tinyint(1) NOT NULL default '1',
NO_SWEAR enum('0','1') NOT NULL default '0', [...]
MySQL said:
#1067 - Invalid default value for 'INSTALL_DATE'
What is causing this?
Now I have 11 tables but cannot get past this.
bot_bot
bot_bots
bot_conversationlog
bot_dstore
bot_gmcache
bot_gossip
bot_patterns
bot_templates
bot_thatindex
bot_thatstack
c_ban_users
Last edit: Sportsman Fishing Adventures 2020-08-26
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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 preffered to contact me by email and then we could have posted here the solution after hunting it down, for other users.
Let me know how it goes.
Ciprian
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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 try another open source chat script as I don't have the time right now to troubleshoot your script to get it to work.
Unfortunate as I had used your script successfully about 7-10 years ago on the same server with no problems.
In any case, I will try it again sometime in the future when I have more time and it is for myself not a customer. Thanks for all your support and for trying to help me with this. Much appreciated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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"
Then restart the database server.
About the pm, Les Pole is right, sourceforge does include the pm feature by clicking on any user profile. But I thought I also gave you my private email, when I asked you to send me your chat url to start debugging (I might be wrong, as you were 3 guys asking for help in the last 3-4 days, on the similar issues). Anyway, it's ciprianmp@yahoo.com.
LE: we did talk to each other 2 days ago by pm, that's how I know your name is Paul :).
"Hi Ciprian, just updated my post but it is waiting for moderation. I got the "install date" errror fixed but cannot seem to get the c_reg_users table to install in the database. Just wondering if phpmychat is compatible with msql 5.7?
Paul"
This pm I didn't reply because you also posted in the forum, so I used my laptop to reply (the post I had to approve).
Best regards,
Ciprian
Last edit: Ciprian Murariu 2020-08-27
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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 to write down. I have since deleted all files/folders from server and dropped tables from database until I can find the time to try again.
Any ideas on why the original error message came up?
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
Last edit: Ciprian Murariu 2020-08-19
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?
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.
Ciprian.
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.
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 username='findinga_chatro' LIMIT 1
MySQLi error: 1146 (Table 'findinga_chatroom.c_reg_users' doesn't exist)
Session halted.
I went into phpmyadmin and there is only 6 databases showing there:
bot_bot
bot_bots
bot_conversationlog
bot_dstore
bot_gmcache
The other tables that were mentioned during the install like c_reg_users isn't there. Somehow the installation script isn't installing all the tables correctly. Is there a sql querie that I can use to add them?
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).
Okay tried that and got this:
MySQL said:
#1067 - Invalid default value for 'INSTALL_DATE'
What is causing this?
Now I have 11 tables but cannot get past this.
bot_bot
bot_bots
bot_conversationlog
bot_dstore
bot_gmcache
bot_gossip
bot_patterns
bot_templates
bot_thatindex
bot_thatstack
c_ban_users
Last edit: Sportsman Fishing Adventures 2020-08-26
Okay solved that error by changing lines 179 & 260 to current date and time but now I am trying to solve the next error:
MySQL said: Documentation
1366 - Incorrect integer value: '' for column 'id' at row 1
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 preffered to contact me by email and then we could have posted here the solution after hunting it down, for other users.
Let me know how it goes.
Ciprian
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 try another open source chat script as I don't have the time right now to troubleshoot your script to get it to work.
Unfortunate as I had used your script successfully about 7-10 years ago on the same server with no problems.
In any case, I will try it again sometime in the future when I have more time and it is for myself not a customer. Thanks for all your support and for trying to help me with this. Much appreciated.
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"
Then restart the database server.
About the pm, Les Pole is right, sourceforge does include the pm feature by clicking on any user profile. But I thought I also gave you my private email, when I asked you to send me your chat url to start debugging (I might be wrong, as you were 3 guys asking for help in the last 3-4 days, on the similar issues). Anyway, it's ciprianmp@yahoo.com.
LE: we did talk to each other 2 days ago by pm, that's how I know your name is Paul :).
"Hi Ciprian, just updated my post but it is waiting for moderation. I got the "install date" errror fixed but cannot seem to get the c_reg_users table to install in the database. Just wondering if phpmychat is compatible with msql 5.7?
Paul"
This pm I didn't reply because you also posted in the forum, so I used my laptop to reply (the post I had to approve).
Best regards,
Ciprian
Last edit: Ciprian Murariu 2020-08-27
Read the full previous answer on the forum, as I editted a bit.
Click on the username and you will see a big blue button that says Send Message
Last edit: lesmond 2020-08-27