Piwigo.org

Lucky · 2007-10-01 14:17:04

Versione MySQL: 4.0.27-standard-log

aruba has monitoring the server where my site is up and it has found these query, but i don't known how and where.

Lucky · 2007-10-01 14:20:17

now for example is incredible slowly www.andjclub.it/gallery

I have set permission of all category folder to 755 before thumbnail generetion or it's ok 777?

Last edited by Lucky (2007-10-01 14:23:26)

VDigital · 2007-10-01 14:43:19

Problem is maybe your history table size.

1 - Please download the last AStat plugin release.
In Admin, Plugins Administration: Install and activate AStat.
Thru AStat (in Plugins menu), you will have a Tools sheet ("Outils", plugin has to be translated)
By the end of page, find "Purge de l'historique":
In "Purger les évènements antérieurs à (JJ/MM/AAAA)" enter a reasonable purge date (take care) in DD/MM/YYYY form.
Tick case box in front of "Appliquer la purge".

2 - In Admin + Specials + Maintenance
Clic on "repair and optimize database"

Test and tell us.

8-)

Lucky · 2007-10-01 17:10:43

this is the error when i access into the plugin astat:

Code:

Warning: main() [function.include]: Failed opening '' for inclusion (include_path='.:/php/lib/php/') in /web/htdocs/www.andjclub.it/home/gallery/plugins/AStat/admin/AStat_admin.php on line 4

select 'Tout' as Id, count(id) as NbPages, count(distinct IP) as NbIP, count(image_id) as NbImg, count(distinct category_id) as NbCat , 0 as MaxPages, 0 as MaxIP, 0 as MaxImg from phpwebgallery_history , (select max(n.MaxPages) as MaxPages, max(n.MaxIP) as MaxIP, max(n.MaxImg) as MaxImg 
      from (select count(id) as MaxPages, count(distinct IP) as MaxIP, count(image_id) as MaxImg 
          from phpwebgallery_history) as n) as n 
[mysql error 1064] 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 'select max(n.MaxPages) as MaxPages, max(n.MaxIP) as MaxIP, max(

I have PHP Version 4.4.7 in my server

Last edited by Lucky (2007-10-01 17:13:21)

VDigital · 2007-10-01 17:44:48

Not a problem of php version
but clearly a MySQL version.

Ok.

Via phpMyAdmin, tell us how many rows are available in #_history table.
Tell us the date you're agree to delete older rows.

I will give you the delete statement.
Maybe you can find it.

8-)

Lucky · 2007-10-01 23:57:49

there are 76.975 rows. I can delete all the rows?

you say this is the problem who occoured in my gallery?

VDigital · 2007-10-02 07:30:20

There is no reason currently I have 88913 rows (that's too much), but it is work well.

You can purge them, AStat does it well (selective) but if you can in Admin + Specials + Maintenance
Purge all History and don't forget to clic on "repair and optimize database".

Nethertheless, try to remove sound.

8-)

Lucky · 2007-10-02 08:21:23

I do that! we will see if the error will be still manifested!

Lucky · 2007-10-24 19:47:20

