Not signed in (Sign In)

Categories

Vanilla 1.1.5 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.

General Support & Troubleshooting: upgrading to 0.9.2

Bottom of Page

1 to 5 of 5

  1.  
    •  
      CommentAuthoroutbreak
    • CommentTimeAug 23rd 2005 edited
     # 1
    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.
    •  
      CommentAuthorMark
    • CommentTimeAug 23rd 2005 edited
     # 2
    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.
    •  
      CommentAuthoroutbreak
    • CommentTimeAug 23rd 2005
     # 3
    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.
    •  
      CommentAuthorMark
    • CommentTimeAug 24th 2005
     # 4
    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.
    •  
      CommentAuthoroutbreak
    • CommentTimeAug 24th 2005
     # 5
    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.

1 to 5 of 5

  1.  
Add your comments
    Username Password
  • Format comments as
 
Back to Discussions Top of Page