Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (Ruben, isaac, Gizmo), 49 guests, and 382 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 82
Joined: September 2008
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 16
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
Moving Database from MySQL 4.0 to 5.0 #252562
03/31/13 02:52 PM
03/31/13 02:52 PM
Joined: Oct 2006
Posts: 142
Louisiana
tonto69 Offline OP
member
tonto69  Offline OP
member
Joined: Oct 2006
Posts: 142
Louisiana
I use 1&1 hosting and they are requiring that all databases using 4.0 be moved to 5.0. I followed their tutorial but I am getting the following error. Any assistance would be greatly appreciated!
[img:left][Linked Image][/img]

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Moving Database from MySQL 4.0 to 5.0 [Re: tonto69] #252564
04/01/13 11:28 AM
04/01/13 11:28 AM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Online yawn

Ruben  Online Yawn


Joined: Dec 2003
Posts: 5,827
Lutz,FL
I don't know what they told you to do in the tutorial.
But ubb works on PHP 5 as is.
There should be no reason you need to re-create tables.
And maybe the error in your case is that you did not add the dbase name to the query so it has no idea what dbase the table would belong to. Or did not have the dbase open at the time.


Confused.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Moving Database from MySQL 4.0 to 5.0 [Re: tonto69] #252573
04/02/13 09:40 PM
04/02/13 09:40 PM
Joined: Oct 2006
Posts: 142
Louisiana
tonto69 Offline OP
member
tonto69  Offline OP
member
Joined: Oct 2006
Posts: 142
Louisiana
thank you for your reply...so you're saying ubb doesn't use mysql at all? what about the database for the usernames etc?

Re: Moving Database from MySQL 4.0 to 5.0 [Re: tonto69] #252576
04/03/13 01:21 PM
04/03/13 01:21 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Online yawn

Ruben  Online Yawn


Joined: Dec 2003
Posts: 5,827
Lutz,FL
Originally Posted by tonto69
thank you for your reply...so you're saying ubb doesn't use mysql at all? what about the database for the usernames etc?


I never said that.
It does use mysql

The current UBB version or I should say the 7X series is already compatible with MYSql version 5 as well as php 5.
PHP 4.3+
MySQL 4 or 5

As noted at:

https://www.ubbcentral.com/
Look on the left side of the page for requirements.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Moving Database from MySQL 4.0 to 5.0 [Re: tonto69] #252577
04/03/13 02:08 PM
04/03/13 02:08 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Online yawn

Ruben  Online Yawn


Joined: Dec 2003
Posts: 5,827
Lutz,FL
I also see from your signature that you are using v7.2.
There are several security patches as well as some enhancements compared to the current version available.


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,540
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)