Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (isaac, Gizmo, dimaninc), 64 guests, and 399 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Mark S
Mark S
Liverpool : England : UK
Posts: 4,704
Joined: July 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 18
M4TT 12
FREAK 11
Ruben 8
mmkk 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Error message installing UBBThreads #243877
06/12/11 04:02 PM
06/12/11 04:02 PM
Joined: Jun 2011
Posts: 9
T
thor Offline OP
stranger
thor  Offline OP
stranger
T
Joined: Jun 2011
Posts: 9
Hello everyone,

I still have a license for UBBThreads 6.5.2 and just wanted to install it on my server. However I got the following error message

Quote:
Creating the tables...

We cannot proceed.
Script: /home/thorsten/public_html/forum/ubbt.inc.php
Line#: 1588
SQL Error: Table 'thorsten_ubb.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 = ''

Please use your back button to return to the previous page.


Would someone be able to help me. What do I need to fix and why does this error show up?

Re: Error message installing UBBThreads [Re: thor] #243906
06/14/11 01:41 PM
06/14/11 01:41 PM
Joined: Jul 2006
Posts: 2,199
David Dreezer Offline

Pooh-Bah
David Dreezer  Offline

Pooh-Bah
Joined: Jul 2006
Posts: 2,199
Table 'thorsten_ubb.w3t_Users' doesn't exist

Did you run the installer and did it create the tables for you? That error message indicates not.


This thread for sale. Click here! [Linked Image]
Re: Error message installing UBBThreads [Re: thor] #244053
06/26/11 04:51 AM
06/26/11 04:51 AM
Joined: Jun 2011
Posts: 9
T
thor Offline OP
stranger
thor  Offline OP
stranger
T
Joined: Jun 2011
Posts: 9
Here's what I did.

1) I went to the install directory and clicked on full new installation.

Main Directory
main.inc.php PASSED
config.inc.php PASSED
theme.inc.php PASSED
sessions directory PASSED
includes/.php files PASSED
stylesheets/all PASSED
images/icons/all PASSED
images/graemlins/all PASSED
All checks passed.

2) Step 2: I entered the information of my database.

Connecting to server PASSED
Connecting to database PASSED
Creating a table PASSED
Dropping a table PASSED
All test passed

3) Step 4 is to gather information on the paths and url.

phpurl PASSED
images PASSED
styledir PASSED
path PASSED
imagepath PASSED
stylepath PASSED
All checks passed.

4) Step 6
All config files have been created. You may now proceed to creating the database tables.

THIS IS WHERE THE ERROR MESSAGE SHOWS UP:

Creating the tables...
Board table created...

We cannot proceed.
Script: /home/thorsten/public_html/ubbthreads/ubbt.inc.php
Line#: 1588
SQL Error: Table 'thorsten_dattabase.ubbthreads_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 ubbthreads_Users WHERE U_Number = ''

Please use your back button to return to the previous page.


Any ideas what I can do?

Re: Error message installing UBBThreads [Re: thor] #244063
06/26/11 11:10 PM
06/26/11 11:10 PM
Joined: Jan 2008
Posts: 547
DE USA
Dunny Offline
addict
Dunny  Offline
addict
Joined: Jan 2008
Posts: 547
DE USA
I would check your mysql db user and password that you are using and make sure it is correct for that database with the correct permissions. Looks like it can't connect to it. (I saw that it passed first, but it isn't writing to it for some reason).

Dunny


Dunny

Removed link due to bleedover spammers

Dawn of Iskirra
Re: Error message installing UBBThreads [Re: thor] #244065
06/27/11 02:41 AM
06/27/11 02:41 AM
Joined: Jun 2011
Posts: 9
T
thor Offline OP
stranger
thor  Offline OP
stranger
T
Joined: Jun 2011
Posts: 9
The database is correct. I'Ve tried it twice with two different databases and have installed another message board software just to make sure. That one was able to write the table.

Any other suggestions?

I'm a bit disappointed. I bought the software 4 years ago and paid 200 dollars for it - and now it's not working anymore?

Re: Error message installing UBBThreads [Re: thor] #244066
06/27/11 03:46 AM
06/27/11 03:46 AM
Joined: Jan 2008
Posts: 547
DE USA
Dunny Offline
addict
Dunny  Offline
addict
Joined: Jan 2008
Posts: 547
DE USA
I am sure it works. Not sure what is going on with your boards. I am fairly sure you did not by version 6.x threads 2 years ago for any price as 2 years ago the only one you could actually perchase was the 7.x versions.

However, something is going on with your install then, and you may have to wait for Giz or SD to look at what your error is. I would take a look at the possibility of a corrupt file upload and would try to DL the software again just to be sure.


Dunny

Removed link due to bleedover spammers

Dawn of Iskirra
Re: Error message installing UBBThreads [Re: thor] #244067
06/27/11 03:50 AM
06/27/11 03:50 AM
Joined: Jun 2011
Posts: 9
T
thor Offline OP
stranger
thor  Offline OP
stranger
T
Joined: Jun 2011
Posts: 9
Thanks for your suggestions. I have uploaded the software twice already and got the same error messages.

I bought UBB.threads version 6 four years ago. I think it was late 2007. I have the receipt somewhere.

Does anyone know if I can download the software again. Maybe there really was a mistake in that file?

Re: Error message installing UBBThreads [Re: thor] #244068
06/27/11 12:10 PM
06/27/11 12:10 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
Something is odd on your two posts.
they each show a different database name.
Your first post it is:
thorsten_ubb.w3t_Users
Your second post is:
thorsten_dattabase.ubbthreads_Users

Are you trying to use a existing database with data in it?
If so you would not run the install script?

As far as a download goes you would need to pay for member access.
ubb6 is there but it is a discontinued product.
But by paying for member access with your current license you would have access to the current version 7.5.6. as well.

Last edited by Ruben; 06/27/11 12:19 PM. Reason: Added comment

Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Error message installing UBBThreads [Re: thor] #244069
06/27/11 12:18 PM
06/27/11 12:18 PM
Joined: Jun 2011
Posts: 9
T
thor Offline OP
stranger
thor  Offline OP
stranger
T
Joined: Jun 2011
Posts: 9
Yes, that is because I tried the installation twice. The prefix for the database table is also different too because I thought maybe I had not been allowed to change it.
But either way, it produces the same error message.

Re: Error message installing UBBThreads [Re: thor] #244070
06/27/11 12:29 PM
06/27/11 12:29 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
I am not to familiar with ubb6 I skipped over it from classic to v7.
But anyway.First thing I would check is the user rights assigned to the database. I usually assign all global rights to the user.

I would then start over from scratch.
Meaning wipe it all and start over.
Or move your working existing board to the new server.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Error message installing UBBThreads [Re: thor] #244071
06/27/11 12:30 PM
06/27/11 12:30 PM
Joined: Jun 2011
Posts: 9
T
thor Offline OP
stranger
thor  Offline OP
stranger
T
Joined: Jun 2011
Posts: 9
I don't have a working existing board, it's a brand new installation. The database permissions are fine as I have installed two other forum software system, just to see if everything is fine with that.

Re: Error message installing UBBThreads [Re: thor] #244072
06/27/11 12:40 PM
06/27/11 12:40 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
So you installed two other ubb6.5.2 forum boards on the same server?
If you installed say other forum software that would have nothing to do with it. since I have no idea what privileges are required for the other software.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Error message installing UBBThreads [Re: thor] #244073
06/27/11 12:42 PM
06/27/11 12:42 PM
Joined: Jun 2011
Posts: 9
T
thor Offline OP
stranger
thor  Offline OP
stranger
T
Joined: Jun 2011
Posts: 9
No I installed two different message board systems. But it shows that permissions with the database are correct. I also checked with my host.

Re: Error message installing UBBThreads [Re: thor] #244074
06/27/11 01:08 PM
06/27/11 01:08 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
For ubb the user will need all permissions usually.
Quote:

ALTER
CREATE
CREATE ROUTINE
CREATE TEMPORARY TABLES
CREATE VIEW
DELETE
DROP
EXECUTE
INDEX
INSERT
LOCK TABLES
REFERENCES
SELECT
UPDATE

Then the only thing I can think of other that trying again from scratch is since the version you have is like from 2006 is it is very old and may not compatible with the newer versions of mysql or php you are using.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Error message installing UBBThreads [Re: thor] #244075
06/27/11 01:20 PM
06/27/11 01:20 PM
Joined: Jun 2011
Posts: 9
T
thor Offline OP
stranger
thor  Offline OP
stranger
T
Joined: Jun 2011
Posts: 9
It seems that ubbthreads version 6.5.2 was corrupt, because the support has just sent me version 6.5.5 and now I succeeded. I vaguley remember that I had the same problem four years ago when I installed the system back then... but I'm not 100% sure.

Re: Error message installing UBBThreads [Re: thor] #244076
06/27/11 01:36 PM
06/27/11 01:36 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
Good.
6.5.5 is jan 2006 so your version was prior and have no docs on that version so it could have been a bug on that version.
Probably due to newer versions of php/mysql or apache.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Error message installing UBBThreads [Re: thor] #244077
06/27/11 01:44 PM
06/27/11 01:44 PM
Joined: Jun 2011
Posts: 9
T
thor Offline OP
stranger
thor  Offline OP
stranger
T
Joined: Jun 2011
Posts: 9
Yes, I'm really glad that it is working now.

If the message board is successful and gets as much feedback as I hope it will get, I will of course upgrade to UBBthreads 7, but I'd like to test it first before spending the extra money.

I'm setting up the forums now and everything seems to be fine.

Re: Error message installing UBBThreads [Re: thor] #249462
06/07/12 08:45 PM
06/07/12 08:45 PM
Joined: Jun 2012
Posts: 3
M
Mac Botdorf Offline
stranger
Mac Botdorf  Offline
stranger
M
Joined: Jun 2012
Posts: 3
I am not to familiar with ubb6 I skipped over it from classic to v7.
But anyway.First thing I would check is the user rights assigned to the database. I usually assign all global rights to the user.

Re: Error message installing UBBThreads [Re: thor] #253101
06/24/13 03:55 PM
06/24/13 03:55 PM
Joined: Jun 2013
Posts: 4
M
mmedo6742 Offline
stranger
mmedo6742  Offline
stranger
M
Joined: Jun 2013
Posts: 4
The database is correct. I'Ve tried it twice with two different databases and have installed another message board software just to make sure. That one was able to write the table.

Any other suggestions?

I'm a bit disappointed. I bought the software 4 years ago and paid 200 dollars for it - and now it's not working anymore?

Re: Error message installing UBBThreads [Re: mmedo6742] #253102
06/24/13 04:38 PM
06/24/13 04:38 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
Originally Posted by mmedo6742
The database is correct. I'Ve tried it twice with two different databases and have installed another message board software just to make sure. That one was able to write the table.

Any other suggestions?

I'm a bit disappointed. I bought the software 4 years ago and paid 200 dollars for it - and now it's not working anymore?


Humm!
Surprised since the going price is 139.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,544
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)