Blanky Blank
hellraiser_rob - November 8, 2007 - 12:18
Hi All,
I seem to have completely broken my drupal installation which can be viewed here: http://www.robertjamesphillips.com/drupal/
I was following this tutorial: [Link to unfinished tutorial removed]
I got to this part:
"Add the fields:
1. Go to Administer -> Content Management -> Content Types -> [Import] (?q=admin/content/types/import)
2. Content type: User Profile
3. Paste in the contents of "User-Profile_uprofile-cck-fields.txt" found in the attached zip. Click submit."
After clicking submit i just get blank pages for everything, obviously something has gone wrong, but i have no idea what to do....
Does anyone have any ideas?
Thanks very much in advance
Rob
error log
Check your Drupal and Apache error logs.
Thanks for your reply, [Thu
Thanks for your reply,
[Thu Nov 08 11:06:53 2007] [error] [client 212.118.224.34] PHP Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 875015 bytes) in /var/www/vhosts/robertjamesphillips.com/httpdocs/drupal/includes/database.mysql.inc on line 380, referer: http://www.robertjamesphillips.com/drupal/admin/content/types/import[Thu Nov 08 11:06:53 2007] [error] [client 212.118.224.34] PHP Warning: Table 'watchdog' was not locked with LOCK TABLES\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Table &amp;#039;sessions&amp;#039; was not locked with LOCK TABLES\\nquery: SELECT sid FROM sessions WHERE sid = &amp;#039;idba3jud3pksp5gr46c0d6hdk4&amp;#039;</em> in <em>/var/www/vhosts/robertjamesphillips.com/httpdocs/drupal/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.robertjamesphillips.com/drupal/admin/content/types/uprofile/fields', 'http://www.robertjamesphillips.com/drupal/admin/content/types/import', '212.118.224.34', 1194520013) in /var/www/vhosts/robertjamesphillips.com/httpdocs/drupal/includes/database.mysql.inc on line 172, referer: http://www.robertjamesphillips.com/drupal/admin/content/types/import
This is from my apache log, obviously some kind of error with memory, what can i do about this? Surely i should just be able to delete to node to blame and it should work?
Cheers
Rob
http://drupal.org/node/158043
http://drupal.org/node/158043
gpk
----
www.alexoria.co.uk
Thanks for your reply, this
Thanks for your reply, this information suggests i either try and increase the memory allocation (I'm using a hosting company so won't be an option), or start ditching modules...which i would do my just deleting them with ftp (likely to cause even more problems?)
But surely The memory issue arose because of trying to import those fields and not because of having too many modules...also why is the rest of my site still working?
Sorry for all the questions.... :)
>I'm using a hosting company
>I'm using a hosting company so won't be an option
You can always ask. 16MB is a pretty paltry limit these days. You need more than that.
gpk
----
www.alexoria.co.uk
will increasing the limit do
will increasing the limit do anything though? Is there nothing else i can do?
If the site runs out of
If the site runs out of memory then you will get blank screens. Alternatively, reducing the number of active modules can help reduce memory usage (try browsing directly to the admin/build/modules page).
gpk
----
www.alexoria.co.uk
Sorry perhaps i didn't make
Sorry perhaps i didn't make it clear, no pages load, no matter what i do....or are you suggesting i remove the modules via ftp?
Sure it's memory?
If your site was running fine before, I doubt it's memory related. Plus, the error you're getting is "Table 'watchdog' was not locked with LOCK TABLES" which has nothing to do with memory. I suspect something got hosed when you used content copy. First of all, make sure your database is backed up. Then go into your database and delete the table content_type_uprofile. In table node_type, delete the record for uprofile. If any of the fields you tried to import are in node_field and node_field_instance, delete those, too. Also delete any content_field_* tables for those fields. That should hopefully clean out anything created by content copy. In addition, empty out the cache_* tables.
Another thing to check... Some people using the tutorial have missed the warning to only have one < ? php at the top of the tempate.php file and not putting them around each snippit and not having the closing ? > at the end. Make sure yours is ok.
Michelle
--------------------------------------
See my Drupal articles and tutorials or come check out life in the Coulee Region.
you superstar, thanks very
you superstar, thanks very much for your help, i'm back into the site :) I still get a few errors here and there but i'm sure i'll be able to nuke them eventually
Cheers for all your help
Rob
Cool :)
Glad you got it somewhat fixed and sorry for the mess. That content copy module is very unreliable. I'm trying to find a better way for version 3.
Michelle
--------------------------------------
See my Drupal articles and tutorials or come check out life in the Coulee Region.
Well there is a memory error
Well there is a memory error as well as the LOCK TABLES warning.
See also this http://drupal.org/node/159860#comment-252659 ... plus doing some quick searches on Google http://www.google.co.uk/search?hl=en&q=+site:drupal.org+PHP+Warning:+Tab... suggests the problem may be fixed by repairing the DB. Possibly the import caused the site to exceed the PHP memory limit and damaged DB tables hence continuing errors. However, *if* memory limit is the problem then this may start happening again once fixed.
Sorry to hear your webhost is unable to help. 16MB is a pretty measly limit.
By disabling modules I just meant unticking them from the admin/build/modules page. If you can't access that then you can edit the system table directly. Do a DB backup first.
gpk
----
www.alexoria.co.uk
Memory error
Yeah, the first error he posted was it running out of memory when trying to import the CCK fields. That's why I asked what continuing errors he was getting, which was the lock tables thing. Which made me think the ongoing problem wasn't a memory one.
Michelle
--------------------------------------
See my Drupal articles and tutorials or come check out life in the Coulee Region.
Indeed
Indeed ;-)
gpk
----
www.alexoria.co.uk
Content copy
Content copy is buggy, unfortunately. I've had people report all sorts of problems with it but I don't know any other way to save people from having to add all the fields manually.
As the other poster said, check your webserver error logs. The WSOD is often a memory error but sometimes can be caused by other things like having a closing ?> with whitespace after it.
Also, please don't try to use version 3. It's not even remotely ready. It's like pre-alpha at this point. LOL
Michelle
--------------------------------------
See my Drupal articles and tutorials or come check out life in the Coulee Region.
Thanks for your reply, by
Thanks for your reply, by version 3, do you mean version 3 of the tutorial?
Yes
The node you linked to is part of version 3. Unfortunately, it's hard to link things in a book structure and keep them unpublished so the nodes are published. I excluded them from all the node listings but people still find them. I put a warning on the first page not to use it but I guess that wasn't enough.
As to the error... That's definitely an out of memory error on importing the fields. But that shouldn't take down your whole site. Are you getting any more errors when you try to go to other pages?
Michelle
--------------------------------------
See my Drupal articles and tutorials or come check out life in the Coulee Region.
OK, thanks for that, i think
OK, thanks for that, i think i ended up on your site directly on page 2, so must have missed the warning on page 1 :(
This is what gets put into the log when i visit the homepage
[Thu Nov 08 15:29:03 2007] [error] [client 212.118.224.34] PHP Warning: Table 'watchdog' was not locked with LOCK TABLES\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Table &amp;#039;sessions&amp;#039; was not locked with LOCK TABLES\\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;idba3jud3pksp5gr46c0d6hdk4&amp;#039;, 1, 0, &amp;#039;212.118.224.34&amp;#039;, &amp;#039;form|a:7:{s:32:\\\\&amp;quot;aa2d1f6cc0168d463d6a80215c321ae8\\\\&amp;quot;;a:2:{s:9:\\\\&amp;quot;timestamp\\\\&amp;quot;;i:1194518734;s:4:\\\\&amp;quot;args\\\\&amp;quot;;a:1:{i:0;s:14:\\\\&amp;quot;system_modules\\\\&amp;quot;;}}s:32:\\\\&amp;quot;3eb8eb3e1296e8b2498ec7ebbaa67600\\\\&amp;quot;;a:2:{s:9:\\\\&amp;quot;timestamp\\\\&amp;quot;;i:1194518740;s:4:\\\\&amp;quot;args\\\\&amp;quot;;a:1:{i:0;s:14:\\\\&amp;quot;system_modules\\\\&amp;quot;;}}s:32:\\\\&amp;quot;466612a0c61c5a9d184f9293c8278 in /var/www/vhosts/robertjamesphillips.com/httpdocs/drupal/includes/database.mysql.inc on line 172I don't seem to have anything suspicious at the end of my watchdog table....the last entry is something about uprofile added.
just as an update i got this
just as an update i got this reply from my host when asking for the memory limit to be incresed:
"Our servers are configured to provide the optimum level of service for all users and for this reason we do not alter the set-up of them."