found a lot of files didn't transfer the first time, so I downloaded again the install.txt (install.php) file and ran it over again. its running a lot longer so far. it also appears to be doing incremental downloads -- adding quite a few more files, and retaining those that already existed.
still not error free... each time I run this I pick up more files missing from prior attempts.
finally, after a dozen attempts I have a successful install.php, and all files look to be downloaded.
i can then get the login page, but my existing account(s) do not work, but I can create a new account.
entering the target creation I get new messages about index errors in the form. also I find html markup inside the text edit fields. I overwrite those values to create a new target, but then I get new errors -- dozens of this variety:
Notice: Undefined variable: OBJECT_NAME in C:\wamp\www\nutcracker_sean\login\process.php on line 80
I think a clean install would make sense at this point. Without wiping all of the wamp stuff, can you provide instructions on clearing out the nutcracker files and database?
thanks!
After the first time of running localhost/install.php in the future you should just need to run localhost/update.php
go to localhost and run phpmyadmin
click on nutcracker database
you should then see 8 tables
look in the rows column. audit log should be empty , the next 6 should have rows.
I export the database from meighan.net into two sql scripts. Look at your
c:\wamp\www\nutcracker_sean directory.
sqbuilder1.sql has all the ddl to create the tables
seqbuilder2.sql has the actual data.
seqbuilder2.sql is failing to load all data because some people have created descriptions with embedded semicolons in them.
you can see that this will screw up the inserts.
Here is an example. This is a huge table. One row wrong, whole table wont insert.
INSERT INTO `effects_user_dtl` (`login`, `effect_name`, `param_name`, `param_value`, `created`, `last_upd`) VALUES
('f', 'SEAN2', 'effect_name', 'SEAN2', NULL, '2012-03-20 22:06:24'),
('f', 'SEAN2', 'number_spirals', '4', NULL, '2012-03-20 22:06:24'),
('f', 'SEAN2', 'number_rotations', '2', NULL, '2012-03-20 22:06:24'),
('jaywalk101', '0319', 'sparkles', '', NULL, '2012-05-02 09:51:24'),
('jaywalk101', '0319', 'use_background', 'n', NULL, '2012-05-02 09:51:24'),
('jaywalk101', '0319', 'background_color', '#FFFFFF', NULL, '2012-05-02 09:51:24'),
('jaywalk101', '0319', 'seq_duration', '5', NULL, '2012-05-02 09:51:24'),
('jaywalk101', '0319', 'show_frame', 'y', NULL, '2012-05-02 09:51:24'),
('Lefserev', 'FIRST_TEXT', 'effect_name', 'First Text', NULL, '2012-03-19 17:25:01'),
('Lefserev', 'FIRST_TEXT', 'text1', 'Works pretty well!', NULL, '2012-03-19 17:25:01'),
('Lefserev', 'FIRST_TEXT', 'text2',
'sɐɯʇsıɹɥɔ ʎɹɹǝɯ', NULL, '2012-03-19 17:25:01'),
('Lefserev', 'FIRST_TEXT', 'window_degrees', '179', NULL, '2012-03-19 17:25:01'),
('Lefserev', 'FIRST_TEXT', 'text1_color', '#FF7424', NULL, '2012-03-19 17:25:01'),
('Lefserev', 'FIRST_TEXT', 'text2_color', '#FF70FF', NULL, '2012-03-19 17:25:01'),
('Lefserev', 'FIRST_TEXT', 'frame_delay', '50', NULL, '2012-03-19 17:25:01'),
('Lefserev', 'FIRST_TEXT', 'seq_duration', '8', NULL, '2012-03-19 17:25:01'),
('Lefserev', 'FIRST_TEXT', 'show_frame', 'n', NULL, '2012-03-19 17:25:01'),
Now what you can do is find your effects, example "Steve Gase". Copy the INSERT command and change last character to semicolon.
INSERT INTO `effects_user_dtl` (`login`, `effect_name`, `param_name`, `param_value`, `created`, `last_upd`) VALUES
('Steve Gase', 'SEAN_TEST', 'effect_name', 'sean test', NULL, '2012-03-06 11:06:14'),
('Steve Gase', 'SEAN_TEST', 'number_spirals', '2', NULL, '2012-03-06 11:06:14'),
('Steve Gase', 'SEAN_TEST', 'number_rotations', '2', NULL, '2012-03-06 11:06:14'),
('Steve Gase', 'SEAN_TEST', 'spiral_thickness', '2', NULL, '2012-03-06 11:06:14'),
('Steve Gase', 'SEAN_TEST', 'start_color', '#29FF30', NULL, '2012-03-06 11:06:14'),
('Steve Gase', 'SEAN_TEST', 'end_color', '#5EF4FF', NULL, '2012-03-06 11:06:14'),
('Steve Gase', 'SEAN_TEST', 'frame_delay', '22', NULL, '2012-03-06 11:06:14'),
('Steve Gase', 'SEAN_TEST', 'direction', 'cw', NULL, '2012-03-06 11:06:14');
Now execute this in the SQL window and you will have loaded your data.
Repeat for the other tables
INSERT INTO `effects_user_hdr` (`effect_class`, `username`, `effect_name`, `effect_desc`, `created`, `last_upd`) VALUES
('spirals', 'Steve Gase', 'SEAN_TEST', 'desc', NULL, '2012-03-06 11:06:14'),
('spirals', 'Steve Gase', 'BARBER', 'desc', NULL, '2012-04-27 20:42:32'),
('spirals', 'Steve Gase', 'BARBER2', 'desc', NULL, '2012-04-23 16:56:13'),
('spirals', 'Steve Gase', 'SEAN_TEST2', 'desc', NULL, '2012-03-12 23:58:47');
INSERT INTO `members` (`member_id`, `firstname`, `lastname`, `login`, `passwd`, `LSP1_8`, `LSP2_0`, `LSP3_0`, `LOR_S2`, `LOR_S3`, `VIXEN211`, `VIXEN25`, `VIXEN3`, `OTHER`) VALUES
(28, 'Steve', 'Gase', 'Steve Gase', '9c156ee357af96ec1179b04c9d7fd229', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
i will look into exporting the data has xml to handle these embedded semicolons