Hello Will,
Yeah I had A similar issue with understanding the instructions., as I also didnt know what "run the SLQ scripts"meant. I'm running my project at this point on mt PC as localhost, and havent got to the upload to website stage yet. I installed phpMyAdmin and spent an eternity sorting out the errors generated by the dodgy php.ini file.
My assumption is that you either import each .sql file into phpmyadmin using the "IMPORT" tab, which runs the script when you press the [GO] button. Alternatively ; cut n paste the text from the .sql file into the box under the "SQL" tab. this will run the script when you press [GO].
However:
I get this BS when I run either way, the [downloads_controller_english.sql ] file.
Error
SQL query:
#NEW FIELDS FOR DOWNLOADS CONTROLLER
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 (
'', 'Downloads Controller Update Status Value', 'DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE', '12', 'What orders_status resets the Download days and Max Downloads - Default is 12', '13', '90', '2003-02-18 13:22:32', '', NULL , NULL
);
MySQL said: Documentation
#1046 - No database selected http://www.oscommerce.com/forums/style_images/ip.boardpr/folder_post_icons/icon13.gif
Hmmmm ... no data base selected... I guess that, in my case is "commerce_db" or is it the mySQL database?
AND how do I select it?
With "new_files" you just drag n drop the files to the appropriate folders as duplicated in the contribution release.
With "modified_files" you need to copy the text contained within the modified files, and paste that text at the described location within the file of the same name in the same appropriate folders as duplicated in the contribution release.... unless I am very much mistaken.
So how do I select the appropriate database so the SQL script will run?http://www.oscommerce.com/forums/style_images/ip.boardpr/folder_post_icons/icon14.gif
Cheers