| Question: |
Stopped working one of the sites. I have just in the browser is an extension that refreshes the page every X seconds. And some time later showed the page where it was written that account is locked. For 3 days the website is down. |
| Answer: |
Hello what kind of website is it? |
| Question: |
chat.zhportal.com |
| Answer: |
this is chat? the chat rooms have banned |
| Question: |
No this is not a chat |
| Question: |
This website displays the data of the database and all. Ie just displays some information. It is not an interactive chat/site. I already asked that you have any claims on your part was not. I never thought that a simple page refresh can lead to something like that. |
| Answer: |
what is the name of the database? how often the site accesses the database? |
| Question: |
zhportal_chatlogНе think that it load the system more than others. The more that half a year is a website for the first time. |
| Answer: |
check amps. what parameters You specify for the database connection? |
| Question: |
Are you interested in it?# The information to connect to the database$dbinfo_hostname = \"zhportal.com\"; // Host$dbinfo_username = \"zhportal_root\"; // username$dbinfo_password = \"*********\"; // Password$dbinfo_dbtable = \"zhportal_chatlog\"; // database Name$dbinfo_tablename = \"chatlog\"; // table Name (quarter sm_chat_log_table) |
| Answer: |
try to reset the password for the database user, if it is complex, has special characters, try without them. |
| Question: |
This password consists of numbers, uppercase and lowercase Latin letters and used in all my databases. If needed I can provide it to check if the problem is in the connection. |
| Answer: |
$dbinfo_hostname = \"zhportal.com\"; // Host enter: $dbinfo_hostname = \"localhost\"; // Host |
| Question: |
Do not quite understand you. I have 5 databases all connected on the same principle, but has stopped working this website after I had \"doomnova\". I remember I was given the page type your account may have expired hosting, etc. And then started giving the message specified in my index.php\"Connection failed. Table is missing or incorrectly specified connection information.\"I will certainly try what you suggest. But how strange it all is. |
| Answer: |
enter localhost. should work. |
| Question: |
Nothing has changed |
| Question: |
This is found in the error logs:[06-Oct-2016 14:01:03 Europe/Moscow] PHP Notice: Undefined variable: db in /home/zhportal/public_html/chat/index.php on line 45[06-Oct-2016 14:01:03 Europe/Moscow] PHP Fatal error: Call to a member function query() on a non-object in /home/zhportal/public_html/chat/index.php on line 45Вот this line 45 index.php$sql = $db->query(\"SELECT * FROM `\" . $dbinfo_tablename . \"` ORDER BY `msg_id` DESC LIMIT 0,\" . $limit . \"\"); |
| Answer: |
1. the parameters we need to specify localhost 2. created a new database user, the connection is gone, but gave an error 3. not properly configured $dbinfo_tablename = \"chatlog\"; // the name of the table (quarter sm_chat_log_table) since the table title chatlog2
Check. |
| Question: |
The name of the table and. I himself renamed. It is created automatically when you connect. Not there you look. Repeat. Almost a year worked fine. I have not changed any settings absolutely. The same settings works 4 site, quite normal. |
| Question: |
If I say that the site has been opened in the browser and the page automatically updated by browser extension every 5 seconds and a few hours later just stopped working. So what about the wrong settings for it? |
| Answer: |
the address of the database server, if the site and database are located on the same server - localhost check the settings. where the database is located? |
| Question: |
Well, I read your message. Refresh the page and it worked. And I have not changed anything anywhere. Thanks, sorry to bother you. |
| Answer: |
what did you change? on our side, no izlendi not done |
| Question: |
I`m not even at home. Have not changed anything. The site has earned. On account of the connections not yet know. But the site is. |
| Answer: |
ok |
