By HJulien on
I am getting this error:
Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\drupal-6.20\includes\database.mysqli.inc on line 115
and found somewhere that I should insert this line into the settings.php file:
ini-set('max_execution_time', 0);
But I don't know how to open and edit this file. I have been searching Drupal and php ite for a way to do something as basic as this and a simple answer for a newbie doesn't seem to exist! Every answer assumes I know how to do this....
Thank you - all help is appreciated!
Comments
Settings.php file is, in safe
Settings.php file is, in safe environments, write-protected.
I think you've cPanel access(because it's widely used).
Open cPanel Legacy file manager and navigate to public_html/sites/default/ folder(or sites/default where you installed Drupal).
Then, click on the name of settings.php file.
Then, in the right bar, click Change Permissions and check all boxes(remember old status).
Then, click on settings.php name again and click Edit.
Alternately you'd
1.download the file
2. Click on the file and ALT+Enter (properties)
3. Uncheck Read-only
4. Open file with Notepad
5. Add line
6. Save
7. Upload
What's new and changing in PHP 8.4
No cPanel
I don't have cPanel and no money to purchase it. Is there something similar available that's free?
Hélène
Do you have an ftp client?
Do you have an ftp client? like filezilla? ther are lots of free ones for mac and pc
If you have ftp access,
If you have ftp access, simply connect to the server and download the settings.php file.
Then, make changes to it.
Finally, in server's settings.php, change permissions(chmod) to 0777. Then, upload the modified file replacing the old one.
What's new and changing in PHP 8.4
All on my computer
I downloaded XAMPP and Drupal to my computer. All my documents are locally accessible but I can't open .php files without some kind of editor.
Hélène
just use a note pad, or text
just use a note pad, or text editor.
settings.php is read-only
I have notepad! Yayy! I tried to insert the line though but it's read-only. Do you know how I get around this?
Hélène
Resolved - settings.php read-only
I found out I can change the file from read-only by right-clicking on the file name and unclicking the read-only box. I added the line and it worked.
Thank you!!
Hélène
great, goodluck!
great, goodluck!
Thanks!
I am finding the installation to be a process of going from one error message to the next. It is very frustrating. It's been 6 days and I still can't even get to the point of doing a thing with any of the modules I've added. Now I'm getting warnings about Mysal server going away. I've changed the settings on the my.ini file stopped and restarted xampp cleared cashe and sitting here not knowing what to try next. I've even disabled a bunch of the modules and that doesn't help either. Is it possible some modules don't work together?
Hélène
It's possible that some will
It's possible that some will interfere with each other, but as a rule the vast majority of modules play together very nicely. My guess is that modules are not your issue, but that's a complete guess.
In the right environments, Drupal installs pretty smoothly and doesn't kick out a lot of errors -- it's hard to guess what exactly is going on without seeing your error messages, but guess is that there are configuration problems with your local environment. What version of PHP are you using? Are you running in safe mode? What version of MySQL (or other database?)
John
My setup
I have Windows 7 on a new machine and I'm running XAMPP as a development environment. I downloaded it a month ago so it has the latest versions of PHP and Mysql with an Apache server. The PHP version is 5.3.5. Mysql is 5.0.7.
As I mentioned earlier I new with Drupal and most of this. What is safe mode? Since it's development on my home computer I didn't put a password on the database but I did on Drupal. I've copied a couple of the messages I am getting below this paragraph but it repeats like this about 1000 times. I updated the mysql bin file called my.ini file which has configuration settings to increase the maximum packet allowed along with some other settings I found on drupal.org/node/259580 but Mysql won't load with those settings. I added database tweaks module to help but I set the settings but it's not helping either.
--------------------
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:102:\"mysqli_query() [function.mysqli-query]: MySQL server has gone away\";s:5:\"%file\";s:56:\"C:\\xampp\\htdocs\\drupal-6.20\\includes\\database.mysqli.inc\";s:5:\"%line\";i:115;}', 3, '', 'http://localhost/drupal-6.20/admin/build/modules/list', 'http://localhost/drupal-6.20/', '127.0.0.1', 1299810216) in C:\xampp\htdocs\drupal-6.20\includes\database.mysqli.inc on line 135
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'backtrace', 'Type: php\n
%message in %file on line %line.
\nBacktrace:
\nmysqli_query(array)[database.mysqli.inc:115];
\n._db_query(array)[database.mysql-common.inc:42];
\n..db_query(array)[update.module:554];
\n..._update_cache_set(array)[update.compare.inc:622];
\n....update_calculate_project_data(array)[update.module:204];
\n.....update_requirements(a:1:{i:0;s:7:\"runtime\";})[update.module:76];
\n......update_help(a:2:{i:0;s:19:\"admin/build/modules\";i:1;a:12:{i:0;s:5:\"admin\";i:1;s:5:\"build\";i:2;s:7:\"modules\";i:3;s:4:\"list\";i:4;s:0:\"\";i:5;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:8;s:0:\"\";i:9;s:0:\"\";i:10;s:0:\"\&q in C:\xampp\htdocs\drupal-6.20\includes\database.mysqli.inc on line 135
Hélène
Great info found
drupal.org/node/227445 had some useful stuff.
I disabled the update status module that is in core and the messages went away. I'll try re-enabling the module after changing the php.ini and my.ini files again.
Hélène