Previous Thread
Next Thread
Print Thread
Hop To
#177221 02/03/2007 12:43 PM
Joined: Jun 2006
Posts: 869
old hand
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
Stan #177224 02/03/2007 12:52 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Rick #177226 02/03/2007 12:57 PM
Joined: Jun 2006
Posts: 869
old hand
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
Stan #177227 02/03/2007 1:05 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Stan #177228 02/03/2007 1:13 PM
Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869
Here is a screen shot of the results after that commane [Linked Image from clubadventist.com]

Someone should take away my keyboard frown


http://clubadventist.com/forums

No longer following the carrot
Stan #177230 02/03/2007 1:32 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Rick #177231 02/03/2007 1:35 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
If it still gives you that error, maybe try deleting everything from the table first.

delete from ubbt_ONLINE

Rick #177233 02/03/2007 1:45 PM
Joined: Jun 2006
Posts: 869
old hand
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 from clubadventist.com]


http://clubadventist.com/forums

No longer following the carrot
Stan #177234 02/03/2007 1:48 PM
Joined: Jun 2006
Posts: 869
old hand
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
Stan #177236 02/03/2007 1:49 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Rick #177237 02/03/2007 1:54 PM
Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869
got this
[Linked Image from clubadventist.com]

Still a no go..


http://clubadventist.com/forums

No longer following the carrot
Stan #177238 02/03/2007 1:56 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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 1:59 PM. Reason: Oopss...bad typo ;)
Stan #177239 02/03/2007 1:57 PM
Joined: Jun 2006
Posts: 869
old hand
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 from clubadventist.com]

and
a
screen shot of the error page
[Linked Image from clubadventist.com]


http://clubadventist.com/forums

No longer following the carrot
Rick #177240 02/03/2007 1:58 PM
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1
Originally Posted by Rick
Maybe I'm missing something from the screensh*t,


whistle laugh


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

GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Rick #177241 02/03/2007 1:59 PM
Joined: Jun 2006
Posts: 869
old hand
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
jgeoff #177242 02/03/2007 2:01 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Originally Posted by jgeoff
Originally Posted by Rick
Maybe I'm missing something from the screenshit,


whistle laugh


Oops wink

Stan #177243 02/03/2007 2:03 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

Rick #177244 02/03/2007 2:05 PM
Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869
here is a screenSHOT ( smile ) from phpmyadmin
[Linked Image from clubadventist.com]
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
Stan #177245 02/03/2007 2:07 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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)

Rick #177247 02/03/2007 2:14 PM
Joined: Jun 2006
Posts: 869
old hand
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 from clubadventist.com]
[Linked Image from clubadventist.com]


http://clubadventist.com/forums

No longer following the carrot
Stan #177248 02/03/2007 2:15 PM
Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869
Got this error
[Linked Image from clubadventist.com]


http://clubadventist.com/forums

No longer following the carrot
Stan #177249 02/03/2007 2:16 PM
Joined: Jun 2006
Posts: 869
old hand
old hand
Joined: Jun 2006
Posts: 869
I really appreciate your help...


http://clubadventist.com/forums

No longer following the carrot
Stan #177250 02/03/2007 2:22 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Rick #177252 02/03/2007 2:28 PM
Joined: Jun 2006
Posts: 869
old hand
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
Stan #177254 02/03/2007 2:29 PM
Joined: Jun 2006
Posts: 869
old hand
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
Stan #177256 02/03/2007 2:32 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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

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

Ian #179367 02/24/2007 5:50 PM
Joined: Jun 2006
Posts: 742
enthusiast
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

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (rootman), 641 guests, and 112 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)