SQL dump still contains minor errors

[johnk]

I'm writing this as a "bump" and a subtle reminder to MaxiDVD to fix the code in his contribution. The errors mentioned here have been raised in earlier posts but the code is still corrupt as of today (25th May, 2004). If the contribution you download is dated today or prior, then the errors will not have been fixed. You will have to alter the code yourself.

 

This package actually does work out of the box, but before you try to overwrite your existing osCommerce files, make sure you "fix" the code in sql_file.sql located in the folder SQL SCRIPT.

 

There are two errors in the code and PHPMyAdmin won't process the full file unless you fix the errors first. It only take a second or two:

 

1. Open "sql_file_sql" using your favorite editor.

2. Change lines 44 and 45 from:

 

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', , 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 35, now(), now(), NULL, NULL);

 

to this:

 

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', '200', 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', '200', 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 35, now(), now(), NULL, NULL);

 

3. Ensure your version of osCommerce is a raw install, that means no changes of any kind by you. If you have fiddled, reinstall the program!

 

4. Copy the new catalog files to your osCommerce catalog.

 

5. Update the database using phpMyAdmin or whatever.

 

6. Run osCommerce and be impressed.

 

Note: If you tried uploading the corrupt sql_file.sql using phpMyAdmin and received an error message, you will have to delete the part that was successfully uploaded before you received the error.

 

1. With phpMyAdmin, select "catalog" (or whatever it's called on your server) from the database list.

 

2. Choose "configuration_group" from the table list.

 

3. Look for WYSIWYG editor 1.7 in the field "configuration_group_title" (Should be the last row.

 

4. Delete this row and this row only!

 

5. Re-run the sql dump after you've made the mods to lines 44 and 45. This time you shouldn't get any errors.

 

It really is a nice package and the only one I've been able to run on my machine. I wasn't able to get any of the "htmlarea" contributions to work so I replaced my windows apache, php, mysql setup and replaced the firewall. It's now possible that the other htmlarea contributions will also work on my machine, but I think I'm going to be happy with this one.

[Guest]

I am having more problems actually (though it looks like a damn fine mod! woo woo), I found those two bum points you mention ed there but I'm also getting the following error:

 

SQL-query :  

INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function ) 
VALUES (

'', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now( ) , now( ) , NULL , NULL 
) 

MySQL said: 


#1136 - Column count doesn't match value count at row 1

 

What's the deal with that?

[Guest]

hoo hoo.. ne'er mind! figured it!

 

Everyone pay attention to johnk, he's right, I'm wrong, it works.. party time excellent.