FUDforum: How To » import issues

Home » FUDforum » How To » import issues

Show: Today's Messages :: Polls :: Message Navigator

import issues [message #164576]

Thu, 17 February 2011 18:50

andy_scouser
Messages: 76
Registered: June 2003

Karma: 1

Member

Hi there,

Ive been having lots of issues with the peole hosting my site recently so i took a backup and brought it home. I made a little ubuntu server i have fire up an apache2 vhost for my forum and changed the local host file. Installed 3.0.1 (same as live site) and pointed the browser at the host. Blank forum runs Smile

I then tried to import and it failed, with the below

Restoring forum files...
Drop database tables...
Create database tables...
Processing table fud30_attach...
Fatal error: Uncaught exception 'Exception' with message '(/var/www/honda-forums.com/honda_FUDforum/include/theme/default/db.inc:72
/var/www/honda-forums.com/html/adm/admimport.php:230
) 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 '\','357','0','168124','236','10','33883'),('13421','/var/www/honda-forums. com/ho' at line 1
Query: INSERT INTO fud30_attach VALUES ('13369','/var/www/honda-forums.com/honda_FUDforum/files/13369.atch','Big All.jpg','342','0','167685','104','10','82059'),

with many many lines looking like the last.

_POST: array ( 'S' => '7c7f11b146ac4409d0389b7342c02d73', 'SQ' => '9da39d49a9293b967cee105c0148fd1c', 'path' => '/var/www/honda-forums.com/html/backup.fud.gz', 'btn_submit' => 'Import Data', )
Server Version: 5.1.49-1ubuntu8.1
[Referring Page] http://www.honda-forums.com/adm/admimport.php
' in /var/www/honda-forums.com/honda_FUDforum/include/core.inc:197 Stack trace: #0 /var/www/honda-forums.com/honda_FUDforum/include/theme/default/db.inc(72): fud_sql_error_handler('INSERT INTO fud...', 'You have an err...', 1064, '5.1.49-1ubuntu8...') #1 /var/www/honda-forums.com/html/adm/admimport.php(230): q('INSERT INTO fud...') #2 {main} thrown in /var/www/honda-forums.com/honda_FUDforum/include/core.inc on line 197

my home ubuntu server is running 5.1.49 of mysql, my live host 5.0.51a and each running ubuntu.

Has any body any suggestions so i can resolve this please? I could update to 3.0.2 on each side but this looks more like an sql issue.

This is not a live issue, however, im thinking if i can get it running at home just in case live fails again at least i will know i can use my home connection and use last backups..

cheers chaps

[Updated on: Thu, 17 February 2011 19:04]

Report message to a moderator

Re: import issues [message #164577 is a reply to message #164576]

Thu, 17 February 2011 23:16

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Known issue with 3.0.1. See documentation at Import forum data.

Report message to a moderator

Re: import issues [message #164580 is a reply to message #164577]

Fri, 18 February 2011 06:54

andy_scouser

Messages: 76
Registered: June 2003

Karma: 1

Member

naudefj, i missed that one. This clearly highlights that im not testing my backups so lessons learnt, so many thanks. Forum has now imported without any issues

Report message to a moderator

Previous Topic:	create a pathinfo theme
Next Topic:	how do i remove the "show what people are doing" link?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 23:30:03 GMT 2024

Total time taken to generate the page: 0.20815 seconds