Previous Thread
Next Thread
Print Thread
Hop To
Upgrade problems #177221 02/03/2007 11:43 AM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
Quote:
Updating step to 7 .... OK
Converting ubbt_ONLINE to a memory (heap) table... FAILED
SQL Query: alter table ubbt_ONLINE type=heap
Reason for failure: The used table type doesn't support BLOB/TEXT columns
Upgrade Step: /install/upgrade.php?step=altertable



Ok now what? am in the middle fo the upgrade, can i open the forums and shut off the who's online?


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177224 02/03/2007 11:52 AM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Do you have mod installed that has altered the ubbt_ONLINE table? The default online table doesn't have a blob or text field. If so, you'll need to uninstall the mod and then drop that field. At that point you can continue with the upgrade.

Re: Upgrade problems [Re: Rick] #177226 02/03/2007 11:57 AM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
I don't recall modifying that...

SHould I reinstall one of the php files or is it in the database, ?


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177227 02/03/2007 12:05 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Well, try this. You'll need to run this SQL command, either directly from within MySQL on the server or using something like phpmyadmin.

show fields from ubbt_ONLINE

Re: Upgrade problems [Re: Stan] #177228 02/03/2007 12:13 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
Here is a screen shot of the results after that commane [Linked Image]

Someone should take away my keyboard frown


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177230 02/03/2007 12:32 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Well, that doesn't make much sense. No blob/text fields in there, so the error message I don't understand. Can you try running this query from within phpmyadmin:

alter table ubbt_ONLINE type=heap

Re: Upgrade problems [Re: Rick] #177231 02/03/2007 12:35 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
If it still gives you that error, maybe try deleting everything from the table first.

delete from ubbt_ONLINE

Re: Upgrade problems [Re: Rick] #177233 02/03/2007 12:45 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
I did the delete from ubbt_ONLINE

and ran through the install again... same error

I have double checked that i am using the right mysql
[Linked Image]


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177234 02/03/2007 12:48 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
I was working on the beta database before, but had the same problems when i was working on the right database


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177236 02/03/2007 12:49 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
I'm a bit stumped. Let's see if it's something related to that specific table or if it's all tables. The TOPIC_VIEWS is converted to a heap table in the next step. So, try running this query:

alter table ubbt_TOPIC_VIEWS type=heap

Re: Upgrade problems [Re: Rick] #177237 02/03/2007 12:54 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
got this
[Linked Image]

Still a no go..


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177238 02/03/2007 12:56 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Hmm, did it give an error? Maybe I'm missing something from the screenshot, but I don't see any info other than the sql command itself.

Last edited by Rick; 02/03/2007 12:59 PM. Reason: Oopss...bad typo ;)
Re: Upgrade problems [Re: Stan] #177239 02/03/2007 12:57 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
jsut to assure you that I am in the right database, I did have the control panel page open BEFORE the upgrade, so I can still work in there
[Linked Image]

and
a
screen shot of the error page
[Linked Image]


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Rick] #177240 02/03/2007 12:58 PM
Joined: Aug 2006
Posts: 1,640
jgeoff Offline
Pooh-Bah
Offline
Pooh-Bah
Joined: Aug 2006
Posts: 1,640
Originally Posted by Rick
Maybe I'm missing something from the screensh*t,


whistle laugh


Last edited by jgeoff; 02/03/2007 1:01 PM. Reason: Fixed lol

GangsterBB.NET (Ver. 7.6.1.1)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Chrome, Firefox, & Safari (iPhone); No IE, ever!
Re: Upgrade problems [Re: Rick] #177241 02/03/2007 12:59 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
Originally Posted by Rick
Hmm, did it give an error? Maybe I'm missing something from the screenshot, but I don't see any info other than the sql command itself.


No errors


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: jgeoff] #177242 02/03/2007 1:01 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Originally Posted by jgeoff
Originally Posted by Rick
Maybe I'm missing something from the screenshit,


