1.4.1 to 1.5.1 upgrade error

[chaozz]

it should not be hard to find out the total amount of posts for every member? right? how would i do this?

[[Unknown]]

SELECT COUNT(ID_MSG)
FROM messages
GROUP BY ID_MEMBER;

-[Unknown]

[Gere]

I have a problem too, when upgrading the upgrade.php stops at upgrade.php?continue=2
it start loading normally but in the ends in The page cannot be displayed.

result: database error when entering boards

It loads always about 10 secs and then gives the page cannot be displayed, could this be caused by some kind of server timeout setting? Can I do the second part of the upgrade manually?

[[Unknown]]

I have a problem too, when upgrading the upgrade.php stops at upgrade.php?continue=2
it start loading normally but in the ends in The page cannot be displayed.

result: database error when entering boards

It loads always about 10 secs and then gives the page cannot be displayed, could this be caused by some kind of server timeout setting? Can I do the second part of the upgrade manually?

You can, but it'd be a pain.  You might try downloading the database, and then locally upgrading.

-[Unknown]

[Gere]

That would be pain too with my 100 mb database and my 56k modem  

[[Unknown]]

That would be pain too with my 100 mb database and my 56k modem  

Well, you can try deleting all the errors from your error log.... that might help somewhat.

At least, that would make the conversion easier on your server.

-[Unknown]

[chaozz]

one last minor request.

the query works perfect, but it doenst display to which user it belongs. the order is not the order of my member list. could any adjust the query so that is does this:

username, posts

[Gere]

Works fine now, installed apache and php on my computer and connected my mysql.
The problem seemed to be log_topics (10mb)

[chaozz]

yess!!! i figured it out!

SELECT DISTINCTROW yabbse_members.memberName, Count( * )
FROM yabbse_members
LEFT JOIN yabbse_messages ON yabbse_members.ID_MEMBER = yabbse_messages.ID_MEMBER
GROUP BY yabbse_members.memberName LIMIT 0 , 30

good old access 2000..