forum might be going down


Discussion Topic

Return to Forum List
Post a Reply
Messages 1 - 22 of total 22 in this topic

Hobart, Australia
Topic Author's Original Post - Jun 21, 2013 - 09:57pm PT
Hi All-

For many of you who posted on forum, thank you, I appreciate the support on that site.

However, my hoster (1and1) is discontinuing SQL4, and is requiring converting all DBs to SQL5. Problem is, I can't seem to get it to take. I exported the SQL4 DB, but a repeated error occurs when trying to import into a SQL5 database.

I'm not really in a time position to spend too much time on it, so it might be the end of the forum. If so, please copy any info you might want to keep in the next week or so.

Willing to try any advice on a fix.


Mountain climber
Anchorage AK, Reno NV
Jun 21, 2013 - 10:01pm PT
Well damn that would terribly suck.

I'm sure you are about to get a flood of smart folks helping fix the issues.

Captain...or Skully

Jun 21, 2013 - 10:18pm PT
Its a better site for real info. I prefer it. Salute, Deucey.
John Mac

Trad climber
Littleton, CO
Jun 21, 2013 - 10:20pm PT
That would be a huge loss. It a great place to bounce ideas around,

San Francisco, CA
Jun 21, 2013 - 10:21pm PT

What's the error? If you want some help trying to debug it, feel free to PM. Glad to try and help if you want it.

Jun 21, 2013 - 11:09pm PT
John, that sucks!! I wish I knew something about that stuff to help, but I only know how to suffer.....

A long way from where I started
Jun 21, 2013 - 11:13pm PT
That totally sucks dead rats. Surely one of the many web-literate people here on ST can help you preserve the site. It has always been one of the best.


Trad climber
The pitch of Bagalaar above you
Jun 21, 2013 - 11:25pm PT
Munge can clear this up Deuce.

I am sure of it, if not, there are more than a few guys here that can step up and put this in motion.

BW is the best site out there, though slow at times, is always full of business end of climbing.

Some of the best TR's are in those archives.

Keep it alive John!

Hobart, Australia
Topic Author's Reply - Jun 22, 2013 - 12:56am PT
spent all day so far and no good. Anyone got expertise in SQL5? Would like to share the export from SQL4 and see if there's a way to clean it up so it can be imported to a SQL5 DB.

Site is at for another 14 days.

Ideally I would like to export the Simple Machines forum to a forum that could be hosted on a Windows 2008 server--as I still maintain some windows servers from my old programming business--any ideas on that as a possibility?

Trad climber
Jun 22, 2013 - 01:04am PT
John, I have no technical knowledge. Would be willing to give some financial support if it would help. I've downloaded so many stories that have helped keep me sane I can't count.

Of course, sanity is a relative term.

philadelphia, pa
Jun 22, 2013 - 09:22am PT
Crap. Was going to offer up hosting it on my service, but no SQL4 there either. :(

Big Wall climber
Ashland, Or
Jun 22, 2013 - 10:06am PT
No!!! Sombudy help save it!!!

Trad climber
Jun 22, 2013 - 10:42am PT
PM send.

Jun 22, 2013 - 10:48am PT
Unacceptable. No way. There is far too much history and life on that site to just shut it down.

People we can figure this out. Duece patience mate. It will live on longer than you and or I just give us a bit of time to figure this out.

Steve Grossman

Trad climber
Seattle, WA
Jun 22, 2013 - 02:53pm PT

Have you captured all of your content to a hard drive or two?

I sure hope so.

Trad climber
dancin on the tip of god's middle finger
Jun 22, 2013 - 06:00pm PT
im going out to my man cave

and im gonna sit and think about this one.

every major part of my body metaphors a machine of greater
(mechanically advantageous) accomplishment.

my shoulder: a dozer blade.
my forearms: a forklift.
my feet: a sheep's foot roller.
my fist: wrecking ball.
my unit: field tiller (and apparently a seed sower)
my scrotum: seed incubator.

my brain: i've not yet found the appropriate application
for this physiological accessory but i feel that now is the time
and that my invention may just help keep your cause alive.

i've got one other agenda item on my universal list
(re-organizing god's dna) and then i'll save
the bigwall archives.

Mountain climber
Okinawa, Japan
Jun 22, 2013 - 06:28pm PT
You need a thread title that is specific to your problem that will attract the many programmers on this site - something like Need Help with Computer Stuff. Then they will show.

Hobart, Australia
Topic Author's Reply - Jun 22, 2013 - 07:45pm PT
now I'm trying to transfer the forum from a hosting site to my Amazon server. But here's the error I get;

SQL query:

CREATE TABLE IF NOT EXISTS `backup_s_attachments` (

`ID_ATTACH` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`ID_THUMB` int( 10 ) unsigned NOT NULL default '0',
`ID_MSG` int( 10 ) unsigned NOT NULL default '0',
`ID_MEMBER` mediumint( 8 ) unsigned NOT NULL default '0',
`filename` tinytext NOT NULL ,
`size` int( 10 ) unsigned NOT NULL default '0',
`downloads` mediumint( 8 ) unsigned NOT NULL default '0',
`attachmentType` tinyint( 3 ) unsigned NOT NULL default '0',
`width` mediumint( 8 ) unsigned NOT NULL default '0',
`height` mediumint( 8 ) unsigned NOT NULL default '0',

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=10' at line 15
mike m

Trad climber
black hills
Jun 22, 2013 - 07:51pm PT
What about working with cmac to transfer it to ST. It would certainly improve the climbing content on here and it would keep all your hard work alive. Maybe we could have a climbing only section of ST.

Hobart, Australia
Topic Author's Reply - Jun 22, 2013 - 08:19pm PT
created another thread thanks to suggestion--this one can disappear....

Jun 22, 2013 - 08:43pm PT
I know very little SQL, but if that's literally the code then there should be a space between logTime and timestamp( 14 ).
Scott McNamara

Tucson, Arizona
Jun 22, 2013 - 10:06pm PT
Messages 1 - 22 of total 22 in this topic
Return to Forum List
Post a Reply
Our Guidebooks
Check 'em out!
SuperTopo Guidebooks

Try a free sample topo!

SuperTopo on the Web

Recent Trip Report and Articles
Recent Route Beta
Recent Gear Reviews