Announcement

#16 2014-02-09 13:09:19

flop25
Piwigo Team
2006-07-06
7037

Re: Major SQL Server Error - PLease help - My site is dead :(

lol they simply deleted the table or you did it instead of emptying it


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#17 2014-02-09 16:33:27

skpManiac
Member
England
2012-02-15
140

Re: Major SQL Server Error - PLease help - My site is dead :(

I think i May have done that, bit not sure - still jetlagged and really should have slept instead of fiddling with this :p

Is there a simple way to add this back to the data, I tried to add "piwigo_sessions" it but asked for lots of variables I didnt understand :s

Thanks Flop


Share & Enjoy

Offline

 

#18 2014-02-09 16:51:18

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: Major SQL Server Error - PLease help - My site is dead :(

The SQL structure is described in install/piwigo_structure-mysql.sql

copy past the command for the two tables and execute in phpMyAdmin (modify the tables name to suit you prefix)

Offline

 

#19 2014-02-09 16:52:03

flop25
Piwigo Team
2006-07-06
7037

Re: Major SQL Server Error - PLease help - My site is dead :(

Code:

  CREATE TABLE `piwigo_sessions` (
    `id` varchar(255) binary NOT NULL default '',
    `data` mediumtext NOT NULL,
    `expiration` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM;

from http://piwigo.org/dev/browser/trunk/ins … l.sql#L280

ps: arf mistic got me


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#20 2014-02-09 17:12:36

skpManiac
Member
England
2012-02-15
140

Re: Major SQL Server Error - PLease help - My site is dead :(

Awesome, think thats it :-)

You guys are awesome - THANK YOU


The database is still showing at 100% usage (150mb) I am sure it is much less - but for now I leave it and ensure the site is working before I try to fix anything else :p lol


Share & Enjoy

Offline

 

#21 2014-02-10 11:23:24

skpManiac
Member
England
2012-02-15
140

Re: Major SQL Server Error - PLease help - My site is dead :(

I have had this message form my ISP, does this help in sorting the problem?

Hi Steve,

This has now been resolved again and the database is working as expected.

It does not appear that any one is attacking your site. Looking through the logs, and the state of the database when we got to it, it would appear that your site is logging all hits to the database in a table called piwigo_history.

I am not sure if this is in built into piwigo or a plugin that has been installed on top. This is the table that had crashed and was causing the issues again this time. This table is also recording all bot GET requests from search engines which appears to be the cause of the table crashing.

If this is a plugin that is not required, I would suggest disabling it which will stop any further issues. However if this is an in built function then there is a plugin to exclude IP's from being recorded in this table. I have included a few of the main bot IP's bellow that would need to be added to this list.

If you have any further issues or questions please let me know.

Regards
Nick | IT Operations Engineer

Robot IP's
These make up over 4000 entries to the piwigo_history table over the last 3 days.
Any more can be found in your /logfiles/ex14****.log files and will reference robot / bot in the line.

178.154.243.81
66.249.66.187
66.249.66.144
66.249.66.91
5.10.83.73
5.10.83.45
5.10.83.49
5.10.83.23
5.10.83.75
5.10.83.86
5.10.83.31
66.249.66.203
5.10.83.84
5.10.83.82
5.10.83.15
5.10.83.72
5.10.83.19
5.10.83.57
5.10.83.80
5.10.83.41


Share & Enjoy

Offline

 

#22 2014-02-10 11:35:38

flop25
Piwigo Team
2006-07-06
7037

Re: Major SQL Server Error - PLease help - My site is dead :(

so that's what I thought, the tables was getting to big for your hosting
so disable the history for non registred visitors, in the Piwigo Options, and you can use [extension by Eric] History IP Excluder or a htaccess to block some ip


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#23 2014-02-10 12:27:09

skpManiac
Member
England
2012-02-15
140

Re: Major SQL Server Error - PLease help - My site is dead :(

Hi Flop, thanks for that, but I cannot see that option on my screen :p

I know I'm a pain lol


Share & Enjoy

Offline

 

#24 2014-02-21 12:13:56

skpManiac
Member
England
2012-02-15
140

Re: Major SQL Server Error - PLease help - My site is dead :(

When I try to add lines to IP EXCLUDER I get this error

Fatal error: Call to undefined function is_adviser() in /home/linweb04/f/freezinglifethroughthelens.co.uk/user/htdocs/plugins/HistoryIPExcluder/admin/HIPE_admin.php on line 24


Share & Enjoy

Offline

 

#25 2014-02-21 12:47:22

Eric
Piwigo Team
VALENCE (FR)
2005-03-25
1768

Re: Major SQL Server Error - PLease help - My site is dead :(

Hi,

I'll fix this in next plugin version (this evening).

Offline

 

#26 2014-02-21 17:10:04

Eric
Piwigo Team
VALENCE (FR)
2005-03-25
1768

Re: Major SQL Server Error - PLease help - My site is dead :(

skpManiac wrote:

Fatal error: Call to undefined function is_adviser() in /home/linweb04/f/freezinglifethroughthelens.co.uk/user/htdocs/plugins/HistoryIPExcluder/admin/HIPE_admin.php on line 24

Error fixed in plugin version 2.6.1 ;-)

Offline

 

#27 2014-02-23 21:59:03

skpManiac
Member
England
2012-02-15
140

Re: Major SQL Server Error - PLease help - My site is dead :(

Great work Eric - Thank you :)

I now have this config:

216.156.128.220
178.154.%
5.10.%
66.249.%

hopefully it will solve the problem I have been having

Steve


Share & Enjoy

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact