Previous Thread
Next Thread
Print Thread
Hop To
#203759 12/23/2007 8:08 PM
Joined: May 2007
Posts: 50
journeyman
journeyman
Joined: May 2007
Posts: 50
ok
I uploaded a fresh copy ubbthreads 6.5.5
I'v run a few of the alt table scripts

on the upgrade.php I get the following error
The following files do not exist in your install
(Make sure these are uploaded)templates/default/ubbt_instant_ubbcode.tmpl


The following files are reporting a wrong version #
(Make sure you updated these files)All files report proper version #.

The following files need to be removedAll files tagged for removal have been removed.

the file is there as it's a fresh copy
just trying to get my database updated so I can move on to 7.2.2
any idea's here

never mind got it to work

Last edited by dslam; 12/23/2007 8:20 PM.
dslam #203760 12/23/2007 8:21 PM
Joined: May 2007
Posts: 50
journeyman
journeyman
Joined: May 2007
Posts: 50
We cannot proceed.
Script: /home/boneyard/public_html/forum2/ubbt.inc.php
Line#: 1608
SQL Error: Unknown column 'U_OC_Userid' in 'field list'
SQL Error #: 1054
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.

ok finished the upgrade but I get this error
now whats wrong

dslam #203769 12/23/2007 11:39 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It looks like you missed a step perhaps. The U_OC_Userid field was added in the altertable-6-3-6.4.php script. Did this one get run? And if so, did it return any errors?

Rick #203770 12/23/2007 11:48 PM
Joined: May 2007
Posts: 50
journeyman
journeyman
Joined: May 2007
Posts: 50
I ran that one & it was fine
can I do it all over again or do I have to start over with another fresh 6.3 db ?

dslam #203788 12/24/2007 9:39 AM
Joined: May 2007
Posts: 50
journeyman
journeyman
Joined: May 2007
Posts: 50
here I ran it again to see
Adding a new table to save database queries that are used frequently from the admin section
Adding a new field to the Groups table to allow for disabling of groups.
Grabbing all old poll data for conversion.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boneyard/public_html/forum2/mysql.inc.php on line 140

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boneyard/public_html/forum2/mysql.inc.php on line 140
Dropping old poll tables and creating new ones for the updated poll system.
importing old poll data...
Adding a table for calendar events...
Altering the user's table to add a few new fields/preferences...
Altering the online table to store info a bit differently...
Altering the board's table to allow admin's to associate an image with a forum...
Altering the posts table so posts can be linked to a calendar event...
Reworking some indexes for speed, this may take awhile. You will get a few errors about indexes not being able to be dropped. This is ok, index names might be a bit different depending on when you installed but they will be dropped properly...
Creating a cache table for some things that don't change to often...
Creating a table to store version info to make future upgrades easier...
Done

same result still getting the same SQL Error: Unknown column 'U_OC_Userid' in 'field list'

Last edited by dslam; 12/24/2007 9:43 AM.
dslam #203794 12/24/2007 12:46 PM
Joined: May 2007
Posts: 50
journeyman
journeyman
Joined: May 2007
Posts: 50
ok lloks like alt table 6.3-6.4 did not add these lines
well thats what I'v found so far
board is up & running after adding these lines
now to check to see if anything else got left out

ALTER TABLE w3t_Users
ADD U_Birthday VARCHAR(10) NOT NULL DEFAULT '0',
ADD U_ShowBday INT(1) NOT NULL DEFAULT '0',
ADD U_TimeFormat VARCHAR(6),
ADD U_Ignored TEXT,
ADD U_OC_Userid VARCHAR(64),
ADD INDEX birthday_ndx (U_Birthday,U_ShowBday)

Last edited by dslam; 12/24/2007 12:46 PM.

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
1 members (Ruben), 1,248 guests, and 268 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)