hey guys, i tried to install Views on drupal
i uploaded calendar, date and cck mods to my drupal
but i still need Views
I uploaded Views and it happens

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 648591 bytes) in /home/hzhancom/public_html/goko/robotics/includes/database.mysqli.inc on line 303

i removed views and it worked again
i tried beta 2 and dev version
it sounds like there is a problem with the coding

my host prodivded 32M
i check php.ini

;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 32M ; Maximum amount of memory a script may consume (8MB)

Comments

jwxie518’s picture

by the way
here is the cache problem

i got the error cache.inc in line 105
same ememory problem
i was trying to install calendar
it sounds like both have problem

when i looked at my phpmyadmin

Space usage Type Usage
Data 182,852 Bytes
Index 6,144 Bytes
Overhead 90,568 Bytes
Effective 98,428 Bytes
Total 188,996 Bytes

the cache table appears to be overhead (over the max)
i have to empty it in order to access a page

merlinofchaos’s picture

Do you have this problem when you turn calendar.module off?

jwxie518’s picture

i tried to install calendar module
this is what i did

i first installed cck

then i uploaded calendar
and then date
and then views
i first checked all of them to install all at once
but it failed, so instead i took another approach to first install dates
then somehow the system got the views on (weird), and then i tried to install calendar
idk
now i just setup a new site
i will install another one just for testing the two modules

faqing’s picture

I have the same problem. After I overwrote the view folder (beta4 over write beta3), I cannot access the module list (admin/build/modules). Now, I am tring to use the dev version and will report here later.

faqing’s picture

I tried Dev version. It has the same problem. I deleted all view folders and upload version beta 3.

Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 570725 bytes) in /home/ibcacth/public_html/elearning/includes/database.mysqli.inc on line 303

faqing’s picture

Problem solved by adding

php_value memory_limit 30M

in .htaccess file in the Drupal root

jwxie518’s picture

i had tried it several time before you had suggested it
i added that extra line onto the htaccess under the drupal root
but then it caused a "internal error"

karens’s picture

The calendar contains several displays so it creates a very large view object and that is probably what is sucking up all the memory. Not sure of the best way around that.

As to #7, not all hosts are set up to allow you to add things like that to the .htaccess file. You need to contact your host and ask the best way to increase the memory allotted to PHP in their system, or search around the drupal.org site for 'memory problems' for other solutions to add memory.

gr33nman’s picture

I was getting the same "/database.mysqli.inc on line 303" error.
I removed 'views' (rm -rf views).

Then I made the change suggested by faqing above:
http://drupal.org/node/270661#comment-884091
Status report confirms the new 32MB upload limit.

I then unzipped views again.
(tar -xzvf views-6.x-2.0-beta4.tar.gz)

When I attempted to look at my modules again, I got this:
"Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 81 bytes) in /home/user/public_html/mysite.com/includes/menu.inc on line 2327" in my browser.

I removed views again (rm -rf views) and got this:
warning: Invalid argument supplied for foreach() in /home/user/public_html/mysite.com/modules/views/includes/view.inc on line 1320.

I refreshed and everything was back to normal.

Any suggestions?

allanx’s picture

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 864355 bytes) in /home/wagreens/public_html/includes/database.mysql.inc on line 301

After installing Views views-6.x-2.0-beta4.tar, When attempting to go to /admin/build/modules, I get the same issue here.

Any news on fixing this would be greatly appreciated!

cheers,
al

PS: Thanks for all the hard work that went into this module!

allanx’s picture

I have solved the problem by upgrading to D6.2 and updating all modules. Views seems to work fine so far, with no error page on the modules admin.

Thanks again for a great module.

al

merlinofchaos’s picture

That's interesting. Versions of Drupal prior to 6.2 are more memory intensive?

Odotnet’s picture

By the looks of it. How can we stop this?

faqing’s picture

Version: 6.x-2.0-beta4 » 5.x-1.6

When I install Veiw 5.x-1.6, it also got this error:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 469234 bytes) in D:\xampplite\htdocs\drupal5\sites\all\modules\views\views_cache.inc on line 146

Change my php.ini memory limit to 32, the same problem. Change to 64MB, the it says mysql gone away... the site dead. (for view 6.x, one can change php.ini memory limit to solve the problem, but 5.x-1.6 one can not change)

Changed to View 5.x-1.5 (delete 1.6, run update.php), it works ok.

faqing’s picture

change back to 5.x-1.5. It works great.

merlinofchaos’s picture

Version: 5.x-1.6 » 6.x-2.0-beta4

Please don't take over pre-existing issues.

beautifulmind’s picture

Hey why don't you make it 96M in your .htaccess?

It will never be a problem anymore!

eggtea’s picture

what line do you change in the .htaccess file? I'm using the current drupal6 dev.

This error shows up when I try to view my modules.

faqing’s picture

How to increase the PHP memory limit in Drupal 6 without approaching hosting provider? check here: http://thanhsiang.org/faqing/node/95

merlinofchaos’s picture

Status: Active » Fixed

For the most part I've fixed a lot of the memory issues; there's no reason for this to still be open.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.