Question about mysql 5.2

Support for IntegraMOD 141

Moderator: Integra Moderator

Question about mysql 5.2

PostAuthor: Watcher » Sat Mar 07, 2009 11:31 am

My web host has just updated all servers to mysql 5.2, will 1.4.1 run on 5.2, im having issues about when i click on forum in the menu it trys to load (30 sec. or more) and it finishes and the page did not open, i just get a blank page (no error or any thing). i have to refresh 3 or 4 times to try and get page to open. web site seems to work alright it just wont open the page all the time, and thats about 70% of the time i get blank pages and have to refresh? has any one else had these problems, I use "Servage.net" for a web host. they were running mysql 4.1 till now.
[img=left]http://worldofarkania.net/Downloads/Sig_logo/Steal_Watcher.gif[/img]
User avatar
Watcher
Integra Member
Integra Member
 
Posts: 183
Likes: 0 post
Liked in: 0 post
Joined: Sun Nov 05, 2006 8:26 pm
Cash on hand: 0.00

Re: Question about mysql 5.2

PostAuthor: .QUACK.Major.Pain » Sat Mar 07, 2009 12:46 pm

I have a similiar problem at first.

I moved my site to a new host, and went from 4.2 I believe to 5.2.6

When I got everything moved and the site up, I found my pages stalled on the forum page, at the point between the Birthday announcement box and the lower qbar.

I would assume it was because it is going trough the entire database looking at those with a birthday.

Lately it has been much better. I guess the database may have optimize to the forum maybe.

If the birthday box becomes to laggy, I will be removing it because I think it's the culprit in my case.

But with 4.2, I don't recall that problem.

.QUACK.Major.Pain
Sr Integra Member
Sr Integra Member
 
Posts: 986
Likes: 0 post
Liked in: 0 post
Joined: Sat Jan 27, 2007 10:15 am
Cash on hand: 0.00

Re: Question about mysql 5.2

PostAuthor: Watcher » Sat Mar 07, 2009 5:23 pm

well my host was keeping 4.1 for those that had stuff that ran on 4.1. but 4 days ago the host updated all there server to 5.2, so now i have to upgrade to something that will work or someone to tell me what to fix.
[img=left]http://worldofarkania.net/Downloads/Sig_logo/Steal_Watcher.gif[/img]
User avatar
Watcher
Integra Member
Integra Member
 
Posts: 183
Likes: 0 post
Liked in: 0 post
Joined: Sun Nov 05, 2006 8:26 pm
Cash on hand: 0.00

Re: Question about mysql 5.2

PostAuthor: .QUACK.Major.Pain » Sat Mar 07, 2009 5:37 pm

If you installed originally for 4.x/5.x, it should work.
Have you optimized your site in ACP?

.QUACK.Major.Pain
Sr Integra Member
Sr Integra Member
 
Posts: 986
Likes: 0 post
Liked in: 0 post
Joined: Sat Jan 27, 2007 10:15 am
Cash on hand: 0.00

Re: Question about mysql 5.2

PostAuthor: Watcher » Sat Mar 07, 2009 7:35 pm

ya but still get blank page loads
i thought i heard that 1.4.1 wasnt compatable with mysql 5 but i havent been reading on it in a while
[img=left]http://worldofarkania.net/Downloads/Sig_logo/Steal_Watcher.gif[/img]
User avatar
Watcher
Integra Member
Integra Member
 
Posts: 183
Likes: 0 post
Liked in: 0 post
Joined: Sun Nov 05, 2006 8:26 pm
Cash on hand: 0.00

Re: Question about mysql 5.2

PostAuthor: .QUACK.Major.Pain » Sat Mar 07, 2009 7:51 pm

I;m using 5.0.67 for mysql

.QUACK.Major.Pain
Sr Integra Member
Sr Integra Member
 
Posts: 986
Likes: 0 post
Liked in: 0 post
Joined: Sat Jan 27, 2007 10:15 am
Cash on hand: 0.00

Re: Question about mysql 5.2

PostAuthor: Watcher » Sat Mar 07, 2009 11:06 pm

looking over the statis of my forum it says the mysql is 4.0.26-standard but the host updated to 5.2 so it could be its trying to run the forum on 4.0.26-standard but its not there? how would i tell the forum that its useing 5.2?
[img=left]http://worldofarkania.net/Downloads/Sig_logo/Steal_Watcher.gif[/img]
User avatar
Watcher
Integra Member
Integra Member
 
Posts: 183
Likes: 0 post
Liked in: 0 post
Joined: Sun Nov 05, 2006 8:26 pm
Cash on hand: 0.00

Re: Question about mysql 5.2

PostAuthor: Watcher » Sat Mar 07, 2009 11:21 pm

looking over the statis of my forum it says the mysql is 4.0.26-standard but the host updated to 5.2 so it could be its trying to run the forum on 4.0.26-standard but its not there? how would i tell the forum that its useing 5.2?

this is from my forum statis

Version information
Version of the Board: 2.0.23
Version of DB Maintenance: 1.2.2c
Version of PHP: 4.3.11
Version of MySQL: 4.0.26-standard


after reading a email from them im wrong its not mysql 5.2 its this

For security reasons PHP v4 support will be discontinued. Instead PHP v5.2 will be default on all clusters - for most customers this will not cause any problems. If you are using old scripts you may want to upgrade them to ensure they work under PHP 5.2.

Thank you for your understanding.


thisd is the info from mysql page

mysql1044.servage.net

* Server version: 4.0.26-standard
* Protocol version: 10
* Server: mysql1044.servage.net via TCP/IP


phpMyAdmin - 2.10.0.2

Server:mysql1044.servage.net:xxxxx
* MySQL client version: 5.0.51a
* Used PHP extensions: mysql
[img=left]http://worldofarkania.net/Downloads/Sig_logo/Steal_Watcher.gif[/img]
User avatar
Watcher
Integra Member
Integra Member
 
Posts: 183
Likes: 0 post
Liked in: 0 post
Joined: Sun Nov 05, 2006 8:26 pm
Cash on hand: 0.00


Return to IntegraMOD 141

Who is online

Registered users: Bing [Bot], Google [Bot], Helter, Majestic-12 [Bot]