Site was ok the other day. This morning gave 3 mysql errors. Couldn't remember if I had upgraded this site to 4.1.60 or not and I couldn't access the admin area either, so overwrote the schema file anyway. Still didn't work so thought I would do a manual upgrade.
Now I just get... Cannot extract data from the database. It seems that although we established a database connection we aren't able to access the database itself. It could be that the database is down (ask your web host about this), or that the mysql user doesn't have proper permissions to acces the database. MySQL returns this error: WSN Links 4.1.61
Just to add that there is no problem with my database - I checked it and had my host check it too.
Check your config.php. Does it have your database info in it? If you did a manual upgrade using already-installed files instead of the exact contents of the zip, you would've overwritten your config.php and thus prevented your site from working.
Paul wrote: Check your config.php. Does it have your database info in it? If you did a manual upgrade using already-installed files instead of the exact contents of the zip, you would've overwritten your config.php and thus prevented your site from working.
Yes, my config.php does have database info and it is correct.
No, I did not overwrite the config.php file when doing a manual upgrade, and yes I did use the exact contents of the latest zip file.
As I said, I only did a manual upgrade because I had 3 mysql errors reported.
Well if you'd told me what the debug of the mysql warnings was I'd know what's going on. As it is now, if if there are no longer any messages, site inspection is the only way to find out.
Thanks Paul, but I couldn't risk waiting so I deleted it all, and started a fresh install of v.4.1.59. I then restored my backup of a couple of days ago and got it all working ok.
However, once I was ready I then clicked upgrade to v.4.1.61 and got a load of the following errors for different files...
Warning: ftp_delete() [function.ftp-delete]: Could not delete admin/emailsubmitter.php: No such file or directory in /home/freewebb/public_html/includes/filefunctions.php on line 143
Complete debug in attached file.
All the files are in the ROOT, so I don't know why it is looking in admin for them.
The site is also extremely slow even though my server load is low.
You must have a path wrong. Check your directory url and upload path, and admin directory name. Or was 4.1.59 the version with that filefunctions error we discussed recently? The line numbers are different, to delete and replace it with the current one.
The site is also extremely slow even though my server load is low.
I was just talking to somebody who was having problems with their script (not wsn, one they are writing) and their problems were due to Liquid Web updat MySQL. At the moment they are still looking into it.
I checked my version which is 4.1.22-standard He was on 5.0 something. I just wondered what version MySQL you were on Paul, and it that would make a difference?
I see two toplists of 500 and 50 categories in the wrapper. plus a links toplist. Several more toplists in the main index template. Yes, I'd expect that to be slow.
Noticed one of my demos that still had FTP info entered (despite using suPHP) failed to overwrite some files. The ones that don't have FTP info upgrade properly. It must be wrongly attempting to use the FTP method. That fits with a problem I found in the deletefile function recently. Replace includes/filefunctions.php (again) before upgrading.
Paul wrote: Noticed one of my demos that still had FTP info entered (despite using suPHP) failed to overwrite some files. The ones that don't have FTP info upgrade properly. It must be wrongly attempting to use the FTP method. That fits with a problem I found in the deletefile function recently. Replace includes/filefunctions.php (again) before upgrading.
I replaced the filefunctions.php with the one from v.4.1.61. No difference.
I didn't realise I didn't have to put ftp info in! So, I removed that info and clicked upgrade. Well, I didn't get any error messages and it said it upgraded. However, going to the overview it is still telling me I am on 4.1.59 and to upgrade.
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on Site down can't access mysql
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Site was ok the other day. This morning gave 3 mysql errors. Couldn't remember if I had upgraded this site to 4.1.60 or not and I couldn't access the admin area either, so overwrote the schema file anyway. Still didn't work so thought I would do a manual upgrade.
Now I just get...
Cannot extract data from the database.
It seems that although we established a database connection we aren't able to access the database itself. It could be that the database is down (ask your web host about this), or that the mysql user doesn't have proper permissions to acces the database. MySQL returns this error:
WSN Links 4.1.61
Just to add that there is no problem with my database - I checked it and had my host check it too.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Check your config.php. Does it have your database info in it? If you did a manual upgrade using already-installed files instead of the exact contents of the zip, you would've overwritten your config.php and thus prevented your site from working.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Check your config.php. Does it have your database info in it? If you did a manual upgrade using already-installed files instead of the exact contents of the zip, you would've overwritten your config.php and thus prevented your site from working.
Yes, my config.php does have database info and it is correct.
No, I did not overwrite the config.php file when doing a manual upgrade, and yes I did use the exact contents of the latest zip file.
As I said, I only did a manual upgrade because I had 3 mysql errors reported.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Well if you'd told me what the debug of the mysql warnings was I'd know what's going on. As it is now, if if there are no longer any messages, site inspection is the only way to find out.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Thanks Paul, but I couldn't risk waiting so I deleted it all, and started a fresh install of v.4.1.59. I then restored my backup of a couple of days ago and got it all working ok.
However, once I was ready I then clicked upgrade to v.4.1.61 and got a load of the following errors for different files...
Warning: ftp_delete() [function.ftp-delete]: Could not delete admin/emailsubmitter.php: No such file or directory in /home/freewebb/public_html/includes/filefunctions.php on line 143
Complete debug in attached file.
All the files are in the ROOT, so I don't know why it is looking in admin for them.
The site is also extremely slow even though my server load is low.
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You must have a path wrong. Check your directory url and upload path, and admin directory name. Or was 4.1.59 the version with that filefunctions error we discussed recently? The line numbers are different, to delete and replace it with the current one.
The site is also extremely slow even though my server load is low.
How many queries per page?
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
All paths are correct
I replaced schemas/dbschema.wsn but that did not make a difference.
For the home page.... 30 total queries
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
I was just talking to somebody who was having problems with their script (not wsn, one they are writing) and their problems were due to Liquid Web updat MySQL. At the moment they are still looking into it.
I checked my version which is 4.1.22-standard He was on 5.0 something. I just wondered what version MySQL you were on Paul, and it that would make a difference?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
MySQL versions shouldn't make any difference, except that 3.x is slower. I'm running MySQL 5.0 on liquidweb.
Your slowness isn't during queries, it's because you have about 150 categories somehow involved in your front page. Is that a sitemap on the left?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I see two toplists of 500 and 50 categories in the wrapper. plus a links toplist. Several more toplists in the main index template. Yes, I'd expect that to be slow.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Is that a sitemap on the left?
No - it's a toplist. I had a sitemap when I first started but you told me to change it to a toplist
I still can't upgrade
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
What message do you get?
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
What message do you get?
Please see post #5 above, which gives you the error messages and debug. I tried again just now and got the same thing, only the times were longer.
In system configuration both site details and installation url are correct and pointing to the root.
Admin directory name is admin
FTP details are correct
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Noticed one of my demos that still had FTP info entered (despite using suPHP) failed to overwrite some files. The ones that don't have FTP info upgrade properly. It must be wrongly attempting to use the FTP method. That fits with a problem I found in the deletefile function recently. Replace includes/filefunctions.php (again) before upgrading.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Noticed one of my demos that still had FTP info entered (despite using suPHP) failed to overwrite some files. The ones that don't have FTP info upgrade properly. It must be wrongly attempting to use the FTP method. That fits with a problem I found in the deletefile function recently. Replace includes/filefunctions.php (again) before upgrading.
I replaced the filefunctions.php with the one from v.4.1.61. No difference.
I didn't realise I didn't have to put ftp info in! So, I removed that info and clicked upgrade. Well, I didn't get any error messages and it said it upgraded. However, going to the overview it is still telling me I am on 4.1.59 and to upgrade.