whistle laugh


Oops wink

Re: Upgrade problems [Re: Stan] #177243 02/03/2007 1:03 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Ok, to make sure we're on the same page here. When you run the following queries from within phpmyadmin the first errors but the second does not?

alter table ubbt_ONLINE type=heap <--- results in an error

alter table ubbt_TOPIC_VIEWS type=heap <--- Does not result in an error

Re: Upgrade problems [Re: Rick] #177244 02/03/2007 1:05 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
here is a screenSHOT ( smile ) from phpmyadmin
[Linked Image]
if that is useful to look at

BTW I appreciate the change that this does not send us our own posts any more, Thanks Yoou!!!


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177245 02/03/2007 1:07 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Ok, I see the issue. Your ONLINE_AGENT and your ONLINE_REFERER are text type. These are supposed to be varchar(255).

You'll need to run the following SQL commands to change those.

alter table ubbt_ONLINE
change ONLINE_AGENT ONLINE_AGENT varchar(255),
change ONLINE_REFERER ONLINE_REFERER varchar(255)

Re: Upgrade problems [Re: Rick] #177247 02/03/2007 1:14 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
Originally Posted by Rick
Ok, to make sure we're on the same page here. When you run the following queries from within phpmyadmin the first errors but the second does not?

alter table ubbt_ONLINE type=heap <--- results in an error

alter table ubbt_TOPIC_VIEWS type=heap <--- Does not result in an error


Correct [Linked Image]
[Linked Image]


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177248 02/03/2007 1:15 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
Got this error
[Linked Image]


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177249 02/03/2007 1:16 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
I really appreciate your help...


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177250 02/03/2007 1:22 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Ok, so this is definitely caused by some earlier modification. So, you'll need to run a couple of queries.

alter table ubbt_ONLINE drop ONLINE_REFER

then

alter table ubbt_ONLINE
change ONLINE_AGENT ONLINE_AGENT varchar(255),
add ONLINE_REFERER varchar(255)


You could probably do those in the same query, but we'll keep them separate just to make things a bit easier to follow what's happening.

Re: Upgrade problems [Re: Rick] #177252 02/03/2007 1:28 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
There must be a mod on here or on https://www.ubbdev.com/ that is unsafe, I am sure others will have the problems
..

I am sorry the extra work this caused you, hopefully it can help anyone else who used that..

Thanks again... it looks like the forum is upgrading now...


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177254 02/03/2007 1:29 PM
Joined: Jun 2006
Posts: 869
Stan Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 869
PS have you ever poked anyone in their eyes with a needle for doing this?

or anything like that??


http://clubadventist.com/forums

No longer following the carrot
Re: Upgrade problems [Re: Stan] #177256 02/03/2007 1:32 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Glad we got that figured out. We used to run into this a lot before I stressed custom field names for modifications. I just made another post here to remind people of that. wink

Re: Upgrade problems [Re: Rick] #177264 02/03/2007 2:17 PM
Joined: Jun 2006
Posts: 3,837
Ian Offline
Carpal Tunnel
Offline
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837
btw - what was the mod?

Re: Upgrade problems [Re: Ian] #179367 02/24/2007 4:50 PM
Joined: Jun 2006
Posts: 742
JoshPet Offline
enthusiast
Offline
enthusiast
Joined: Jun 2006
Posts: 742
Probably that old Online User Agent mod, or the mod that was called Enhanced Who's Online JustDave did years ago. It used to track user agents and referrers and such. Someone must have updated it for 7.


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Exceeded Number of attachments
by rbrtgrmn - 11/02/2019 9:57 PM
Forum New User Registration
by kf6zpl - 10/25/2019 10:45 AM
Having issue with redirects to UBB classic URLs
by amciotola - 10/16/2019 12:11 AM
Who's Online Now
2 registered members (isaac, M4TT), 84 guests, and 413 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)