Announcement

#1 2014-02-07 09:14:54

skpManiac
Member
England
2012-02-15
140

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

I am really hoping someone here can help resolve  my problem as my site is offline.

I was on the site just over 2 weeks ago, showing sunset photos to a client, I went to Philippines to acquire some new photos and when I got home yesterday, my site was sating the HISTORY was corrupt and the site would not work.

I found a solution o0n here where I sent a command to repair the history.
repair table piwigo_sessions;

This was going for about an hour when Firefox crashed, now the site code looks more fatal :(

Can anyone please help me as I don't fancy having to start form scratch, there is a lot of images on the site :(

www.freezinglife.co.uk

Thanks in advance

I am not very skilled in MySQL Server but will try to do my best to do anything you suggest :)

Steve


Share & Enjoy

Offline

 

#2 2014-02-07 09:20:28

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13548

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

Hi Steve,

I see:

Warning: mysqli::mysqli() [mysqli.mysqli]: (42000/1203): User steveprocter already has more than 'max_user_connections' active connections

Contact your web hosting provider to see what is happening to MySQL. If you have a dedicated server, restart MySQL.

Offline

 

#3 2014-02-07 09:33:44

skpManiac
Member
England
2012-02-15
140

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

Hi there, that was the first thing I did - I am still waiting for a response.

I will let you know what they say

Thanks


Share & Enjoy

Offline

 

#4 2014-02-07 21:54:37

skpManiac
Member
England
2012-02-15
140

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

Ok, so they have removed the connection threads and have advised me to change all passwords inc FTP access, so looks like it may have been hacked :/

The site is still dead, but now with new errors, can you please take a look and advise what I need to do to try and resolve this?

Thank you

Steve


Share & Enjoy

Offline

 

#5 2014-02-07 21:58:42

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13548

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

In your database manager :

Code:

repair table piwigo_sessions;
repair table piwigo_history;

Then deactivate plugin Whois Online.

Offline

 

#6 2014-02-07 22:26:12

skpManiac
Member
England
2012-02-15
140

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

This is what I tried originally when it crashed Firefox

I am logged in online through my host and it says:
Run SQL query/queries on database freezinglife:

Is that the right place?

Thanks again :)


Share & Enjoy

Offline

 

#7 2014-02-07 22:30:41

flop25
Piwigo Team
2006-07-06
7037

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

yes it is
you do that selecting the tables and the click repaire


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

 

#8 2014-02-07 22:37:05

skpManiac
Member
England
2012-02-15
140

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

ok guys, here goes

Wish me luck :)

How long should it take approx, because last time it was running for around an hour when FF bombed :/


Share & Enjoy

Offline

 

#9 2014-02-08 00:30:57

skpManiac
Member
England
2012-02-15
140

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

2 hours and its still connecting :/
I hope thats normal as its now gone back to the previous error about MAX CONNECTIONS

I will leave PC on all night and hope it sorts it out.


Share & Enjoy

Offline

 

#10 2014-02-08 00:34:33

flop25
Piwigo Team
2006-07-06
7037

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

wow

maybe you might empty it before


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

 

#11 2014-02-08 07:55:21

skpManiac
Member
England
2012-02-15
140

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

Empty what and how please?


It now has the max connections error again :/


Share & Enjoy

Offline

 

#12 2014-02-08 12:30:20

flop25
Piwigo Team
2006-07-06
7037

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

empty the session and history tables which might be too big for your hosting


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

 

#13 2014-02-08 13:41:52

skpManiac
Member
England
2012-02-15
140

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

Thanks Flop, I will try when my hosts kills all the connections again :s


Share & Enjoy

Offline

 

#14 2014-02-08 19:17:07

skpManiac
Member
England
2012-02-15
140

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

ok, so I dropped the sessions
Site came back online

Ran the update

now its dead again :/


Share & Enjoy

Offline

 

#15 2014-02-09 08:05:07

skpManiac
Member
England
2012-02-15
140

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

Another fix from ISP but now getting this error on the site

Warning:  [mysql error 1146] Table 'freezinglife.piwigo_sessions' doesn't exist

SELECT data
  FROM piwigo_sessions
  WHERE id = '520846u9m5durun6dq3i16t06krq50'
; in /home/linweb04/f/freezinglifethroughthelens.co.uk/user/htdocs/include/dblayer/functions_mysqli.inc.php on line 798


Share & Enjoy

Offline

 

Board footer

Powered by FluxBB

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