|
Joined: Jun 2006
Posts: 869
old hand
|
old hand
Joined: Jun 2006
Posts: 869 |
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?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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.
|
|
|
|
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, ?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
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 Someone should take away my keyboard 
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
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/Picture 8.png)
|
|
|
|
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
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
Joined: Jun 2006
Posts: 869
old hand
|
old hand
Joined: Jun 2006
Posts: 869 |
got this Still a no go..
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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 12:59 PM. Reason: Oopss...bad typo ;)
|
|
|
|
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 and a screen shot of the error page ![[Linked Image from clubadventist.com]](http://clubadventist.com/Picture 14.png)
|
|
|
|
Joined: Aug 2006
Posts: 1,649 Likes: 1
Pooh-Bah
|
Pooh-Bah
Joined: Aug 2006
Posts: 1,649 Likes: 1 |
Maybe I'm missing something from the screensh*t, 
Last edited by jgeoff; 02/03/2007 1: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
|
|
|
|
Joined: Jun 2006
Posts: 869
old hand
|
old hand
Joined: Jun 2006
Posts: 869 |
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
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Maybe I'm missing something from the screenshit,  Oops 
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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
|
|
|
|
Joined: Jun 2006
Posts: 869
old hand
|
old hand
Joined: Jun 2006
Posts: 869 |
here is a screenSHOT (  ) from phpmyadmin 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!!!
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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)
|
|
|
|
Joined: Jun 2006
Posts: 869
old hand
|
old hand
Joined: Jun 2006
Posts: 869 |
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]](http://clubadventist.com/Picture 18.png)
|
|
|
|
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/Picture 19.png)
|
|
|
|
Joined: Jun 2006
Posts: 869
old hand
|
old hand
Joined: Jun 2006
Posts: 869 |
I really appreciate your help...
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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.
|
|
|
|
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...
|
|
|
|
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??
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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. 
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
|
|
|
|
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.
|
|
|
2 members (Gizmo, 1 invisible),
198
guests, and
94
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|