upgrading to 0.9.2

outbreak

ok, i upgraded, and i kept getting some fatal error, so i decided to export my old database, reinstall vanilla and then import my old one. i transferred the whole database over without a hitch except for the LUM_User table. i cant seem to get any of the users to transfer over, i keep getting errors every time i try to insert the SQL.

SQL-query:

INSERT INTO `LUM_User`
VALUES ( 1, 6, 5, 'http://www.one26.com/gmonkey/styles/classic/', 'Jon', 'Contino', 'jon', '637c456ff9b347c370554442e034ceae', '29ab574bb68c950dc2e370d718a9798b', '', 'jon@one26.com', '1', '1', 'http://www.one26.com/gmonkey/images/usericons/jon.gif', 'http://www.one26.com/gmonkey/images/userpics/jon.jpg', 'a:6:{i:0;a:2:{s:5:"Label";s:7:"Website";s:5:"Value";s:20:"http://www.one26.com";}i:1;a:2:{s:5:"Label";s:11:"Shutterbook";s:5:"Value";s:43:"http://www.shutterbook.com/albums/outbreak/";}i:2;a:2:{s:5:"Label";s:6:"Flickr";s:5:"Value";s:38:"http://www.flickr.com/photos/outbreak/";}i:3;a:2:{s:5:"Label";s:8:"Playlist";s:5:"Value";s:47:"http://www.audioscrobbler.com/user/outbreak516/";}i:4;a:2:{s:5:"Label";s:9:"Bookmarks";s:5:"Value";s:27:"http://del.icio.us/outbreak";}i:5;a:2:{s:5:"Label";s:11:"Get File SN";s:5:"Value";s:13:"jons get file";}}', '1', 327, 124, 849, '2005-06-22 00:00:00', '2005-08-23 20:25:20', '71.241.145.75', '2005-08-23 14:11:43', 1, '2005-08-23 02:30:02', 1, '0', '0', 'Html', NULL , 'a:6:{s:9:"HidePanel";i:0;s:6:"HtmlOn";i:1;s:14:"ShowAppendices";i:0;s:13:"ShowBookmarks";i:1;s:22:"ShowPrivateDiscussions";i:0;s:21:"JumpToLastReadComment";i:0;}' )

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

i get the error for every user i try to insert.

Mark

What version were you upgrading from? There were some database changes between different versions. All of which should be documented - unless you were upgrading from a pre-release version. Either way, it shouldn't be too hard to figure out the problem.

outbreak

it may have been a pre-release version. to tell you the truth, i'm not even really sure which version it is, but my SQL knowledge is severely limited and i'm not sure how to get that one table over and working.

Mark

Do you have either command line access or access to a phpmyadmin installation or something? Somewhere you can find out what columns are on your installation of the LUM_User table? If you can tell me what the columns were on your old db's LUM_User table, I can tell you what you need to do in order to update your old data so the import will work.

outbreak

yeah, i saw how different the columns were and couldnt figure out the proper SQL code to insert, so i just did each one by hand. thank god i only have 22 members. thanks mark.