| import issues [message #164576] |
Thu, 17 February 2011 18:50  |
 |
andy_scouser
Messages: 76
Registered: June 2003
Karma:
|
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 
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 |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]