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
Offline
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
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
Offline
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
Offline
In your database manager :
repair table piwigo_sessions; repair table piwigo_history;
Then deactivate plugin Whois Online.
Offline
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 :)
Offline
yes it is
you do that selecting the tables and the click repaire
Offline
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 :/
Offline
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.
Offline
wow
maybe you might empty it before
Offline
Empty what and how please?
It now has the max connections error again :/
Offline
empty the session and history tables which might be too big for your hosting
Offline
Thanks Flop, I will try when my hosts kills all the connections again :s
Offline
ok, so I dropped the sessions
Site came back online
Ran the update
now its dead again :/
Offline
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
Offline