UBB.Developers Forums UBB.threads 7 Development How Do I? using the backup utility in admin to export to another board

I am trying to move all of the threads from 1 board into another. The client would like to take all of the threads from 1 forum, put them into another, recategorize them, and then add new forums. They want to set it up in a new board (to preview it 1st) so that's why I'm doing it this way.

I did the DB Backup from 1 board successfully. Then I created the new board and ran the DB Restore. No errors but where do I see the old users and forums/threads?

New board here.

Do you have any mysql error's? Have you made sure all tables were restored.

Actually:

Unable to do_query: SELECT t1.B_Number,t1.B_Main,t3.U_Username,t1.B_Subject,t1.B_Posted,t1.B_Board,t3.U_Color,t1.B_Reged,t1.B_Icon,t2.Bo_Title,t2.Bo_Read_Perm,t2.Bo_Cat,t1.B_Posterid,t1.B_Status,t1.B_AnonName,t1.B_Body FROM w3t_Posts AS t1, w3t_Boards AS t2, w3t_Users AS t3 WHERE t1.B_Approved = 'yes' AND t1.B_Board = t2.Bo_Keyword AND t1.B_Posterid = t3.U_Number AND t1.B_Status <> 'M' AND t1.B_Board IN () AND t1.B_Posted > '1070758863' ORDER BY B_Posted DESC LIMIT 26 - You have an error in your SQL syntax near ') AND t1.B_Posted > '1070758863' ORDER BY B_Poste' at line 10


But on that note what's the file name for MySQL errors? I know about the 1 UBBT makes and there's nothing in that 1...also, how do you run "altertables" which I didn't do?

You do have errors I looked at your site.

Warning: Variable passed to each() is not an array or object in /usr/home/admin/html/www.uemforums.com/sony/ubbthreads/search.php on line 115

You can not install 6.4 and create the 6.4 tablestructure and then create your admin account. You then used the admin section to restore your old database. This will not work. You need to delete your database. Use PHPMyAdmin or use putty or other shell client to go in and use the mysql command line utility to restore the 6.3 database. After this you run the altertables to bring it up to the current one.

SQL ERROR: Sun, Dec 07 2003 20:19:04 -0500 Database error only visible to forum administrators
SQL ERROR: Sun, Dec 07 2003 20:19:04 -0500 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/admin/html/www.uemforums.com/sony/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Sun, Dec 07 2003 20:19:04 -0500 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/admin/html/www.uemforums.com/sony/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Sun, Dec 07 2003 20:19:04 -0500 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/admin/html/www.uemforums.com/sony/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Sun, Dec 07 2003 20:19:04 -0500 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/admin/html/www.uemforums.com/sony/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Sun, Dec 07 2003 20:19:04 -0500 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/admin/html/www.uemforums.com/sony/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Sun, Dec 07 2003 20:19:04 -0500 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/admin/html/www.uemforums.com/sony/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Sun, Dec 07 2003 20:19:04 -0500 Database error only visible to forum administrators