Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

upgrading to 0.9.2

outbreakoutbreak New
edited August 2005 in Vanilla 1.0 Help
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, '', 'Jon', 'Contino', 'jon', '637c456ff9b347c370554442e034ceae', '29ab574bb68c950dc2e370d718a9798b', '', '', '1', '1', '', '', 'a:6:{i:0;a:2:{s:5:"Label";s:7:"Website";s:5:"Value";s:20:"";}i:1;a:2:{s:5:"Label";s:11:"Shutterbook";s:5:"Value";s:43:"";}i:2;a:2:{s:5:"Label";s:6:"Flickr";s:5:"Value";s:38:"";}i:3;a:2:{s:5:"Label";s:8:"Playlist";s:5:"Value";s:47:"";}i:4;a:2:{s:5:"Label";s:9:"Bookmarks";s:5:"Value";s:27:"";}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', '', '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.


  • Options
    MarkMark Vanilla Staff
    edited August 2005
    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.
  • Options
    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.
  • Options
    MarkMark Vanilla Staff
    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.
  • Options
    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.
This discussion has been closed.