UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support MySQL 5?

Does ubb.threads officially support MySQL 5.0 ? I'm trying to install 6.5.2 on an IIS server with PHP5 and MySQL 5. I got up to the createtable.php portion of the install process, it creates the boards table, but on the very next query dies on ubbt.inc.php:1588 because the users table doesn't exist yet (obviously). I'll work on figuring out why that's being called, but was just wondering if anyone had success with an iis/php5/mysql5 setup, or if this is a known problem.

well, I changed to a MySQL 4.1 db server, and everything went smooth sailing.

interesting, thank you for the headsup <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Was there ever a determination on wither a new install is supported by MySQL 5.0.15-nt? I'm trying to install a new installation of threads on a w2k3 web server and I'm getting the following error during the table creation process of threads v 6.5.2

"
We cannot proceed.

Script: C:\Inetpub\wwwroot\ubbthreads\ubbt.inc.php
Line#: 1588
SQL Error: Table 'ubbthreads.w3t_users' doesn't exist
SQL Error #: 1146
Query: SELECT U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned,U_LastOn,U_OC_Userid FROM w3t_Users WHERE U_Number = ''
"

You can see a copy of the error for yourself at http://bb.dibene.com/ubbthreads/ubbthreads.php

The installation is creating a table: w3t_boards

I am also using PHP 5.0.5 which was installed manually to support IIS 6.0 web services.

Thanks,

I got this to work but it took some effort.

The Online table needs to be created first. Followed by the Users table. I just cut and copied the table sections to the top right before the Board table section.

The all the other problems were when the script called for NOT NULL but the installation did not define the DEFAULT setting. I either defined a DEFAULT '<something>' setting based on the variable type, or I removed the NOT NULL text from the line.

I've don't have any idea what the ramifications are of my modifications, but I was able to get the script to execute and I have a working threads install.

>he all the other problems were when the script called for NOT NULL but the installation
>did not define the DEFAULT setting. I either defined a DEFAULT '<something>' setting
>based on the variable type, or I removed the NOT NULL text from the line.

This is an old problem stemming since a few versions before the latest...
It is puzzling why this still hasn't been fixed.

This problem extends beyond the installation. Creating forums (the header and footer checkbox) returns a NULL character instead of a '0'. The same goes for posting a new thread or reply. It seems like I have some work ahead of me in order to get this working properly based on my configuration.

It would seem that either MySQL 4 has poor error checking or that this installation really isn't designed for MySQL 5. However, I’m confident that I will eventually figure it out and get everything working…

You should not run on mySQL5 if your scripts not 100% tested with it. My provider rollback to mySQL4. E simple script kann do a table lockup under 5 witch riuns perfect under 4. He must restart nearly every hour the SQL server. Nearle every older board scripts (not only thread) locks tables and crash the server.
User mySQL5 with threads only in an enviroment with one site so you can track down all locks and resolve them. I fear there is no mre support by Infopop/Groupee on this and you find out your own whats going wrong.

If my "your scripts" you mean the ubb.threads php code, then I agree.

I've been finding the problems as I go through testing. I will get it working or give up and build a new box that I can install MySQL 4 onto.