Hello, i am attempting to restore a backup from v3.0.3 (mysql 5.1.49) to v3.0.3 (postgresql 8.4). Im not sure if backups are supposed to be database neutral, however my goal is to move all my applications from mysql to postgresql including my forums.
the fudforums install properly as a new install on postgresql, then i attempt to restore a backup file from the other installation...
here is the output...
Quote:
Restore progress
Restore forum files...
Drop and recreate database tables...
Start loading database tables...
Process table fud30_action_log:
...59 rows loaded.
Process table fud30_ann_forums:
...149 rows loaded.
Process table fud30_announce:
...11 rows loaded.
Process table fud30_attach:
...713 rows loaded.
Process table fud30_avatar:
...84 rows loaded.
Process table fud30_bookmarks:
...1 rows loaded.
Process table fud30_buddy:
...91 rows loaded.
Process table fud30_calendar:
...1 rows loaded.
Process table fud30_cat:
...3 rows loaded.
Process table fud30_custom_tags:
...15 rows loaded.
Process table fud30_fc_view:
...14 rows loaded.
Process table fud30_forum:
...35 rows loaded.
Process table fud30_forum_notify:
...7 rows loaded.
Process table fud30_forum_read:
...2506 rows loaded.
Process table fud30_geoip:
...10000 rows
...20000 rows
...30000 rows
...40000 rows
...50000 rows
...60000 rows
...70000 rows
...80000 rows
...90000 rows
...100000 rows
...110000 rows
...111799 rows loaded.
Process table fud30_group_cache:
...77 rows loaded.
Process table fud30_group_members:
...77 rows loaded.
Process table fud30_group_resources:
...36 rows loaded.
Process table fud30_groups:
...38 rows loaded.
Process table fud30_level:
...5 rows loaded.
Process table fud30_mime:
...43 rows loaded.
Process table fud30_mod:
...10 rows loaded.
Process table fud30_msg:
...10000 rows
Warning: pg_query(): Query failed: ERROR: syntax error at or near "'staffNULL status in rego list'" LINE 1: ...21.44.125.133',NULL,'1211710597','0','0',NULL,NULL'staffNULL... ^ in /var/www/sites/forums.fragfest.com.au/FUDforum/include/theme/default/db.inc on line 108 Fatal error: Uncaught exception 'Exception' with message '(/var/www/sites/forums.fragfest.com.au/FUDforum/include/theme/default/db.i nc:108
/var/www/sites/forums.fragfest.com.au/htdocs/adm/admimport.php:199
) : ERROR: syntax error at or near "'staffNULL status in rego list'" LINE 1: ...21.44.125.133',NULL,'1211710597','0','0',NULL,NULL'staffNULL... ^
Query: INSERT INTO fud30_msg VALUES ('17425','1532','4','0','121.44.125.133',NULL,'1211710597','0','0',NULL,NUL L'staffNULL status in rego list','0','0','138797','324','130000','0','0','0',NULL,NULL,NULL,'1','1','a u','AUSTRALIA')
_POST: array ( 'SQ' => '3c7f284369032ff2f1cc18cf34f776b9', 'path' => '/tmp/FUDforum_15_10_2011_10_17.fud.gz', 'btn_submit' => 'Import Data', )
Database version: 8.4.8
[Referring Page] http://forums.fragfest.com.au/adm/admimport.php?&SQ=3c7f284369032ff2f1c c18cf34f776b9
' in /var/www/sites/forums.fragfest.com.au/FUDforum/include/core.inc:256 Stack trace: #0 /var/www/sites/forums.fragfest.com.au/FUDforum/include/theme/default/db.inc (108): fud_sql_error_handler('INSERT INTO fud...', 'ERROR: syntax ...', '', '8.4.8') #1 /var/www/sites/forums.fragfest.com.au/htdocs/adm/admimport.php(199): q('INSERT INTO fud...') #2 {main} thrown in /var/www/sites/forums.fragfest.com.au/FUDforum/include/core.inc on line 256
|