Bug Nothing to Display

[Andy Dean]

I've been running InfernoShout Pro on my site for a few years now without issue. In the past week i''ve decided to update it to DBTech VbShout.

I've installed it and everything seems fine withe the exception that shouts simply will not post. Attemptimg to post a shout updates the active users box but not the shoutbox, that simply remains 'Nothing to Display...'

I've uploaded the files/reinstalled the XML several times but it still will not display shouts...

...Any help would be greatly appreciated!

 

[Fillip H.]

Did you CHMOD the directory as per the readme file?

 

[Andy Dean]

Did you CHMOD the directory as per the readme file?

Yes, all the text files in that folder are 644 though and i can't seem to be able to change them.

 

[Fillip H.]

Text files don't need to be chmodded, only the directory itself.

I'll check it out on your forum and post back if I need any more information / access

 

[Andy Dean]

Cheers! You'll need admin access 'cos it's only viewable by admins at the moment.

 

[Fillip H.]

It appears that I can't access the shoutbox as a newly registered user - could you please update my Fillip H. account to the required permissions?

 

[Andy Dean]

You should have admin permissions now Fillip H.

 

[Fillip H.]

I'll need an FTP account to check this out, could you PM me the info please?

 

[Andy Dean]

Sure Fillip, i'll PM you the details!

 

[Fillip H.]

The problem appears to be that your MySQL version is too old and doesn't support the sub-queries feature properly. This mod's only tested on MySQL 5.0.x, not 4.1.x.

Is there any way you can either upgrade MySQL yourself, or have your host do it for you? 4.1 is unsupported by MySQL for several years now, so I believe it'd be in your best interest to upgrade to a newer version

In the meantime, I have commented out the offending code from the /dbtech/vbshout_pro/includes/hooks/dbtech_vbshout_fetch_shouts_query.php

 

[Andy Dean]

Yeah, i have the ability to upgrade MySQl via WHM, it's just never occured to me to do it lol

I'll backup the Databases and upgrade to MySQL 5.1

Thank you very much for your help Fillip!

 

[Fillip H.]

No probs Don't forget to un-comment the code once the upgrade is complete