Advertisement:

Author Topic: restore_backup.php problems..  (Read 34669 times)

Offline Tristan Perry

  • SMF Hero
  • ******
  • Posts: 2,498
  • Gender: Male
    • Tristan Perry
restore_backup.php problems..
« on: June 04, 2005, 04:39:01 PM »
Hello,
 I'm trying to restore a 100 megabyte database onto my test server's version of SMF. When running the restore_backup.php file, everything is fine, apart from the messages and members tables; which render many errors. Below are a few errors that are shown:

Quote
Some of the queries were not executed properly. Technical information about the queries:
Line #32984: BLOB/TEXT column 'personalText' used in key specification without a key length
Line #x: Table 'smf.yabbse_members' doesn't exist
Line #34299: BLOB/TEXT column 'subject' used in key specification without a key length
Line #x: Table 'smf.yabbse_messages' doesn't exist

The "Table 'x' doesn't exist" errors are shown about 100 times each. I'm running PHP 4.3.11 and MySQL 4.1.12 on my test server. Edit: Oh, and I'm using create_backup.php to create the backup. The server where I get the backup from is running MySQL 4.0.24.
 Any help would be appreciated,
Tau Online
« Last Edit: June 04, 2005, 04:43:07 PM by Tau Online »

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: restore_backup.php problems..
« Reply #1 on: June 04, 2005, 09:00:05 PM »
Are you sure you're using the latest versions of the two tools?

I haven't actually released them as stable yet, mind you.

The two errors are probably faily easy to fix, and the rest are caused by those two:

Line #32984: BLOB/TEXT column 'personalText' used in key specification without a key length
Line #34299: BLOB/TEXT column 'subject' used in key specification without a key length

To fix them, assuming it was an old create_backup.php or a different version of MySQL, find:

(personalText)

Replace:

(personalText(30))

Find:

(subject)

Replace:

(subject(30))

Each should be on or very near the specified lines.

-[Unknown]

Offline Tristan Perry

  • SMF Hero
  • ******
  • Posts: 2,498
  • Gender: Male
    • Tristan Perry
Re: restore_backup.php problems..
« Reply #2 on: June 05, 2005, 06:49:00 AM »
Hmm.. Thanks. Using the new files, the only error shown was a PHP notice which isn't really important:

Quote
Notice: Undefined index: line in C:\Program Files\Apache Group\Apache2\htdocs\SMF\restore_backup.php on line 191

Although same problem as last time- Comparing the two databases everything after log_topics seems to not have been restored.. So I make the changes you mentioned above, and now get:

