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

Home » FUDforum » How To » Import Issues to new Host (v3.0.4)
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Import Issues to new Host (v3.0.4) [message #168291 is a reply to message #168289] Fri, 12 April 2013 13:12 Go to previous messageGo to previous message
Kermit is currently offline  Kermit   United Kingdom
Messages: 35
Registered: November 2004
Karma:
Member
I've now tried the same backup import on the proper new host and get this

Cleanup old files...
Restore files from backup...
Drop and recreate database tables...
Start loading database tables...
Process table fud30_action_log:
...12 rows loaded.
Process table fud30_ann_forums:
...3 rows loaded.
Process table fud30_announce:
...3 rows loaded.
Process table fud30_attach:
...670 rows loaded.
Process table fud30_bookmarks:
...25 rows loaded.
Process table fud30_buddy:
...259 rows loaded.

******snip*******

Process table fud30_mime:
...43 rows loaded.
Process table fud30_mod:
...116 rows loaded.
Process table fud30_msg:
 ...10000 rows

Fatal error: Uncaught exception 'Exception' with message '(/home/hondafor/fuddata/include/theme/default/db.inc:112<br /> /home/hondafor/public_html/forum/adm/admimport.php:186<br /> ) 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 '>' at line 1<br /> Query: INSERT INTO fud30_msg VALUES ('12803','1450','41','12216','81.128.199.63',NULL,'1074945292','0','0',NULL,'Re: Another 3 points','0','0','2084114','1078','350000','0','0','0',NULL,NULL,NULL,'1','1','gb','UNITED KINGDOM'),('12804','1403','41','12155','81.128.199.63',NULL,'1074945793','0','0',NULL,'Re: Job shopping','0','0','2085192','706','350000','0','0','0',NULL,NULL,NULL,'1','1','gb','UNITED KINGDOM'),('12805','1457','41','12176','81.128.199.63',NULL,'1074946619','0','0',NULL,'Re: Norwich Union - how do they survive?','0','0','2085898','764','350000','0','0','0',NULL,NULL,NULL,'1','1','gb','UNITED KINGDOM'),('12806','1422','41','12179','81.128.199.63',NULL,'1074946737','0','0',NULL,'Re: Mystery phrases','0','0','2086662','106','350000','0','0','0',NULL,NULL,NULL,'1','1','gb','UNITED KINGDOM'),('12807','1496','41','12798','81.128.199.63',NULL,'1074947129','0','0',NULL,'Re: Security Locks and 

many pages of out put like this then....

 I''m sick of it....'&lt;br /&gt;<br /> _POST: array ( 'SQ' =&gt; '6b2f44b24f892edcd05a51ef20530d62', 'path' =&gt; '/home/hondafor/fuddata/tmp/FUDforum_12_04_2013_12_12.fud', 'skipsearch' =&gt; 'y', 'btn_submit' =&gt; 'Import Data', )<br /> Database version: 5.5.30-cll<br /> [Referring Page] http://www.honda-forums.com/forum/adm/admimport.php?&amp;SQ=6b2f44b24f892edcd05a51ef20530d62<br /> ' in /home/hondafor/fuddata/include/core.inc:248 Stack trace: #0 /home/hondafor/fuddata/include/theme/default/db.inc(112): fud_sql_error_handler('INSERT INTO fud...', 'You have an err...', 1064, '5.5.30-cll') #1 /home/hondafor/public_html/forum/adm/admimport.php(186): q('INSERT INTO fud...') #2 {main} thrown in /home/hondafor/fuddata/include/core.inc on line 248


so different issues to when trying to restore to my local PC.

New Host Versions
FUDforum: 3.0.4
PHP: 5.4.12
Database: mysql 5.5.30-cll (mysql)
Operating system: Linux 3.2.40-grsec

Current Host Versions

FUDforum: 3.0.4
PHP: 5.2.6-1+lenny16
Database: mysql 5.0.51a-24+lenny5-log (mysql)
Operating system: Linux 2.6.32-5-xen-amd64

[Updated on: Fri, 12 April 2013 14:36]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: how to mark a single post
Next Topic: Individual Forum Analytics
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 01 10:19:37 GMT 2024

Total time taken to generate the page: 0.03867 seconds