Logo by mclarekin - Contribute your own Logo!

END OF AN ERA, FRACTALFORUMS.COM IS CONTINUED ON FRACTALFORUMS.ORG

it was a great time but no longer maintainable by c.Kleinhuis contact him for any data retrieval,
thanks and see you perhaps in 10 years again

this forum will stay online for reference
News: Support us via Flattr FLATTR Link
 
Home Help Search Gallery Downloads Login Register
*
Welcome, Guest. Please login or register. April 18, 2024, 05:04:42 AM


Login with username, password and session length


The All New FractalForums is now in Public Beta Testing! Visit FractalForums.org and check it out!


Welcome to Fractal Forums > Community > Meet & Greet > Fractal Forums News > failed db move...
Pages: [1]   Go Down
« previous next »
  Print  
Share this topic on DiggShare this topic on FacebookShare this topic on GoogleShare this topic on RedditShare this topic on StumbleUponShare this topic on Twitter
Author Topic: failed db move...  (Read 3291 times)
0 Members and 1 Guest are viewing this topic.
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« on: August 01, 2011, 02:04:49 AM »
due to the fact that in the db is only 5 megabytes left, i felt to switch the databases, but unfortunately
after hand-inserting tons of db sql queries, i realised that the forum only works with mysql4.x and not with 5.x....

so it will be re-done later this weekl, sorry for inconvenience... hurt
Logged
---

divide and conquer - iterate and rule - chaos is No random!
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« Reply #1 on: August 01, 2011, 02:05:53 AM »
can anybody confirm that smf1.x isnt workin with mysql 5 ?
or perhaps it is another fault....
Logged
---

divide and conquer - iterate and rule - chaos is No random!
klixon
Navigator
*****
Posts: 76
« Reply #2 on: August 01, 2011, 02:25:11 AM »
Quote from: cKleinhuis on August 01, 2011, 02:05:53 AM
can anybody confirm that smf1.x isnt workin with mysql 5 ?
or perhaps it is another fault....
* klixon needs more info to make sense of this...
bummer it didn't work out yet!  smiley

edit: what went wrong? Can i Help?
edit2: capitalization is not my strong point in times of wine
« Last Edit: August 01, 2011, 03:03:50 AM by klixon » Logged
Visit me on vimeo
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« Reply #3 on: August 01, 2011, 11:51:50 AM »
hi there,
i transferred all the data to the new db, and changed the settings,
at first i had a typo in the server url, so no db connection was available, after i corrected that i got the error "database error" it seems that somehow
the users table or something isnt accessible....
Logged
---

divide and conquer - iterate and rule - chaos is No random!
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« Reply #4 on: August 01, 2011, 12:10:55 PM »
has anybody poroblems migrating smf to mysql5.0 as well ? or did i something completely wrong ?!

the problem is that time is running out, only the messages table in the database consumes 50mb ... wikth attachments info, and gallery it is all about 65~mb ... JUST FOR THE CONTENT, additionally in the db are stored: pretty url schemes, logs, session data ...

and i can remove some logs, but this way i just get it down to 90mb(%) usage...

sad

damn i thought it was a straightforward thing ... and now hence i set the forum live again the database
has to be transfered again ... arg..... sad
Logged
---

divide and conquer - iterate and rule - chaos is No random!
Sockratease
Global Moderator
Fractal Senior
******
Posts: 3181
« Reply #5 on: August 01, 2011, 01:19:42 PM »
I'd ask at the smf support forums.

I'm unfamiliar with this site's database & host structure or I'd ask there myself...
Logged
Life is complex - It has real and imaginary components.

The All New Fractal Forums is now in Public Beta Testing! Visit FractalForums.org and check it out!
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« Reply #6 on: August 01, 2011, 01:41:18 PM »
it is in the gallery script:

and it has something todo with mysql5 join syntax:

http://forums.oscommerce.com/topic/208286-1054-unknown-column-xxx-in-on-clause/


hmm, i will try to deactivate the gallery to check if that is the only module that is using such syntax....
Logged
---

divide and conquer - iterate and rule - chaos is No random!
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« Reply #7 on: August 01, 2011, 01:52:59 PM »
daaaaaaaaaaaaaaaaaaaaaaamn iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiit!
Logged
---

divide and conquer - iterate and rule - chaos is No random!
ker2x
Fractal Molossus
**
Posts: 795


WWW
« Reply #8 on: August 01, 2011, 01:59:58 PM »
Quote from: cKleinhuis on August 01, 2011, 01:52:59 PM
daaaaaaaaaaaaaaaaaaaaaaamn iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiit!

 cry  cry
Logged
often times... there are other approaches which are kinda crappy until you put them in the context of parallel machines
(en) http://www.blog-gpgpu.com/ , (fr) http://www.keru.org/ ,
Sysadmin & DBA @ http://www.over-blog.com/
Sockratease
Global Moderator
Fractal Senior
******
Posts: 3181
« Reply #9 on: August 01, 2011, 05:39:52 PM »
Not a problem then.

Just give everyone 1 week to download their stuff  (maybe back it up yourself too for those who miss the announcement)  and ditch that outmoded gallery!!

smf has newer and better multimedia galleries now  afro
Logged
Life is complex - It has real and imaginary components.

The All New Fractal Forums is now in Public Beta Testing! Visit FractalForums.org and check it out!
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« Reply #10 on: August 01, 2011, 05:45:26 PM »
with more than 6000 entries in the gallery i feel like do not touch any running system ....

Quote from: Sockratease on August 01, 2011, 05:39:52 PM
Not a problem then.

Just give everyone 1 week to download their stuff  (maybe back it up yourself too for those who miss the announcement)  and ditch that outmoded gallery!!

smf has newer and better multimedia galleries now  afro
Logged
---

divide and conquer - iterate and rule - chaos is No random!
Sockratease
Global Moderator
Fractal Senior
******
Posts: 3181
« Reply #11 on: August 01, 2011, 06:07:32 PM »
Quote from: cKleinhuis on August 01, 2011, 05:45:26 PM
with more than 6000 entries in the gallery i feel like do not touch any running system ....

Be prepared - you may have no other choice!

Either that, or lock this entire forum and create a new one in the new database with a new url  (index2.php?)  (just link to it on top of the current index page).  That wont break any existing links, but it would give a totally blank slate to build a better forum on.

Whatever you deem best   afro
Logged
Life is complex - It has real and imaginary components.

The All New Fractal Forums is now in Public Beta Testing! Visit FractalForums.org and check it out!
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« Reply #12 on: August 01, 2011, 06:52:10 PM »
yes  a transformation to smf2.0 is also on my plan ... perhaps a good idea... but i cant really make friends with it.....
Logged
---

divide and conquer - iterate and rule - chaos is No random!
Pages: [1]   Go Down
« previous next »
  Print  
« previous next »
 
Jump to:  

Related Topics
Subject Started by Replies Views Last post
On the Move Mandelbulb3D Gallery lenord 0 801 Last post March 04, 2011, 10:23:30 PM
by lenord
urban move Mandelbulb3D Gallery taurus 0 734 Last post July 12, 2011, 10:03:08 AM
by taurus
Failed DE over 2900 % - what am I doing wrong Mandelbulber darksky 6 2743 Last post September 23, 2011, 05:22:04 PM
by Buddhi
Failed to load texture Fragmentarium cyberxaos 6 5895 Last post December 05, 2012, 12:05:05 AM
by cyberxaos
Move around in realtime feature request sikerow 3 774 Last post May 16, 2015, 11:04:44 AM
by Chillheimer

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM
Page created in 0.135 seconds with 25 queries. (Pretty URLs adds 0.009s, 2q)