[FIXED] Serious LIMIT problem causes blank pages - Joomla! Forum - community, help and support

-

i have large website running on mambo looking upgrade joomla. on test-server installed same site on latest joomla version. discovered serious problem in (amongst others) components/com_content/content.php on latest versions of both mambo , joomla:

all of select queries not limited or limited @ all. causes serious problems large websites.

my site has on 1300 content items. when visiting front page or large blogsection such newssection, joomla returns blank page. caused memory-limit set on mysql server of hosting provider. single query not allowed generate more amount of data.

the queries in content.php never limited. means if site grows large enough , hosting provider has set memory limit on mysql database, parts of site go blank because server refuses perform query or returns error.

i first encountered when frontpage went blank while ago. solution remove "show on front page" check on oldest items. after removing enough items front page, worked again. same thing happened on blogsections. after putting "limit 500" after select queries in content.php blogsection page showed correctly again.

i think solution rewrite parts of content.php code. if user requests page 1 of blogsection of front page, mysql query should limit query items only. may prevent major performance issues on large websites if implemented.

i hope joomla developers find post useful , hope can , fixed in future version.

thanks,
mrzystem

(unfortunately lack of limiting found in other parts , lot of 3rd party components , modules. instance, can no longer use admin backend of ako_comment because there 13.000 comments items , queries aren't limited.)

moving thread "joomla! 1.0.x_q&t" board.





Comments

Post a Comment

Popular posts from this blog

Convierte tu Raspberry en un NAS. Firmware fvdw-sl 15.3 - Raspberry Pi Forums

-
¿conocéis este proyecto? fvdw-sl 15.3 para raspberry pi. convierte la raspi en un nas. http://plugout.net/viewtopic.php?f=31&t=1880 llevo tiempo intentando encontrar la forma de hacer que una de mis raspberry se comporte como un nas. configurando samba, minidlna, transmision, ftp, nfs, etc. pues con esta distribución lo tengo todo hecho. lo instalé ayer y me tiene soprendido. ahora mi raspi es un nas, hecho y derecho. caracterísitcas. - interfaz web. que cambia en función de si eres el administrador o un usuario. - gestión de usuarios. puediendo dar distintos permisos carpetas y funciones. - gestión de carpetas - vpn - ftp - nfs - webdav - varios servidores dlna como minidlna, townky, etc - varios gestores de descarga como transmision, mldonkey, etc - gestión de periféricos usb como impresoras o webcam. - gestión de cron para automatizar procesos. - creo que se basa en arch linux. por cierto, estoy creando una tarea para que me exporte un archivo txt del dis...
Read more

How to format a Get Request

-
i have external server running mysql. have installed php script that, when accessed http deliver data 1 of tables. works fine browser: code: [select] http://www.seti.net/php/getevents.php i cannot figure out how send command arduino. have ethernetclient library working , can access google in example. when send command through client: code: [select] client.println("//get /php/getevents.php http/1.0"); the server returns: code: [select] </head><body> <h1>method not implemented</h1> <p>get /php/getevents.php not supported.<br /> what correct way format in arduino? i use send temperature web server. note lack of http version , additional blank line after - not sure whether difference important works: code: [select] void  sendtemptoserver() { char getrequest[80]; if (client.connect(server, 80))   {   sprintf(getrequest,"get /cgi-bin/arduino.cgi?reading=%s&arduino_id=23&sensor_id=1",t...
Read more

avrdude: verification error, first mismatch at byte 0x0000 0x0c != 0x62

-
hello, im confused uno r3, uploaded code quite few months in uno, working fine. now without having altered of circuits, trying upload code changes,im getting strange error "avrdude: verification error, first mismatch @ byte 0x0000          0x0c != 0x62" i tried research able solve issue,  im running kind of fuse bit being changed or clock speed altered, im pretty sure did not play around these items. any people, please . . thanks taz Arduino Forum > Using Arduino > Installation & Troubleshooting > avrdude: verification error, first mismatch at byte 0x0000 0x0c != 0x62 arduino
Read more