By Kit_Hally on

ok got the same problems with the 6.14 as i did with the 6.0 and beta 1 version of 6.0
meaning there is no mysql option
leaving me with these failers and unable to install

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /includes/menu.inc on line 315.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /includes/menu.inc on line 315.

does this mean i have got to wait till the next version to be able to install a clean drupal ?
or does someone have a solution for this?

p.s. i did not have any problems with any other versions besides the ones i mentioned here

⋅ Categories: Drupal 6.x

Comments

ma7md-janoobe’s picture

ma7md-janoobe commented

An error occurred. http://localhost/drp/install.php?locale=ar&profile=default&id=1&op=do
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 98304 bytes) in C:\AppServ\www\drp\includes\locale.inc on line 1166

vm’s picture

vm commented

@ ma7md-janoobe, next time please start a new thread rather than insert your question into a thread that has nothing to do with your issue. Your server is running out of memory. Please read the Troubleshooting FAQ's section of the handbook where it explains what to do in this cse.

vm’s picture

vm commented

@ Kit Hally - more information about the OS on the server may help. ex: what version of MySQL?

Kit_Hally’s picture

Kit_Hally commented

thanks VeryMisunderstood
the host thought the prob was a missing install.php file, (but that file was there)
it seems that it was a much simpler fix/prob as i discovered
i used the auto generate password this time for the db (in cpanel)and that fixed it
still have no idea why it does with that and not with typing own one as i always did with other versions
but what ever the reason might be for that this works so its fine by me
thanks for offering your help though i really appreciate it !
have a great weekend

umina’s picture

umina commented

This morning I attempted to upgrade from 6.13 to 6.14. I had a problem with update.php WSOD. After doing every possible recommendation in the forum, I finally decided to start over with a clean install of 6.14.

Site is up, looks and acts normal - your typical virgin install.

So I tried update.php on the new site. It fails just like it did this morning when I tried the upgrade! WSOD when I tell get to the update button. No error messages in log.

I'm about to do a virgin install of 6.13 to see update.php works out of the box, but thought I might as well report this, just in case I'm not the only one with this problem.

FYI I blew away the database for the new install so I'd have a clean database, had a new .htaccess properly configured, and still update.php fails. I wen to my backup system and ran update.php there with no issues (it of course still has 6.13 on it).

/Len

umina’s picture

umina commented

This is from a clean install of 6.14 after running the install script. It is from the error log.

[Sat Sep 19 06:37:42 2009] [error] [client 10.10.9.25] PHP Fatal error: Call to undefined function _system_theme_data() in /var/www/html/drupal/includes/theme.inc on line 459

So why is _system_theme_data() undefined?

----------------------------------
SOLVED THIS ONE

I had uncompressed the .tar file in another folder and copied the contents using scp, but the hidden files were not being transferred. Expanding the archive (.tar) file in the proper folder, in my case 'drupal' in the server root, fixed this problem.

The basic problem, not being able to run update.php remains.

umina’s picture

umina commented

Here is the access log of the webserver, from get of update.php to WSOD:

10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/update.php HTTP/1.1" 302 - "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/update.php?op=info HTTP/1.1" 200 3508 "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/modules/system/defaults.css?J HTTP/1.1" 200 757 "http://revere.umina.lan/drupal/update.php?op=info" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/modules/system/system.css?J HTTP/1.1" 200 10020 "http://revere.umina.lan/drupal/update.php?op=info" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/modules/system/system-menus.css?J HTTP/1.1" 200 935 "http://revere.umina.lan/drupal/update.php?op=info" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/modules/system/maintenance.css?J HTTP/1.1" 200 425 "http://revere.umina.lan/drupal/update.php?op=info" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/themes/garland/style.css?J HTTP/1.1" 200 18844 "http://revere.umina.lan/drupal/update.php?op=info" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/themes/garland/minnelli/minnelli.css?J HTTP/1.1" 200 378 "http://revere.umina.lan/drupal/update.php?op=info" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/themes/garland/print.css?J HTTP/1.1" 200 1247 "http://revere.umina.lan/drupal/update.php?op=info" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/themes/garland/images/bg-navigation.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/themes/garland/minnelli/logo.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/update.php?op=info" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/themes/garland/images/body.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/themes/garland/images/bg-content.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/themes/garland/images/task-list.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/themes/garland/images/bg-content-left.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:00 -0700] "GET /drupal/themes/garland/images/bg-content-right.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "POST /drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7 HTTP/1.1" 200 6918 "http://revere.umina.lan/drupal/update.php?op=info" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/modules/system/defaults.css?J HTTP/1.1" 304 - "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/modules/system/system.css?J HTTP/1.1" 304 - "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/modules/system/system-menus.css?J HTTP/1.1" 304 - "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/modules/system/maintenance.css?J HTTP/1.1" 304 - "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/style.css?J HTTP/1.1" 304 - "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/minnelli/minnelli.css?J HTTP/1.1" 304 - "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/print.css?J HTTP/1.1" 304 - "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/misc/jquery.js?J HTTP/1.1" 200 31089 "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/misc/drupal.js?J HTTP/1.1" 200 9834 "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/misc/collapse.js?J HTTP/1.1" 200 2669 "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/minnelli/logo.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/images/body.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/images/bg-navigation.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/misc/watchdog-ok.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/images/bg-content.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/images/task-list.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/images/bg-content-left.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/images/bg-content-right.png HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:02 -0700] "GET /drupal/themes/garland/images/menu-collapsed.gif HTTP/1.1" 304 - "http://revere.umina.lan/drupal/themes/garland/style.css?J" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:03 -0700] "POST /drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7 HTTP/1.1" 302 - "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
10.10.9.25 - - [19/Sep/2009:07:55:04 -0700] "GET /drupal/update.php?op=start&id=2 HTTP/1.1" 200 - "http://revere.umina.lan/drupal/update.php?op=selection&token=3926d50c59656f36cac7dea0a99d8cf7" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090908 Fedora/1.1.18-1.fc10 SeaMonkey/1.1.18"
[root@revere httpd]#

