FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » import issues
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
import issues [message #164576] Thu, 17 February 2011 18:50 Go to next message
andy_scouser is currently offline  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 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Known issue with 3.0.1. See documentation at Import forum data.
Re: import issues [message #164580 is a reply to message #164577] Fri, 18 February 2011 06:54 Go to previous message
andy_scouser is currently offline  andy_scouser   United Kingdom
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
  Switch to threaded view of this topic Create a new topic Submit Reply
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) ] [ RSS ]

Current Time: Sun Nov 24 23:35:46 GMT 2024

Total time taken to generate the page: 0.02476 seconds