the problem persist... uff!! :(

500 Internal server Error:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, postmaster@andjclub.it and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Lucky · 2007-10-24 20:01:54

I think there is a Idiot who refresh and make a error in the page... multi refresh? this gallery is subject to many problem :(

VDigital · 2007-10-24 20:35:38

You can do several things...

Banish an IP address. Do you have History active? Maybe we can develop something to manage banishment.

But before clear your script...

Result: 27 errors / 0 avertissements

line 310 column 58 - Erreur: required attribute "ALT" not specified
line 311 column 58 - Erreur: required attribute "ALT" not specified
line 312 column 58 - Erreur: required attribute "ALT" not specified
line 313 column 58 - Erreur: required attribute "ALT" not specified
line 314 column 58 - Erreur: required attribute "ALT" not specified
line 323 column 43 - Erreur: character data is not allowed here
line 323 column 73 - Erreur: end tag for "BLOCKQUOTE" which is not finished
line 331 column 43 - Erreur: character data is not allowed here
line 331 column 78 - Erreur: end tag for "BLOCKQUOTE" which is not finished
line 339 column 43 - Erreur: character data is not allowed here
line 339 column 144 - Erreur: end tag for "BLOCKQUOTE" which is not finished
line 347 column 50 - Erreur: document type does not allow element "STRONG" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "PRE", "DIV", "ADDRESS" start-tag
line 347 column 76 - Erreur: character data is not allowed here
line 347 column 316 - Erreur: document type does not allow element "IMG" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "DIV", "ADDRESS" start-tag
line 347 column 324 - Erreur: document type does not allow element "BR" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "PRE", "DIV", "ADDRESS" start-tag
line 348 column 4 - Erreur: document type does not allow element "BR" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "PRE", "DIV", "ADDRESS" start-tag
line 349 column 95 - Erreur: document type does not allow element "BR" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "PRE", "DIV", "ADDRESS" start-tag
line 350 column 4 - Erreur: document type does not allow element "BR" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "PRE", "DIV", "ADDRESS" start-tag
line 351 column 7 - Erreur: document type does not allow element "STRONG" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "PRE", "DIV", "ADDRESS" start-tag
line 351 column 31 - Erreur: character data is not allowed here
line 351 column 147 - Erreur: document type does not allow element "IMG" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "DIV", "ADDRESS" start-tag
line 351 column 153 - Erreur: document type does not allow element "BR" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "PRE", "DIV", "ADDRESS" start-tag
line 352 column 4 - Erreur: document type does not allow element "BR" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "PRE", "DIV", "ADDRESS" start-tag
line 353 column 4 - Erreur: document type does not allow element "BR" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "PRE", "DIV", "ADDRESS" start-tag
line 354 column 4 - Erreur: document type does not allow element "BR" here; missing one of "P", "H1", "H2", "H3", "H4", "H5", "H6", "PRE", "DIV", "ADDRESS" start-tag
line 355 column 3 - Erreur: end tag for element "P" which is not open
line 355 column 15 - Erreur: there is no attribute "ALIGN"

Lucky · 2007-10-24 21:11:57

I have History active. I can test who in firefox there are many problems who in konquero, safari or camino.

This error is frequently (500 internal server error!!!)

now i can't login in admin panel... when i login the system not log me. :(

how i can fix these errors?

Last edited by Lucky (2007-10-24 21:13:55)

VDigital · 2007-10-24 21:42:58

Who wrote these lines?

<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<img src="template/yoga/icon/sabato.gif"/>

<img src="template/yoga/icon/sabato.gif"/>
<img src="template/yoga/icon/sabato.gif"/>
<img src="template/yoga/icon/sabato.gif"/>
<img src="template/yoga/icon/sabato.gif"/>

Notice:

1 - template/yoga/icon/sabato.gif doesn't exist on your gallery
2 - in HTML img tag needs alt= attribute.

8-)

Lucky · 2007-10-25 01:40:52

VDigital wrote:
Who wrote these lines?

<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<img src="template/yoga/icon/sabato.gif"/>

<img src="template/yoga/icon/sabato.gif"/>
<img src="template/yoga/icon/sabato.gif"/>
<img src="template/yoga/icon/sabato.gif"/>
<img src="template/yoga/icon/sabato.gif"/>
Notice:

1 - template/yoga/icon/sabato.gif doesn't exist on your gallery
2 - in HTML img tag needs alt= attribute.

8-)

I wrote these lines! :D I ad this file in this folder... The alt attribute does't indispensable i say..

The other issue is who on login the system failed. :(
And the internal server erro is persistent... :((

Tx for all Vincent in advantage!

Last edited by Lucky (2007-10-25 01:50:30)

Asep · 2011-05-25 02:20:03

I have same problem, my gallery is http://www.absolutematic.com
anyone can help me to fix this problem?

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@absolutematic.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.absolutematic.com Port 80

Piwigo.org

Announcement

#16 2007-10-01 14:17:04

Re: internal server error - page not accessible

#17 2007-10-01 14:20:17

Re: internal server error - page not accessible

#18 2007-10-01 14:43:19

Re: internal server error - page not accessible

#19 2007-10-01 17:10:43

Re: internal server error - page not accessible

Code:

#20 2007-10-01 17:44:48

Re: internal server error - page not accessible

#21 2007-10-01 23:57:49

Re: internal server error - page not accessible

#22 2007-10-02 07:30:20

Re: internal server error - page not accessible

#23 2007-10-02 08:21:23

Re: internal server error - page not accessible

#24 2007-10-24 19:47:20

Re: internal server error - page not accessible

#25 2007-10-24 20:01:54

Re: internal server error - page not accessible

#26 2007-10-24 20:35:38

Re: internal server error - page not accessible

#27 2007-10-24 21:11:57

Re: internal server error - page not accessible

#28 2007-10-24 21:42:58

Re: internal server error - page not accessible

#29 2007-10-25 01:40:52

Re: internal server error - page not accessible

VDigital wrote:

#30 2011-05-25 02:20:03

Re: internal server error - page not accessible

Board footer