Title: failed db move... Post by: cKleinhuis 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: Title: Re: failed db move... Post by: 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.... Title: Re: failed db move... Post by: klixon on August 01, 2011, 02:25:11 AM can anybody confirm that smf1.x isnt workin with mysql 5 ? /me needs more info to make sense of this...or perhaps it is another fault.... bummer it didn't work out yet! :) edit: what went wrong? Can i Help? edit2: capitalization is not my strong point in times of wine Title: Re: failed db move... Post by: cKleinhuis 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.... Title: Re: failed db move... Post by: cKleinhuis 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... :( 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..... :( Title: Re: failed db move... Post by: Sockratease 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... Title: Re: failed db move... Post by: cKleinhuis 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.... Title: Re: failed db move... Post by: cKleinhuis on August 01, 2011, 01:52:59 PM daaaaaaaaaaaaaaaaaaaaaaamn iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiit!
Title: Re: failed db move... Post by: ker2x on August 01, 2011, 01:59:58 PM daaaaaaaaaaaaaaaaaaaaaaamn iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiit! :'( :'( Title: Re: failed db move... Post by: 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 O0 Title: Re: failed db move... Post by: 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 ....
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 O0 Title: Re: failed db move... Post by: Sockratease on August 01, 2011, 06:07:32 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 O0 Title: Re: failed db move... Post by: cKleinhuis 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..... |