Try going to http://myurl.com/myforums/phpinfo.php
If that file is there, it should tell you what the MySQL version number is.

If it is not, you can download the attached file from this message, rename it to mysqlver.php and upload it your main forums directory. Go to it in a browser and it will tell you the version number.

k thx

mysql is on version

MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.22-beta
MYSQL_INCLUDE
MYSQL_LFLAGS
MYSQL_LIBS

Odd...SUBSTRING() was added in v3.22.4. And my testbed is running the same version of MySQL as you are and it works fine for me...Maybe try reuploading commbull.php.

I honestly cannot think of any reason why it wouldn't work.

I'm getting the same error on the birthday query, and I'm running MySQL 3.22.32

The workaround is not to use the birthday feature of commbull :(

If you are running 3.22.32 that would explain it: substring wasn't added until 3.22.4.

I'll look into some other way to do it.

Thanks!
I'm not ready to upgrade MySQL eventhough I would like to. But I'm too stupid for that :(

Couple questions, observations:

What are "blocks"....block 1, block 2, etc?

I noticed that the dates shown for new thread replies are all 1-18-2038?????? Is this some kind of Y2K bug somewhere??

Blocks allow you to present different sets of threads, sorted in different manners. For example, you could set the first block to "no replies" and the second to "most replies" and you would get two different sets of threads.

The date is a problem with the UBB5 -> vB import script.
Look here for a script to fix the dates. (Backup your database FIRST!) Upload it your admin directory and run it.

Tubeddog-

There's still a bug in the that script to update the date problem. I downloaded the new script you posted and still got a parse error on line 15. I had to change this line towards the bottom:

if ($i = $50) {
echo("Updated another 50 threads...continuing<br>");
$i = 0;

I changed the :

if ($i = $50) {

to be

if ($i = 50) {

NOTE: I took out the $ sign before the 50, then the script ran without problems.

Also, the hack works well in sending out the bulletin, but when you assign a copy to be saved in a particular Forum number, it doesn't save it. I assigned my username and in my profile, it shows that the bulletin is my last post, but when you click on the link, it can't find it.