[Done 1.4.x & 1.3.x] Speedup your Boardindex NEW Version 2!

[Compuart]

They might show some extra load. It's always a trade-off between speed and resources. But in most cases the PHP-MySQL connection is the bottleneck. At large forums this bottleneck cannot be stretched very much, while the resources can. For smaller forums the amount of resources hardly plays a role, and speed prevails

[TheJkWhoSaysNi]

Help! i just installed this mod and it has wiped my "Installed Mods" settings and reset them all to blank, i cannot edit them

What should i do?

[Compuart]

Help! i just installed this mod and it has wiped my "Installed Mods" settings and reset them all to blank, i cannot edit them

What should i do?

Are you sure you uploaded the modified index.php as well?

[Behr]

After applying this mod, the allowed user mod doesnt work display a blank page after u press allowed user button from the Mod settings page.
Can you fix this?

YABBSE ver 1.4.1

[TheJkWhoSaysNi]

Help! i just installed this mod and it has wiped my "Installed Mods" settings and reset them all to blank, i cannot edit them

What should i do?

Are you sure you uploaded the modified index.php as well?

Aha! thanks.. diddnt see that was modified, i just uploaded the sources folder.

but now i get an error where the "Topic Summary" should be

2: mysql_num_rows(): supplied argument is not a valid MySQL result resource
(/websites/hosted/ud/board/Sources/Post.php ln 885)

I have tried reuploading the original post.php and the modified one

[riekl]

Ok just installed .. i screwed something up tho .. this is what my IM look like now

http://dmaw.avalys.com/missing.doc

Where did i go wrong ?

[Juana]

i got this error :

2: Supplied argument is not a valid MySQL result resource
(c:\apache\apache\htdocs\yabbse\Sources\BoardIndex.php ln 167)

what should i do ?

[smacktalk]

I get this error:

Board 1 updated!
Board 7 updated!
Board 10 updated!
Board 11 updated!
Board 12 updated!
Board 13 updated!
Board 14 updated!
Error updating the DB. SQL Error: You have an error in your SQL syntax near ''msgtime') ' at line 1

[smacktalk]

:BUMP:

[groundup]

don't worry about bumping this, this will be in 1.5.0 so it isn't lost

[PioneeR]

I have moved over to Rochen. My forum is 1.3.1. Quite heavily modded to.

As requested by Rochen, have to install this mod.

Is it still incompatible with the Allower User Mod?

Would it be best for me to wait until 1.5 is out and then go with that?

Thanks

[Compuart]

but now i get an error where the "Topic Summary" should be

2: mysql_num_rows(): supplied argument is not a valid MySQL result resource
(/websites/hosted/ud/board/Sources/Post.php ln 885)

I have tried reuploading the original post.php and the modified one

This part of the Post.php isn't edited by the speedup mod. So it's not likely the mod has caused the error.

After applying this mod, the allowed user mod doesnt work display a blank page after u press allowed user button from the Mod settings page.
Can you fix this?

YABBSE ver 1.4.1

For the moment I don't have enough time to support this mod combined with other mods  

Ok just installed .. i screwed something up tho .. this is what my IM look like now

http://dmaw.avalys.com/missing.doc

Where did i go wrong ?

this seems to be a bug in the mod. To fix:

replace (InstantMessages):

Code Select Expand

   $request = mysql_query("SELECT ID_IM, fromname, subject, body, msgtime FROM {$db_prefix}instant_messages WHERE ID_MEMBER_TO=$ID_MEMBER AND deletedBy!=1 ORDER BY msgtime");by:

Code Select Expand

   $request = mysql_query("SELECT ID_IM, fromName, subject, body, msgtime FROM {$db_prefix}instant_messages WHERE ID_MEMBER_TO=$ID_MEMBER AND deletedBy!=1 ORDER BY msgtime");

Error updating the DB. SQL Error: You have an error in your SQL syntax near ''msgtime') ' at line 1

this line doesn't seem to work on all systems. There will not be problems when this query is omitted though. To fix:

replace (SpeedUpBoardIndex.php):

Code Select Expand

$result4 = mysql_query("ALTER TABLE {$db_prefix}instant_messages ADD INDEX ('msgtime') ");by:

Code Select Expand

$result4 = mysql_query("ALTER TABLE {$db_prefix}instant_messages ADD INDEX (msgtime) ");

[Compuart]

Released version 2.3 fixing the two bugs mentioned above.

I also added a full installation of YaBB SE 1.4.1 including the speedup mod to the download list. This mod will (by default) be included with YaBB SE 1.5.0

[groundup]

replace (InstantMessages):

Code Select Expand

   $request = mysql_query("SELECT ID_IM, fromname, subject, body, msgtime FROM {$db_prefix}instant_messages WHERE ID_MEMBER_TO=$ID_MEMBER AND deletedBy!=1 ORDER BY msgtime");by:

Code Select Expand

   $request = mysql_query("SELECT ID_IM, fromName, subject, body, msgtime FROM {$db_prefix}instant_messages WHERE ID_MEMBER_TO=$ID_MEMBER AND deletedBy!=1 ORDER BY msgtime");

is it just me or is that the same thing?

[Daniel D.]

It's the same. I thought it should be something with "ID_IM" ??