Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options
Need help regenerating old 2012-07-06 sql dump file into new 2.2 version sql file.
ufolog
New
Hello. I need help regenerating old 2012-07month vanilla sql dump file into new vanilla 2.2 version sql file.
My problems: I been able to import users to my new vanilla 2.2 forum but unable to import discussions, comments and other things.
Tryed vanilla porter its not working.
I have old vanilla sql database dump and need someones help who able to rgenerate it to new so i be able to upload it via phpmyadmin.
0
Comments
porter should not be used for upgrades.
What do you mean regenerating?
Do you have the dump?
You need to upload it and and import it.
grep is your friend.
Tables not same. Tryed to to do you saying its not working some ids not meet.
Yes i have old dump and need some help repairing so i can import in phpmyadmin.
Then i trying only to upload old discussion table i getting this error:
SQL query:
-- -- Dumping data for table
GDN_Discussion-- INSERT INTOGDN_Discussion(DiscussionID,CategoryID,Name,InsertUserID,CountViews,FirstCommentID,Format,CountComments,Closed,Announce,DateInserted,DateUpdated,DateLastComment,_NewID,_Action) VALUES (14, 5, 'animals', 6, 757, 14, 'BBCode', 7, 0, 0, '2007-04-24 20:49:09', '2008-03-28 19:18:14', '2008-03-28 19:18:14', NULL, NULL), (1, 9, 'Pradžia ', 3, 412, 1, 'BBCode', 14, 0, 0, '2007-04-07 18:41:47', '2007-05-11 13:52:56', '2007-05-11 13:52:56', NULL, NULL), (19, 10, 'Del video', 6, 318, 19, 'BBCode', 15, 1, 0, '2007-04-27 19:24:47', '2007-07-21 18:53:10', '2007-07-21 18:53:10', NULL, NULL), (21, 6, 'Kas vyksta iš tikro?', 7, 1510, 21, 'BBCode', 23, 0, 0, '2007-04-29 13:08:20', '2008-01-01 12:22:19', '2008-01-01 12:22:19', NULL, NULL), (24, 7, 'MEG (Motionless Electromagnetic Generator)', 7, 1185, 24, 'BBCode', 13, 0, 0, '2007-04-29 20:35:03', '2008-11-18 08:00:07', '2008-11-18 08:00:07', [...]MySQL said: Documentation
1054 - Unknown column '_NewID' in 'field list'
If i try to upload whole old dump to new sql database i have new one GND_Discussion and old one GND_zDiscussion but not getting any data in forum from old tables.
So i need some kind of generator who able to generate old standard to new one so i be able to upload separate tables or all old sql .dump width data who will appear on forum.
IF i uploading old one and trying to click on thread link in forum getting error:
Something has gone wrong.
We've run into a problem and are unable to handle this request right now.
Please check back in a little while.
www.ufolog.lt try to click yourself.
You'll get more info by adding this to your conf/config.php:
$Configuration['Debug'] = TRUE;
This will show a detailed error report in place of the 'Something has gone wrong' page.
Have you run www.yourforum.com/dashboard/utility/structure
and
www.yourforum.com/dashboard/utility/update
Thanks for info. Just installed old 2.0 instead of 2.2 and its working. Now thinking if it will support upgrading and still will work after upgrade.
The dump needs to creates the tables (if you didn't select that option when making the dump you made a mistake). You should insert into a new database.
grep is your friend.
There should be no problem.
You don't need to export anything, just run the utility structure and update after upgrading.
So does i understand right: Now then its working on old 2.0 version i just need to export sql database copy and then i install 2.2 just import the old sql database who worked in version 2.0 right ?
NO!
Don't export anything. (But do make a copy of your DB just in case...)
Follow the instructions in the 2.2 Readme to upgrade to 2.2, noting that there are two additional steps for 2.0 forums.
Run the utilities.
That should be it.
Ok. Got the procedure. Thanks for help.