------------------------------------------------------
And here is the error log of the webserver:

[root@revere httpd]# cat error_log
[Sat Sep 19 07:40:51 2009] [notice] SELinux policy enabled; httpd running as context unconfined_u:system_r:httpd_t:s0
[Sat Sep 19 07:40:51 2009] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Sat Sep 19 07:40:52 2009] [notice] Digest: generating secret for digest authentication ...
[Sat Sep 19 07:40:52 2009] [notice] Digest: done
[Sat Sep 19 07:40:52 2009] [notice] mod_python: Creating 4 session mutexes based on 256 max processes and 0 max threads.
[Sat Sep 19 07:40:52 2009] [notice] mod_python: using mutex_directory /tmp 
[Sat Sep 19 07:40:52 2009] [notice] Apache/2.2.13 (Unix) DAV/2 PHP/5.2.9 mod_python/3.3.1 Python/2.6 mod_ssl/2.2.13 OpenSSL/0.9.8k-fips mod_perl/2.0.4 Perl/v5.10.0 configured -- resuming normal operations
[root@revere httpd]#

----------------------------------

umina’s picture

umina commented

That is I can create nodes, all of the admin functions appear to work fine, site is otherwise fully functional. Just cannot run udpate.php to save my life!

umina’s picture

umina commented

I have been doing a lot of experimentation trying to debug this and I've discovered something. I change the $base_url in settings.php.

It did not have the desired effect, so I changed it back (commented it out).

I then realized that trying to reverse having set $base_url DOES NOT WORK.

I went to .htaccess in the drupal folder and found that RewriteBase was commented out. I fixed that, putting it back to /drupal, BUT THAT STILL DID NOT CORRECT THE PROBLEM.

My site responded but the site name revere.umina.lan was repeated twice on the screen, and although I was asked to log in from a themless screen, when I did drupal would fail.

I had been entering http://revere.umina.lan/drupal into my browser.

On a hunch I entered http://revere.umina.lan/drupal/index.php

Suddenly everything fixed itself. I got my theme back, I can log in, and site works normally.

Of course the core problem with update.php still exists.

My guess at this point is that update.php has an issue, but it may be related to a configuration parameter in the webserver. So off I go to see what I can find.

umina’s picture

umina commented

The problem appears to be a JS problem with the Seamonkey browser.

I tried Mozilla and boom, everything works.

I'm not going to try debugging this anymore, but if you get here TRY A DIFFERENT BROWSER if you have a problem with Update.php as whatever it does breaks some browsers - sometimes.

umina’s picture

umina commented

OK, I decided to look into this just a wee bit more....since I figured it might be the way the browsers handle coding errors.....

Warning: Error in parsing value for property 'display'. Declaration dropped.
Source File: http://revere.umina.lan/drupal/modules/system/defaults.css?U
Line: 43

Warning: Error in parsing value for property 'display'. Declaration dropped.
Source File: http://revere.umina.lan/drupal/themes/garland/style.css?U
Line: 646

Warning: Error in parsing value for property 'display'. Declaration dropped.
Source File: http://revere.umina.lan/drupal/modules/system/defaults.css?U
Line: 43

Warning: Error in parsing value for property 'display'. Declaration dropped.
Source File: http://revere.umina.lan/drupal/themes/garland/style.css?U
Line: 646

crutch’s picture

crutch commented

Using TWAMP server on local. I made a number of module security updates with success, no errors. The last update was D6.14 from 6.12. Updated files, then ran update.php. Database changes were made, but now server times out or crashes, no more site.

Reverting to backup.

Strangely, http://localhost will come up in FF, but trying to go to http://localhost/user server times out.

no errors are recorded in watchdog or logfiles