Quote
Some of the queries were not executed properly. Technical information about the queries:
Line #23395: 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 '(30) NOT NULL default '',
`gender` tinyint(4) unsigned NOT NUL
Line #x: Table 'smf.yabbse_members' doesn't exist
Line #24746: 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 '(30)
`posterName` tinytext NOT NULL default '',
`posterEmail
Line #x: Table 'smf.yabbse_messages' doesn't exist

The odd thing with this is that, now, all tables have been fully restored, apart from the members and messages tables- which have been deleted and so SMF won't open ("Table 'smf.yabbse_members' doesn't exist") The key lengths are there which is what is confusing me.

I realize these files aren't stable yet, and so I appreciate the help lots but if the errors can't be easily fixed, I fully understand  :)
« Last Edit: June 05, 2005, 08:48:08 AM by Tau Online »

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: restore_backup.php problems..
« Reply #3 on: June 06, 2005, 04:33:17 AM »
Those weren't the changes I meant :/.

Can you email me the dump?

-[Unknown]

Offline Tristan Perry

  • SMF Hero
  • ******
  • Posts: 2,498
  • Gender: Male
    • Tristan Perry
Re: restore_backup.php problems..
« Reply #4 on: June 06, 2005, 01:48:33 PM »
Those weren't the changes I meant :/.

Can you email me the dump?

-[Unknown]
Oh right..  :-[ I'd be happy to e-mail you the file (To 'unknown@simplemachines.org' ?) although it's 26 megabytes when gz-zipped, and 80 un-zipped just to let you know. Should I still send it? [The zipped one]

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: restore_backup.php problems..
« Reply #5 on: June 07, 2005, 06:17:43 AM »
Yes, that's fine... I'll take a look at what might be wrong.

-[Unknown]

Offline Tristan Perry

  • SMF Hero
  • ******
  • Posts: 2,498
  • Gender: Male
    • Tristan Perry
Re: restore_backup.php problems..
« Reply #6 on: June 07, 2005, 01:55:07 PM »
Yes, that's fine... I'll take a look at what might be wrong.

-[Unknown]
Ok thanks a lot  :) I'm e-mailing you it know... By the way sorry about the first e-mail, I forgot to attach the file  :-[

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: restore_backup.php problems..
« Reply #7 on: June 07, 2005, 08:33:08 PM »
I only received one email with no attachment.

If you can't send that large an attachment, what about restoring those tables that work fine (not members and messages, yes?) and then trying to (with a copy of the backup!) strip out the data for the other tables (like log_topics, topics, personal_messages, etc.) - maybe that would make it small enough?

-[Unknown]

Offline Tristan Perry

  • SMF Hero
  • ******
  • Posts: 2,498
  • Gender: Male
    • Tristan Perry
Re: restore_backup.php problems..
« Reply #8 on: June 08, 2005, 11:58:32 AM »
I only received one email with no attachment.

If you can't send that large an attachment, what about restoring those tables that work fine (not members and messages, yes?) and then trying to (with a copy of the backup!) strip out the data for the other tables (like log_topics, topics, personal_messages, etc.) - maybe that would make it small enough?

-[Unknown]
Ok thanks, I'll try stripping out the data. I have definately sent both and so it's probably because of the size of the attachment that the e-mail wasn't sent properly. One final question: What program do you use to open databases? Using Word is too slow and crashes my PC, notepad works about 50% of the time, although crashes my PC the other half of the time..

Offline Tristan Perry

  • SMF Hero
  • ******
  • Posts: 2,498
  • Gender: Male
    • Tristan Perry
Re: restore_backup.php problems..
« Reply #9 on: June 08, 2005, 04:11:33 PM »
I just got an un-delievered mail message. It appears your inbox is full?

Quote
This message was created automatically by mail delivery software.
A message that you sent has not yet been delivered to one or more of its
recipients after more than 24 hours on the queue on monkey.lewismedia.com.

The message identifier is:     [Edited]
The subject of the message is: [Edited]
The date of the message is:    Tue, 7 Jun 2005 18:54:28 +0100

The address to which the message has not yet been delivered is:

  unknown@simplemachines.org
    Delay reason: mailbox is full

No action is required on your part. Delivery attempts will continue for
some time, and this warning may be repeated at intervals if the message
remains undelivered. Eventually the mail delivery software will give up,
and when that happens, the message will be returned to you.

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: restore_backup.php problems..
« Reply #10 on: June 08, 2005, 06:27:26 PM »
Interesting.  I thought it was set so my box couldn't be full :P.

Anyway, I would use a text editor.  A good one for large files is UltraEdit.

-[Unknown]

Offline sifirforum.com

  • Jr. Member
  • **
  • Posts: 379
    • SIFIR Forum, Özgür bilincin ifade zemini
Re: restore_backup.php problems..
« Reply #11 on: February 19, 2006, 03:12:15 AM »
i have this error:

Quote
Undefined index: line in /home/..../forum/restore_backup.php on line 191
SIFIR proudly hosted by servega

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: restore_backup.php problems..
« Reply #12 on: February 19, 2006, 03:17:01 PM »
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Dorte

  • Semi-Newbie
  • *
  • Posts: 63
  • Gender: Female
Re: restore_backup.php problems..
« Reply #13 on: March 17, 2006, 11:20:20 AM »
Hi!
I tried moving my SQL data with create_backup and restore_backup. Backuping went wonderfully, but when restoring I got this message:
"Some of the queries were not executed properly. Technical information about the queries:
Line #1: Query was empty"

Any idea what went wrong?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: restore_backup.php problems..
« Reply #14 on: March 17, 2006, 06:33:35 PM »
Did you modify any of the tables?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Dorte

  • Semi-Newbie
  • *
  • Posts: 63
  • Gender: Female
Re: restore_backup.php problems..
« Reply #15 on: March 18, 2006, 06:48:27 AM »
Not that I know of, I don't really have a clue about SQL and all that sort of stuff which is why I chose SMF ;) it's so wonderfully automatic...

Offline ~Romil

  • Newbie
  • *
  • Posts: 8
  • Gender: Male
    • ~Romil
Re: restore_backup.php problems..
« Reply #16 on: December 19, 2006, 09:33:37 AM »
Hi, sorry to have bumped this old thread, but isnt it supposed to address those restore_backup.php issues?

Well, I took two backups of my Joomla bridged SMF, one via phpMyAdmin and one using [Unknown]'s backup utility. Both of them render this error on the stage3:

Code: [Select]
Notice: Undefined index: line in /home/mediacra/public_html/arpsshillong/forum/restore_backup.php on line 181
[color=red]Some of the queries were not executed properly. Technical information about the queries:[/color]
Line #1718: Invalid default value for 'logTime'
Line #1726: Table 'mediacra_smf.smf2_log_online' doesn't exist

The earlier installation was SMF RC 1.1 and trying to do it over SMF 1.1, and haven't touched the db as such. Any ideas?
« Last Edit: December 19, 2006, 09:57:53 AM by ~Romil »
~Romil

Offline ~Romil

  • Newbie
  • *
  • Posts: 8
  • Gender: Male
    • ~Romil
UPDATE
« Reply #17 on: December 19, 2006, 09:56:47 AM »
I fixed the 'TIMESTAMP' issue, and restored the .sql file using restore_backup, it was a success there.

But, cant see restored posts and topics on live forum? What could be the problem?
~Romil

Offline ~Romil

  • Newbie
  • *
  • Posts: 8
  • Gender: Male
    • ~Romil
Re: restore_backup.php problems..
« Reply #18 on: December 20, 2006, 06:39:40 AM »
Sorry for being impatient, but retried everything and got success message but still those forum posts dont appear. But, when I see the db with myPHPAdmin, the db is there allright. (hxxp:www.arpsshillong.com/forum [nonactive])

Do I have to run any update on the version numbers for SMF 1.1? Earlier installation was SMF 1.1 RC1 with Joomla bridge. Please suggest.
~Romil

Orstio

  • Guest
Re: restore_backup.php problems..
« Reply #19 on: December 20, 2006, 07:12:55 AM »
You can't use a SMF 1.1 RC1 database backup on a SMF 1.1 Final forum.  There have been too many changes for that to work.

Do you still have a backup of the SMF 1.1 RC1 files?